PREVIEW / etf_30min / 2025-04-23

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-23.parquet
  size:    979 KB
  rows:    41,083

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-23 04:00:00	SPY	ETF	536.79	537.65	536.5	537.5	67215.0
2025-04-23 04:30:00	SPY	ETF	537.54	538.74	537.5	537.95	30323.0
2025-04-23 05:00:00	SPY	ETF	538.0	538.49	537.94	537.96	73250.0
2025-04-23 05:30:00	SPY	ETF	537.97	538.17	537.26	538.01	47974.0
2025-04-23 06:00:00	SPY	ETF	538.0	539.0	538.0	538.98	80314.0
2025-04-23 06:30:00	SPY	ETF	538.91	540.48	538.72	540.17	103313.0
2025-04-23 07:00:00	SPY	ETF	540.12	540.7	539.3	539.35	187203.0
2025-04-23 07:30:00	SPY	ETF	539.25	539.63	538.56	538.57	212487.0
2025-04-23 08:00:00	SPY	ETF	540.17	540.66	534.37	539.36	308206.0
2025-04-23 08:30:00	SPY	ETF	539.32	541.0	539.2	540.99	271928.0
2025-04-23 09:00:00	SPY	ETF	540.95	540.95	539.07	540.44	376464.0
2025-04-23 09:30:00	SPY	ETF	540.43	544.99	539.51	543.56	13588030.0
2025-04-23 10:00:00	SPY	ETF	543.595	545.43	540.75	543.88	5668607.0
2025-04-23 10:30:00	SPY	ETF	543.82	545.2	542.25	542.555	2690061.0
2025-04-23 11:00:00	SPY	ETF	542.54	543.77	537.67	538.6	5192537.0
2025-04-23 11:30:00	SPY	ETF	538.59	539.51	535.57	537.43	4327364.0
2025-04-23 12:00:00	SPY	ETF	537.42	537.58	534.0	536.3	3428135.0
2025-04-23 12:30:00	SPY	ETF	536.3	538.6444	535.79	538.22	2883356.0
2025-04-23 13:00:00	SPY	ETF	538.2	539.59	536.19	538.2	2187835.0
2025-04-23 13:30:00	SPY	ETF	538.21	538.99	536.34	538.36	2193863.0
2025-04-23 14:00:00	SPY	ETF	538.34	538.89	536.26	536.57	2776636.0
2025-04-23 14:30:00	SPY	ETF	536.57	537.73	535.8	536.36	2178907.0
2025-04-23 15:00:00	SPY	ETF	536.36	537.02	534.1	534.63	3017782.0
2025-04-23 15:30:00	SPY	ETF	534.71	537.17	533.88	535.41	9542432.0
2025-04-23 16:00:00	SPY	ETF	535.38	538.83	535.2	537.88	4318580.0
2025-04-23 16:30:00	SPY	ETF	537.86	538.35	536.84	536.9	440909.0
2025-04-23 17:00:00	SPY	ETF	536.93	537.85	536.8033	537.05	224515.0
2025-04-23 17:30:00	SPY	ETF	537.1	537.1	535.5	535.94	116224.0
2025-04-23 18:00:00	SPY	ETF	536.31	536.68	534.46	535.2317	100444.0
2025-04-23 18:30:00	SPY	ETF	535.23	536.3298	535.213	536.1104	38369.0
2025-04-23 19:00:00	SPY	ETF	536.0	537.05	535.98	536.5601	39857.0
2025-04-23 19:30:00	SPY	ETF	536.3	536.94	535.92	536.7	26274.0
2025-04-23 04:00:00	QQQ	ETF	453.21	455.37	453.0	454.92	175929.0
2025-04-23 04:30:00	QQQ	ETF	454.96	455.89	454.96	455.22	61797.0
2025-04-23 05:00:00	QQQ	ETF	455.43	455.75	455.28	455.36	42809.0
2025-04-23 05:30:00	QQQ	ETF	455.42	455.76	454.96	455.67	33265.0
2025-04-23 06:00:00	QQQ	ETF	455.69	456.55	455.58	456.39	139154.0
2025-04-23 06:30:00	QQQ	ETF	456.45	457.7	456.14	457.49	169656.0
2025-04-23 07:00:00	QQQ	ETF	457.42	458.07	456.7	456.74	218241.0
2025-04-23 07:30:00	QQQ	ETF	456.73	457.11	456.09	456.09	243280.0
2025-04-23 08:00:00	QQQ	ETF	457.51	457.9686	451.85	457.19	457328.0
2025-04-23 08:30:00	QQQ	ETF	457.1	458.75	457.0	458.6	270790.0
2025-04-23 09:00:00	QQQ	ETF	458.7	458.7	456.81	458.24	450367.0
2025-04-23 09:30:00	QQQ	ETF	458.17	462.35	457.435	460.95	7955677.0
2025-04-23 10:00:00	QQQ	ETF	460.97	462.58	458.77	461.84	3604883.0
2025-04-23 10:30:00	QQQ	ETF	461.82	463.38	460.59	460.852	2394554.0
2025-04-23 11:00:00	QQQ	ETF	460.91	461.83	456.53	457.33	3179041.0
2025-04-23 11:30:00	QQQ	ETF	457.34	458.3	454.5	456.4	2934133.0
2025-04-23 12:00:00	QQQ	ETF	456.42	456.54	453.31	455.47	2381235.0
2025-04-23 12:30:00	QQQ	ETF	455.445	457.8198	455.06	457.47	2023119.0

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

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