PREVIEW / etf_30min / 2025-08-19

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-19.parquet
  size:    1009 KB
  rows:    41,274

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-19 04:00:00	SPY	ETF	642.63	642.83	642.41	642.65	4386.0
2025-08-19 04:30:00	SPY	ETF	642.61	643.0	642.61	642.99	2821.0
2025-08-19 05:00:00	SPY	ETF	643.0	643.35	642.97	643.34	17772.0
2025-08-19 05:30:00	SPY	ETF	643.33	643.33	643.05	643.05	5271.0
2025-08-19 06:00:00	SPY	ETF	643.01	643.01	642.63	642.91	15886.0
2025-08-19 06:30:00	SPY	ETF	642.96	642.96	642.5	642.67	9692.0
2025-08-19 07:00:00	SPY	ETF	642.66	642.83	642.66	642.8	6740.0
2025-08-19 07:30:00	SPY	ETF	642.75	643.28	642.67	643.23	33629.0
2025-08-19 08:00:00	SPY	ETF	643.21	643.33	642.0	643.23	81894.0
2025-08-19 08:30:00	SPY	ETF	643.27	643.34	642.74	642.85	99674.0
2025-08-19 09:00:00	SPY	ETF	642.81	643.09	642.66	643.07	142327.0
2025-08-19 09:30:00	SPY	ETF	643.12	643.43	641.99	642.87	5736301.0
2025-08-19 10:00:00	SPY	ETF	642.86	644.105	642.82	643.03	3748127.0
2025-08-19 10:30:00	SPY	ETF	643.04	643.54	641.21	641.215	4981202.0
2025-08-19 11:00:00	SPY	ETF	641.22	641.695	640.47	641.61	3457943.0
2025-08-19 11:30:00	SPY	ETF	641.61	641.91	640.62	640.75	2383680.0
2025-08-19 12:00:00	SPY	ETF	640.73	641.1	640.17	640.35	2277732.0
2025-08-19 12:30:00	SPY	ETF	640.36	640.625	639.331	639.67	2994456.0
2025-08-19 13:00:00	SPY	ETF	639.67	639.86	638.805	639.72	2881130.0
2025-08-19 13:30:00	SPY	ETF	639.71	640.11	639.625	639.83	1870375.0
2025-08-19 14:00:00	SPY	ETF	639.82	639.88	638.82	639.095	2310641.0
2025-08-19 14:30:00	SPY	ETF	639.095	639.28	638.66	639.1	2200264.0
2025-08-19 15:00:00	SPY	ETF	639.12	639.25	638.48	639.205	3731019.0
2025-08-19 15:30:00	SPY	ETF	639.21	639.91	638.715	639.77	7926993.0
2025-08-19 16:00:00	SPY	ETF	639.77	640.11	639.74	640.01	2810916.0
2025-08-19 16:30:00	SPY	ETF	640.0	640.03	639.77	640.01	67973.0
2025-08-19 17:00:00	SPY	ETF	639.98	640.04	639.84	639.9	49682.0
2025-08-19 17:30:00	SPY	ETF	639.9	639.9	639.65	639.7	31498.0
2025-08-19 18:00:00	SPY	ETF	639.72	640.19	639.5	639.5	232730.0
2025-08-19 18:30:00	SPY	ETF	639.5512	639.93	639.5512	639.8101	18107.0
2025-08-19 19:00:00	SPY	ETF	639.7407	639.88	638.94	639.48	25503.0
2025-08-19 19:30:00	SPY	ETF	639.44	639.44	639.0	639.2	66763.0
2025-08-19 20:00:00	SPY	ETF	639.22	639.22	639.22	639.22	500.0
2025-08-19 04:00:00	QQQ	ETF	576.75	576.92	576.07	576.48	12487.0
2025-08-19 04:30:00	QQQ	ETF	576.54	577.0	576.47	577.0	6927.0
2025-08-19 05:00:00	QQQ	ETF	576.91	577.36	576.88	577.27	6408.0
2025-08-19 05:30:00	QQQ	ETF	577.3	577.36	576.94	576.99	9665.0
2025-08-19 06:00:00	QQQ	ETF	576.98	576.98	576.64	576.78	12562.0
2025-08-19 06:30:00	QQQ	ETF	576.79	576.83	576.14	576.44	8454.0
2025-08-19 07:00:00	QQQ	ETF	576.41	576.59	576.28	576.46	17228.0
2025-08-19 07:30:00	QQQ	ETF	576.33	576.7	576.22	576.68	9053.0
2025-08-19 08:00:00	QQQ	ETF	576.46	577.31	575.67	576.73	45867.0
2025-08-19 08:30:00	QQQ	ETF	576.79	576.83	575.84	575.89	76755.0
2025-08-19 09:00:00	QQQ	ETF	575.93	576.37	575.74	576.37	114727.0
2025-08-19 09:30:00	QQQ	ETF	576.39	576.56	573.42	574.32	6156663.0
2025-08-19 10:00:00	QQQ	ETF	574.33	575.53	573.01	573.095	3076897.0
2025-08-19 10:30:00	QQQ	ETF	573.11	573.85	571.02	571.0399	4262361.0
2025-08-19 11:00:00	QQQ	ETF	571.03	572.12	570.39	571.96	3044869.0
2025-08-19 11:30:00	QQQ	ETF	571.95	572.175	571.3	571.46	1693071.0
2025-08-19 12:00:00	QQQ	ETF	571.45	571.91	570.41	570.84	1975335.0

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

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