PREVIEW / etf_30min / 2023-07-26

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-26.parquet
  size:    709 KB
  rows:    28,369

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
2023-07-26 04:00:00	SPY	ETF	455.78	455.78	455.51	455.75	16690.0
2023-07-26 04:30:00	SPY	ETF	455.55	455.56	455.24	455.24	22262.0
2023-07-26 05:00:00	SPY	ETF	455.35	455.47	455.15	455.31	4319.0
2023-07-26 05:30:00	SPY	ETF	455.3	455.3	454.88	455.1	5587.0
2023-07-26 06:00:00	SPY	ETF	455.14	455.14	454.6	454.7	13005.0
2023-07-26 06:30:00	SPY	ETF	454.73	454.95	454.73	454.77	8918.0
2023-07-26 07:00:00	SPY	ETF	454.8	455.04	454.69	454.82	54622.0
2023-07-26 07:30:00	SPY	ETF	454.84	455.14	454.7	454.95	51074.0
2023-07-26 08:00:00	SPY	ETF	454.7587	456.1	454.58	454.84	98312.0
2023-07-26 08:30:00	SPY	ETF	454.79	454.95	454.37	454.44	121521.0
2023-07-26 09:00:00	SPY	ETF	454.39	454.65	454.35	454.48	145604.0
2023-07-26 09:30:00	SPY	ETF	454.47	455.16	454.42	454.8192	3731818.0
2023-07-26 10:00:00	SPY	ETF	454.815	454.99	454.46	454.72	2144733.0
2023-07-26 10:30:00	SPY	ETF	454.72	454.85	454.05	454.1475	2591615.0
2023-07-26 11:00:00	SPY	ETF	454.15	454.5	453.99	454.36	2279517.0
2023-07-26 11:30:00	SPY	ETF	454.36	454.98	454.33	454.94	1797544.0
2023-07-26 12:00:00	SPY	ETF	454.935	455.13	454.62	454.635	1634865.0
2023-07-26 12:30:00	SPY	ETF	454.64	454.7	454.025	454.255	1827651.0
2023-07-26 13:00:00	SPY	ETF	454.25	454.481	454.11	454.29	1722488.0
2023-07-26 13:30:00	SPY	ETF	454.29	454.38	454.07	454.24	1815747.0
2023-07-26 14:00:00	SPY	ETF	454.17	455.0	453.81	454.34	4160301.0
2023-07-26 14:30:00	SPY	ETF	454.35	456.99	454.27	456.0	9036215.0
2023-07-26 15:00:00	SPY	ETF	456.01	456.21	453.38	454.51	7423742.0
2023-07-26 15:30:00	SPY	ETF	454.505	455.54	454.055	455.51	11013327.0
2023-07-26 16:00:00	SPY	ETF	455.51	456.61	455.3403	455.68	3582787.0
2023-07-26 16:30:00	SPY	ETF	455.67	455.67	455.15	455.2	197722.0
2023-07-26 17:00:00	SPY	ETF	455.15	455.51	455.07	455.24	290378.0
2023-07-26 17:30:00	SPY	ETF	455.51	455.51	455.22	455.28	263339.0
2023-07-26 18:00:00	SPY	ETF	455.28	455.46	455.05	455.4	76151.0
2023-07-26 18:30:00	SPY	ETF	455.4	455.51	455.4	455.43	22268.0
2023-07-26 19:00:00	SPY	ETF	455.47	455.7	455.42	455.66	8511.0
2023-07-26 19:30:00	SPY	ETF	455.52	455.6	455.49	455.6	41866.0
2023-07-26 04:00:00	QQQ	ETF	378.72	378.8	378.5	378.71	31812.0
2023-07-26 04:30:00	QQQ	ETF	378.65	378.68	378.22	378.28	17677.0
2023-07-26 05:00:00	QQQ	ETF	378.36	378.5	378.29	378.46	4400.0
2023-07-26 05:30:00	QQQ	ETF	378.47	378.5	378.08	378.35	8589.0
2023-07-26 06:00:00	QQQ	ETF	378.41	378.41	377.73	377.87	12632.0
2023-07-26 06:30:00	QQQ	ETF	377.84	378.01	377.84	377.91	14057.0
2023-07-26 07:00:00	QQQ	ETF	377.97	378.37	377.85	378.16	34922.0
2023-07-26 07:30:00	QQQ	ETF	378.16	378.16	377.79	377.979	31115.0
2023-07-26 08:00:00	QQQ	ETF	377.98	379.064	377.4	378.0	157875.0
2023-07-26 08:30:00	QQQ	ETF	377.96	378.24	377.61	377.61	131290.0
2023-07-26 09:00:00	QQQ	ETF	377.61	378.11	377.61	377.72	141999.0
2023-07-26 09:30:00	QQQ	ETF	377.72	378.21	376.43	377.87	4719951.0
2023-07-26 10:00:00	QQQ	ETF	377.87	378.07	377.24	377.38	2230679.0
2023-07-26 10:30:00	QQQ	ETF	377.4	377.7199	375.6	375.73	2392622.0
2023-07-26 11:00:00	QQQ	ETF	375.73	376.23	375.18	376.03	2196709.0
2023-07-26 11:30:00	QQQ	ETF	376.03	377.15	375.99	376.9016	1431000.0
2023-07-26 12:00:00	QQQ	ETF	376.91	377.198	376.1928	376.21	1281060.0
2023-07-26 12:30:00	QQQ	ETF	376.21	376.48	375.8199	376.064	1070757.0

> showing 50 of 28,369 rows — these rows as CSV

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