PREVIEW / etf_30min / 2025-03-21

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-21.parquet
  size:    924 KB
  rows:    37,299

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-03-21 04:00:00	SPY	ETF	563.09	563.84	561.72	561.8	34569.0
2025-03-21 04:30:00	SPY	ETF	561.71	562.03	561.32	562.02	12636.0
2025-03-21 05:00:00	SPY	ETF	561.88	562.08	561.53	561.96	8840.0
2025-03-21 05:30:00	SPY	ETF	561.9	562.46	561.9	562.14	12942.0
2025-03-21 06:00:00	SPY	ETF	562.44	563.11	562.44	562.63	4892.0
2025-03-21 06:30:00	SPY	ETF	562.57	562.65	561.7	562.5	117274.0
2025-03-21 07:00:00	SPY	ETF	562.47	562.87	562.24	562.87	48076.0
2025-03-21 07:30:00	SPY	ETF	562.82	563.01	562.06	562.3	58401.0
2025-03-21 08:00:00	SPY	ETF	562.25	564.35	561.5796	562.15	149826.0
2025-03-21 08:30:00	SPY	ETF	562.12	562.21	559.32	559.48	404622.0
2025-03-21 09:00:00	SPY	ETF	559.35	559.5	558.04	559.27	873292.0
2025-03-21 09:30:00	SPY	ETF	559.29	560.32	558.27	559.841	5340589.0
2025-03-21 10:00:00	SPY	ETF	559.85	560.4	558.03	559.88	2226166.0
2025-03-21 10:30:00	SPY	ETF	559.9	561.48	559.04	561.47	1851849.0
2025-03-21 11:00:00	SPY	ETF	561.47	561.81	559.68	559.83	1661205.0
2025-03-21 11:30:00	SPY	ETF	559.82	560.5799	558.8	559.44	1285798.0
2025-03-21 12:00:00	SPY	ETF	559.37	562.69	558.76	562.3626	2872786.0
2025-03-21 12:30:00	SPY	ETF	562.38	563.685	561.76	563.6504	1856066.0
2025-03-21 13:00:00	SPY	ETF	563.65	563.65	561.8969	562.07	1348557.0
2025-03-21 13:30:00	SPY	ETF	562.1	563.93	561.52	562.905	1634194.0
2025-03-21 14:00:00	SPY	ETF	562.905	563.3062	562.05	562.11	1673360.0
2025-03-21 14:30:00	SPY	ETF	562.12	563.29	562.1	562.49	1585321.0
2025-03-21 15:00:00	SPY	ETF	562.495	562.6	561.48	561.99	2099577.0
2025-03-21 15:30:00	SPY	ETF	561.97	564.89	561.7301	564.19	10551938.0
2025-03-21 16:00:00	SPY	ETF	564.2	564.72	563.94	564.4399	5502671.0
2025-03-21 16:30:00	SPY	ETF	564.46	564.8	564.351	564.59	165374.0
2025-03-21 17:00:00	SPY	ETF	564.56	564.98	564.56	564.96	94183.0
2025-03-21 17:30:00	SPY	ETF	564.91	564.96	564.81	564.8892	23384.0
2025-03-21 18:00:00	SPY	ETF	564.9	565.04	564.86	565.03	16550.0
2025-03-21 18:30:00	SPY	ETF	565.03	565.1	565.0	565.04	12149.0
2025-03-21 19:00:00	SPY	ETF	565.074	565.08	564.847	564.85	12612.0
2025-03-21 19:30:00	SPY	ETF	564.99	565.11	564.7	565.0	36821.0
2025-03-21 04:00:00	QQQ	ETF	478.54	479.21	477.15	477.21	23531.0
2025-03-21 04:30:00	QQQ	ETF	477.0	477.5	476.67	477.39	23401.0
2025-03-21 05:00:00	QQQ	ETF	477.22	477.38	476.63	477.32	19554.0
2025-03-21 05:30:00	QQQ	ETF	477.3	477.93	477.25	477.38	16133.0
2025-03-21 06:00:00	QQQ	ETF	477.48	478.51	477.39	477.89	21283.0
2025-03-21 06:30:00	QQQ	ETF	477.76	477.76	476.83	477.49	21887.0
2025-03-21 07:00:00	QQQ	ETF	477.45	478.01	477.3	477.91	37909.0
2025-03-21 07:30:00	QQQ	ETF	478.03	478.15	477.25	477.4	54588.0
2025-03-21 08:00:00	QQQ	ETF	477.53	479.62	476.6804	477.37	162902.0
2025-03-21 08:30:00	QQQ	ETF	477.42	477.4498	474.55	474.72	342169.0
2025-03-21 09:00:00	QQQ	ETF	474.6	474.73	472.92	474.15	676286.0
2025-03-21 09:30:00	QQQ	ETF	474.09	476.34	472.905	475.52	3698798.0
2025-03-21 10:00:00	QQQ	ETF	475.56	476.82	474.21	476.16	2160524.0
2025-03-21 10:30:00	QQQ	ETF	476.17	477.39	474.96	477.34	1461776.0
2025-03-21 11:00:00	QQQ	ETF	477.39	477.77	475.3107	475.5	1292912.0
2025-03-21 11:30:00	QQQ	ETF	475.42	476.25	474.59	475.34	1467745.0
2025-03-21 12:00:00	QQQ	ETF	475.31	479.08	474.6	478.52	2121438.0
2025-03-21 12:30:00	QQQ	ETF	478.53	479.74	477.95	479.72	1465136.0

> showing 50 of 37,299 rows — these rows as CSV

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