PREVIEW / etf_30min / 2025-03-26

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-26.parquet
  size:    939 KB
  rows:    38,115

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-26 04:00:00	SPY	ETF	575.1	575.24	574.48	574.85	12798.0
2025-03-26 04:30:00	SPY	ETF	574.93	575.21	574.75	574.78	2963.0
2025-03-26 05:00:00	SPY	ETF	574.79	574.92	574.5	574.64	8650.0
2025-03-26 05:30:00	SPY	ETF	574.71	574.88	574.35	574.35	9741.0
2025-03-26 06:00:00	SPY	ETF	574.26	574.8	574.24	574.68	8483.0
2025-03-26 06:30:00	SPY	ETF	574.67	575.36	574.67	575.27	8499.0
2025-03-26 07:00:00	SPY	ETF	575.35	575.5	575.13	575.44	34142.0
2025-03-26 07:30:00	SPY	ETF	575.4	575.81	575.4	575.69	10888.0
2025-03-26 08:00:00	SPY	ETF	575.4	575.83	574.7596	575.29	51334.0
2025-03-26 08:30:00	SPY	ETF	575.39	575.94	574.99	575.72	81276.0
2025-03-26 09:00:00	SPY	ETF	575.72	575.94	574.9	575.17	145192.0
2025-03-26 09:30:00	SPY	ETF	575.19	576.33	573.33	573.63	3160180.0
2025-03-26 10:00:00	SPY	ETF	573.62	574.52	572.486	573.375	2740423.0
2025-03-26 10:30:00	SPY	ETF	573.37	573.83	572.87	573.44	1932498.0
2025-03-26 11:00:00	SPY	ETF	573.42	573.84	571.95	572.34	1196283.0
2025-03-26 11:30:00	SPY	ETF	572.315	572.79	570.12	570.66	2096861.0
2025-03-26 12:00:00	SPY	ETF	570.66	571.12	570.2048	571.07	1822566.0
2025-03-26 12:30:00	SPY	ETF	571.07	571.39	569.28	569.49	1627557.0
2025-03-26 13:00:00	SPY	ETF	569.49	570.1999	568.78	568.95	1683025.0
2025-03-26 13:30:00	SPY	ETF	568.965	569.28	567.94	568.0498	1882511.0
2025-03-26 14:00:00	SPY	ETF	568.06	569.49	567.96	569.2406	1612921.0
2025-03-26 14:30:00	SPY	ETF	569.22	569.48	567.2	567.41	1615133.0
2025-03-26 15:00:00	SPY	ETF	567.4	568.74	567.19	567.7	2414672.0
2025-03-26 15:30:00	SPY	ETF	567.71	569.58	567.61	568.74	7011535.0
2025-03-26 16:00:00	SPY	ETF	568.74	568.9438	568.2	568.33	3683888.0
2025-03-26 16:30:00	SPY	ETF	568.29	568.41	568.1	568.29	71876.0
2025-03-26 17:00:00	SPY	ETF	568.27	568.49	567.5	567.95	141532.0
2025-03-26 17:30:00	SPY	ETF	568.01	568.3	566.81	567.17	134930.0
2025-03-26 18:00:00	SPY	ETF	567.02	568.06	566.03	566.43	264351.0
2025-03-26 18:30:00	SPY	ETF	566.5	567.09	566.5	566.69	87490.0
2025-03-26 19:00:00	SPY	ETF	566.69	567.0	566.5	566.96	31542.0
2025-03-26 19:30:00	SPY	ETF	566.96	567.8	566.96	567.62	167401.0
2025-03-26 04:00:00	QQQ	ETF	493.28	494.0	492.37	492.86	18430.0
2025-03-26 04:30:00	QQQ	ETF	493.03	493.12	492.6	492.66	15151.0
2025-03-26 05:00:00	QQQ	ETF	492.68	492.93	492.48	492.68	16934.0
2025-03-26 05:30:00	QQQ	ETF	492.8	492.87	492.16	492.16	20432.0
2025-03-26 06:00:00	QQQ	ETF	492.15	492.7	492.1	492.58	11266.0
2025-03-26 06:30:00	QQQ	ETF	492.63	493.13	492.63	493.12	12246.0
2025-03-26 07:00:00	QQQ	ETF	493.18	493.26	492.83	493.18	53422.0
2025-03-26 07:30:00	QQQ	ETF	493.15	493.63	493.13	493.39	33958.0
2025-03-26 08:00:00	QQQ	ETF	493.24	493.67	492.6096	492.99	163701.0
2025-03-26 08:30:00	QQQ	ETF	492.93	493.35	492.63	493.28	66077.0
2025-03-26 09:00:00	QQQ	ETF	493.27	493.4	492.29	492.29	117187.0
2025-03-26 09:30:00	QQQ	ETF	492.3	493.16	489.11	489.3504	2896188.0
2025-03-26 10:00:00	QQQ	ETF	489.38	490.31	487.2101	488.6009	2752439.0
2025-03-26 10:30:00	QQQ	ETF	488.6	489.3	487.96	488.87	1358808.0
2025-03-26 11:00:00	QQQ	ETF	488.87	489.48	487.92	488.35	1169597.0
2025-03-26 11:30:00	QQQ	ETF	488.34	488.92	485.89	486.4	1672973.0
2025-03-26 12:00:00	QQQ	ETF	486.39	486.76	485.76	486.74	1607544.0
2025-03-26 12:30:00	QQQ	ETF	486.7	487.0	484.78	484.9401	1208500.0

> showing 50 of 38,115 rows — these rows as CSV

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