PREVIEW / etf_1min / 2023-09-19

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-09-19.parquet
  size:    4.4 MB
  rows:    242,508

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.1	444.05	444.1	650.0
2023-09-19 04:02:00	SPY	ETF	444.21	444.21	444.21	444.21	100.0
2023-09-19 04:03:00	SPY	ETF	444.18	444.18	444.18	444.18	119.0
2023-09-19 04:05:00	SPY	ETF	444.21	444.22	444.21	444.22	224.0
2023-09-19 04:07:00	SPY	ETF	444.23	444.26	444.23	444.26	248.0
2023-09-19 04:11:00	SPY	ETF	444.29	444.29	444.29	444.29	712.0
2023-09-19 04:13:00	SPY	ETF	444.36	444.36	444.36	444.36	100.0
2023-09-19 04:15:00	SPY	ETF	444.32	444.32	444.31	444.31	800.0
2023-09-19 04:17:00	SPY	ETF	444.23	444.23	444.23	444.23	100.0
2023-09-19 04:19:00	SPY	ETF	444.17	444.17	444.15	444.15	750.0
2023-09-19 04:20:00	SPY	ETF	444.17	444.17	444.17	444.17	112.0
2023-09-19 04:21:00	SPY	ETF	444.18	444.18	444.18	444.18	212.0
2023-09-19 04:23:00	SPY	ETF	444.23	444.23	444.21	444.21	338.0
2023-09-19 04:25:00	SPY	ETF	444.22	444.22	444.22	444.22	105.0
2023-09-19 04:26:00	SPY	ETF	444.21	444.21	444.21	444.21	150.0
2023-09-19 04:27:00	SPY	ETF	444.24	444.24	444.21	444.21	332.0
2023-09-19 04:29:00	SPY	ETF	444.15	444.15	444.15	444.15	227.0
2023-09-19 04:31:00	SPY	ETF	444.18	444.19	444.15	444.15	368.0
2023-09-19 04:34:00	SPY	ETF	444.22	444.22	444.22	444.22	100.0
2023-09-19 04:35:00	SPY	ETF	444.19	444.19	444.19	444.19	100.0
2023-09-19 04:36:00	SPY	ETF	444.19	444.19	444.17	444.17	498.0
2023-09-19 04:39:00	SPY	ETF	444.24	444.24	444.22	444.22	279.0
2023-09-19 04:41:00	SPY	ETF	444.17	444.17	444.17	444.17	224.0
2023-09-19 04:44:00	SPY	ETF	444.18	444.18	444.18	444.18	112.0
2023-09-19 04:49: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.27	444.3	323.0
2023-09-19 04:52:00	SPY	ETF	444.27	444.27	444.27	444.27	112.0
2023-09-19 04:53:00	SPY	ETF	444.24	444.3	444.24	444.3	512.0
2023-09-19 05:00:00	SPY	ETF	444.21	444.21	444.21	444.21	141.0
2023-09-19 05:01:00	SPY	ETF	444.16	444.16	444.13	444.13	422.0
2023-09-19 05:07:00	SPY	ETF	444.09	444.09	444.09	444.09	102.0
2023-09-19 05:08:00	SPY	ETF	444.12	444.12	444.12	444.12	130.0
2023-09-19 05:13:00	SPY	ETF	444.05	444.05	444.05	444.05	200.0
2023-09-19 05:14:00	SPY	ETF	444.09	444.09	444.09	444.09	159.0
2023-09-19 05:15:00	SPY	ETF	444.17	444.17	444.17	444.17	172.0
2023-09-19 05:18:00	SPY	ETF	444.21	444.21	444.21	444.21	124.0
2023-09-19 05:19:00	SPY	ETF	444.21	444.21	444.21	444.21	200.0
2023-09-19 05:24:00	SPY	ETF	444.2	444.21	444.2	444.21	1421.0
2023-09-19 05:26:00	SPY	ETF	444.31	444.43	444.31	444.43	1108.0
2023-09-19 05:27:00	SPY	ETF	444.44	444.49	444.44	444.49	900.0
2023-09-19 05:28:00	SPY	ETF	444.5	444.5	444.5	444.5	1400.0
2023-09-19 05:29:00	SPY	ETF	444.5	444.5	444.5	444.5	1898.0
2023-09-19 05:32:00	SPY	ETF	444.49	444.49	444.45	444.45	2497.0
2023-09-19 05:34:00	SPY	ETF	444.5	444.5	444.5	444.5	1000.0
2023-09-19 05:35:00	SPY	ETF	444.48	444.48	444.48	444.48	800.0
2023-09-19 05:36:00	SPY	ETF	444.43	444.43	444.43	444.43	141.0
2023-09-19 05:39:00	SPY	ETF	444.45	444.45	444.45	444.45	112.0
2023-09-19 05:42:00	SPY	ETF	444.47	444.47	444.47	444.47	225.0
2023-09-19 05:46:00	SPY	ETF	444.43	444.43	444.43	444.43	112.0
2023-09-19 05:48:00	SPY	ETF	444.41	444.41	444.41	444.41	500.0

> showing 50 of 242,508 rows — these rows as CSV

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