PREVIEW / etf_5min / 2023-09-19

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-09-19.parquet
  size:    1.9 MB
  rows:    93,017

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-09-19 04:00:00	SPY	ETF	444.06	444.21	444.05	444.18	869.0
2023-09-19 04:05:00	SPY	ETF	444.21	444.26	444.21	444.26	472.0
2023-09-19 04:10:00	SPY	ETF	444.29	444.36	444.29	444.36	812.0
2023-09-19 04:15:00	SPY	ETF	444.32	444.32	444.15	444.15	1650.0
2023-09-19 04:20:00	SPY	ETF	444.17	444.23	444.17	444.21	662.0
2023-09-19 04:25:00	SPY	ETF	444.22	444.24	444.15	444.15	814.0
2023-09-19 04:30:00	SPY	ETF	444.18	444.22	444.15	444.22	468.0
2023-09-19 04:35:00	SPY	ETF	444.19	444.24	444.17	444.22	877.0
2023-09-19 04:40:00	SPY	ETF	444.17	444.18	444.17	444.18	336.0
2023-09-19 04:45:00	SPY	ETF	444.26	444.26	444.26	444.26	105.0
2023-09-19 04:50:00	SPY	ETF	444.27	444.3	444.24	444.3	947.0
2023-09-19 05:00:00	SPY	ETF	444.21	444.21	444.13	444.13	563.0
2023-09-19 05:05:00	SPY	ETF	444.09	444.12	444.09	444.12	232.0
2023-09-19 05:10:00	SPY	ETF	444.05	444.09	444.05	444.09	359.0
2023-09-19 05:15:00	SPY	ETF	444.17	444.21	444.17	444.21	496.0
2023-09-19 05:20:00	SPY	ETF	444.2	444.21	444.2	444.21	1421.0
2023-09-19 05:25:00	SPY	ETF	444.31	444.5	444.31	444.5	5306.0
2023-09-19 05:30:00	SPY	ETF	444.49	444.5	444.45	444.5	3497.0
2023-09-19 05:35:00	SPY	ETF	444.48	444.48	444.43	444.45	1053.0
2023-09-19 05:40:00	SPY	ETF	444.47	444.47	444.47	444.47	225.0
2023-09-19 05:45:00	SPY	ETF	444.43	444.43	444.41	444.41	1012.0
2023-09-19 05:50:00	SPY	ETF	444.38	444.39	444.36	444.39	1700.0
2023-09-19 06:00:00	SPY	ETF	444.33	444.34	444.29	444.29	1265.0
2023-09-19 06:05:00	SPY	ETF	444.38	444.39	444.35	444.39	544.0
2023-09-19 06:10:00	SPY	ETF	444.41	444.44	444.41	444.44	287.0
2023-09-19 06:20:00	SPY	ETF	444.44	444.44	444.41	444.41	536.0
2023-09-19 06:25:00	SPY	ETF	444.43	444.43	444.3	444.3	1000.0
2023-09-19 06:30:00	SPY	ETF	444.36	444.37	444.34	444.37	1750.0
2023-09-19 06:35:00	SPY	ETF	444.43	444.5	444.43	444.46	709.0
2023-09-19 06:40:00	SPY	ETF	444.47	444.56	444.47	444.56	1550.0
2023-09-19 06:45:00	SPY	ETF	444.48	444.48	444.39	444.39	1002.0
2023-09-19 06:50:00	SPY	ETF	444.35	444.36	444.29	444.36	8688.0
2023-09-19 06:55:00	SPY	ETF	444.27	444.27	444.2	444.25	8600.0
2023-09-19 07:00:00	SPY	ETF	444.24	444.24	444.19	444.19	2549.0
2023-09-19 07:05:00	SPY	ETF	444.2	444.25	444.2	444.25	1617.0
2023-09-19 07:10:00	SPY	ETF	444.26	444.26	444.16	444.16	1808.0
2023-09-19 07:15:00	SPY	ETF	444.16	444.19	444.12	444.13	11650.0
2023-09-19 07:20:00	SPY	ETF	444.24	444.31	444.24	444.3	1844.0
2023-09-19 07:25:00	SPY	ETF	444.311	444.35	444.29	444.35	2321.0
2023-09-19 07:30:00	SPY	ETF	444.36	444.36	444.2	444.2	53242.0
2023-09-19 07:35:00	SPY	ETF	444.26	444.26	444.11	444.11	4197.0
2023-09-19 07:40:00	SPY	ETF	444.1	444.11	444.0	444.05	57865.0
2023-09-19 07:45:00	SPY	ETF	444.01	444.13	443.96	444.13	4973.0
2023-09-19 07:50:00	SPY	ETF	444.13	444.18	444.1	444.16	1988.0
2023-09-19 07:55:00	SPY	ETF	444.16	444.16	444.09	444.13	1772.0
2023-09-19 08:00:00	SPY	ETF	444.21	444.41	443.24	444.02	81232.0
2023-09-19 08:05:00	SPY	ETF	444.04	444.08	444.02	444.06	11172.0
2023-09-19 08:10:00	SPY	ETF	444.04	444.15	444.0	444.15	3425.0
2023-09-19 08:15:00	SPY	ETF	444.14	444.14	443.86	443.87	42712.0
2023-09-19 08:20:00	SPY	ETF	443.87	443.9	443.81	443.87	17554.0

> showing 50 of 93,017 rows — these rows as CSV

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