PREVIEW / etf_30min / 2026-08-17

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-08-17.parquet
  size:    1.1 MB
  rows:    47,148

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
2026-08-17 04:00:00	SPY	ETF	777.27	777.88	777.0	777.48	41303.0
2026-08-17 04:30:00	SPY	ETF	777.47	777.53	777.21	777.47	4647.0
2026-08-17 05:00:00	SPY	ETF	777.53	777.61	777.33	777.33	5288.0
2026-08-17 05:30:00	SPY	ETF	777.35	777.53	777.26	777.26	4911.0
2026-08-17 06:00:00	SPY	ETF	777.37	778.2	777.11	778.16	20913.0
2026-08-17 06:30:00	SPY	ETF	778.17	778.23	777.36	777.52	7973.0
2026-08-17 07:00:00	SPY	ETF	777.47	777.65	777.2	777.34	75206.0
2026-08-17 07:30:00	SPY	ETF	777.34	777.4898	777.12	777.15	69711.0
2026-08-17 08:00:00	SPY	ETF	777.17	777.31	776.39	776.6104	129988.0
2026-08-17 08:30:00	SPY	ETF	776.62	776.78	776.0	776.19	129099.0
2026-08-17 09:00:00	SPY	ETF	776.2	776.62	776.15	776.16	121694.0
2026-08-17 09:30:00	SPY	ETF	776.18	776.775	775.18	775.2906	2361412.0
2026-08-17 10:00:00	SPY	ETF	775.265	775.77	775.0	775.46	1544164.0
2026-08-17 10:30:00	SPY	ETF	775.45	775.5899	774.89	775.27	1630520.0
2026-08-17 11:00:00	SPY	ETF	775.27	775.86	775.15	775.715	1108980.0
2026-08-17 11:30:00	SPY	ETF	775.715	775.82	774.71	775.3	1226228.0
2026-08-17 12:00:00	SPY	ETF	775.295	775.61	775.06	775.29	859646.0
2026-08-17 12:30:00	SPY	ETF	775.3	775.41	774.61	774.68	928122.0
2026-08-17 13:00:00	SPY	ETF	774.67	774.78	773.47	773.58	1683743.0
2026-08-17 13:30:00	SPY	ETF	773.57	773.86	773.1	773.41	1561932.0
2026-08-17 14:00:00	SPY	ETF	773.42	773.8	773.28	773.59	1578855.0
2026-08-17 14:30:00	SPY	ETF	773.58	773.82	773.23	773.535	1115098.0
2026-08-17 15:00:00	SPY	ETF	773.535	773.59	773.12	773.12	1689958.0
2026-08-17 15:30:00	SPY	ETF	773.13	773.36	772.51	772.68	6377478.0
2026-08-17 16:00:00	SPY	ETF	772.67	772.8	772.23	772.4748	1912021.0
2026-08-17 16:30:00	SPY	ETF	772.47	772.5	772.22	772.4	218804.0
2026-08-17 17:00:00	SPY	ETF	772.41	772.67	772.4	772.55	34491.0
2026-08-17 17:30:00	SPY	ETF	772.49	772.67	772.39	772.5338	601135.0
2026-08-17 18:00:00	SPY	ETF	772.54	772.71	772.17	772.47	49508.0
2026-08-17 18:30:00	SPY	ETF	772.44	772.49	772.3	772.44	4189.0
2026-08-17 19:00:00	SPY	ETF	772.31	772.4194	772.24	772.34	34814.0
2026-08-17 19:30:00	SPY	ETF	772.4	772.7	772.32	772.7	28722.0
2026-08-17 04:00:00	QQQ	ETF	735.21	735.64	733.34	735.24	141891.0
2026-08-17 04:30:00	QQQ	ETF	735.25	735.32	734.59	734.85	20007.0
2026-08-17 05:00:00	QQQ	ETF	734.85	734.85	734.2	734.2555	32127.0
2026-08-17 05:30:00	QQQ	ETF	734.28	734.665	734.14	734.45	18807.0
2026-08-17 06:00:00	QQQ	ETF	734.4	735.86	734.32	735.77	56116.0
2026-08-17 06:30:00	QQQ	ETF	735.805	735.83	734.75	735.15	22664.0
2026-08-17 07:00:00	QQQ	ETF	735.23	735.43	734.59	734.81	148914.0
2026-08-17 07:30:00	QQQ	ETF	734.78	735.1	734.54	734.54	53112.0
2026-08-17 08:00:00	QQQ	ETF	734.59	734.59	730.522	733.39	119955.0
2026-08-17 08:30:00	QQQ	ETF	733.33	733.65	732.0	732.52	139321.0
2026-08-17 09:00:00	QQQ	ETF	732.56	733.36	732.49	732.93	138652.0
2026-08-17 09:30:00	QQQ	ETF	732.93	734.08	731.64	733.3	2473458.0
2026-08-17 10:00:00	QQQ	ETF	733.3395	733.5	731.51	732.44	1701304.0
2026-08-17 10:30:00	QQQ	ETF	732.45	733.62	732.19	733.56	1324843.0
2026-08-17 11:00:00	QQQ	ETF	733.57	734.58	733.33	734.18	1933462.0
2026-08-17 11:30:00	QQQ	ETF	734.2	734.28	732.73	733.4999	1171541.0
2026-08-17 12:00:00	QQQ	ETF	733.47	733.55	732.37	732.7	1145548.0
2026-08-17 12:30:00	QQQ	ETF	732.7	732.835	731.9513	732.135	952365.0

> showing 50 of 47,148 rows — these rows as CSV

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