PREVIEW / etf_1hour / 2021-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-05.parquet
  size:    438 KB
  rows:    15,171

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
2021-03-05 04:00:00	SPY	ETF	375.16	375.66	374.34	375.07	67889.0
2021-03-05 05:00:00	SPY	ETF	375.06	376.1	374.84	375.9	77295.0
2021-03-05 06:00:00	SPY	ETF	375.76	377.4	375.76	376.8	259899.0
2021-03-05 07:00:00	SPY	ETF	376.72	377.86	376.48	377.64	339663.0
2021-03-05 08:00:00	SPY	ETF	377.1701	379.48	374.02	379.05	2651732.0
2021-03-05 09:00:00	SPY	ETF	378.91	381.21	375.79	377.34	13574010.0
2021-03-05 10:00:00	SPY	ETF	377.33	379.23	374.93	375.39	20983938.0
2021-03-05 11:00:00	SPY	ETF	375.381	376.3	372.64	375.86	16508413.0
2021-03-05 12:00:00	SPY	ETF	375.84	379.53	375.44	379.14	10755266.0
2021-03-05 13:00:00	SPY	ETF	379.11	381.88	377.89	381.34	11457460.0
2021-03-05 14:00:00	SPY	ETF	381.36	383.23	379.92	383.0946	9420996.0
2021-03-05 15:00:00	SPY	ETF	383.0919	384.76	382.5048	383.595	22540761.0
2021-03-05 16:00:00	SPY	ETF	383.61	384.07	383.39	383.82	8276971.0
2021-03-05 17:00:00	SPY	ETF	383.75	384.0	383.6	383.88	225371.0
2021-03-05 18:00:00	SPY	ETF	383.89	383.92	383.63	383.85	33411.0
2021-03-05 19:00:00	SPY	ETF	383.81	384.03	383.8	383.95	41877.0
2021-03-05 04:00:00	QQQ	ETF	302.66	303.33	301.89	302.01	84285.0
2021-03-05 05:00:00	QQQ	ETF	302.03	303.06	301.64	302.77	75336.0
2021-03-05 06:00:00	QQQ	ETF	302.61	304.31	302.61	303.6	188961.0
2021-03-05 07:00:00	QQQ	ETF	303.53	304.97	303.2	304.66	385333.0
2021-03-05 08:00:00	QQQ	ETF	304.67	305.57	301.5	304.81	2953983.0
2021-03-05 09:00:00	QQQ	ETF	304.8	307.98	301.35	302.94	14610426.0
2021-03-05 10:00:00	QQQ	ETF	302.94	304.62	300.36	300.89	17795120.0
2021-03-05 11:00:00	QQQ	ETF	300.9002	301.5894	297.45	301.34	15830230.0
2021-03-05 12:00:00	QQQ	ETF	301.34	305.55	300.27	305.35	11130843.0
2021-03-05 13:00:00	QQQ	ETF	305.32	307.83	303.52	306.93	8708791.0
2021-03-05 14:00:00	QQQ	ETF	306.93	309.1	305.07	308.89	8037718.0
2021-03-05 15:00:00	QQQ	ETF	308.9	309.609	307.96	308.73	11543305.0
2021-03-05 16:00:00	QQQ	ETF	308.75	308.94	308.4	308.56	1776784.0
2021-03-05 17:00:00	QQQ	ETF	308.54	308.99	308.521	308.84	196998.0
2021-03-05 18:00:00	QQQ	ETF	308.9	309.15	308.84	309.11	38692.0
2021-03-05 19:00:00	QQQ	ETF	309.05	309.2	308.92	309.07	34824.0
2021-03-05 04:00:00	IWM	ETF	212.5	212.86	211.3	212.1	10265.0
2021-03-05 05:00:00	IWM	ETF	212.29	212.78	211.62	212.73	29704.0
2021-03-05 06:00:00	IWM	ETF	212.7	214.4	212.7	214.15	49563.0
2021-03-05 07:00:00	IWM	ETF	214.07	214.68	213.55	214.68	175956.0
2021-03-05 08:00:00	IWM	ETF	214.53	216.78	212.47	216.2	570865.0
2021-03-05 09:00:00	IWM	ETF	216.31	217.28	211.76	213.46	6484394.0
2021-03-05 10:00:00	IWM	ETF	213.46	214.32	209.87	210.63	7499442.0
2021-03-05 11:00:00	IWM	ETF	210.64	211.2	207.21	210.95	5826718.0
2021-03-05 12:00:00	IWM	ETF	210.91	214.108	210.22	213.63	4233240.0
2021-03-05 13:00:00	IWM	ETF	213.63	215.99	212.31	215.47	3720705.0
2021-03-05 14:00:00	IWM	ETF	215.5	216.57	213.82	216.3125	2992606.0
2021-03-05 15:00:00	IWM	ETF	216.28	218.15	215.625	217.62	6576262.0
2021-03-05 16:00:00	IWM	ETF	217.62	218.08	216.2601	217.71	4719347.0
2021-03-05 17:00:00	IWM	ETF	217.83	218.09	217.65	217.81	211336.0
2021-03-05 18:00:00	IWM	ETF	217.99	217.99	217.79	217.83	3574.0
2021-03-05 19:00:00	IWM	ETF	217.92	218.1	217.86	217.86	1613.0
2021-03-05 04:00:00	DIA	ETF	308.22	308.56	308.06	308.41	2100.0
2021-03-05 05:00:00	DIA	ETF	308.66	309.02	308.66	309.02	2800.0

> showing 50 of 15,171 rows — these rows as CSV

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