PREVIEW / etf_30min / 2025-08-12

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-12.parquet
  size:    1.0 MB
  rows:    41,745

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-08-12 04:00:00	SPY	ETF	636.68	636.83	636.33	636.38	14761.0
2025-08-12 04:30:00	SPY	ETF	636.5	636.5	636.09	636.09	6730.0
2025-08-12 05:00:00	SPY	ETF	636.16	636.27	636.07	636.27	5703.0
2025-08-12 05:30:00	SPY	ETF	636.2	636.37	635.97	635.97	27131.0
2025-08-12 06:00:00	SPY	ETF	635.91	636.03	635.74	635.77	40465.0
2025-08-12 06:30:00	SPY	ETF	635.93	636.0	635.74	635.74	12727.0
2025-08-12 07:00:00	SPY	ETF	635.83	635.83	635.25	635.51	47692.0
2025-08-12 07:30:00	SPY	ETF	635.51	635.82	635.14	635.75	51441.0
2025-08-12 08:00:00	SPY	ETF	635.71	636.87	635.23	636.43	447070.0
2025-08-12 08:30:00	SPY	ETF	636.54	640.1	636.0	639.03	1489347.0
2025-08-12 09:00:00	SPY	ETF	639.19	639.24	637.85	638.25	518491.0
2025-08-12 09:30:00	SPY	ETF	638.28	639.875	636.97	637.34	8354753.0
2025-08-12 10:00:00	SPY	ETF	637.36	639.5506	636.79	639.29	4244260.0
2025-08-12 10:30:00	SPY	ETF	639.29	640.23	638.86	639.875	3183121.0
2025-08-12 11:00:00	SPY	ETF	639.87	641.03	639.825	640.48	3704564.0
2025-08-12 11:30:00	SPY	ETF	640.47	641.27	640.31	641.23	2601049.0
2025-08-12 12:00:00	SPY	ETF	641.23	641.5	640.86	641.3792	1773539.0
2025-08-12 12:30:00	SPY	ETF	641.38	641.99	641.37	641.7	1951056.0
2025-08-12 13:00:00	SPY	ETF	641.7	641.845	641.435	641.54	1549635.0
2025-08-12 13:30:00	SPY	ETF	641.535	642.145	641.425	642.06	1617313.0
2025-08-12 14:00:00	SPY	ETF	642.07	642.615	642.07	642.22	2148270.0
2025-08-12 14:30:00	SPY	ETF	642.23	642.3	641.975	642.035	1983534.0
2025-08-12 15:00:00	SPY	ETF	642.04	642.43	641.99	642.32	2309441.0
2025-08-12 15:30:00	SPY	ETF	642.315	642.85	641.98	642.64	8156070.0
2025-08-12 16:00:00	SPY	ETF	642.64	642.7597	642.44	642.65	2986706.0
2025-08-12 16:30:00	SPY	ETF	642.64	642.86	642.56	642.7995	143789.0
2025-08-12 17:00:00	SPY	ETF	642.72	642.72	642.5	642.54	16548.0
2025-08-12 17:30:00	SPY	ETF	642.54	642.54	642.35	642.42	33808.0
2025-08-12 18:00:00	SPY	ETF	642.43	642.6	642.3002	642.41	50613.0
2025-08-12 18:30:00	SPY	ETF	642.41	642.43	642.32	642.38	7424.0
2025-08-12 19:00:00	SPY	ETF	642.4199	642.6192	642.4199	642.56	12276.0
2025-08-12 19:30:00	SPY	ETF	642.56	643.1	642.45	643.06	53125.0
2025-08-12 04:00:00	QQQ	ETF	573.31	573.67	573.17	573.18	11201.0
2025-08-12 04:30:00	QQQ	ETF	573.27	573.3	572.84	572.94	11137.0
2025-08-12 05:00:00	QQQ	ETF	572.93	573.1	572.85	572.96	9603.0
2025-08-12 05:30:00	QQQ	ETF	573.0	573.22	572.86	572.86	8184.0
2025-08-12 06:00:00	QQQ	ETF	572.73	573.03	572.71	572.76	5775.0
2025-08-12 06:30:00	QQQ	ETF	572.89	572.98	572.74	572.77	3800.0
2025-08-12 07:00:00	QQQ	ETF	572.78	572.83	572.18	572.49	15686.0
2025-08-12 07:30:00	QQQ	ETF	572.47	572.96	572.27	572.95	46424.0
2025-08-12 08:00:00	QQQ	ETF	572.42	573.82	572.0	573.56	315394.0
2025-08-12 08:30:00	QQQ	ETF	573.87	577.24	573.6	576.12	646233.0
2025-08-12 09:00:00	QQQ	ETF	576.16	576.33	574.91	575.19	276272.0
2025-08-12 09:30:00	QQQ	ETF	575.16	576.94	573.14	573.26	5891134.0
2025-08-12 10:00:00	QQQ	ETF	573.28	575.85	572.485	575.65	3123382.0
2025-08-12 10:30:00	QQQ	ETF	575.65	576.32	575.15	576.21	1557092.0
2025-08-12 11:00:00	QQQ	ETF	576.21	578.22	576.135	577.56	2720386.0
2025-08-12 11:30:00	QQQ	ETF	577.56	578.47	577.27	578.4	1501949.0
2025-08-12 12:00:00	QQQ	ETF	578.398	578.77	577.8855	578.66	1010251.0
2025-08-12 12:30:00	QQQ	ETF	578.67	579.41	578.57	579.165	1223994.0

> showing 50 of 41,745 rows — these rows as CSV

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