PREVIEW / etf_5min / 2021-08-10

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-08-10.parquet
  size:    1.7 MB
  rows:    78,483

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
2021-08-10 04:00:00	SPY	ETF	442.15	442.3	442.11	442.3	5437.0
2021-08-10 04:05:00	SPY	ETF	442.18	442.2	442.13	442.2	1254.0
2021-08-10 04:10:00	SPY	ETF	442.15	442.2	442.15	442.2	1821.0
2021-08-10 04:15:00	SPY	ETF	442.0	442.0	442.0	442.0	100.0
2021-08-10 04:20:00	SPY	ETF	442.08	442.08	442.07	442.08	900.0
2021-08-10 04:30:00	SPY	ETF	442.11	442.11	442.11	442.11	856.0
2021-08-10 04:35:00	SPY	ETF	442.08	442.08	442.08	442.08	100.0
2021-08-10 04:40:00	SPY	ETF	442.0	442.06	442.0	442.06	586.0
2021-08-10 04:45:00	SPY	ETF	442.07	442.11	442.07	442.11	400.0
2021-08-10 05:00:00	SPY	ETF	442.15	442.15	442.13	442.13	868.0
2021-08-10 05:05:00	SPY	ETF	442.14	442.14	442.11	442.11	200.0
2021-08-10 05:20:00	SPY	ETF	442.08	442.08	442.08	442.08	1000.0
2021-08-10 05:25:00	SPY	ETF	442.08	442.08	442.08	442.08	200.0
2021-08-10 05:35:00	SPY	ETF	442.09	442.09	442.09	442.09	100.0
2021-08-10 05:40:00	SPY	ETF	442.11	442.11	442.11	442.11	148.0
2021-08-10 05:45:00	SPY	ETF	442.13	442.13	442.13	442.13	200.0
2021-08-10 05:50:00	SPY	ETF	442.12	442.12	442.12	442.12	300.0
2021-08-10 05:55:00	SPY	ETF	442.16	442.16	442.1	442.1	1734.0
2021-08-10 06:00:00	SPY	ETF	442.09	442.09	442.0	442.0	997.0
2021-08-10 06:15:00	SPY	ETF	442.06	442.06	442.05	442.06	600.0
2021-08-10 06:20:00	SPY	ETF	442.06	442.08	442.06	442.08	400.0
2021-08-10 06:25:00	SPY	ETF	442.11	442.11	442.11	442.11	200.0
2021-08-10 06:30:00	SPY	ETF	442.1	442.1	442.06	442.06	2570.0
2021-08-10 06:35:00	SPY	ETF	442.09	442.19	442.09	442.16	7192.0
2021-08-10 06:45:00	SPY	ETF	442.1	442.1	442.1	442.1	100.0
2021-08-10 06:50:00	SPY	ETF	442.13	442.16	442.13	442.16	600.0
2021-08-10 07:00:00	SPY	ETF	442.05	442.22	442.05	442.22	5439.0
2021-08-10 07:05:00	SPY	ETF	442.22	442.22	442.18	442.19	879.0
2021-08-10 07:10:00	SPY	ETF	442.17	442.24	442.17	442.23	1155.0
2021-08-10 07:15:00	SPY	ETF	442.22	442.22	442.19	442.22	1900.0
2021-08-10 07:20:00	SPY	ETF	442.26	442.26	442.24	442.24	220.0
2021-08-10 07:25:00	SPY	ETF	442.21	442.22	442.13	442.18	4100.0
2021-08-10 07:35:00	SPY	ETF	442.25	442.25	442.2	442.2	5380.0
2021-08-10 07:40:00	SPY	ETF	442.2	442.2	442.14	442.15	3050.0
2021-08-10 07:45:00	SPY	ETF	442.2	442.2	442.2	442.2	259.0
2021-08-10 07:50:00	SPY	ETF	442.2	442.28	442.2	442.25	17599.0
2021-08-10 07:55:00	SPY	ETF	442.24	442.25	442.19	442.19	3088.0
2021-08-10 08:00:00	SPY	ETF	442.2399	442.511	441.63	442.2	24060.0
2021-08-10 08:05:00	SPY	ETF	442.19	442.23	442.19	442.23	445.0
2021-08-10 08:10:00	SPY	ETF	442.24	442.25	442.13	442.17	3501.0
2021-08-10 08:15:00	SPY	ETF	442.18	442.23	442.15	442.23	3136.0
2021-08-10 08:20:00	SPY	ETF	442.26	442.27	442.18	442.18	1180.0
2021-08-10 08:25:00	SPY	ETF	442.19	442.25	442.19	442.25	3282.0
2021-08-10 08:30:00	SPY	ETF	442.24	442.3	442.24	442.27	11303.0
2021-08-10 08:35:00	SPY	ETF	442.27	442.3	442.26	442.3	500.0
2021-08-10 08:40:00	SPY	ETF	442.298	442.3	442.26	442.26	2473.0
2021-08-10 08:45:00	SPY	ETF	442.28	442.32	442.28	442.29	17916.0
2021-08-10 08:50:00	SPY	ETF	442.27	442.3	442.23	442.27	9714.0
2021-08-10 08:55:00	SPY	ETF	442.27	442.29	442.25	442.25	8083.0
2021-08-10 09:00:00	SPY	ETF	442.28	442.41	442.27	442.4	12564.0

> showing 50 of 78,483 rows — these rows as CSV

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