PREVIEW / etf_1hour / 2023-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-22.parquet
  size:    521 KB
  rows:    19,365

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
2023-12-22 04:00:00	SPY	ETF	472.15	472.64	472.13	472.4	7989.0
2023-12-22 05:00:00	SPY	ETF	472.37	472.63	472.26	472.6	27491.0
2023-12-22 06:00:00	SPY	ETF	472.59	472.77	472.44	472.71	130724.0
2023-12-22 07:00:00	SPY	ETF	472.7	472.95	472.6	472.62	80000.0
2023-12-22 08:00:00	SPY	ETF	472.82	474.0	472.0	473.96	709178.0
2023-12-22 09:00:00	SPY	ETF	473.94	475.38	473.77	474.91	6174771.0
2023-12-22 10:00:00	SPY	ETF	474.92	475.299	474.14	474.15	6391801.0
2023-12-22 11:00:00	SPY	ETF	474.155	474.6999	473.58	474.065	5715163.0
2023-12-22 12:00:00	SPY	ETF	474.07	474.565	473.661	474.55	3202508.0
2023-12-22 13:00:00	SPY	ETF	474.54	474.75	474.19	474.22	3374573.0
2023-12-22 14:00:00	SPY	ETF	474.22	474.27	471.7	473.88	9398822.0
2023-12-22 15:00:00	SPY	ETF	473.88	474.03	472.975	473.62	10366326.0
2023-12-22 16:00:00	SPY	ETF	473.62	473.91	472.84	473.0	3755065.0
2023-12-22 17:00:00	SPY	ETF	472.99	473.2	472.97	473.12	83252.0
2023-12-22 18:00:00	SPY	ETF	473.02	473.2	473.02	473.18	1599.0
2023-12-22 19:00:00	SPY	ETF	473.15	473.18	473.0	473.18	21487.0
2023-12-22 04:00:00	QQQ	ETF	406.66	407.16	406.65	406.98	20814.0
2023-12-22 05:00:00	QQQ	ETF	406.94	407.36	406.89	407.36	14517.0
2023-12-22 06:00:00	QQQ	ETF	407.37	407.5	407.27	407.44	24580.0
2023-12-22 07:00:00	QQQ	ETF	407.47	407.85	407.47	407.7	110087.0
2023-12-22 08:00:00	QQQ	ETF	407.66	409.17	406.5	409.03	645218.0
2023-12-22 09:00:00	QQQ	ETF	409.05	409.97	408.77	409.55	3981165.0
2023-12-22 10:00:00	QQQ	ETF	409.55	409.829	408.87	408.88	3044919.0
2023-12-22 11:00:00	QQQ	ETF	408.88	409.3	408.24	408.735	2783627.0
2023-12-22 12:00:00	QQQ	ETF	408.75	409.1999	408.22	409.15	1590737.0
2023-12-22 13:00:00	QQQ	ETF	409.13	409.465	408.97	409.045	1483037.0
2023-12-22 14:00:00	QQQ	ETF	409.05	409.0999	406.4787	408.645	5654641.0
2023-12-22 15:00:00	QQQ	ETF	408.67	408.79	407.93	408.44	5082424.0
2023-12-22 16:00:00	QQQ	ETF	408.44	408.61	407.94	408.01	1833371.0
2023-12-22 17:00:00	QQQ	ETF	408.01	408.08	407.9	407.97	24251.0
2023-12-22 18:00:00	QQQ	ETF	407.99	408.38	407.99	408.03	16981.0
2023-12-22 19:00:00	QQQ	ETF	407.99	408.2	407.99	408.2	6254.0
2023-12-22 04:00:00	IWM	ETF	199.38	199.55	199.09	199.44	18596.0
2023-12-22 05:00:00	IWM	ETF	199.4	199.67	199.34	199.57	13998.0
2023-12-22 06:00:00	IWM	ETF	199.59	199.86	199.59	199.86	14286.0
2023-12-22 07:00:00	IWM	ETF	199.81	200.11	199.8	199.94	31651.0
2023-12-22 08:00:00	IWM	ETF	200.05	200.87	199.01	200.81	490060.0
2023-12-22 09:00:00	IWM	ETF	200.83	202.81	200.33	202.11	7039800.0
2023-12-22 10:00:00	IWM	ETF	202.11	202.31	201.18	201.2066	4740685.0
2023-12-22 11:00:00	IWM	ETF	201.19	202.09	200.8	201.82	3482129.0
2023-12-22 12:00:00	IWM	ETF	201.82	202.27	201.37	202.25	2172358.0
2023-12-22 13:00:00	IWM	ETF	202.24	202.38	201.98	202.12	1761169.0
2023-12-22 14:00:00	IWM	ETF	202.11	202.11	200.19	201.69	5513421.0
2023-12-22 15:00:00	IWM	ETF	201.69	201.77	201.22	201.46	5354873.0
2023-12-22 16:00:00	IWM	ETF	201.46	201.6	200.99	201.07	789601.0
2023-12-22 17:00:00	IWM	ETF	201.08	201.48	201.02	201.48	29748.0
2023-12-22 18:00:00	IWM	ETF	201.28	201.35	201.18	201.3	5359.0
2023-12-22 19:00:00	IWM	ETF	201.3	201.31	201.25	201.29	8998.0
2023-12-22 04:00:00	DIA	ETF	372.77	373.0	372.76	373.0	450.0
2023-12-22 05:00:00	DIA	ETF	372.79	372.79	372.75	372.75	400.0

> showing 50 of 19,365 rows — these rows as CSV

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