PREVIEW / etf_1hour / 2021-10-29

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-29.parquet
  size:    430 KB
  rows:    15,069

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-10-29 04:00:00	SPY	ETF	456.6	456.6	455.81	456.22	40686.0
2021-10-29 05:00:00	SPY	ETF	456.11	456.4	455.8	456.18	9648.0
2021-10-29 06:00:00	SPY	ETF	456.29	456.32	455.5	456.09	103603.0
2021-10-29 07:00:00	SPY	ETF	455.99	456.5	455.95	456.15	213052.0
2021-10-29 08:00:00	SPY	ETF	456.12	456.69	455.53	455.81	379221.0
2021-10-29 09:00:00	SPY	ETF	455.79	457.64	455.45	457.12	5393616.0
2021-10-29 10:00:00	SPY	ETF	457.13	457.595	456.48	457.32	5247714.0
2021-10-29 11:00:00	SPY	ETF	457.32	458.48	457.29	458.06	4528464.0
2021-10-29 12:00:00	SPY	ETF	458.07	459.165	457.94	458.73	3648796.0
2021-10-29 13:00:00	SPY	ETF	458.74	459.13	458.42	458.7	2366578.0
2021-10-29 14:00:00	SPY	ETF	458.7	458.78	457.73	458.19	4843820.0
2021-10-29 15:00:00	SPY	ETF	458.205	459.56	457.58	459.23	16270165.0
2021-10-29 16:00:00	SPY	ETF	459.22	459.77	459.07	459.66	5379940.0
2021-10-29 17:00:00	SPY	ETF	459.62	459.73	459.49	459.61	70006.0
2021-10-29 18:00:00	SPY	ETF	459.59	459.7	459.25	459.59	24026.0
2021-10-29 19:00:00	SPY	ETF	459.68	459.79	459.57	459.7	27891.0
2021-10-29 04:00:00	QQQ	ETF	381.51	381.57	381.0	381.23	85035.0
2021-10-29 05:00:00	QQQ	ETF	381.12	381.38	380.79	381.03	116648.0
2021-10-29 06:00:00	QQQ	ETF	381.04	381.18	380.28	381.01	149836.0
2021-10-29 07:00:00	QQQ	ETF	380.91	381.41	380.74	381.14	352803.0
2021-10-29 08:00:00	QQQ	ETF	381.0101	381.66	380.3396	380.97	1046556.0
2021-10-29 09:00:00	QQQ	ETF	380.94	382.74	380.7	382.3298	5079349.0
2021-10-29 10:00:00	QQQ	ETF	382.3383	382.92	381.96	382.56	4119196.0
2021-10-29 11:00:00	QQQ	ETF	382.56	383.8603	382.51	383.6432	3080166.0
2021-10-29 12:00:00	QQQ	ETF	383.66	385.03	383.555	384.7601	3323676.0
2021-10-29 13:00:00	QQQ	ETF	384.78	385.38	384.5001	384.77	1800541.0
2021-10-29 14:00:00	QQQ	ETF	384.78	385.08	384.18	384.835	2440149.0
2021-10-29 15:00:00	QQQ	ETF	384.8236	386.28	384.47	386.08	7057565.0
2021-10-29 16:00:00	QQQ	ETF	386.08	386.65	385.97	386.63	1269321.0
2021-10-29 17:00:00	QQQ	ETF	386.57	386.68	386.42	386.42	58317.0
2021-10-29 18:00:00	QQQ	ETF	386.5	386.67	386.11	386.67	63363.0
2021-10-29 19:00:00	QQQ	ETF	386.6	386.75	386.52	386.75	17558.0
2021-10-29 04:00:00	IWM	ETF	227.94	228.05	227.65	227.65	7427.0
2021-10-29 05:00:00	IWM	ETF	227.94	228.07	227.7	228.07	21929.0
2021-10-29 06:00:00	IWM	ETF	228.01	228.14	227.5	227.7	19215.0
2021-10-29 07:00:00	IWM	ETF	227.78	228.31	227.7	228.01	78965.0
2021-10-29 08:00:00	IWM	ETF	227.7901	228.3	227.34	227.65	157647.0
2021-10-29 09:00:00	IWM	ETF	227.6	228.75	227.4	228.23	2283855.0
2021-10-29 10:00:00	IWM	ETF	228.23	228.83	227.42	228.119	2578133.0
2021-10-29 11:00:00	IWM	ETF	228.09	228.69	227.8284	228.01	1372937.0
2021-10-29 12:00:00	IWM	ETF	228.03	228.24	227.72	227.78	1055956.0
2021-10-29 13:00:00	IWM	ETF	227.79	228.225	227.72	228.02	1148706.0
2021-10-29 14:00:00	IWM	ETF	228.03	228.0699	227.1	227.51	1348487.0
2021-10-29 15:00:00	IWM	ETF	227.52	228.34	226.96	228.11	4021841.0
2021-10-29 16:00:00	IWM	ETF	228.11	228.37	228.0	228.32	1049834.0
2021-10-29 17:00:00	IWM	ETF	228.18	228.38	228.05	228.17	348344.0
2021-10-29 18:00:00	IWM	ETF	228.34	228.36	228.05	228.23	170697.0
2021-10-29 19:00:00	IWM	ETF	228.22	228.35	228.16	228.29	7460.0
2021-10-29 04:00:00	DIA	ETF	356.69	356.81	356.59	356.66	1312.0
2021-10-29 06:00:00	DIA	ETF	356.76	356.8	356.76	356.8	624.0

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

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