PREVIEW / etf_1hour / 2023-12-21

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-21.parquet
  size:    522 KB
  rows:    19,415

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-21 04:00:00	SPY	ETF	470.7	471.01	469.82	470.76	46277.0
2023-12-21 05:00:00	SPY	ETF	470.69	470.73	470.21	470.21	55296.0
2023-12-21 06:00:00	SPY	ETF	470.3	470.6	470.28	470.42	89011.0
2023-12-21 07:00:00	SPY	ETF	470.34	470.81	469.4	470.67	310941.0
2023-12-21 08:00:00	SPY	ETF	470.67	472.64	468.26	471.8	1311660.0
2023-12-21 09:00:00	SPY	ETF	471.8	472.3	470.98	471.4	8335445.0
2023-12-21 10:00:00	SPY	ETF	471.41	472.44	470.55	471.17	9826848.0
2023-12-21 11:00:00	SPY	ETF	471.16	471.69	470.42	470.55	6544097.0
2023-12-21 12:00:00	SPY	ETF	470.55	470.55	469.27	469.4799	7371270.0
2023-12-21 13:00:00	SPY	ETF	469.48	470.59	468.84	470.55	6306813.0
2023-12-21 14:00:00	SPY	ETF	470.56	471.06	470.16	470.57	4890866.0
2023-12-21 15:00:00	SPY	ETF	470.57	472.975	470.25	472.67	14994501.0
2023-12-21 16:00:00	SPY	ETF	472.67	473.04	470.2085	472.77	8082523.0
2023-12-21 17:00:00	SPY	ETF	472.78	472.99	472.7	472.88	621285.0
2023-12-21 18:00:00	SPY	ETF	472.88	472.88	472.39	472.59	109538.0
2023-12-21 19:00:00	SPY	ETF	472.57	472.6	472.35	472.38	81687.0
2023-12-21 04:00:00	QQQ	ETF	405.01	406.31	405.0	406.04	48006.0
2023-12-21 05:00:00	QQQ	ETF	406.01	406.02	405.56	405.7	26007.0
2023-12-21 06:00:00	QQQ	ETF	405.79	406.07	405.71	405.85	34120.0
2023-12-21 07:00:00	QQQ	ETF	405.86	406.3	405.77	406.14	141287.0
2023-12-21 08:00:00	QQQ	ETF	405.8	408.16	405.06	407.5	1054001.0
2023-12-21 09:00:00	QQQ	ETF	407.46	407.92	403.08	406.34	5741934.0
2023-12-21 10:00:00	QQQ	ETF	406.32	407.27	405.14	405.865	5688154.0
2023-12-21 11:00:00	QQQ	ETF	405.85	407.005	405.58	406.02	4180241.0
2023-12-21 12:00:00	QQQ	ETF	406.02	406.02	404.725	405.0	3993170.0
2023-12-21 13:00:00	QQQ	ETF	405.005	406.08	404.47	406.06	3426180.0
2023-12-21 14:00:00	QQQ	ETF	406.07	406.72	405.69	406.16	3426755.0
2023-12-21 15:00:00	QQQ	ETF	406.17	408.14	405.89	407.79	7291846.0
2023-12-21 16:00:00	QQQ	ETF	407.78	407.88	403.08	407.75	957756.0
2023-12-21 17:00:00	QQQ	ETF	407.75	408.02	407.7	407.9	57741.0
2023-12-21 18:00:00	QQQ	ETF	407.85	407.9	407.351	407.53	83634.0
2023-12-21 19:00:00	QQQ	ETF	407.6	407.6	407.26	407.3	47402.0
2023-12-21 04:00:00	IWM	ETF	198.09	198.62	198.09	198.37	44592.0
2023-12-21 05:00:00	IWM	ETF	198.36	198.36	198.01	198.02	33231.0
2023-12-21 06:00:00	IWM	ETF	198.03	198.5	198.02	198.36	111101.0
2023-12-21 07:00:00	IWM	ETF	198.34	198.6	198.19	198.4	110449.0
2023-12-21 08:00:00	IWM	ETF	198.3799	199.21	197.91	198.6	593778.0
2023-12-21 09:00:00	IWM	ETF	198.59	199.68	198.29	198.55	5834702.0
2023-12-21 10:00:00	IWM	ETF	198.55	199.31	197.85	198.75	5515244.0
2023-12-21 11:00:00	IWM	ETF	198.7401	198.95	198.3	198.38	2619760.0
2023-12-21 12:00:00	IWM	ETF	198.38	198.51	197.71	198.05	3096890.0
2023-12-21 13:00:00	IWM	ETF	198.05	198.7	197.52	198.7	2676718.0
2023-12-21 14:00:00	IWM	ETF	198.68	198.81	198.21	198.52	2196561.0
2023-12-21 15:00:00	IWM	ETF	198.52	199.82	198.445	199.75	6851426.0
2023-12-21 16:00:00	IWM	ETF	199.62	199.8	199.61	199.7	708343.0
2023-12-21 17:00:00	IWM	ETF	199.6801	199.88	199.6701	199.76	46816.0
2023-12-21 18:00:00	IWM	ETF	199.73	199.73	199.52	199.56	67952.0
2023-12-21 19:00:00	IWM	ETF	199.5	199.62	199.41	199.46	39445.0
2023-12-21 04:00:00	DIA	ETF	372.5	372.82	372.5	372.81	3592.0
2023-12-21 05:00:00	DIA	ETF	372.62	372.62	372.58	372.58	796.0

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

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