PREVIEW / etf_5min / 2023-09-06

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-09-06.parquet
  size:    2.0 MB
  rows:    94,698

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-06 04:00:00	SPY	ETF	448.09	448.26	447.98	448.26	2926.0
2023-09-06 04:05:00	SPY	ETF	448.28	448.6	448.28	448.6	650.0
2023-09-06 04:10:00	SPY	ETF	448.52	448.52	448.47	448.47	593.0
2023-09-06 04:15:00	SPY	ETF	448.27	448.27	448.19	448.19	600.0
2023-09-06 04:20:00	SPY	ETF	448.11	448.21	448.11	448.2	1333.0
2023-09-06 04:25:00	SPY	ETF	448.2	448.21	448.12	448.12	737.0
2023-09-06 04:30:00	SPY	ETF	448.12	448.2	448.12	448.2	231.0
2023-09-06 04:35:00	SPY	ETF	448.3	448.3	448.11	448.11	884.0
2023-09-06 04:40:00	SPY	ETF	448.09	448.09	448.09	448.09	700.0
2023-09-06 04:45:00	SPY	ETF	448.14	448.15	448.14	448.14	700.0
2023-09-06 04:50:00	SPY	ETF	448.31	448.31	448.31	448.31	100.0
2023-09-06 05:00:00	SPY	ETF	448.52	448.52	448.52	448.52	500.0
2023-09-06 05:05:00	SPY	ETF	448.38	448.38	448.38	448.38	118.0
2023-09-06 05:10:00	SPY	ETF	448.33	448.33	448.33	448.33	1000.0
2023-09-06 05:20:00	SPY	ETF	448.49	448.49	448.49	448.49	100.0
2023-09-06 05:25:00	SPY	ETF	448.31	448.31	448.31	448.31	200.0
2023-09-06 05:30:00	SPY	ETF	448.43	448.45	448.43	448.45	206.0
2023-09-06 05:35:00	SPY	ETF	448.35	448.35	448.33	448.35	1241.0
2023-09-06 05:45:00	SPY	ETF	448.26	448.26	448.26	448.26	100.0
2023-09-06 05:55:00	SPY	ETF	448.5	448.53	448.5	448.53	900.0
2023-09-06 06:00:00	SPY	ETF	448.43	448.43	448.43	448.43	700.0
2023-09-06 06:10:00	SPY	ETF	448.6	448.6	448.6	448.6	248.0
2023-09-06 06:15:00	SPY	ETF	448.63	448.63	448.55	448.55	1200.0
2023-09-06 06:20:00	SPY	ETF	448.55	448.55	448.5	448.5	785.0
2023-09-06 06:25:00	SPY	ETF	448.45	448.45	448.41	448.43	1140.0
2023-09-06 06:30:00	SPY	ETF	448.52	448.57	448.51	448.57	1400.0
2023-09-06 06:35:00	SPY	ETF	448.57	448.57	448.43	448.46	543.0
2023-09-06 06:40:00	SPY	ETF	448.4	448.4	448.4	448.4	500.0
2023-09-06 06:45:00	SPY	ETF	448.51	448.51	448.51	448.51	100.0
2023-09-06 06:50:00	SPY	ETF	448.43	448.48	448.43	448.43	606.0
2023-09-06 06:55:00	SPY	ETF	448.38	448.38	448.36	448.36	440.0
2023-09-06 07:00:00	SPY	ETF	448.37	448.45	448.23	448.23	8777.0
2023-09-06 07:05:00	SPY	ETF	448.22	448.31	448.2	448.31	2313.0
2023-09-06 07:10:00	SPY	ETF	448.28	448.51	448.28	448.5	8317.0
2023-09-06 07:15:00	SPY	ETF	448.51	448.53	448.41	448.53	10483.0
2023-09-06 07:20:00	SPY	ETF	448.56	448.58	448.55	448.55	8946.0
2023-09-06 07:25:00	SPY	ETF	448.5	448.53	448.45	448.53	700.0
2023-09-06 07:30:00	SPY	ETF	448.52	448.52	448.49	448.49	400.0
2023-09-06 07:35:00	SPY	ETF	448.47	448.58	448.47	448.55	1550.0
2023-09-06 07:40:00	SPY	ETF	448.57	448.57	448.27	448.3	3400.0
2023-09-06 07:45:00	SPY	ETF	448.3	448.36	448.25	448.36	872.0
2023-09-06 07:50:00	SPY	ETF	448.3	448.3	448.17	448.24	9621.0
2023-09-06 07:55:00	SPY	ETF	448.33	448.33	448.25	448.33	7872.0
2023-09-06 08:00:00	SPY	ETF	448.26	449.12	447.89	448.24	58245.0
2023-09-06 08:05:00	SPY	ETF	448.25	448.39	448.19	448.39	2655.0
2023-09-06 08:10:00	SPY	ETF	448.35	448.35	448.21	448.26	4547.0
2023-09-06 08:15:00	SPY	ETF	448.2394	448.32	448.23	448.25	2562.0
2023-09-06 08:20:00	SPY	ETF	448.24	448.35	448.2	448.27	6581.0
2023-09-06 08:25:00	SPY	ETF	448.23	448.28	448.18	448.22	8516.0
2023-09-06 08:30:00	SPY	ETF	448.26	448.26	448.1	448.1	13448.0

> showing 50 of 94,698 rows — these rows as CSV

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