PREVIEW / etf_1hour / 2022-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-07.parquet
  size:    448 KB
  rows:    16,052

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
2022-01-07 04:00:00	SPY	ETF	468.89	468.89	467.24	468.43	54096.0
2022-01-07 05:00:00	SPY	ETF	468.45	469.25	468.21	469.01	45400.0
2022-01-07 06:00:00	SPY	ETF	469.01	469.23	468.62	468.68	61361.0
2022-01-07 07:00:00	SPY	ETF	468.54	469.2	468.23	468.33	76122.0
2022-01-07 08:00:00	SPY	ETF	468.29	469.3	466.27	466.98	1319581.0
2022-01-07 09:00:00	SPY	ETF	466.99	469.2	466.73	468.64	8074101.0
2022-01-07 10:00:00	SPY	ETF	468.65	468.78	464.65	465.25	10151640.0
2022-01-07 11:00:00	SPY	ETF	465.27	468.09	464.685	467.6574	9350865.0
2022-01-07 12:00:00	SPY	ETF	467.66	467.81	466.47	467.26	4407532.0
2022-01-07 13:00:00	SPY	ETF	467.26	467.69	466.59	466.91	3655571.0
2022-01-07 14:00:00	SPY	ETF	466.91	467.73	466.1	467.47	6014156.0
2022-01-07 15:00:00	SPY	ETF	467.47	467.98	465.92	466.12	11975367.0
2022-01-07 16:00:00	SPY	ETF	466.13	467.259	465.95	465.99	3724180.0
2022-01-07 17:00:00	SPY	ETF	466.01	466.33	465.9	466.0	138233.0
2022-01-07 18:00:00	SPY	ETF	465.95	466.09	465.9	466.0401	23155.0
2022-01-07 19:00:00	SPY	ETF	466.11	466.15	465.9	465.9	23643.0
2022-01-07 04:00:00	QQQ	ETF	385.35	385.35	382.24	383.91	105729.0
2022-01-07 05:00:00	QQQ	ETF	383.98	385.3	383.71	384.94	20555.0
2022-01-07 06:00:00	QQQ	ETF	384.72	385.64	384.63	384.9	43602.0
2022-01-07 07:00:00	QQQ	ETF	384.95	385.56	384.3	384.36	115548.0
2022-01-07 08:00:00	QQQ	ETF	385.03	385.67	380.89	382.1	2212396.0
2022-01-07 09:00:00	QQQ	ETF	382.28	385.76	381.1	384.8975	11019967.0
2022-01-07 10:00:00	QQQ	ETF	384.9	385.04	378.04	379.07	13218663.0
2022-01-07 11:00:00	QQQ	ETF	379.08	381.99	378.62	381.31	9323024.0
2022-01-07 12:00:00	QQQ	ETF	381.32	381.66	379.85	381.1317	4058842.0
2022-01-07 13:00:00	QQQ	ETF	381.16	381.61	379.9531	380.35	3972205.0
2022-01-07 14:00:00	QQQ	ETF	380.36	381.53	379.1501	381.1599	4912355.0
2022-01-07 15:00:00	QQQ	ETF	381.14	381.93	379.57	379.81	7387827.0
2022-01-07 16:00:00	QQQ	ETF	379.83	380.27	379.51	379.56	1220152.0
2022-01-07 17:00:00	QQQ	ETF	379.5	383.9728	379.5	379.53	305584.0
2022-01-07 18:00:00	QQQ	ETF	379.64	379.69	379.55	379.66	16963.0
2022-01-07 19:00:00	QQQ	ETF	379.69	379.72	379.62	379.72	11654.0
2022-01-07 04:00:00	IWM	ETF	218.17	219.16	218.08	218.77	24353.0
2022-01-07 05:00:00	IWM	ETF	218.84	219.34	218.7	219.18	14623.0
2022-01-07 06:00:00	IWM	ETF	219.01	219.17	218.74	218.74	12378.0
2022-01-07 07:00:00	IWM	ETF	218.72	219.14	218.46	218.51	62919.0
2022-01-07 08:00:00	IWM	ETF	218.58	219.3	217.64	218.25	316532.0
2022-01-07 09:00:00	IWM	ETF	218.32	220.38	218.05	220.0	4424184.0
2022-01-07 10:00:00	IWM	ETF	220.01	220.07	216.0	216.48	5280154.0
2022-01-07 11:00:00	IWM	ETF	216.47	218.0	215.925	217.88	3582908.0
2022-01-07 12:00:00	IWM	ETF	217.87	218.345	217.37	217.65	1721274.0
2022-01-07 13:00:00	IWM	ETF	217.66	217.92	217.21	217.23	1469716.0
2022-01-07 14:00:00	IWM	ETF	217.25	217.36	216.3	216.91	1673337.0
2022-01-07 15:00:00	IWM	ETF	216.9	217.16	215.97	216.06	3534900.0
2022-01-07 16:00:00	IWM	ETF	216.06	216.75	215.79	215.9	649078.0
2022-01-07 17:00:00	IWM	ETF	215.98	216.07	215.76	215.95	604711.0
2022-01-07 18:00:00	IWM	ETF	215.8	216.02	215.8	216.0	4319.0
2022-01-07 19:00:00	IWM	ETF	215.97	216.07	215.88	215.97	7750.0
2022-01-07 04:00:00	DIA	ETF	362.43	362.97	362.43	362.97	1595.0
2022-01-07 05:00:00	DIA	ETF	362.91	362.99	362.91	362.99	500.0

> showing 50 of 16,052 rows — these rows as CSV

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