PREVIEW / etf_30min / 2025-10-14

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-10-14.parquet
  size:    1.1 MB
  rows:    45,125

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-14 04:00:00	SPY	ETF	659.83	659.83	656.49	657.98	74119.0
2025-10-14 04:30:00	SPY	ETF	658.02	658.63	657.39	658.53	49625.0
2025-10-14 05:00:00	SPY	ETF	658.59	658.9	657.96	658.05	37730.0
2025-10-14 05:30:00	SPY	ETF	658.13	658.13	657.23	657.44	31417.0
2025-10-14 06:00:00	SPY	ETF	657.26	657.4	656.1	656.14	56279.0
2025-10-14 06:30:00	SPY	ETF	656.05	656.18	654.52	655.53	154060.0
2025-10-14 07:00:00	SPY	ETF	655.66	657.5	655.49	656.97	153184.0
2025-10-14 07:30:00	SPY	ETF	656.95	658.0	656.83	657.7	103944.0
2025-10-14 08:00:00	SPY	ETF	655.655	662.96	654.61	657.43	205451.0
2025-10-14 08:30:00	SPY	ETF	657.43	657.46	655.41	656.88	440067.0
2025-10-14 09:00:00	SPY	ETF	656.8863	657.64	656.6	657.18	318900.0
2025-10-14 09:30:00	SPY	ETF	657.18	657.41	653.17	656.82	9816803.0
2025-10-14 10:00:00	SPY	ETF	656.8	659.91	656.49	659.79	6008820.0
2025-10-14 10:30:00	SPY	ETF	659.78	660.32	659.0408	659.745	3323613.0
2025-10-14 11:00:00	SPY	ETF	659.76	661.11	659.49	659.675	2531867.0
2025-10-14 11:30:00	SPY	ETF	659.68	663.08	659.64	662.385	4095167.0
2025-10-14 12:00:00	SPY	ETF	662.41	663.96	661.44	663.635	3179612.0
2025-10-14 12:30:00	SPY	ETF	663.64	665.64	663.57	664.37	3430958.0
2025-10-14 13:00:00	SPY	ETF	664.36	665.58	663.65	665.35	2266122.0
2025-10-14 13:30:00	SPY	ETF	665.34	665.83	664.39	665.13	2111315.0
2025-10-14 14:00:00	SPY	ETF	665.15	665.37	664.601	665.12	2217738.0
2025-10-14 14:30:00	SPY	ETF	665.11	665.35	664.452	664.9	1822010.0
2025-10-14 15:00:00	SPY	ETF	664.91	665.36	664.64	664.79	2441386.0
2025-10-14 15:30:00	SPY	ETF	664.79	664.8	660.28	662.2	15095468.0
2025-10-14 16:00:00	SPY	ETF	662.2	662.98	660.89	661.32	2388647.0
2025-10-14 16:30:00	SPY	ETF	661.29	662.22	661.29	662.04	285264.0
2025-10-14 17:00:00	SPY	ETF	662.11	662.25	661.86	662.1	79470.0
2025-10-14 17:30:00	SPY	ETF	662.02	662.22	662.02	662.21	14971.0
2025-10-14 18:00:00	SPY	ETF	662.13	663.37	662.13	662.52	88618.0
2025-10-14 18:30:00	SPY	ETF	662.7	662.7387	662.27	662.66	17625.0
2025-10-14 19:00:00	SPY	ETF	662.69	663.48	662.54	663.01	42559.0
2025-10-14 19:30:00	SPY	ETF	663.0	663.09	662.595	662.595	17637.0
2025-10-14 04:00:00	QQQ	ETF	598.5	598.83	594.08	595.74	105574.0
2025-10-14 04:30:00	QQQ	ETF	595.81	596.69	595.21	596.51	76054.0
2025-10-14 05:00:00	QQQ	ETF	596.55	596.99	595.83	595.9	76835.0
2025-10-14 05:30:00	QQQ	ETF	596.07	596.28	595.0	595.22	111966.0
2025-10-14 06:00:00	QQQ	ETF	595.28	595.35	593.72	593.84	97919.0
2025-10-14 06:30:00	QQQ	ETF	593.81	593.82	592.0	593.28	241282.0
2025-10-14 07:00:00	QQQ	ETF	593.36	595.14	593.04	594.73	244214.0
2025-10-14 07:30:00	QQQ	ETF	594.64	595.9	594.56	595.67	139430.0
2025-10-14 08:00:00	QQQ	ETF	593.365	601.85	592.04	595.62	493202.0
2025-10-14 08:30:00	QQQ	ETF	595.63	595.63	593.32	594.74	329110.0
2025-10-14 09:00:00	QQQ	ETF	594.8	595.68	594.5298	595.34	453838.0
2025-10-14 09:30:00	QQQ	ETF	595.3	595.33	590.13	593.8	5604810.0
2025-10-14 10:00:00	QQQ	ETF	593.77	597.38	593.34	597.3	2887285.0
2025-10-14 10:30:00	QQQ	ETF	597.29	597.8199	596.04	596.52	2545445.0
2025-10-14 11:00:00	QQQ	ETF	596.56	598.39	596.39	596.84	1945537.0
2025-10-14 11:30:00	QQQ	ETF	596.86	600.07	596.8	599.27	2955682.0
2025-10-14 12:00:00	QQQ	ETF	599.29	601.02	598.25	600.87	2133696.0
2025-10-14 12:30:00	QQQ	ETF	600.868	602.69	600.82	601.355	2475817.0

> showing 50 of 45,125 rows — these rows as CSV

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