PREVIEW / etf_30min / 2025-04-14

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-14.parquet
  size:    995 KB
  rows:    41,468

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-04-14 04:00:00	SPY	ETF	540.0	542.0	540.0	541.66	39940.0
2025-04-14 04:30:00	SPY	ETF	541.91	542.04	541.36	541.59	31037.0
2025-04-14 05:00:00	SPY	ETF	541.57	542.2	540.22	540.28	25662.0
2025-04-14 05:30:00	SPY	ETF	540.31	540.45	539.26	540.16	26534.0
2025-04-14 06:00:00	SPY	ETF	540.47	540.85	539.78	540.28	18059.0
2025-04-14 06:30:00	SPY	ETF	540.38	541.42	540.38	541.34	34140.0
2025-04-14 07:00:00	SPY	ETF	541.36	542.99	541.08	542.22	338481.0
2025-04-14 07:30:00	SPY	ETF	542.33	542.5	540.0	540.03	114766.0
2025-04-14 08:00:00	SPY	ETF	541.75	542.9	538.59	541.6	278213.0
2025-04-14 08:30:00	SPY	ETF	541.57	542.85	541.38	542.73	251073.0
2025-04-14 09:00:00	SPY	ETF	542.69	544.48	542.441	544.05	711460.0
2025-04-14 09:30:00	SPY	ETF	544.02	544.28	539.21	540.47	6892271.0
2025-04-14 10:00:00	SPY	ETF	540.63	543.49	539.71	542.12	3666431.0
2025-04-14 10:30:00	SPY	ETF	542.14	543.85	541.63	542.42	2525981.0
2025-04-14 11:00:00	SPY	ETF	542.435	543.09	538.43	538.52	3208795.0
2025-04-14 11:30:00	SPY	ETF	538.64	539.93	535.23	535.74	4402210.0
2025-04-14 12:00:00	SPY	ETF	535.725	537.85	533.86	535.85	4575386.0
2025-04-14 12:30:00	SPY	ETF	535.82	537.92	535.37	535.52	2204422.0
2025-04-14 13:00:00	SPY	ETF	535.6	539.23	535.29	537.3	2678685.0
2025-04-14 13:30:00	SPY	ETF	537.26	539.45	536.49	538.97	1896124.0
2025-04-14 14:00:00	SPY	ETF	538.95	540.51	538.81	540.38	1967506.0
2025-04-14 14:30:00	SPY	ETF	540.38	541.31	540.05	540.73	2240165.0
2025-04-14 15:00:00	SPY	ETF	540.77	542.58	540.64	541.33	3142839.0
2025-04-14 15:30:00	SPY	ETF	541.32	542.15	538.36	538.97	7973949.0
2025-04-14 16:00:00	SPY	ETF	538.98	539.47	535.39	536.47	2980820.0
2025-04-14 16:30:00	SPY	ETF	536.6	538.1773	536.55	538.05	258162.0
2025-04-14 17:00:00	SPY	ETF	538.06	538.18	537.53	537.8	54149.0
2025-04-14 17:30:00	SPY	ETF	537.85	538.45	537.85	538.2	91815.0
2025-04-14 18:00:00	SPY	ETF	538.15	538.21	536.6492	536.6492	191064.0
2025-04-14 18:30:00	SPY	ETF	536.63	537.11	536.22	536.3	56796.0
2025-04-14 19:00:00	SPY	ETF	536.34	537.32	536.29	537.19	30601.0
2025-04-14 19:30:00	SPY	ETF	537.2122	537.5	536.56	536.9	41577.0
2025-04-14 04:00:00	QQQ	ETF	462.66	463.24	461.22	462.27	145153.0
2025-04-14 04:30:00	QQQ	ETF	462.4	462.5	461.63	461.79	40251.0
2025-04-14 05:00:00	QQQ	ETF	461.77	462.34	460.5	460.5	32771.0
2025-04-14 05:30:00	QQQ	ETF	460.69	460.72	459.5	460.44	55412.0
2025-04-14 06:00:00	QQQ	ETF	460.54	461.0	460.0	460.57	27265.0
2025-04-14 06:30:00	QQQ	ETF	460.68	461.39	460.64	461.36	32185.0
2025-04-14 07:00:00	QQQ	ETF	461.42	463.09	461.26	462.67	154267.0
2025-04-14 07:30:00	QQQ	ETF	462.65	462.67	460.6	460.68	219925.0
2025-04-14 08:00:00	QQQ	ETF	461.61	462.8296	454.06	462.25	283125.0
2025-04-14 08:30:00	QQQ	ETF	462.29	463.59	462.07	463.37	184343.0
2025-04-14 09:00:00	QQQ	ETF	463.13	465.06	463.1	464.53	539127.0
2025-04-14 09:30:00	QQQ	ETF	464.46	465.05	458.6318	460.03	4720099.0
2025-04-14 10:00:00	QQQ	ETF	460.07	463.16	459.665	462.17	2373690.0
2025-04-14 10:30:00	QQQ	ETF	462.21	463.55	461.69	462.0236	1739673.0
2025-04-14 11:00:00	QQQ	ETF	461.99	462.56	457.53	457.6	2276757.0
2025-04-14 11:30:00	QQQ	ETF	457.63	458.72	454.17	454.7501	2584716.0
2025-04-14 12:00:00	QQQ	ETF	454.81	456.46	452.63	454.47	2466343.0
2025-04-14 12:30:00	QQQ	ETF	454.465	456.4	453.65	453.72	1242565.0

> showing 50 of 41,468 rows — these rows as CSV

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