PREVIEW / etf_1min / 2023-09-15

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-09-15.parquet
  size:    4.4 MB
  rows:    250,867

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-15 04:00:00	SPY	ETF	445.0	449.68	445.0	449.4	3259.0
2023-09-15 04:01:00	SPY	ETF	449.44	449.44	449.44	449.44	200.0
2023-09-15 04:02:00	SPY	ETF	449.37	449.37	449.25	449.25	2397.0
2023-09-15 04:03:00	SPY	ETF	449.26	449.38	449.26	449.36	3730.0
2023-09-15 04:04:00	SPY	ETF	449.25	449.25	449.22	449.24	2272.0
2023-09-15 04:05:00	SPY	ETF	449.34	449.34	449.33	449.33	200.0
2023-09-15 04:06:00	SPY	ETF	449.33	449.33	449.33	449.33	2103.0
2023-09-15 04:07:00	SPY	ETF	449.33	449.33	449.32	449.32	635.0
2023-09-15 04:08:00	SPY	ETF	449.47	449.47	449.41	449.41	675.0
2023-09-15 04:10:00	SPY	ETF	449.41	449.41	449.39	449.39	900.0
2023-09-15 04:11:00	SPY	ETF	449.29	449.29	449.29	449.29	100.0
2023-09-15 04:12:00	SPY	ETF	449.27	449.27	449.27	449.27	100.0
2023-09-15 04:13:00	SPY	ETF	449.36	449.36	449.36	449.36	100.0
2023-09-15 04:14:00	SPY	ETF	449.36	449.36	449.29	449.29	368.0
2023-09-15 04:15:00	SPY	ETF	449.31	449.31	449.31	449.31	100.0
2023-09-15 04:16:00	SPY	ETF	449.15	449.15	449.14	449.14	200.0
2023-09-15 04:17:00	SPY	ETF	449.13	449.13	449.13	449.13	1000.0
2023-09-15 04:19:00	SPY	ETF	449.11	449.11	449.1	449.1	200.0
2023-09-15 04:20:00	SPY	ETF	449.12	449.27	449.12	449.27	533.0
2023-09-15 04:21:00	SPY	ETF	449.25	449.26	449.2	449.2	803.0
2023-09-15 04:22:00	SPY	ETF	449.27	449.27	449.27	449.27	107.0
2023-09-15 04:24:00	SPY	ETF	449.2	449.21	449.2	449.21	500.0
2023-09-15 04:26:00	SPY	ETF	449.28	449.28	449.28	449.28	187.0
2023-09-15 04:28:00	SPY	ETF	449.22	449.22	449.22	449.22	1000.0
2023-09-15 04:29:00	SPY	ETF	449.18	449.18	449.18	449.18	800.0
2023-09-15 04:30:00	SPY	ETF	449.16	449.16	449.11	449.11	400.0
2023-09-15 04:31:00	SPY	ETF	449.1	449.12	449.1	449.1	4492.0
2023-09-15 04:35:00	SPY	ETF	449.2	449.2	449.2	449.2	475.0
2023-09-15 04:36:00	SPY	ETF	449.2	449.2	449.19	449.19	900.0
2023-09-15 04:37:00	SPY	ETF	449.1	449.1	449.1	449.1	2429.0
2023-09-15 04:38:00	SPY	ETF	449.1	449.1	449.1	449.1	1895.0
2023-09-15 04:39:00	SPY	ETF	449.1	449.1	449.1	449.1	500.0
2023-09-15 04:41:00	SPY	ETF	449.14	449.14	449.14	449.14	100.0
2023-09-15 04:43:00	SPY	ETF	449.17	449.17	449.17	449.17	100.0
2023-09-15 04:45:00	SPY	ETF	449.1	449.1	449.1	449.1	100.0
2023-09-15 04:46:00	SPY	ETF	449.12	449.12	449.12	449.12	200.0
2023-09-15 04:47:00	SPY	ETF	449.13	449.13	449.11	449.11	400.0
2023-09-15 04:48:00	SPY	ETF	449.21	449.21	449.21	449.21	500.0
2023-09-15 04:50:00	SPY	ETF	449.26	449.26	449.26	449.26	500.0
2023-09-15 04:52:00	SPY	ETF	449.23	449.23	449.23	449.23	600.0
2023-09-15 04:53:00	SPY	ETF	449.23	449.25	449.22	449.22	984.0
2023-09-15 04:54:00	SPY	ETF	449.1	449.12	449.1	449.1	2670.0
2023-09-15 04:56:00	SPY	ETF	449.15	449.15	449.11	449.11	487.0
2023-09-15 04:58:00	SPY	ETF	449.15	449.15	449.12	449.15	500.0
2023-09-15 04:59:00	SPY	ETF	449.1	449.1	449.1	449.1	900.0
2023-09-15 05:01:00	SPY	ETF	449.11	449.12	449.11	449.11	2250.0
2023-09-15 05:02:00	SPY	ETF	449.07	449.08	449.06	449.08	3200.0
2023-09-15 05:05:00	SPY	ETF	449.22	449.23	449.22	449.22	575.0
2023-09-15 05:07:00	SPY	ETF	449.36	449.36	449.36	449.36	100.0
2023-09-15 05:08:00	SPY	ETF	449.38	449.39	449.38	449.39	500.0

> showing 50 of 250,867 rows — these rows as CSV

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