PREVIEW / etf_30min / 2025-05-12

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-12.parquet
  size:    1.0 MB
  rows:    43,170

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-05-12 04:00:00	SPY	ETF	571.12	579.12	571.11	578.6	133224.0
2025-05-12 04:30:00	SPY	ETF	578.73	580.05	578.41	579.48	79407.0
2025-05-12 05:00:00	SPY	ETF	579.5	580.17	579.32	580.06	61607.0
2025-05-12 05:30:00	SPY	ETF	580.09	580.46	579.98	580.31	59912.0
2025-05-12 06:00:00	SPY	ETF	580.33	581.23	580.04	581.22	88703.0
2025-05-12 06:30:00	SPY	ETF	581.15	582.53	580.99	582.26	863104.0
2025-05-12 07:00:00	SPY	ETF	582.2	582.92	581.44	581.74	661228.0
2025-05-12 07:30:00	SPY	ETF	581.76	581.94	580.28	581.0	285404.0
2025-05-12 08:00:00	SPY	ETF	582.0201	582.9001	572.48	582.54	450218.0
2025-05-12 08:30:00	SPY	ETF	582.53	582.53	581.12	581.29	210060.0
2025-05-12 09:00:00	SPY	ETF	581.32	581.9	580.61	581.48	416443.0
2025-05-12 09:30:00	SPY	ETF	581.49	581.73	578.34	578.79	7747339.0
2025-05-12 10:00:00	SPY	ETF	578.8	580.5	577.89	578.26	3944265.0
2025-05-12 10:30:00	SPY	ETF	578.27	580.18	577.04	579.05	4111689.0
2025-05-12 11:00:00	SPY	ETF	579.06	579.7315	578.16	578.85	3102612.0
2025-05-12 11:30:00	SPY	ETF	578.87	579.33	578.035	578.1695	2469328.0
2025-05-12 12:00:00	SPY	ETF	578.16	579.83	577.9775	579.3	2206400.0
2025-05-12 12:30:00	SPY	ETF	579.27	581.22	579.235	581.06	2148113.0
2025-05-12 13:00:00	SPY	ETF	581.08	582.43	580.97	581.3199	3324781.0
2025-05-12 13:30:00	SPY	ETF	581.29	582.0	581.16	581.5006	1581964.0
2025-05-12 14:00:00	SPY	ETF	581.51	582.1798	581.32	581.95	1884915.0
2025-05-12 14:30:00	SPY	ETF	581.98	582.58	581.5	581.54	2280023.0
2025-05-12 15:00:00	SPY	ETF	581.55	582.1949	581.1403	581.52	2531307.0
2025-05-12 15:30:00	SPY	ETF	581.51	583.0	580.8	582.84	9999301.0
2025-05-12 16:00:00	SPY	ETF	582.84	583.96	564.4344	583.1	5920149.0
2025-05-12 16:30:00	SPY	ETF	583.11	583.26	583.0	583.2	144645.0
2025-05-12 17:00:00	SPY	ETF	583.2084	583.2084	583.03	583.09	72235.0
2025-05-12 17:30:00	SPY	ETF	583.09	583.2	583.08	583.17	20323.0
2025-05-12 18:00:00	SPY	ETF	583.17	583.24	582.602	582.75	99928.0
2025-05-12 18:30:00	SPY	ETF	582.71	582.71	582.33	582.3507	28443.0
2025-05-12 19:00:00	SPY	ETF	582.5	583.37	582.48	583.22	15873.0
2025-05-12 19:30:00	SPY	ETF	583.21	583.21	582.11	582.13	35236.0
2025-05-12 04:00:00	QQQ	ETF	497.33	505.27	496.33	504.97	204436.0
2025-05-12 04:30:00	QQQ	ETF	504.98	506.5	504.6	506.0	144632.0
2025-05-12 05:00:00	QQQ	ETF	506.05	506.92	505.97	506.6	84857.0
2025-05-12 05:30:00	QQQ	ETF	506.6	506.81	506.37	506.76	74565.0
2025-05-12 06:00:00	QQQ	ETF	506.74	507.2	506.23	507.15	105484.0
2025-05-12 06:30:00	QQQ	ETF	507.28	508.55	506.92	508.4	221007.0
2025-05-12 07:00:00	QQQ	ETF	508.28	508.85	507.17	507.21	315131.0
2025-05-12 07:30:00	QQQ	ETF	507.29	507.38	506.14	506.91	216365.0
2025-05-12 08:00:00	QQQ	ETF	507.66	508.6697	487.605	508.04	651932.0
2025-05-12 08:30:00	QQQ	ETF	508.03	508.03	506.73	506.95	167442.0
2025-05-12 09:00:00	QQQ	ETF	506.92	507.4799	506.3	507.03	327873.0
2025-05-12 09:30:00	QQQ	ETF	507.0	507.06	502.78	503.8	5484954.0
2025-05-12 10:00:00	QQQ	ETF	503.83	505.32	502.28	502.7	2753764.0
2025-05-12 10:30:00	QQQ	ETF	502.74	504.48	501.48	503.41	2119576.0
2025-05-12 11:00:00	QQQ	ETF	503.45	504.0922	503.03	503.7741	1225012.0
2025-05-12 11:30:00	QQQ	ETF	503.78	504.28	503.16	503.31	1086545.0
2025-05-12 12:00:00	QQQ	ETF	503.33	505.0629	503.13	504.67	1327958.0
2025-05-12 12:30:00	QQQ	ETF	504.64	506.17	504.6	506.01	1116211.0

> showing 50 of 43,170 rows — these rows as CSV

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