PREVIEW / etf_30min / 2023-12-26

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-26.parquet
  size:    772 KB
  rows:    30,295

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-26 04:00:00	SPY	ETF	474.41	474.54	474.03	474.3	11949.0
2023-12-26 04:30:00	SPY	ETF	474.35	474.39	474.3	474.31	1598.0
2023-12-26 05:00:00	SPY	ETF	474.32	474.35	474.29	474.29	2568.0
2023-12-26 05:30:00	SPY	ETF	474.37	474.45	474.36	474.45	3199.0
2023-12-26 06:00:00	SPY	ETF	474.45	474.49	474.14	474.22	4371.0
2023-12-26 06:30:00	SPY	ETF	474.31	474.38	474.27	474.27	3622.0
2023-12-26 07:00:00	SPY	ETF	474.23	474.23	473.83	474.04	24126.0
2023-12-26 07:30:00	SPY	ETF	474.04	474.27	474.04	474.27	11888.0
2023-12-26 08:00:00	SPY	ETF	474.2	474.64	473.83	474.27	83664.0
2023-12-26 08:30:00	SPY	ETF	474.28	474.34	474.0	474.25	49087.0
2023-12-26 09:00:00	SPY	ETF	474.25	474.32	474.04	474.09	81986.0
2023-12-26 09:30:00	SPY	ETF	474.08	474.81	473.99	474.67	3089150.0
2023-12-26 10:00:00	SPY	ETF	474.68	475.12	474.6	474.865	2421327.0
2023-12-26 10:30:00	SPY	ETF	474.87	475.19	474.53	474.9	1776923.0
2023-12-26 11:00:00	SPY	ETF	474.91	475.14	474.58	474.75	1545155.0
2023-12-26 11:30:00	SPY	ETF	474.745	475.13	474.73	475.0799	1402890.0
2023-12-26 12:00:00	SPY	ETF	475.08	475.23	474.88	475.07	1300661.0
2023-12-26 12:30:00	SPY	ETF	475.07	475.4	474.85	475.05	1471816.0
2023-12-26 13:00:00	SPY	ETF	475.06	475.46	475.0202	475.3113	1122637.0
2023-12-26 13:30:00	SPY	ETF	475.31	475.42	475.14	475.2	1142953.0
2023-12-26 14:00:00	SPY	ETF	475.2	475.57	475.1697	475.525	1490486.0
2023-12-26 14:30:00	SPY	ETF	475.53	475.78	475.47	475.7599	1728614.0
2023-12-26 15:00:00	SPY	ETF	475.76	476.58	475.62	476.2	3012637.0
2023-12-26 15:30:00	SPY	ETF	476.2	476.44	475.29	475.59	9905381.0
2023-12-26 16:00:00	SPY	ETF	475.59	475.79	475.5	475.58	2313877.0
2023-12-26 16:30:00	SPY	ETF	475.59	475.82	475.55	475.8	270116.0
2023-12-26 17:00:00	SPY	ETF	475.75	475.82	475.73	475.82	9578.0
2023-12-26 17:30:00	SPY	ETF	475.81	475.84	475.65	475.84	18970.0
2023-12-26 18:00:00	SPY	ETF	475.86	476.0797	475.83	475.92	22684.0
2023-12-26 18:30:00	SPY	ETF	475.95	475.95	475.79	475.79	7272.0
2023-12-26 19:00:00	SPY	ETF	475.82	475.83	475.6	475.6	15544.0
2023-12-26 19:30:00	SPY	ETF	475.62	475.66	475.57	475.59	15091.0
2023-12-26 04:00:00	QQQ	ETF	409.6	409.6	409.1	409.24	15912.0
2023-12-26 04:30:00	QQQ	ETF	409.29	409.43	409.26	409.33	4932.0
2023-12-26 05:00:00	QQQ	ETF	409.3	409.3	409.19	409.25	2254.0
2023-12-26 05:30:00	QQQ	ETF	409.24	409.45	409.24	409.37	4654.0
2023-12-26 06:00:00	QQQ	ETF	409.36	409.36	409.13	409.2	2072.0
2023-12-26 06:30:00	QQQ	ETF	409.26	409.35	409.26	409.32	1200.0
2023-12-26 07:00:00	QQQ	ETF	409.22	409.22	408.79	408.96	19595.0
2023-12-26 07:30:00	QQQ	ETF	409.02	409.4	409.02	409.37	31503.0
2023-12-26 08:00:00	QQQ	ETF	409.02	409.86	408.71	409.3	66251.0
2023-12-26 08:30:00	QQQ	ETF	409.24	409.24	408.96	409.14	28451.0
2023-12-26 09:00:00	QQQ	ETF	409.14	409.37	409.14	409.22	68554.0
2023-12-26 09:30:00	QQQ	ETF	409.25	410.24	409.15	409.97	2438689.0
2023-12-26 10:00:00	QQQ	ETF	409.98	410.32	409.842	410.01	1229333.0
2023-12-26 10:30:00	QQQ	ETF	410.03	410.415	409.53	409.9599	1088765.0
2023-12-26 11:00:00	QQQ	ETF	409.96	410.2095	409.59	409.865	794848.0
2023-12-26 11:30:00	QQQ	ETF	409.86	410.26	409.86	410.17	638242.0
2023-12-26 12:00:00	QQQ	ETF	410.16	410.292	409.94	410.016	625391.0
2023-12-26 12:30:00	QQQ	ETF	410.015	410.32	409.8201	410.04	685944.0

> showing 50 of 30,295 rows — these rows as CSV

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