PREVIEW / etf_30min / 2025-01-10

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-10.parquet
  size:    1002 KB
  rows:    40,291

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-01-10 04:00:00	SPY	ETF	588.11	588.29	587.4	587.86	27283.0
2025-01-10 04:30:00	SPY	ETF	587.84	588.16	587.37	587.79	5850.0
2025-01-10 05:00:00	SPY	ETF	587.78	588.1	587.76	588.04	7438.0
2025-01-10 05:30:00	SPY	ETF	588.13	588.64	588.07	588.51	32517.0
2025-01-10 06:00:00	SPY	ETF	588.43	589.61	588.43	589.14	116965.0
2025-01-10 06:30:00	SPY	ETF	589.02	589.3	588.61	588.61	11249.0
2025-01-10 07:00:00	SPY	ETF	588.57	588.759	587.48	587.9	33948.0
2025-01-10 07:30:00	SPY	ETF	588.05	588.84	588.05	588.82	71396.0
2025-01-10 08:00:00	SPY	ETF	588.8	589.3404	587.58	588.3	189491.0
2025-01-10 08:30:00	SPY	ETF	588.0	588.0	582.44	584.2	1599156.0
2025-01-10 09:00:00	SPY	ETF	583.99	585.86	583.47	585.83	413413.0
2025-01-10 09:30:00	SPY	ETF	585.88	585.96	582.28	582.98	5194415.0
2025-01-10 10:00:00	SPY	ETF	582.39	582.95	579.15	581.89	7016231.0
2025-01-10 10:30:00	SPY	ETF	581.9	583.2288	580.92	581.1	3674005.0
2025-01-10 11:00:00	SPY	ETF	581.1	581.37	579.59	579.86	2344230.0
2025-01-10 11:30:00	SPY	ETF	579.87	580.81	578.78	579.095	2551190.0
2025-01-10 12:00:00	SPY	ETF	579.12	580.09	578.55	580.0	1774239.0
2025-01-10 12:30:00	SPY	ETF	579.98	581.71	579.9	581.56	1751672.0
2025-01-10 13:00:00	SPY	ETF	581.55	583.75	580.98	583.24	2021214.0
2025-01-10 13:30:00	SPY	ETF	583.24	584.5	582.62	584.42	1748024.0
2025-01-10 14:00:00	SPY	ETF	584.435	584.46	581.58	582.6	3080279.0
2025-01-10 14:30:00	SPY	ETF	582.61	582.62	581.23	582.1	1694736.0
2025-01-10 15:00:00	SPY	ETF	582.09	582.37	579.97	580.33	2817307.0
2025-01-10 15:30:00	SPY	ETF	580.3318	581.12	579.7	580.51	7145299.0
2025-01-10 16:00:00	SPY	ETF	580.52	580.86	579.75	580.15	3176297.0
2025-01-10 16:30:00	SPY	ETF	580.17	580.21	579.9	580.03	232547.0
2025-01-10 17:00:00	SPY	ETF	580.03	580.1	579.79	580.021	86308.0
2025-01-10 17:30:00	SPY	ETF	580.03	580.05	579.9	579.95	15576.0
2025-01-10 18:00:00	SPY	ETF	579.98	580.03	579.7	579.87	20608.0
2025-01-10 18:30:00	SPY	ETF	579.74	579.97	579.68	579.9	9332.0
2025-01-10 19:00:00	SPY	ETF	579.85	579.94	579.66	579.9	5155.0
2025-01-10 19:30:00	SPY	ETF	579.87	579.88	579.73	579.7817	3573.0
2025-01-10 04:00:00	QQQ	ETF	513.62	513.73	512.85	513.47	24351.0
2025-01-10 04:30:00	QQQ	ETF	513.5	513.71	513.16	513.43	8037.0
2025-01-10 05:00:00	QQQ	ETF	513.63	513.91	513.36	513.77	18935.0
2025-01-10 05:30:00	QQQ	ETF	513.81	514.56	513.81	514.45	15228.0
2025-01-10 06:00:00	QQQ	ETF	514.55	515.77	514.44	515.16	41493.0
2025-01-10 06:30:00	QQQ	ETF	515.24	515.3	514.43	514.43	28129.0
2025-01-10 07:00:00	QQQ	ETF	514.43	514.59	513.06	513.58	46236.0
2025-01-10 07:30:00	QQQ	ETF	513.59	514.49	513.59	514.42	65832.0
2025-01-10 08:00:00	QQQ	ETF	514.52	515.656	512.5	513.8914	97352.0
2025-01-10 08:30:00	QQQ	ETF	514.34	514.34	508.0	509.72	802970.0
2025-01-10 09:00:00	QQQ	ETF	509.59	511.57	509.04	511.49	429567.0
2025-01-10 09:30:00	QQQ	ETF	511.48	511.58	507.1504	508.35	4296210.0
2025-01-10 10:00:00	QQQ	ETF	508.26	508.284	503.92	507.66	3695348.0
2025-01-10 10:30:00	QQQ	ETF	507.64	509.86	506.55	506.68	2918049.0
2025-01-10 11:00:00	QQQ	ETF	506.69	506.89	505.13	505.46	1574816.0
2025-01-10 11:30:00	QQQ	ETF	505.42	506.5	504.22	504.5	1470517.0
2025-01-10 12:00:00	QQQ	ETF	504.57	505.98	504.2	505.84	1514028.0
2025-01-10 12:30:00	QQQ	ETF	505.84	507.85	505.78	507.7306	1207859.0

> showing 50 of 40,291 rows — these rows as CSV

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