PREVIEW / etf_30min / 2025-03-25

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-25.parquet
  size:    943 KB
  rows:    38,040

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-25 04:00:00	SPY	ETF	573.52	573.54	572.91	573.18	14760.0
2025-03-25 04:30:00	SPY	ETF	573.14	573.49	573.1	573.27	5097.0
2025-03-25 05:00:00	SPY	ETF	573.15	573.47	572.99	573.44	7484.0
2025-03-25 05:30:00	SPY	ETF	573.29	573.82	573.29	573.82	2895.0
2025-03-25 06:00:00	SPY	ETF	573.83	574.25	573.28	574.17	15440.0
2025-03-25 06:30:00	SPY	ETF	574.18	574.56	574.09	574.56	10806.0
2025-03-25 07:00:00	SPY	ETF	574.52	574.91	573.95	574.75	78084.0
2025-03-25 07:30:00	SPY	ETF	574.78	575.59	574.69	575.56	47406.0
2025-03-25 08:00:00	SPY	ETF	574.65	575.69	573.29	575.64	121547.0
2025-03-25 08:30:00	SPY	ETF	575.68	576.03	575.3	575.3781	184047.0
2025-03-25 09:00:00	SPY	ETF	575.32	575.9303	575.09	575.29	105982.0
2025-03-25 09:30:00	SPY	ETF	575.3	575.655	574.02	574.66	3029677.0
2025-03-25 10:00:00	SPY	ETF	574.7	575.81	573.94	575.8	2412971.0
2025-03-25 10:30:00	SPY	ETF	575.8	576.41	575.37	575.99	1940151.0
2025-03-25 11:00:00	SPY	ETF	575.97	576.21	575.585	575.69	1091059.0
2025-03-25 11:30:00	SPY	ETF	575.7	575.76	574.56	574.7599	1225055.0
2025-03-25 12:00:00	SPY	ETF	574.76	574.99	574.4	574.5399	990793.0
2025-03-25 12:30:00	SPY	ETF	574.53	575.09	574.17	574.955	939648.0
2025-03-25 13:00:00	SPY	ETF	574.96	575.54	574.02	574.18	1239767.0
2025-03-25 13:30:00	SPY	ETF	574.19	574.69	574.09	574.125	1087773.0
2025-03-25 14:00:00	SPY	ETF	574.12	574.9499	573.8	574.41	1437766.0
2025-03-25 14:30:00	SPY	ETF	574.42	574.57	573.69	573.9392	1431059.0
2025-03-25 15:00:00	SPY	ETF	573.88	574.61	573.88	574.11	1674261.0
2025-03-25 15:30:00	SPY	ETF	574.11	575.6	573.87	575.36	4861072.0
2025-03-25 16:00:00	SPY	ETF	575.35	575.81	574.71	575.81	2996590.0
2025-03-25 16:30:00	SPY	ETF	575.8	575.94	575.7501	575.89	127282.0
2025-03-25 17:00:00	SPY	ETF	575.88	576.02	575.77	575.91	41342.0
2025-03-25 17:30:00	SPY	ETF	576.01	576.01	575.82	575.82	16056.0
2025-03-25 18:00:00	SPY	ETF	575.9	576.19	575.8298	575.8698	39277.0
2025-03-25 18:30:00	SPY	ETF	575.83	575.84	575.66	575.74	18054.0
2025-03-25 19:00:00	SPY	ETF	575.77	575.9	575.77	575.8301	11910.0
2025-03-25 19:30:00	SPY	ETF	575.82	576.18	575.79	576.0	28597.0
2025-03-25 04:00:00	QQQ	ETF	489.95	490.22	488.77	488.97	46522.0
2025-03-25 04:30:00	QQQ	ETF	488.84	489.43	488.77	489.09	40611.0
2025-03-25 05:00:00	QQQ	ETF	489.0	489.49	488.83	489.3	17945.0
2025-03-25 05:30:00	QQQ	ETF	489.27	489.99	489.26	489.91	15516.0
2025-03-25 06:00:00	QQQ	ETF	489.9	490.5	489.46	490.27	24333.0
2025-03-25 06:30:00	QQQ	ETF	490.37	490.9	490.22	490.73	14410.0
2025-03-25 07:00:00	QQQ	ETF	490.7	491.2	490.46	491.0	71129.0
2025-03-25 07:30:00	QQQ	ETF	490.98	491.7	490.82	491.55	36847.0
2025-03-25 08:00:00	QQQ	ETF	491.1	491.9	488.8404	491.84	151415.0
2025-03-25 08:30:00	QQQ	ETF	491.85	492.42	491.42	491.46	116299.0
2025-03-25 09:00:00	QQQ	ETF	491.45	492.15	491.23	491.41	132990.0
2025-03-25 09:30:00	QQQ	ETF	491.39	492.005	490.42	491.5912	2907816.0
2025-03-25 10:00:00	QQQ	ETF	491.7	492.6497	490.645	492.6497	1800148.0
2025-03-25 10:30:00	QQQ	ETF	492.65	493.51	491.8801	493.1888	1604584.0
2025-03-25 11:00:00	QQQ	ETF	493.16	493.62	492.92	493.13	812800.0
2025-03-25 11:30:00	QQQ	ETF	493.15	493.1769	492.11	492.36	929129.0
2025-03-25 12:00:00	QQQ	ETF	492.35	492.77	492.01	492.11	967393.0
2025-03-25 12:30:00	QQQ	ETF	492.11	492.81	491.75	492.545	853707.0

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

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