PREVIEW / etf_1hour / 2020-03-30

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-30.parquet
  size:    382 KB
  rows:    12,977

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-30 04:00:00	SPY	ETF	250.25	253.66	250.2	252.46	386300.0
2020-03-30 05:00:00	SPY	ETF	252.55	253.89	251.24	251.94	190545.0
2020-03-30 06:00:00	SPY	ETF	251.93	253.81	251.93	253.5	416733.0
2020-03-30 07:00:00	SPY	ETF	253.44	254.26	252.6	253.8	1244005.0
2020-03-30 08:00:00	SPY	ETF	253.7101	256.96	250.09	256.25	2116743.0
2020-03-30 09:00:00	SPY	ETF	256.26	257.24	253.53	255.31	15806848.0
2020-03-30 10:00:00	SPY	ETF	255.3	258.56	254.74	257.0761	20148929.0
2020-03-30 11:00:00	SPY	ETF	257.07	259.87	256.81	259.16	18402373.0
2020-03-30 12:00:00	SPY	ETF	259.17	260.38	258.12	260.32	13578572.0
2020-03-30 13:00:00	SPY	ETF	260.33	260.33	258.57	259.0919	15519451.0
2020-03-30 14:00:00	SPY	ETF	259.09	260.95	257.94	260.32	17523959.0
2020-03-30 15:00:00	SPY	ETF	260.32	262.43	258.92	261.68	39333773.0
2020-03-30 16:00:00	SPY	ETF	261.63	262.25	260.87	261.69	23156294.0
2020-03-30 17:00:00	SPY	ETF	261.63	262.0	261.5	261.57	349531.0
2020-03-30 18:00:00	SPY	ETF	261.56	262.6	261.34	261.95	319152.0
2020-03-30 19:00:00	SPY	ETF	261.78	262.23	261.29	261.93	362862.0
2020-03-30 04:00:00	QQQ	ETF	183.32	185.44	183.19	184.69	116922.0
2020-03-30 05:00:00	QQQ	ETF	185.0	186.07	184.14	184.57	100583.0
2020-03-30 06:00:00	QQQ	ETF	184.61	185.85	184.61	185.59	168476.0
2020-03-30 07:00:00	QQQ	ETF	185.56	186.15	185.08	185.71	230596.0
2020-03-30 08:00:00	QQQ	ETF	185.54	187.5	183.5	187.5	369922.0
2020-03-30 09:00:00	QQQ	ETF	187.5	188.34	186.3406	187.73	5385500.0
2020-03-30 10:00:00	QQQ	ETF	187.72	190.36	187.43	189.58	7674028.0
2020-03-30 11:00:00	QQQ	ETF	189.55	191.16	189.38	190.59	4546923.0
2020-03-30 12:00:00	QQQ	ETF	190.59	191.61	189.745	191.58	4113166.0
2020-03-30 13:00:00	QQQ	ETF	191.56	191.56	190.46	190.82	3947913.0
2020-03-30 14:00:00	QQQ	ETF	190.817	191.88	190.04	191.35	4058010.0
2020-03-30 15:00:00	QQQ	ETF	191.35	192.49	190.4	192.11	10544928.0
2020-03-30 16:00:00	QQQ	ETF	192.09	192.17	191.22	191.79	1254186.0
2020-03-30 17:00:00	QQQ	ETF	191.48	192.0	191.48	191.73	41693.0
2020-03-30 18:00:00	QQQ	ETF	191.7	192.5	191.6	192.1	359846.0
2020-03-30 19:00:00	QQQ	ETF	192.11	192.43	191.71	192.2	80077.0
2020-03-30 04:00:00	IWM	ETF	111.01	111.92	110.94	111.92	7248.0
2020-03-30 05:00:00	IWM	ETF	111.43	112.26	111.19	111.62	1899.0
2020-03-30 06:00:00	IWM	ETF	112.16	112.4	111.68	112.4	65366.0
2020-03-30 07:00:00	IWM	ETF	112.24	113.1	111.94	112.94	145380.0
2020-03-30 08:00:00	IWM	ETF	112.0	114.21	111.5	113.79	196305.0
2020-03-30 09:00:00	IWM	ETF	113.79	113.9198	110.8	111.77	3704433.0
2020-03-30 10:00:00	IWM	ETF	111.81	113.77	111.435	112.7492	5213591.0
2020-03-30 11:00:00	IWM	ETF	112.75	114.4	112.54	114.26	5602698.0
2020-03-30 12:00:00	IWM	ETF	114.26	114.74	113.58	114.11	3640552.0
2020-03-30 13:00:00	IWM	ETF	114.12	114.25	113.12	113.24	3308786.0
2020-03-30 14:00:00	IWM	ETF	113.23	113.79	112.115	113.59	4291606.0
2020-03-30 15:00:00	IWM	ETF	113.59	115.26	113.34	115.11	7015956.0
2020-03-30 16:00:00	IWM	ETF	115.12	115.15	114.5	114.8	2205632.0
2020-03-30 17:00:00	IWM	ETF	114.98	115.02	114.98	115.02	1200.0
2020-03-30 18:00:00	IWM	ETF	114.9	115.39	114.77	114.93	60091.0
2020-03-30 19:00:00	IWM	ETF	114.96	115.24	114.75	115.05	10600.0
2020-03-30 04:00:00	DIA	ETF	214.74	215.93	213.35	214.53	13742.0
2020-03-30 05:00:00	DIA	ETF	214.6	216.52	214.45	214.88	5614.0

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

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