PREVIEW / etf_5min / 2023-06-05

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-06-05.parquet
  size:    2.0 MB
  rows:    98,104

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-06-05 04:00:00	SPY	ETF	427.98	428.18	427.98	428.18	3262.0
2023-06-05 04:05:00	SPY	ETF	428.12	428.12	428.1	428.1	200.0
2023-06-05 04:10:00	SPY	ETF	428.05	428.06	427.84	427.87	2383.0
2023-06-05 04:15:00	SPY	ETF	427.85	427.86	427.78	427.82	5006.0
2023-06-05 04:20:00	SPY	ETF	427.91	427.98	427.91	427.98	400.0
2023-06-05 04:25:00	SPY	ETF	427.9	427.9	427.9	427.9	100.0
2023-06-05 04:30:00	SPY	ETF	428.1	428.1	428.03	428.03	600.0
2023-06-05 04:35:00	SPY	ETF	427.89	427.9	427.89	427.9	1000.0
2023-06-05 04:50:00	SPY	ETF	427.93	427.93	427.76	427.78	2055.0
2023-06-05 04:55:00	SPY	ETF	427.85	427.85	427.8	427.84	1200.0
2023-06-05 05:00:00	SPY	ETF	427.84	427.95	427.84	427.88	1619.0
2023-06-05 05:05:00	SPY	ETF	427.8	427.85	427.78	427.85	387.0
2023-06-05 05:10:00	SPY	ETF	427.9	427.9	427.9	427.9	400.0
2023-06-05 05:15:00	SPY	ETF	427.88	427.88	427.72	427.76	1175.0
2023-06-05 05:20:00	SPY	ETF	427.85	427.85	427.8	427.8	681.0
2023-06-05 05:25:00	SPY	ETF	427.9	427.93	427.9	427.93	415.0
2023-06-05 05:30:00	SPY	ETF	427.9	427.9	427.9	427.9	2260.0
2023-06-05 05:35:00	SPY	ETF	427.9	427.93	427.9	427.93	994.0
2023-06-05 05:45:00	SPY	ETF	427.84	427.88	427.84	427.88	1000.0
2023-06-05 05:55:00	SPY	ETF	427.81	427.81	427.81	427.81	375.0
2023-06-05 06:00:00	SPY	ETF	427.8	427.8	427.74	427.8	400.0
2023-06-05 06:05:00	SPY	ETF	427.84	427.84	427.8	427.84	1000.0
2023-06-05 06:10:00	SPY	ETF	427.75	427.76	427.71	427.71	3700.0
2023-06-05 06:15:00	SPY	ETF	427.76	427.76	427.76	427.76	138.0
2023-06-05 06:20:00	SPY	ETF	427.79	427.79	427.75	427.79	1114.0
2023-06-05 06:25:00	SPY	ETF	427.76	427.86	427.76	427.86	1557.0
2023-06-05 06:30:00	SPY	ETF	427.88	428.0	427.88	428.0	1940.0
2023-06-05 06:35:00	SPY	ETF	427.99	427.99	427.89	427.89	600.0
2023-06-05 06:40:00	SPY	ETF	427.97	427.99	427.97	427.99	699.0
2023-06-05 06:45:00	SPY	ETF	427.99	428.13	427.99	428.09	1824.0
2023-06-05 06:50:00	SPY	ETF	428.03	428.03	428.01	428.01	635.0
2023-06-05 06:55:00	SPY	ETF	428.09	428.15	428.09	428.14	2287.0
2023-06-05 07:00:00	SPY	ETF	428.12	428.18	428.05	428.17	9057.0
2023-06-05 07:05:00	SPY	ETF	428.17	428.24	428.1	428.1	5746.0
2023-06-05 07:10:00	SPY	ETF	428.18	428.21	428.16	428.21	4273.0
2023-06-05 07:15:00	SPY	ETF	428.2	428.23	428.14	428.18	3299.0
2023-06-05 07:20:00	SPY	ETF	428.18	428.2	428.04	428.04	2295.0
2023-06-05 07:25:00	SPY	ETF	428.06	428.06	427.98	428.02	19178.0
2023-06-05 07:30:00	SPY	ETF	428.07	428.07	427.95	427.95	2700.0
2023-06-05 07:35:00	SPY	ETF	427.99	428.1	427.99	428.03	4454.0
2023-06-05 07:40:00	SPY	ETF	427.99	427.99	427.93	427.98	1628.0
2023-06-05 07:45:00	SPY	ETF	427.97	428.07	427.95	428.06	15379.0
2023-06-05 07:50:00	SPY	ETF	427.98	428.05	427.98	428.05	2218.0
2023-06-05 07:55:00	SPY	ETF	428.01	428.01	428.01	428.01	810.0
2023-06-05 08:00:00	SPY	ETF	428.1212	428.24	427.29	427.86	51767.0
2023-06-05 08:05:00	SPY	ETF	427.87	428.12	427.87	428.04	9306.0
2023-06-05 08:10:00	SPY	ETF	428.04	428.04	427.91	427.91	8835.0
2023-06-05 08:15:00	SPY	ETF	427.92	427.98	427.85	427.89	1907.0
2023-06-05 08:20:00	SPY	ETF	427.95	428.0	427.95	427.99	12651.0
2023-06-05 08:25:00	SPY	ETF	427.99	428.0101	427.96	428.0	4149.0

> showing 50 of 98,104 rows — these rows as CSV

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