PREVIEW / etf_5min / 2024-06-24

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-06-24.parquet
  size:    2.3 MB
  rows:    112,178

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-06-24 04:00:00	SPY	ETF	545.12	545.49	544.4	545.31	8936.0
2024-06-24 04:05:00	SPY	ETF	545.31	545.56	545.25	545.54	3130.0
2024-06-24 04:10:00	SPY	ETF	545.54	545.62	545.45	545.53	1842.0
2024-06-24 04:15:00	SPY	ETF	545.59	545.59	545.47	545.47	1084.0
2024-06-24 04:20:00	SPY	ETF	545.49	545.6	545.49	545.6	1235.0
2024-06-24 04:25:00	SPY	ETF	545.61	545.73	545.61	545.73	699.0
2024-06-24 04:30:00	SPY	ETF	545.6	545.6	545.55	545.55	600.0
2024-06-24 04:35:00	SPY	ETF	545.52	545.52	545.52	545.52	2000.0
2024-06-24 04:40:00	SPY	ETF	545.57	545.58	545.57	545.58	262.0
2024-06-24 04:45:00	SPY	ETF	545.57	545.57	545.57	545.57	200.0
2024-06-24 04:50:00	SPY	ETF	545.37	545.41	545.37	545.41	350.0
2024-06-24 04:55:00	SPY	ETF	545.38	545.38	545.38	545.38	990.0
2024-06-24 05:00:00	SPY	ETF	545.49	545.49	545.36	545.36	384.0
2024-06-24 05:05:00	SPY	ETF	545.49	545.49	545.49	545.49	150.0
2024-06-24 05:10:00	SPY	ETF	545.31	545.31	545.31	545.31	525.0
2024-06-24 05:15:00	SPY	ETF	545.21	545.23	545.18	545.22	2175.0
2024-06-24 05:20:00	SPY	ETF	545.25	545.36	545.25	545.36	898.0
2024-06-24 05:25:00	SPY	ETF	545.32	545.32	545.25	545.25	601.0
2024-06-24 05:30:00	SPY	ETF	545.1	545.11	544.91	544.98	1422.0
2024-06-24 05:35:00	SPY	ETF	544.96	544.96	544.96	544.96	331.0
2024-06-24 05:40:00	SPY	ETF	544.97	544.97	544.97	544.97	100.0
2024-06-24 05:45:00	SPY	ETF	544.82	544.82	544.69	544.69	1100.0
2024-06-24 05:50:00	SPY	ETF	544.7	544.72	544.7	544.72	2000.0
2024-06-24 05:55:00	SPY	ETF	544.63	544.87	544.63	544.87	1400.0
2024-06-24 06:00:00	SPY	ETF	544.95	544.99	544.92	544.99	914.0
2024-06-24 06:05:00	SPY	ETF	544.99	544.99	544.99	544.99	100.0
2024-06-24 06:10:00	SPY	ETF	544.83	544.83	544.83	544.83	197.0
2024-06-24 06:25:00	SPY	ETF	544.83	545.08	544.83	545.08	850.0
2024-06-24 06:35:00	SPY	ETF	545.01	545.03	544.98	544.98	570.0
2024-06-24 06:40:00	SPY	ETF	544.95	545.18	544.95	545.18	4600.0
2024-06-24 06:45:00	SPY	ETF	545.22	545.3	545.22	545.26	820.0
2024-06-24 06:50:00	SPY	ETF	545.24	545.32	545.03	545.15	1288.0
2024-06-24 06:55:00	SPY	ETF	545.16	545.29	545.16	545.26	3798.0
2024-06-24 07:00:00	SPY	ETF	545.25	545.4	545.25	545.35	1843.0
2024-06-24 07:05:00	SPY	ETF	545.4	545.4	545.23	545.23	1822.0
2024-06-24 07:10:00	SPY	ETF	545.22	545.301	545.2	545.301	2407.0
2024-06-24 07:15:00	SPY	ETF	545.28	545.28	545.22	545.24	1650.0
2024-06-24 07:20:00	SPY	ETF	545.29	545.29	544.95	544.97	17449.0
2024-06-24 07:25:00	SPY	ETF	544.98	545.01	544.91	545.01	1805.0
2024-06-24 07:30:00	SPY	ETF	545.01	545.01	544.9	544.95	5082.0
2024-06-24 07:35:00	SPY	ETF	545.0	545.15	545.0	545.15	1901.0
2024-06-24 07:40:00	SPY	ETF	545.09	545.2	545.09	545.2	2826.0
2024-06-24 07:45:00	SPY	ETF	545.14	545.2	545.131	545.18	1980.0
2024-06-24 07:50:00	SPY	ETF	545.2	545.25	544.86	544.86	14712.0
2024-06-24 07:55:00	SPY	ETF	544.89	544.94	544.85	544.91	14761.0
2024-06-24 08:00:00	SPY	ETF	545.27	545.4	543.8	544.5	26067.0
2024-06-24 08:05:00	SPY	ETF	544.42	544.75	544.41	544.65	7389.0
2024-06-24 08:10:00	SPY	ETF	544.65	544.72	544.63	544.72	4532.0
2024-06-24 08:15:00	SPY	ETF	544.63	544.79	544.53	544.78	3059.0
2024-06-24 08:20:00	SPY	ETF	544.73	545.1	544.73	545.1	6843.0

> showing 50 of 112,178 rows — these rows as CSV

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