PREVIEW / etf_5min / 2023-07-24

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-24.parquet
  size:    2.0 MB
  rows:    96,986

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-24 04:00:00	SPY	ETF	453.02	453.02	452.86	452.91	2323.0
2023-07-24 04:05:00	SPY	ETF	452.91	452.91	452.78	452.8	3776.0
2023-07-24 04:10:00	SPY	ETF	452.96	453.08	452.93	453.05	1607.0
2023-07-24 04:15:00	SPY	ETF	452.91	452.92	452.81	452.86	1386.0
2023-07-24 04:20:00	SPY	ETF	452.79	452.79	452.79	452.79	222.0
2023-07-24 04:25:00	SPY	ETF	452.97	453.13	452.97	453.13	12658.0
2023-07-24 04:30:00	SPY	ETF	453.13	453.26	453.13	453.24	6658.0
2023-07-24 04:35:00	SPY	ETF	453.26	453.26	453.19	453.19	1400.0
2023-07-24 04:40:00	SPY	ETF	453.16	453.16	452.99	452.99	1200.0
2023-07-24 04:45:00	SPY	ETF	453.07	453.07	453.07	453.07	675.0
2023-07-24 04:50:00	SPY	ETF	453.11	453.13	453.09	453.13	400.0
2023-07-24 04:55:00	SPY	ETF	453.12	453.12	453.12	453.12	240.0
2023-07-24 05:00:00	SPY	ETF	453.11	453.11	453.08	453.1	1400.0
2023-07-24 05:05:00	SPY	ETF	453.15	453.15	453.15	453.15	100.0
2023-07-24 05:10:00	SPY	ETF	453.18	453.18	453.18	453.18	2600.0
2023-07-24 05:15:00	SPY	ETF	453.23	453.5	453.23	453.43	5019.0
2023-07-24 05:20:00	SPY	ETF	453.42	453.42	453.42	453.42	131.0
2023-07-24 05:25:00	SPY	ETF	453.38	453.39	453.38	453.39	600.0
2023-07-24 05:35:00	SPY	ETF	453.4	453.4	453.36	453.36	1375.0
2023-07-24 05:40:00	SPY	ETF	453.35	453.35	453.31	453.31	2200.0
2023-07-24 05:45:00	SPY	ETF	453.29	453.29	453.29	453.29	243.0
2023-07-24 05:55:00	SPY	ETF	453.32	453.33	453.32	453.33	465.0
2023-07-24 06:00:00	SPY	ETF	453.28	453.28	453.23	453.23	973.0
2023-07-24 06:05:00	SPY	ETF	453.26	453.26	453.26	453.26	700.0
2023-07-24 06:10:00	SPY	ETF	453.19	453.19	453.18	453.18	700.0
2023-07-24 06:15:00	SPY	ETF	453.23	453.25	453.23	453.23	436.0
2023-07-24 06:25:00	SPY	ETF	453.19	453.27	453.19	453.27	550.0
2023-07-24 06:30:00	SPY	ETF	453.27	453.37	453.27	453.37	2000.0
2023-07-24 06:35:00	SPY	ETF	453.3	453.33	453.3	453.32	2203.0
2023-07-24 06:40:00	SPY	ETF	453.34	453.34	453.34	453.34	200.0
2023-07-24 06:45:00	SPY	ETF	453.2	453.21	453.16	453.16	800.0
2023-07-24 06:50:00	SPY	ETF	453.2	453.27	453.2	453.27	1000.0
2023-07-24 06:55:00	SPY	ETF	453.11	453.11	453.11	453.11	275.0
2023-07-24 07:00:00	SPY	ETF	453.11	453.14	452.89	452.95	9261.0
2023-07-24 07:05:00	SPY	ETF	452.93	452.99	452.93	452.99	4340.0
2023-07-24 07:10:00	SPY	ETF	453.0	453.29	453.0	453.29	5300.0
2023-07-24 07:15:00	SPY	ETF	453.29	453.4	453.28	453.31	1846.0
2023-07-24 07:20:00	SPY	ETF	453.24	453.26	453.19	453.19	3659.0
2023-07-24 07:25:00	SPY	ETF	453.13	453.27	453.13	453.25	5489.0
2023-07-24 07:30:00	SPY	ETF	453.29	453.34	453.17	453.17	2900.0
2023-07-24 07:35:00	SPY	ETF	452.995	453.1	452.99	453.06	4400.0
2023-07-24 07:40:00	SPY	ETF	453.07	453.26	453.011	453.17	14186.0
2023-07-24 07:45:00	SPY	ETF	453.17	453.22	453.1	453.1	4328.0
2023-07-24 07:50:00	SPY	ETF	453.12	453.23	453.1	453.12	4267.0
2023-07-24 07:55:00	SPY	ETF	453.13	453.16	453.01	453.06	12132.0
2023-07-24 08:00:00	SPY	ETF	452.97	453.4004	452.33	452.99	32322.0
2023-07-24 08:05:00	SPY	ETF	453.01	453.03	452.84	452.84	12599.0
2023-07-24 08:10:00	SPY	ETF	452.82	452.84	452.73	452.745	19915.0
2023-07-24 08:15:00	SPY	ETF	452.76	452.92	452.76	452.87	6696.0
2023-07-24 08:20:00	SPY	ETF	452.85	452.94	452.79	452.84	2536.0

> showing 50 of 96,986 rows — these rows as CSV

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