PREVIEW / etf_30min / 2025-04-15

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-15.parquet
  size:    976 KB
  rows:    39,968

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-15 04:00:00	SPY	ETF	539.27	540.86	539.27	540.3	27805.0
2025-04-15 04:30:00	SPY	ETF	539.46	540.12	539.2	540.12	18719.0
2025-04-15 05:00:00	SPY	ETF	539.58	540.61	539.12	540.44	7705.0
2025-04-15 05:30:00	SPY	ETF	540.54	540.67	538.9	539.33	14772.0
2025-04-15 06:00:00	SPY	ETF	539.66	540.32	539.6	540.05	27722.0
2025-04-15 06:30:00	SPY	ETF	539.89	540.26	538.75	539.68	45519.0
2025-04-15 07:00:00	SPY	ETF	539.67	539.89	539.13	539.56	38551.0
2025-04-15 07:30:00	SPY	ETF	539.51	540.0	536.9	537.38	110247.0
2025-04-15 08:00:00	SPY	ETF	539.66	541.0	536.16	536.67	477979.0
2025-04-15 08:30:00	SPY	ETF	536.67	538.3	536.67	538.17	188284.0
2025-04-15 09:00:00	SPY	ETF	538.22	539.68	538.22	539.68	300209.0
2025-04-15 09:30:00	SPY	ETF	539.68	542.9499	539.249	541.48	4245331.0
2025-04-15 10:00:00	SPY	ETF	541.52	543.23	538.14	539.4	4785769.0
2025-04-15 10:30:00	SPY	ETF	539.4	541.88	539.08	540.58	2857877.0
2025-04-15 11:00:00	SPY	ETF	540.5801	542.03	540.15	540.1701	1739873.0
2025-04-15 11:30:00	SPY	ETF	540.22	541.53	539.44	540.9717	1831715.0
2025-04-15 12:00:00	SPY	ETF	541.0	541.62	540.3726	540.98	1048756.0
2025-04-15 12:30:00	SPY	ETF	541.0	541.4302	538.48	539.04	1487193.0
2025-04-15 13:00:00	SPY	ETF	539.01	539.9	537.37	537.76	1920950.0
2025-04-15 13:30:00	SPY	ETF	537.77	539.2458	537.385	538.2867	2052299.0
2025-04-15 14:00:00	SPY	ETF	538.32	538.775	536.81	537.5	1945302.0
2025-04-15 14:30:00	SPY	ETF	537.44	539.21	537.435	538.63	1933195.0
2025-04-15 15:00:00	SPY	ETF	538.63	539.29	537.74	538.3434	2051045.0
2025-04-15 15:30:00	SPY	ETF	538.36	538.73	537.14	537.72	6075942.0
2025-04-15 16:00:00	SPY	ETF	537.71	538.2899	537.1298	537.26	2772792.0
2025-04-15 16:30:00	SPY	ETF	537.22	537.54	537.0	537.4	191782.0
2025-04-15 17:00:00	SPY	ETF	537.35	538.2	537.35	537.61	221750.0
2025-04-15 17:30:00	SPY	ETF	537.57	537.61	535.06	535.19	131214.0
2025-04-15 18:00:00	SPY	ETF	535.15	535.15	532.39	534.12	290386.0
2025-04-15 18:30:00	SPY	ETF	534.15	534.39	533.51	533.91	58136.0
2025-04-15 19:00:00	SPY	ETF	533.9	534.1	533.1341	533.25	46307.0
2025-04-15 19:30:00	SPY	ETF	533.33	533.62	532.82	533.58	53255.0
2025-04-15 04:00:00	QQQ	ETF	459.16	459.65	458.16	458.92	46917.0
2025-04-15 04:30:00	QQQ	ETF	458.87	459.06	458.17	458.96	23348.0
2025-04-15 05:00:00	QQQ	ETF	458.8	459.36	458.28	459.31	14898.0
2025-04-15 05:30:00	QQQ	ETF	459.26	459.53	458.06	458.49	22172.0
2025-04-15 06:00:00	QQQ	ETF	458.27	459.1	458.15	458.84	11503.0
2025-04-15 06:30:00	QQQ	ETF	458.8	458.9	457.77	458.49	35014.0
2025-04-15 07:00:00	QQQ	ETF	458.49	458.65	457.83	458.24	52488.0
2025-04-15 07:30:00	QQQ	ETF	458.15	458.5	455.83	456.21	72387.0
2025-04-15 08:00:00	QQQ	ETF	458.3	459.81	454.97	455.57	275678.0
2025-04-15 08:30:00	QQQ	ETF	455.4	457.49	455.4	457.36	103306.0
2025-04-15 09:00:00	QQQ	ETF	457.37	458.55	457.37	458.55	181530.0
2025-04-15 09:30:00	QQQ	ETF	458.54	461.715	458.14	460.5	2640416.0
2025-04-15 10:00:00	QQQ	ETF	460.53	462.38	457.15	458.09	4113466.0
2025-04-15 10:30:00	QQQ	ETF	458.17	460.78	458.14	459.39	2076791.0
2025-04-15 11:00:00	QQQ	ETF	459.405	461.23	459.1697	459.24	1238371.0
2025-04-15 11:30:00	QQQ	ETF	459.26	460.56	458.57	460.11	1718684.0
2025-04-15 12:00:00	QQQ	ETF	460.13	461.0969	459.88	460.56	1261198.0
2025-04-15 12:30:00	QQQ	ETF	460.59	460.9199	457.63	458.11	1142105.0

> showing 50 of 39,968 rows — these rows as CSV

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