PREVIEW / etf_30min / 2025-04-07

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-07.parquet
  size:    1.1 MB
  rows:    47,899

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-07 04:00:00	SPY	ETF	486.9	491.09	482.96	489.0	473050.0
2025-04-07 04:30:00	SPY	ETF	488.65	490.68	487.4	487.87	217198.0
2025-04-07 05:00:00	SPY	ETF	487.77	488.77	484.83	487.12	217718.0
2025-04-07 05:30:00	SPY	ETF	486.96	490.62	486.9	488.8	172389.0
2025-04-07 06:00:00	SPY	ETF	488.83	495.28	487.69	493.51	621830.0
2025-04-07 06:30:00	SPY	ETF	493.45	498.9	492.49	494.81	557958.0
2025-04-07 07:00:00	SPY	ETF	494.66	498.58	493.93	496.38	780487.0
2025-04-07 07:30:00	SPY	ETF	496.35	496.6	492.09	493.47	606625.0
2025-04-07 08:00:00	SPY	ETF	493.41	498.78	480.0	495.9	3056580.0
2025-04-07 08:30:00	SPY	ETF	495.95	497.6	490.5	496.11	2636755.0
2025-04-07 09:00:00	SPY	ETF	496.07	496.07	488.72	489.21	1964447.0
2025-04-07 09:30:00	SPY	ETF	489.19	496.46	481.8	495.69	22794354.0
2025-04-07 10:00:00	SPY	ETF	495.67	523.17	493.37	498.19	41749199.0
2025-04-07 10:30:00	SPY	ETF	498.21	508.78	493.67	505.91	20200691.0
2025-04-07 11:00:00	SPY	ETF	505.88	509.77	492.66	493.75	20119002.0
2025-04-07 11:30:00	SPY	ETF	493.75	503.98	493.73	499.5	9922337.0
2025-04-07 12:00:00	SPY	ETF	499.5	500.52	495.015	499.56	5675926.0
2025-04-07 12:30:00	SPY	ETF	499.56	501.77	494.7	495.68	5204514.0
2025-04-07 13:00:00	SPY	ETF	495.63	505.94	495.59	505.62	8923015.0
2025-04-07 13:30:00	SPY	ETF	505.62	509.36	502.16	509.09	7934912.0
2025-04-07 14:00:00	SPY	ETF	509.07	510.47	504.66	505.19	6639079.0
2025-04-07 14:30:00	SPY	ETF	505.15	508.34	502.28	503.21	5293844.0
2025-04-07 15:00:00	SPY	ETF	503.25	506.31	500.14	500.605	8331504.0
2025-04-07 15:30:00	SPY	ETF	500.605	506.64	500.56	504.55	15448183.0
2025-04-07 16:00:00	SPY	ETF	504.55	509.14	503.83	507.0	9198916.0
2025-04-07 16:30:00	SPY	ETF	507.1	507.52	504.4141	506.45	656442.0
2025-04-07 17:00:00	SPY	ETF	506.49	507.2	506.35	507.1	283357.0
2025-04-07 17:30:00	SPY	ETF	507.09	507.5	507.0	507.1101	159303.0
2025-04-07 18:00:00	SPY	ETF	507.17	508.35	506.66	508.35	160924.0
2025-04-07 18:30:00	SPY	ETF	508.3596	509.1	507.75	509.1	243482.0
2025-04-07 19:00:00	SPY	ETF	509.1	510.24	509.0	509.58	180735.0
2025-04-07 19:30:00	SPY	ETF	509.8	510.0	508.95	509.53	89891.0
2025-04-07 04:00:00	QQQ	ETF	402.67	408.65	400.0	407.47	421563.0
2025-04-07 04:30:00	QQQ	ETF	407.12	409.37	406.0	406.68	191233.0
2025-04-07 05:00:00	QQQ	ETF	406.61	407.64	404.36	406.26	217159.0
2025-04-07 05:30:00	QQQ	ETF	405.99	409.26	405.71	407.64	165094.0
2025-04-07 06:00:00	QQQ	ETF	407.87	414.43	406.99	412.8	263502.0
2025-04-07 06:30:00	QQQ	ETF	412.64	417.07	411.64	413.17	254597.0
2025-04-07 07:00:00	QQQ	ETF	413.4	415.99	412.31	414.09	389443.0
2025-04-07 07:30:00	QQQ	ETF	414.5	414.5	410.5	411.89	334848.0
2025-04-07 08:00:00	QQQ	ETF	412.42	422.987	396.0	414.63	3075440.0
2025-04-07 08:30:00	QQQ	ETF	414.7	415.89	410.12	414.5	980581.0
2025-04-07 09:00:00	QQQ	ETF	414.14	414.33	408.17	408.28	1498901.0
2025-04-07 09:30:00	QQQ	ETF	408.66	417.48	402.39	416.89	16476155.0
2025-04-07 10:00:00	QQQ	ETF	416.89	443.14	414.32	419.09	28187163.0
2025-04-07 10:30:00	QQQ	ETF	419.17	428.877	414.295	426.24	14278716.0
2025-04-07 11:00:00	QQQ	ETF	426.2	429.63	414.06	415.1112	12517878.0
2025-04-07 11:30:00	QQQ	ETF	415.1	424.0	415.1	419.76	6608209.0
2025-04-07 12:00:00	QQQ	ETF	419.8	421.09	415.7199	420.1	4587349.0
2025-04-07 12:30:00	QQQ	ETF	420.09	422.36	415.57	416.52	3535582.0

> showing 50 of 47,899 rows — these rows as CSV

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