PREVIEW / etf_30min / 2025-06-02

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-02.parquet
  size:    966 KB
  rows:    39,989

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-02 04:00:00	SPY	ETF	586.8	587.33	585.99	587.33	107921.0
2025-06-02 04:30:00	SPY	ETF	587.3	587.34	586.53	586.82	8119.0
2025-06-02 05:00:00	SPY	ETF	586.7	586.84	585.99	586.19	30759.0
2025-06-02 05:30:00	SPY	ETF	586.35	586.45	585.7	586.23	18514.0
2025-06-02 06:00:00	SPY	ETF	586.23	586.9	586.13	586.69	18990.0
2025-06-02 06:30:00	SPY	ETF	586.56	587.04	586.36	586.98	26123.0
2025-06-02 07:00:00	SPY	ETF	587.04	587.63	586.74	587.52	38603.0
2025-06-02 07:30:00	SPY	ETF	587.52	588.0	587.18	587.18	77389.0
2025-06-02 08:00:00	SPY	ETF	586.98	587.9301	584.97	587.21	127113.0
2025-06-02 08:30:00	SPY	ETF	587.17	589.39	587.1	587.85	533752.0
2025-06-02 09:00:00	SPY	ETF	587.87	588.14	587.26	587.75	182932.0
2025-06-02 09:30:00	SPY	ETF	587.76	589.74	586.64	586.8499	6130320.0
2025-06-02 10:00:00	SPY	ETF	586.63	588.61	585.06	588.59	5566258.0
2025-06-02 10:30:00	SPY	ETF	588.58	589.94	588.12	589.33	3471861.0
2025-06-02 11:00:00	SPY	ETF	589.34	589.68	588.325	588.54	2696512.0
2025-06-02 11:30:00	SPY	ETF	588.57	590.06	588.13	589.81	2019944.0
2025-06-02 12:00:00	SPY	ETF	589.8	589.97	588.98	589.41	1293235.0
2025-06-02 12:30:00	SPY	ETF	589.37	590.19	589.04	590.0	1335244.0
2025-06-02 13:00:00	SPY	ETF	589.9817	590.61	589.72	589.86	1351646.0
2025-06-02 13:30:00	SPY	ETF	589.85	590.22	589.5	589.98	1110338.0
2025-06-02 14:00:00	SPY	ETF	589.98	591.7	589.54	591.505	2858016.0
2025-06-02 14:30:00	SPY	ETF	591.5	591.96	591.175	591.86	2064538.0
2025-06-02 15:00:00	SPY	ETF	591.86	592.72	591.7446	592.4	3365515.0
2025-06-02 15:30:00	SPY	ETF	592.39	592.79	591.65	592.65	7812905.0
2025-06-02 16:00:00	SPY	ETF	592.63	593.44	592.05	593.16	2769407.0
2025-06-02 16:30:00	SPY	ETF	593.189	593.189	592.78	592.79	96281.0
2025-06-02 17:00:00	SPY	ETF	592.85	593.0	592.85	592.96	22353.0
2025-06-02 17:30:00	SPY	ETF	592.96	593.15	592.96	592.97	26912.0
2025-06-02 18:00:00	SPY	ETF	592.96	592.96	592.17	592.18	92866.0
2025-06-02 18:30:00	SPY	ETF	592.23	592.35	592.18	592.18	9234.0
2025-06-02 19:00:00	SPY	ETF	592.17	592.65	591.04	592.6496	43273.0
2025-06-02 19:30:00	SPY	ETF	592.1702	592.19	591.42	591.48	48433.0
2025-06-02 04:00:00	QQQ	ETF	515.62	516.54	515.33	516.44	40050.0
2025-06-02 04:30:00	QQQ	ETF	516.44	516.64	515.78	516.02	22956.0
2025-06-02 05:00:00	QQQ	ETF	515.98	516.1	515.37	515.84	48154.0
2025-06-02 05:30:00	QQQ	ETF	515.74	515.93	515.2	515.64	19994.0
2025-06-02 06:00:00	QQQ	ETF	515.66	516.33	515.52	515.77	11645.0
2025-06-02 06:30:00	QQQ	ETF	515.74	516.4	515.57	516.28	28567.0
2025-06-02 07:00:00	QQQ	ETF	516.37	517.11	516.07	516.82	39326.0
2025-06-02 07:30:00	QQQ	ETF	516.81	517.35	516.49	516.49	43868.0
2025-06-02 08:00:00	QQQ	ETF	516.5	519.499	514.42	516.36	179794.0
2025-06-02 08:30:00	QQQ	ETF	516.4	517.4	516.25	517.19	106822.0
2025-06-02 09:00:00	QQQ	ETF	517.18	517.45	516.52	517.26	162632.0
2025-06-02 09:30:00	QQQ	ETF	517.27	521.35	517.22	517.75	4734200.0
2025-06-02 10:00:00	QQQ	ETF	517.73	519.58	515.97	519.455	3700063.0
2025-06-02 10:30:00	QQQ	ETF	519.45	520.47	518.73	519.87	3002437.0
2025-06-02 11:00:00	QQQ	ETF	519.88	520.34	518.88	519.22	2322195.0
2025-06-02 11:30:00	QQQ	ETF	519.26	521.02	518.89	520.78	1850871.0
2025-06-02 12:00:00	QQQ	ETF	520.77	520.95	520.18	520.49	1336931.0
2025-06-02 12:30:00	QQQ	ETF	520.47	521.27	520.0	521.06	1146492.0

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

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