PREVIEW / etf_30min / 2025-09-23

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-09-23.parquet
  size:    1.0 MB
  rows:    43,805

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-09-23 04:00:00	SPY	ETF	666.57	667.18	666.0	667.09	34815.0
2025-09-23 04:30:00	SPY	ETF	667.09	667.1	666.8	666.8	2540.0
2025-09-23 05:00:00	SPY	ETF	666.74	666.91	666.69	666.81	3582.0
2025-09-23 05:30:00	SPY	ETF	666.88	666.98	666.88	666.94	800.0
2025-09-23 06:00:00	SPY	ETF	666.95	666.96	666.6	666.6	13976.0
2025-09-23 06:30:00	SPY	ETF	666.57	666.64	666.37	666.6	16570.0
2025-09-23 07:00:00	SPY	ETF	666.48	666.48	666.14	666.45	41072.0
2025-09-23 07:30:00	SPY	ETF	666.46	666.85	666.44	666.85	16027.0
2025-09-23 08:00:00	SPY	ETF	666.47	666.96	666.16	666.71	79922.0
2025-09-23 08:30:00	SPY	ETF	666.64	666.93	666.5	666.879	43803.0
2025-09-23 09:00:00	SPY	ETF	666.89	666.91	666.58	666.71	71283.0
2025-09-23 09:30:00	SPY	ETF	666.71	667.34	666.57	666.89	6020287.0
2025-09-23 10:00:00	SPY	ETF	666.9	667.245	666.36	666.62	4218998.0
2025-09-23 10:30:00	SPY	ETF	666.63	666.76	666.155	666.3153	2827836.0
2025-09-23 11:00:00	SPY	ETF	666.31	666.47	666.02	666.15	2111606.0
2025-09-23 11:30:00	SPY	ETF	666.15	666.24	665.49	665.55	2342135.0
2025-09-23 12:00:00	SPY	ETF	665.56	665.69	664.97	665.24	3238473.0
2025-09-23 12:30:00	SPY	ETF	665.235	665.84	664.88	665.155	3231700.0
2025-09-23 13:00:00	SPY	ETF	665.165	665.25	663.69	663.708	3486337.0
2025-09-23 13:30:00	SPY	ETF	663.7	663.85	662.035	663.23	6876297.0
2025-09-23 14:00:00	SPY	ETF	663.24	663.38	662.21	662.675	3565088.0
2025-09-23 14:30:00	SPY	ETF	662.65	663.3199	661.98	662.11	3350980.0
2025-09-23 15:00:00	SPY	ETF	662.1	662.81	662.09	662.3698	3466524.0
2025-09-23 15:30:00	SPY	ETF	662.37	663.54	662.29	663.23	9674742.0
2025-09-23 16:00:00	SPY	ETF	663.25	663.5392	663.0	663.34	2197207.0
2025-09-23 16:30:00	SPY	ETF	663.35	663.45	663.24	663.35	99069.0
2025-09-23 17:00:00	SPY	ETF	663.38	663.9	663.36	663.73	63395.0
2025-09-23 17:30:00	SPY	ETF	663.73	663.8	663.52	663.52	18109.0
2025-09-23 18:00:00	SPY	ETF	663.55	663.95	663.48	663.59	59377.0
2025-09-23 18:30:00	SPY	ETF	663.61	663.85	663.57	663.75	45521.0
2025-09-23 19:00:00	SPY	ETF	663.759	663.759	663.62	663.65	4399.0
2025-09-23 19:30:00	SPY	ETF	663.68	663.68	663.5301	663.55	6191.0
2025-09-23 04:00:00	QQQ	ETF	601.34	602.98	601.34	602.91	26974.0
2025-09-23 04:30:00	QQQ	ETF	602.82	602.89	602.44	602.44	17956.0
2025-09-23 05:00:00	QQQ	ETF	602.44	602.6	602.3	602.46	24325.0
2025-09-23 05:30:00	QQQ	ETF	602.47	602.7	602.41	602.63	18222.0
2025-09-23 06:00:00	QQQ	ETF	602.63	602.75	602.38	602.38	22905.0
2025-09-23 06:30:00	QQQ	ETF	602.33	602.5	602.11	602.43	24040.0
2025-09-23 07:00:00	QQQ	ETF	602.41	602.41	601.63	602.16	49922.0
2025-09-23 07:30:00	QQQ	ETF	602.19	602.43	602.07	602.36	16342.0
2025-09-23 08:00:00	QQQ	ETF	601.94	602.87	601.73	602.22	84788.0
2025-09-23 08:30:00	QQQ	ETF	602.16	602.57	601.97	602.57	59443.0
2025-09-23 09:00:00	QQQ	ETF	602.57	602.6	602.26	602.35	78672.0
2025-09-23 09:30:00	QQQ	ETF	602.37	602.57	600.69	600.87	5350154.0
2025-09-23 10:00:00	QQQ	ETF	600.89	601.41	600.62	601.19	3193076.0
2025-09-23 10:30:00	QQQ	ETF	601.21	601.7	600.81	600.97	2444144.0
2025-09-23 11:00:00	QQQ	ETF	600.97	601.57	600.675	601.3	1854833.0
2025-09-23 11:30:00	QQQ	ETF	601.3	601.39	600.61	601.0	1724233.0
2025-09-23 12:00:00	QQQ	ETF	601.0	601.2006	600.26	600.6501	2239308.0
2025-09-23 12:30:00	QQQ	ETF	600.65	601.15	600.3	600.58	2230516.0

> showing 50 of 43,805 rows — these rows as CSV

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