PREVIEW / etf_1hour / 2020-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-31.parquet
  size:    381 KB
  rows:    12,998

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2020-03-31 04:00:00	SPY	ETF	262.74	263.9	262.5	263.3	100607.0
2020-03-31 05:00:00	SPY	ETF	263.46	263.75	262.46	263.01	91919.0
2020-03-31 06:00:00	SPY	ETF	262.93	262.96	261.05	261.18	200151.0
2020-03-31 07:00:00	SPY	ETF	261.26	261.41	259.96	260.43	929977.0
2020-03-31 08:00:00	SPY	ETF	260.8299	263.46	257.67	259.4499	3099924.0
2020-03-31 09:00:00	SPY	ETF	259.45	260.92	258.286	259.19	16810238.0
2020-03-31 10:00:00	SPY	ETF	259.16	263.25	259.13	261.79	26223808.0
2020-03-31 11:00:00	SPY	ETF	261.8	263.33	261.0	262.515	16720629.0
2020-03-31 12:00:00	SPY	ETF	262.51	262.71	258.52	259.3767	19977322.0
2020-03-31 13:00:00	SPY	ETF	259.36	260.31	257.94	260.1	17293797.0
2020-03-31 14:00:00	SPY	ETF	260.09	260.64	258.77	259.8084	16101075.0
2020-03-31 15:00:00	SPY	ETF	259.805	260.4537	256.22	257.7	47309932.0
2020-03-31 16:00:00	SPY	ETF	257.71	258.582	256.02	256.74	21903057.0
2020-03-31 17:00:00	SPY	ETF	256.69	257.75	256.69	256.75	765530.0
2020-03-31 18:00:00	SPY	ETF	256.75	257.75	254.16	255.05	1014553.0
2020-03-31 19:00:00	SPY	ETF	255.0	255.37	254.19	254.31	572530.0
2020-03-31 04:00:00	QQQ	ETF	193.27	194.05	193.13	193.81	127988.0
2020-03-31 05:00:00	QQQ	ETF	193.84	194.29	193.39	193.7	124639.0
2020-03-31 06:00:00	QQQ	ETF	193.65	193.65	192.14	192.24	80167.0
2020-03-31 07:00:00	QQQ	ETF	192.28	192.37	191.55	192.14	227380.0
2020-03-31 08:00:00	QQQ	ETF	192.03	194.05	189.62	190.65	1370280.0
2020-03-31 09:00:00	QQQ	ETF	190.63	192.32	190.43	191.02	6078327.0
2020-03-31 10:00:00	QQQ	ETF	191.01	195.25	190.99	193.775	9770015.0
2020-03-31 11:00:00	QQQ	ETF	193.78	194.6	193.1	193.7	4658080.0
2020-03-31 12:00:00	QQQ	ETF	193.7	193.89	190.87	191.59	6272388.0
2020-03-31 13:00:00	QQQ	ETF	191.59	192.74	190.76	192.55	4817516.0
2020-03-31 14:00:00	QQQ	ETF	192.54	192.66	191.47	191.93	4007000.0
2020-03-31 15:00:00	QQQ	ETF	191.93	192.37	189.2	190.46	13376608.0
2020-03-31 16:00:00	QQQ	ETF	190.46	190.46	189.44	190.06	1355933.0
2020-03-31 17:00:00	QQQ	ETF	190.19	190.4	189.78	189.85	1225570.0
2020-03-31 18:00:00	QQQ	ETF	189.8	189.8	188.3	188.74	230385.0
2020-03-31 19:00:00	QQQ	ETF	188.85	190.4	188.23	188.31	798289.0
2020-03-31 04:00:00	IWM	ETF	115.48	115.97	115.21	115.63	7220.0
2020-03-31 05:00:00	IWM	ETF	115.79	115.79	115.17	115.27	4300.0
2020-03-31 06:00:00	IWM	ETF	115.29	115.31	114.81	115.1	26875.0
2020-03-31 07:00:00	IWM	ETF	114.8	114.8	114.16	114.6	67301.0
2020-03-31 08:00:00	IWM	ETF	114.4901	114.79	113.46	114.25	195770.0
2020-03-31 09:00:00	IWM	ETF	114.21	115.405	113.88	114.45	2647714.0
2020-03-31 10:00:00	IWM	ETF	114.43	116.17	114.36	115.3901	4024133.0
2020-03-31 11:00:00	IWM	ETF	115.4	115.81	114.98	115.41	2635701.0
2020-03-31 12:00:00	IWM	ETF	115.375	115.53	113.52	113.69	3430167.0
2020-03-31 13:00:00	IWM	ETF	113.69	114.13	112.55	113.68	3998061.0
2020-03-31 14:00:00	IWM	ETF	113.69	114.3491	113.325	113.93	3071636.0
2020-03-31 15:00:00	IWM	ETF	113.925	114.52	111.955	114.44	12515070.0
2020-03-31 16:00:00	IWM	ETF	114.46	114.6247	113.11	113.15	8181537.0
2020-03-31 17:00:00	IWM	ETF	113.59	114.46	113.19	113.3	662467.0
2020-03-31 18:00:00	IWM	ETF	113.23	113.23	111.93	112.23	83563.0
2020-03-31 19:00:00	IWM	ETF	112.32	112.4	111.48	111.48	57869.0
2020-03-31 04:00:00	DIA	ETF	224.54	225.32	224.39	225.03	16299.0
2020-03-31 05:00:00	DIA	ETF	224.71	225.15	224.24	224.66	9469.0

> showing 50 of 12,998 rows — these rows as CSV

> unlock the full archive -- $79 one-time