PREVIEW / etf_30min / 2025-09-09

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-09-09.parquet
  size:    1.0 MB
  rows:    42,226

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-09 04:00:00	SPY	ETF	649.75	649.86	649.43	649.72	9072.0
2025-09-09 04:30:00	SPY	ETF	649.71	649.71	649.37	649.46	2234.0
2025-09-09 05:00:00	SPY	ETF	649.62	650.1	649.41	649.66	6491.0
2025-09-09 05:30:00	SPY	ETF	649.62	649.66	649.37	649.47	48995.0
2025-09-09 06:00:00	SPY	ETF	649.56	649.62	649.55	649.56	500.0
2025-09-09 06:30:00	SPY	ETF	649.4	649.61	649.26	649.43	10531.0
2025-09-09 07:00:00	SPY	ETF	649.45	649.46	648.97	649.13	7094.0
2025-09-09 07:30:00	SPY	ETF	649.34	649.66	649.27	649.61	89118.0
2025-09-09 08:00:00	SPY	ETF	649.33	650.53	649.12	649.6	58568.0
2025-09-09 08:30:00	SPY	ETF	649.58	649.6	649.3	649.42	23268.0
2025-09-09 09:00:00	SPY	ETF	649.39	649.39	648.45	648.96	378486.0
2025-09-09 09:30:00	SPY	ETF	648.96	649.495	648.54	649.02	4303401.0
2025-09-09 10:00:00	SPY	ETF	649.02	649.73	648.43	648.755	4553771.0
2025-09-09 10:30:00	SPY	ETF	648.74	648.8051	647.22	648.325	4664526.0
2025-09-09 11:00:00	SPY	ETF	648.325	648.835	647.79	648.77	2557023.0
2025-09-09 11:30:00	SPY	ETF	648.76	648.825	648.04	648.265	2134716.0
2025-09-09 12:00:00	SPY	ETF	648.26	649.06	648.17	648.86	2202784.0
2025-09-09 12:30:00	SPY	ETF	648.855	649.21	648.765	649.04	1727858.0
2025-09-09 13:00:00	SPY	ETF	649.05	649.8	649.02	649.565	2491744.0
2025-09-09 13:30:00	SPY	ETF	649.565	649.98	649.48	649.795	1781297.0
2025-09-09 14:00:00	SPY	ETF	649.8	649.99	649.57	649.83	1852233.0
2025-09-09 14:30:00	SPY	ETF	649.84	650.1	649.615	649.86	2051365.0
2025-09-09 15:00:00	SPY	ETF	649.86	650.14	649.55	650.065	2377814.0
2025-09-09 15:30:00	SPY	ETF	650.065	650.86	649.695	650.33	6817252.0
2025-09-09 16:00:00	SPY	ETF	650.34	651.44	649.91	651.36	8841386.0
2025-09-09 16:30:00	SPY	ETF	651.36	651.8192	651.21	651.32	374094.0
2025-09-09 17:00:00	SPY	ETF	651.56	651.82	651.34	651.381	107851.0
2025-09-09 17:30:00	SPY	ETF	651.4	651.84	651.36	651.7	73796.0
2025-09-09 18:00:00	SPY	ETF	651.64	651.9	651.37	651.61	79032.0
2025-09-09 18:30:00	SPY	ETF	651.71	651.79	651.59	651.6694	36170.0
2025-09-09 19:00:00	SPY	ETF	651.57	651.58	650.8	650.98	104875.0
2025-09-09 19:30:00	SPY	ETF	650.96	651.3	650.9	651.09	34619.0
2025-09-09 04:00:00	QQQ	ETF	580.13	580.22	579.78	579.98	24283.0
2025-09-09 04:30:00	QQQ	ETF	580.01	580.13	579.65	579.88	15736.0
2025-09-09 05:00:00	QQQ	ETF	579.85	580.14	579.7	579.95	13427.0
2025-09-09 05:30:00	QQQ	ETF	579.99	580.17	579.86	579.88	12772.0
2025-09-09 06:00:00	QQQ	ETF	579.89	580.19	579.85	579.99	7700.0
2025-09-09 06:30:00	QQQ	ETF	579.98	580.24	579.76	579.89	16833.0
2025-09-09 07:00:00	QQQ	ETF	579.91	579.91	579.13	579.34	22536.0
2025-09-09 07:30:00	QQQ	ETF	579.44	580.05	579.44	580.05	22208.0
2025-09-09 08:00:00	QQQ	ETF	579.8	580.82	579.1682	580.08	99168.0
2025-09-09 08:30:00	QQQ	ETF	580.05	580.07	579.6694	579.78	41845.0
2025-09-09 09:00:00	QQQ	ETF	579.79	579.79	578.83	579.65	210821.0
2025-09-09 09:30:00	QQQ	ETF	579.67	580.2	578.84	579.2	4446220.0
2025-09-09 10:00:00	QQQ	ETF	579.2	580.03	578.35	579.08	3621201.0
2025-09-09 10:30:00	QQQ	ETF	579.07	579.11	577.04	578.49	4144332.0
2025-09-09 11:00:00	QQQ	ETF	578.48	578.9	577.66	578.43	2064118.0
2025-09-09 11:30:00	QQQ	ETF	578.43	579.11	577.685	578.43	1922593.0
2025-09-09 12:00:00	QQQ	ETF	578.44	579.63	578.38	579.25	1916132.0
2025-09-09 12:30:00	QQQ	ETF	579.26	579.535	578.97	579.32	961265.0

> showing 50 of 42,226 rows — these rows as CSV

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