PREVIEW / etf_5min / 2024-04-23

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-04-23.parquet
  size:    2.2 MB
  rows:    110,002

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
2024-04-23 04:00:00	SPY	ETF	499.8	500.36	499.8	500.34	6297.0
2024-04-23 04:05:00	SPY	ETF	500.16	500.18	500.16	500.18	323.0
2024-04-23 04:10:00	SPY	ETF	500.24	500.38	500.24	500.29	3251.0
2024-04-23 04:15:00	SPY	ETF	500.69	500.73	500.65	500.65	808.0
2024-04-23 04:20:00	SPY	ETF	500.65	500.71	500.65	500.71	200.0
2024-04-23 04:25:00	SPY	ETF	500.65	500.65	500.65	500.65	300.0
2024-04-23 04:30:00	SPY	ETF	500.52	500.56	500.46	500.47	7200.0
2024-04-23 04:35:00	SPY	ETF	500.0	500.0	500.0	500.0	300.0
2024-04-23 04:40:00	SPY	ETF	500.0	500.12	500.0	500.11	3900.0
2024-04-23 04:45:00	SPY	ETF	500.15	500.15	500.15	500.15	400.0
2024-04-23 04:50:00	SPY	ETF	500.12	500.27	500.12	500.27	1116.0
2024-04-23 04:55:00	SPY	ETF	500.22	500.23	500.07	500.07	16145.0
2024-04-23 05:00:00	SPY	ETF	500.05	500.31	500.05	500.31	2100.0
2024-04-23 05:05:00	SPY	ETF	500.15	500.15	500.15	500.15	579.0
2024-04-23 05:10:00	SPY	ETF	500.24	500.24	500.24	500.24	200.0
2024-04-23 05:20:00	SPY	ETF	500.21	500.22	500.21	500.22	300.0
2024-04-23 05:25:00	SPY	ETF	500.26	500.5	500.26	500.5	200.0
2024-04-23 05:30:00	SPY	ETF	500.26	500.26	500.0	500.13	4719.0
2024-04-23 05:35:00	SPY	ETF	500.23	500.23	500.22	500.22	275.0
2024-04-23 05:40:00	SPY	ETF	500.2	500.2	500.08	500.08	400.0
2024-04-23 05:45:00	SPY	ETF	500.01	500.01	499.88	499.98	1325.0
2024-04-23 05:50:00	SPY	ETF	499.95	499.98	499.95	499.98	600.0
2024-04-23 05:55:00	SPY	ETF	499.95	499.98	499.85	499.85	925.0
2024-04-23 06:00:00	SPY	ETF	500.0	500.18	500.0	500.18	950.0
2024-04-23 06:05:00	SPY	ETF	500.1	500.1	500.01	500.09	1194.0
2024-04-23 06:10:00	SPY	ETF	500.43	500.54	500.43	500.54	350.0
2024-04-23 06:15:00	SPY	ETF	500.54	500.7	500.5	500.7	3875.0
2024-04-23 06:20:00	SPY	ETF	500.68	500.8	500.68	500.68	1309.0
2024-04-23 06:25:00	SPY	ETF	500.7	500.7	500.68	500.7	500.0
2024-04-23 06:30:00	SPY	ETF	500.73	500.99	500.73	500.96	5079.0
2024-04-23 06:35:00	SPY	ETF	500.97	501.04	500.94	500.99	7689.0
2024-04-23 06:40:00	SPY	ETF	501.05	501.08	500.97	500.97	2870.0
2024-04-23 06:45:00	SPY	ETF	501.02	501.02	500.96	500.97	1100.0
2024-04-23 06:50:00	SPY	ETF	501.08	501.21	501.08	501.19	5999.0
2024-04-23 06:55:00	SPY	ETF	501.16	501.24	501.16	501.24	11906.0
2024-04-23 07:00:00	SPY	ETF	501.24	501.43	500.8	501.23	91739.0
2024-04-23 07:05:00	SPY	ETF	501.22	501.28	501.22	501.28	9473.0
2024-04-23 07:10:00	SPY	ETF	501.3	501.4	501.28	501.37	21893.0
2024-04-23 07:15:00	SPY	ETF	501.32	501.32	501.1	501.1	16368.0
2024-04-23 07:20:00	SPY	ETF	500.95	501.11	500.95	501.0	6848.0
2024-04-23 07:25:00	SPY	ETF	500.99	501.19	500.93	500.95	15916.0
2024-04-23 07:30:00	SPY	ETF	500.99	500.99	500.76	500.8	11360.0
2024-04-23 07:35:00	SPY	ETF	500.78	501.0	500.78	500.96	17064.0
2024-04-23 07:40:00	SPY	ETF	500.98	500.98	500.81	500.81	1738.0
2024-04-23 07:45:00	SPY	ETF	500.78	500.85	500.59	500.62	5978.0
2024-04-23 07:50:00	SPY	ETF	500.55	500.64	500.51	500.62	10256.0
2024-04-23 07:55:00	SPY	ETF	500.67	500.7	500.54	500.6	6995.0
2024-04-23 08:00:00	SPY	ETF	501.27	501.45	499.22	500.5	49201.0
2024-04-23 08:05:00	SPY	ETF	500.48	500.66	500.36	500.4	13628.0
2024-04-23 08:10:00	SPY	ETF	500.37	500.4	500.28	500.29	6841.0

> showing 50 of 110,002 rows — these rows as CSV

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