Hi!
I'm not getting my head around how to extract data from the output from the Alpha vantage stock addon. I would be very grateful if someone could help me in the right direction.
The output from the addon is:
{"data":{"information":"Intraday (1min) open, high, low, close prices and volume","symbol":"TSLA","last_refreshed":"2020-06-09 16:00:00","interval":"1min","output_size":"Compact","time_zone":"US/Eastern"},"series":{"2020-06-09 16:00:00":{"open":941.85,"high":942.68,"low":940.67,"close":941.07,"volume":50444},"2020-06-09 15:59:00":{"open":940.97,"high":942.1999,"low":940.68,"close":941.89,"volume":38401},"2020-06-09 15:58:00":{"open":941.25,"high":941.48,"low":940.13,"close":941.06,"volume":28092},"2020-06-09 15:57:00":{"open":940.575,"high":941.54,"low":940.01,"close":941.123,"volume":24880},"2020-06-09 15:56:00":{"open":939.8,"high":940.87,"low":939.55,"close":940.781,"volume":41898},"2020-06-09 15:55:00":{"open":940.505,"high":940.76,"low":939.56,"close":939.75,"volume":47959},"2020-06-09 15:54:00":{"open":941.846,"high":942.23,"low":940.23,"close":940.31,"volume":37943},"2020-06-09 15:53:00":{"open":941.8364,"high":942.77,"low":941.69,"close":941.915,"volume":24715},"2020-06-09 15:52:00":{"open":942.29,"high":942.4553,"low":941.27,"close":941.8558,"volume":19295},"2020-06-09 15:51:00":{"open":942.21,"high":942.9099,"low":941,"close":942.268,"volume":31382},"2020-06-09 15:50:00":{"open":942.99,"high":943.51,"low":942.0301,"close":942.53,"volume":33382},"2020-06-09 15:49:00":{"open":942.25,"high":942.98,"low":941.1249,"close":942.98,"volume":29534},"2020-06-09 15:48:00":{"open":943.49,"high":943.51,"low":942,"close":942.39,"volume":29046},"2020-06-09 15:47:00":{"open":943.69,"high":943.8406,"low":943.1,"close":943.51,"volume":17600},"2020-06-09 15:46:00":{"open":945.435,"high":945.58,"low":943.4,"close":943.63,"volume":25357},"2020-06-09 15:45:00":{"open":946.5,"high":946.5,"low":945.17,"close":945.63,"volume":18890},"2020-06-09 15:44:00":{"open":946.5864,"high":946.77,"low":946.5,"close":946.5,"volume":15611},"2020-06-09 15:43:00":{"open":945.815,"high":946.9399,"low":945.8101,"close":946.5,"volume":26990},"2020-06-09 15:42:00":{"open":946.0533,"high":946.3899,"low":945.5,"close":945.8199,"volume":12298},"2020-06-09 15:41:00":{"open":945.605,"high":946.34,"low":945.51,"close":946.026,"volume":19037},"2020-06-09 15:40:00":{"open":945.29,"high":946,"low":945.235,"close":945.6036,"volume":15271},"2020-06-09 15:39:00":{"open":944.3,"high":945.6,"low":944.3,"close":945.4508,"volume":17192},"2020-06-09 15:38:00":{"open":945.42,"high":945.48,"low":944.26,"close":944.66,"volume":16367},"2020-06-09 15:37:00":{"open":944.32,"high":945.5,"low":944.205,"close":945.2,"volume":14710},"2020-06-09 15:36:00":{"open":943.588,"high":944.96,"low":943.3,"close":944.07,"volume":14489},"2020-06-09 15:35:00":{"open":943.72,"high":944.04,"low":943.31,"close":943.5,"volume":14910},"2020-06-09 15:34:00":{"open":945.635,"high":945.96,"low":943.81,"close":944.07,"volume":16818},"2020-06-09 15:33:00":{"open":945.61,"high":946.02,"low":945.502,"close":945.68,"volume":9962},"2020-06-09 15:32:00":{"open":946.4956,"high":946.4956,"low":945.1035,"close":945.49,"volume":13543},"2020-06-09 15:31:00":{"open":945.9496,"high":946.65,"low":945.7,"close":946.35,"volume":8321},"2020-06-09 15:30:00":{"open":946.54,"high":946.82,"low":946,"close":946.2299,"volume":10016},"2020-06-09 15:29:00":{"open":946.32,"high":946.89,"low":946.22,"close":946.53,"volume":13041},"2020-06-09 15:28:00":{"open":946.87,"high":947.4599,"low":946.26,"close":946.35,"volume":14042},"2020-06-09 15:27:00":{"open":945.9,"high":947.0237,"low":945.89,"close":946.98,"volume":7511},"2020-06-09 15:26:00":{"open":945.8198,"high":946.4,"low":944.53,"close":946.0354,"volume":13997},"2020-06-09 15:25:00":{"open":946.34,"high":946.39,"low":945.18,"close":945.6989,"volume":17829},"2020-06-09 15:24:00":{"open":947.51,"high":947.78,"low":946.5,"close":946.5,"volume":9957},"2020-06-09 15:23:00":{"open":948.2,"high":948.28,"low":947.3301,"close":947.51,"volume":12918},"2020-06-09 15:22:00":{"open":947.66,"high":948.49,"low":947.5,"close":948.26,"volume":22962},"2020-06-09 15:21:00":{"open":946.79,"high":947.88,"low":946.55,"close":947.25,"volume":12844},"2020-06-09 15:20:00":{"open":946.985,"high":947,"low":946.56,"close":946.71,"volume":6112},"2020-06-09 15:19:00":{"open":946.8,"high":947.5,"low":946.7318,"close":947,"volume":12867},"2020-06-09 15:18:00":{"open":946.96,"high":947.23,"low":946.68,"close":947.15,"volume":12715},"2020-06-09 15:17:00":{"open":946.2716,"high":947,"low":946.2716,"close":946.9507,"volume":15321},"2020-06-09 15:16:00":{"open":945.17,"high":946.84,"low":945.17,"close":946.29,"volume":22335},"2020-06-09 15:15:00":{"open":944.55,"high":945,"low":944.2984,"close":945,"volume":10049},"2020-06-09 15:14:00":{"open":944.3114,"high":945,"low":944.0001,"close":944.5,"volume":17170},"2020-06-09 15:13:00":{"open":944.6,"high":944.84,"low":944,"close":944.46,"volume":14319},"2020-06-09 15:12:00":{"open":944.785,"high":945,"low":943.89,"close":944.63,"volume":18627},"2020-06-09 15:11:00":{"open":944.45,"high":944.985,"low":944.4001,"close":944.81,"volume":20193},"2020-06-09 15:10:00":{"open":943.623,"high":944.5,"low":943.34,"close":944.45,"volume":23209},"2020-06-09 15:09:00":{"open":943.61,"high":943.81,"low":942.18,"close":943.25,"volume":33385},"2020-06-09 15:08:00":{"open":943.9899,"high":944.01,"low":942.29,"close":943.78,"volume":24689},"2020-06-09 15:07:00":{"open":944.6,"high":944.65,"low":943.3,"close":943.692,"volume":14771},"2020-06-09 15:06:00":{"open":945.54,"high":945.56,"low":944.26,"close":944.62,"volume":10375},"2020-06-09 15:05:00":{"open":946.38,"high":946.5401,"low":945.01,"close":945.4755,"volume":10455},"2020-06-09 15:04:00":{"open":946.7,"high":947,"low":946.164,"close":946.164,"volume":8404},"2020-06-09 15:03:00":{"open":946.64,"high":947.06,"low":946.3,"close":946.65,"volume":7281},"2020-06-09 15:02:00":{"open":946.1,"high":946.8699,"low":946.1,"close":946.625,"volume":8322},"2020-06-09 15:01:00":{"open":946.815,"high":946.98,"low":946.12,"close":946.18,"volume":8392},"2020-06-09 15:00:00":{"open":946.47,"high":946.8975,"low":946.11,"close":946.3401,"volume":7842},"2020-06-09 14:59:00":{"open":945.91,"high":946.47,"low":945.79,"close":946.3024,"volume":6514},"2020-06-09 14:58:00":{"open":947.175,"high":947.175,"low":945.5235,"close":945.9548,"volume":9723},"2020-06-09 14:57:00":{"open":946.985,"high":947.3,"low":946.69,"close":947.151,"volume":7667},"2020-06-09 14:56:00":{"open":947.005,"high":947.346,"low":946.89,"close":947.005,"volume":5975},"2020-06-09 14:55:00":{"open":947.19,"high":947.68,"low":946.96,"close":947.05,"volume":14069},"2020-06-09 14:54:00":{"open":946.83,"high":947.33,"low":946.74,"close":947.04,"volume":8147},"2020-06-09 14:53:00":{"open":947.88,"high":948,"low":945.96,"close":946.85,"volume":18722},"2020-06-09 14:52:00":{"open":947.31,"high":947.89,"low":946.97,"close":947.7201,"volume":16138},"2020-06-09 14:51:00":{"open":946.715,"high":947.72,"low":946.715,"close":947.51,"volume":24187},"2020-06-09 14:50:00":{"open":945.71,"high":947.02,"low":945.5201,"close":946.72,"volume":21706},"2020-06-09 14:49:00":{"open":945.1099,"high":945.9599,"low":944.645,"close":945.53,"volume":11044},"2020-06-09 14:48:00":{"open":944.99,"high":945.1299,"low":944.52,"close":944.71,"volume":10843},"2020-06-09 14:47:00":{"open":944.761,"high":945.18,"low":944.55,"close":944.72,"volume":11214},"2020-06-09 14:46:00":{"open":945.06,"high":945.0822,"low":944.4225,"close":944.81,"volume":8329},"2020-06-09 14:45:00":{"open":944.87,"high":945.214,"low":944.8201,"close":945.08,"volume":5150},"2020-06-09 14:44:00":{"open":945.22,"high":945.2427,"low":944.75,"close":945.045,"volume":3949},"2020-06-09 14:43:00":{"open":944.98,"high":945.46,"low":944.98,"close":945.381,"volume":10018},"2020-06-09 14:42:00":{"open":945.1955,"high":945.535,"low":944,"close":944.98,"volume":13177},"2020-06-09 14:41:00":{"open":945.295,"high":946,"low":945.19,"close":945.4183,"volume":6995},"2020-06-09 14:40:00":{"open":945.6373,"high":946.3599,"low":945.2809,"close":945.77,"volume":13351},"2020-06-09 14:39:00":{"open":945.4299,"high":945.63,"low":944.7001,"close":945.63,"volume":8877},"2020-06-09 14:38:00":{"open":945.02,"high":945.6604,"low":944.7,"close":945.185,"volume":11893},"2020-06-09 14:37:00":{"open":945.695,"high":945.8863,"low":944.75,"close":945.02,"volume":14442},"2020-06-09 14:36:00":{"open":947.05,"high":947.2828,"low":945.52,"close":945.725,"volume":15467},"2020-06-09 14:35:00":{"open":946.78,"high":947.7399,"low":946.76,"close":947.2764,"volume":11656},"2020-06-09 14:34:00":{"open":947.08,"high":947.18,"low":946.35,"close":946.8233,"volume":8320},"2020-06-09 14:33:00":{"open":946.9,"high":947.773,"low":946.77,"close":947.285,"volume":11076},"2020-06-09 14:32:00":{"open":946.55,"high":947.25,"low":946.3,"close":946.785,"volume":13113},"2020-06-09 14:31:00":{"open":945.78,"high":947.1,"low":945.77,"close":946.7102,"volume":19935},"2020-06-09 14:30:00":{"open":946.23,"high":946.24,"low":945.5101,"close":945.825,"volume":10287},"2020-06-09 14:29:00":{"open":944.65,"high":946.24,"low":944.65,"close":946.12,"volume":16837},"2020-06-09 14:28:00":{"open":944.42,"high":945.1,"low":944.33,"close":944.63,"volume":16070},"2020-06-09 14:27:00":{"open":944.94,"high":944.99,"low":944.3101,"close":944.51,"volume":9102},"2020-06-09 14:26:00":{"open":944.6199,"high":945.68,"low":944.3047,"close":945.105,"volume":22400},"2020-06-09 14:25:00":{"open":943.71,"high":944.62,"low":943.68,"close":944.5975,"volume":16552},"2020-06-09 14:24:00":{"open":943.73,"high":944.53,"low":943.58,"close":943.67,"volume":20150},"2020-06-09 14:23:00":{"open":944.2,"high":944.44,"low":943.6,"close":943.6,"volume":15090},"2020-06-09 14:22:00":{"open":944.4654,"high":944.7,"low":943.262,"close":943.8001,"volume":15506},"2020-06-09 14:21:00":{"open":945.27,"high":945.71,"low":944.26,"close":944.4556,"volume":28735}}}
So being able to export of from the lastest series would be great.
