PREVIEW / etf_30min / 2025-06-12

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-12.parquet
  size:    949 KB
  rows:    39,017

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-06-12 04:00:00	SPY	ETF	598.68	599.88	597.59	598.16	37743.0
2025-06-12 04:30:00	SPY	ETF	598.16	599.16	597.84	599.1	34524.0
2025-06-12 05:00:00	SPY	ETF	599.1	599.38	598.77	599.12	31801.0
2025-06-12 05:30:00	SPY	ETF	599.11	599.76	598.89	598.96	30746.0
2025-06-12 06:00:00	SPY	ETF	598.82	599.08	598.06	598.36	32373.0
2025-06-12 06:30:00	SPY	ETF	598.44	599.24	598.23	598.75	79497.0
2025-06-12 07:00:00	SPY	ETF	598.73	599.0	598.2	598.27	96319.0
2025-06-12 07:30:00	SPY	ETF	598.23	598.53	597.67	597.86	96771.0
2025-06-12 08:00:00	SPY	ETF	600.78	600.78	597.69	598.3	151611.0
2025-06-12 08:30:00	SPY	ETF	598.39	600.1488	597.85	599.99	493909.0
2025-06-12 09:00:00	SPY	ETF	600.03	601.3995	599.77	600.02	398807.0
2025-06-12 09:30:00	SPY	ETF	600.02	601.24	599.52	600.7699	4530858.0
2025-06-12 10:00:00	SPY	ETF	600.76	602.64	600.61	602.48	4009867.0
2025-06-12 10:30:00	SPY	ETF	602.49	603.13	602.35	602.6413	3046643.0
2025-06-12 11:00:00	SPY	ETF	602.65	603.62	601.54	602.45	5026592.0
2025-06-12 11:30:00	SPY	ETF	602.45	602.61	601.74	602.47	2343692.0
2025-06-12 12:00:00	SPY	ETF	602.475	603.32	601.915	603.0046	3197313.0
2025-06-12 12:30:00	SPY	ETF	602.99	603.42	602.02	602.425	2804908.0
2025-06-12 13:00:00	SPY	ETF	602.45	603.34	602.37	602.98	1834183.0
2025-06-12 13:30:00	SPY	ETF	602.97	603.5604	602.94	603.1108	1617980.0
2025-06-12 14:00:00	SPY	ETF	603.11	603.4286	602.42	602.81	2164426.0
2025-06-12 14:30:00	SPY	ETF	602.84	603.365	602.46	603.33	2684761.0
2025-06-12 15:00:00	SPY	ETF	603.32	603.57	603.08	603.2946	2748674.0
2025-06-12 15:30:00	SPY	ETF	603.28	603.72	602.39	603.72	7186498.0
2025-06-12 16:00:00	SPY	ETF	603.7	603.75	603.03	603.05	2208846.0
2025-06-12 16:30:00	SPY	ETF	603.05	603.2	602.86	602.94	114705.0
2025-06-12 17:00:00	SPY	ETF	602.97	603.15	602.83	602.98	81844.0
2025-06-12 17:30:00	SPY	ETF	602.9503	603.25	602.9503	603.15	35907.0
2025-06-12 18:00:00	SPY	ETF	603.11	603.11	602.2	602.29	77781.0
2025-06-12 18:30:00	SPY	ETF	602.2	602.44	601.92	602.41	39162.0
2025-06-12 19:00:00	SPY	ETF	602.32	602.47	602.19	602.28	15571.0
2025-06-12 19:30:00	SPY	ETF	602.26	602.3999	600.12	600.19	111301.0
2025-06-12 04:00:00	QQQ	ETF	529.73	530.04	528.3	529.18	36336.0
2025-06-12 04:30:00	QQQ	ETF	529.16	530.45	528.9	530.35	19229.0
2025-06-12 05:00:00	QQQ	ETF	530.33	530.78	530.21	530.54	22702.0
2025-06-12 05:30:00	QQQ	ETF	530.62	531.36	530.51	530.6	35659.0
2025-06-12 06:00:00	QQQ	ETF	530.4	530.74	529.51	529.87	63403.0
2025-06-12 06:30:00	QQQ	ETF	529.94	530.85	529.73	530.46	37625.0
2025-06-12 07:00:00	QQQ	ETF	530.5	530.53	529.55	529.69	59671.0
2025-06-12 07:30:00	QQQ	ETF	529.6	529.75	528.79	528.85	40164.0
2025-06-12 08:00:00	QQQ	ETF	530.94	531.73	528.84	529.4002	141015.0
2025-06-12 08:30:00	QQQ	ETF	529.54	531.51	528.63	531.39	215532.0
2025-06-12 09:00:00	QQQ	ETF	531.27	532.0	530.9499	530.97	108672.0
2025-06-12 09:30:00	QQQ	ETF	531.07	532.59	530.84	531.75	2362595.0
2025-06-12 10:00:00	QQQ	ETF	531.75	533.51	531.34	533.265	2379647.0
2025-06-12 10:30:00	QQQ	ETF	533.28	533.95	533.03	533.5929	1467777.0
2025-06-12 11:00:00	QQQ	ETF	533.6	534.6438	532.3501	533.21	2342684.0
2025-06-12 11:30:00	QQQ	ETF	533.22	533.51	532.6399	533.32	1465775.0
2025-06-12 12:00:00	QQQ	ETF	533.32	534.32	532.83	534.1236	1909465.0
2025-06-12 12:30:00	QQQ	ETF	534.12	534.42	533.14	533.33	1785561.0

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

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