PREVIEW / etf_30min / 2025-10-08

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-10-08.parquet
  size:    1.1 MB
  rows:    44,233

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
2025-10-08 04:00:00	SPY	ETF	670.11	670.28	670.02	670.25	10087.0
2025-10-08 04:30:00	SPY	ETF	670.3	670.44	669.65	669.92	15867.0
2025-10-08 05:00:00	SPY	ETF	670.07	670.18	669.88	669.98	6273.0
2025-10-08 05:30:00	SPY	ETF	670.16	670.22	670.08	670.12	3219.0
2025-10-08 06:00:00	SPY	ETF	670.1	670.1	669.5	669.96	3737.0
2025-10-08 06:30:00	SPY	ETF	670.02	670.38	670.02	670.38	5370.0
2025-10-08 07:00:00	SPY	ETF	670.4	670.56	669.72	669.72	68214.0
2025-10-08 07:30:00	SPY	ETF	669.76	670.4	669.76	670.34	102147.0
2025-10-08 08:00:00	SPY	ETF	670.08	670.55	668.93	669.96	128044.0
2025-10-08 08:30:00	SPY	ETF	669.93	670.16	669.63	670.03	54354.0
2025-10-08 09:00:00	SPY	ETF	670.08	670.58	669.91	670.3	102011.0
2025-10-08 09:30:00	SPY	ETF	670.26	670.59	669.42	670.28	6680816.0
2025-10-08 10:00:00	SPY	ETF	670.29	671.96	670.285	671.89	4546186.0
2025-10-08 10:30:00	SPY	ETF	671.885	672.165	671.34	671.76	3235663.0
2025-10-08 11:00:00	SPY	ETF	671.76	672.73	671.685	672.545	2843563.0
2025-10-08 11:30:00	SPY	ETF	672.54	672.96	672.36	672.77	2096914.0
2025-10-08 12:00:00	SPY	ETF	672.78	673.0985	672.55	672.64	1817933.0
2025-10-08 12:30:00	SPY	ETF	672.64	672.78	672.23	672.715	1458782.0
2025-10-08 13:00:00	SPY	ETF	672.71	673.03	672.44	672.895	1322649.0
2025-10-08 13:30:00	SPY	ETF	672.895	673.0	672.525	672.64	1596207.0
2025-10-08 14:00:00	SPY	ETF	672.64	673.14	672.47	672.8	2716312.0
2025-10-08 14:30:00	SPY	ETF	672.81	672.87	672.17	672.25	2184407.0
2025-10-08 15:00:00	SPY	ETF	672.24	673.01	672.15	672.895	3042039.0
2025-10-08 15:30:00	SPY	ETF	672.89	673.2056	672.66	673.07	7708395.0
2025-10-08 16:00:00	SPY	ETF	673.05	673.63	672.887	673.54	3085284.0
2025-10-08 16:30:00	SPY	ETF	673.5599	673.6	673.16	673.17	108468.0
2025-10-08 17:00:00	SPY	ETF	673.3	673.39	672.95	673.03	71560.0
2025-10-08 17:30:00	SPY	ETF	673.0389	673.09	673.03	673.05	6059.0
2025-10-08 18:00:00	SPY	ETF	673.1	673.58	673.1	673.5596	33848.0
2025-10-08 18:30:00	SPY	ETF	673.56	673.6	673.38	673.589	10534.0
2025-10-08 19:00:00	SPY	ETF	673.62	674.0488	673.47	674.0	12110.0
2025-10-08 19:30:00	SPY	ETF	673.95	673.98	673.65	673.78	22259.0
2025-10-08 04:00:00	QQQ	ETF	605.48	605.74	605.39	605.7	25134.0
2025-10-08 04:30:00	QQQ	ETF	605.8	606.14	604.8	605.54	73287.0
2025-10-08 05:00:00	QQQ	ETF	605.55	605.81	605.31	605.49	22231.0
2025-10-08 05:30:00	QQQ	ETF	605.43	605.75	605.35	605.58	22789.0
2025-10-08 06:00:00	QQQ	ETF	605.58	605.7	604.9	605.53	30816.0
2025-10-08 06:30:00	QQQ	ETF	605.55	605.84	605.49	605.83	24979.0
2025-10-08 07:00:00	QQQ	ETF	605.82	605.99	604.91	604.92	33002.0
2025-10-08 07:30:00	QQQ	ETF	604.95	605.71	604.94	605.64	48872.0
2025-10-08 08:00:00	QQQ	ETF	605.81	606.05	604.057	604.96	190593.0
2025-10-08 08:30:00	QQQ	ETF	604.99	605.22	604.58	604.95	92018.0
2025-10-08 09:00:00	QQQ	ETF	604.97	605.85	604.81	605.4	129962.0
2025-10-08 09:30:00	QQQ	ETF	605.41	607.81	605.26	607.58	5227251.0
2025-10-08 10:00:00	QQQ	ETF	607.59	608.945	607.59	608.63	4031692.0
2025-10-08 10:30:00	QQQ	ETF	608.61	608.83	607.585	608.095	2526224.0
2025-10-08 11:00:00	QQQ	ETF	608.1	609.35	608.02	609.1	2103930.0
2025-10-08 11:30:00	QQQ	ETF	609.08	609.685	608.94	609.538	1689789.0
2025-10-08 12:00:00	QQQ	ETF	609.54	610.06	609.36	609.4992	1761725.0
2025-10-08 12:30:00	QQQ	ETF	609.49	609.49	609.03	609.4696	1109941.0

> showing 50 of 44,233 rows — these rows as CSV

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