PREVIEW / etf_1min / 2023-09-18

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-09-18.parquet
  size:    4.3 MB
  rows:    241,060

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-18 04:00:00	SPY	ETF	444.0	444.18	444.0	444.13	2913.0
2023-09-18 04:01:00	SPY	ETF	444.08	444.08	444.02	444.02	600.0
2023-09-18 04:02:00	SPY	ETF	444.02	444.06	444.02	444.06	884.0
2023-09-18 04:03:00	SPY	ETF	444.02	444.02	444.0	444.0	500.0
2023-09-18 04:04:00	SPY	ETF	444.0	444.05	444.0	444.05	643.0
2023-09-18 04:06:00	SPY	ETF	444.0	444.0	443.97	443.97	1400.0
2023-09-18 04:07:00	SPY	ETF	444.04	444.08	444.04	444.08	302.0
2023-09-18 04:09:00	SPY	ETF	444.07	444.09	444.07	444.08	924.0
2023-09-18 04:13:00	SPY	ETF	444.14	444.15	444.14	444.15	437.0
2023-09-18 04:14:00	SPY	ETF	444.11	444.11	444.11	444.11	100.0
2023-09-18 04:15:00	SPY	ETF	444.11	444.11	444.07	444.07	2131.0
2023-09-18 04:17:00	SPY	ETF	444.03	444.03	444.03	444.03	100.0
2023-09-18 04:18:00	SPY	ETF	443.96	443.96	443.96	443.96	100.0
2023-09-18 04:19:00	SPY	ETF	443.95	443.95	443.93	443.93	427.0
2023-09-18 04:22:00	SPY	ETF	443.95	443.95	443.95	443.95	500.0
2023-09-18 04:23:00	SPY	ETF	443.99	444.02	443.98	443.98	1616.0
2023-09-18 04:24:00	SPY	ETF	443.98	443.98	443.98	443.98	400.0
2023-09-18 04:25:00	SPY	ETF	443.97	443.97	443.97	443.97	100.0
2023-09-18 04:26:00	SPY	ETF	443.92	443.92	443.92	443.92	100.0
2023-09-18 04:30:00	SPY	ETF	443.87	443.9	443.87	443.9	912.0
2023-09-18 04:31:00	SPY	ETF	443.92	443.96	443.92	443.96	787.0
2023-09-18 04:32:00	SPY	ETF	443.96	443.96	443.96	443.96	400.0
2023-09-18 04:36:00	SPY	ETF	443.95	443.95	443.95	443.95	200.0
2023-09-18 04:38:00	SPY	ETF	443.94	444.1	443.94	444.1	598.0
2023-09-18 04:39:00	SPY	ETF	444.14	444.16	444.14	444.16	800.0
2023-09-18 04:40:00	SPY	ETF	444.12	444.12	444.12	444.12	1371.0
2023-09-18 04:41:00	SPY	ETF	444.17	444.17	444.16	444.16	387.0
2023-09-18 04:42:00	SPY	ETF	444.1	444.1	444.07	444.07	405.0
2023-09-18 04:43:00	SPY	ETF	444.0	444.0	444.0	444.0	100.0
2023-09-18 04:45:00	SPY	ETF	443.95	443.95	443.95	443.95	100.0
2023-09-18 04:46:00	SPY	ETF	443.92	443.92	443.92	443.92	187.0
2023-09-18 04:49:00	SPY	ETF	443.98	443.98	443.98	443.98	103.0
2023-09-18 04:52:00	SPY	ETF	444.08	444.08	444.08	444.08	100.0
2023-09-18 04:53:00	SPY	ETF	444.05	444.06	444.05	444.05	546.0
2023-09-18 04:54:00	SPY	ETF	444.04	444.05	444.04	444.05	200.0
2023-09-18 04:55:00	SPY	ETF	444.0	444.0	444.0	444.0	202.0
2023-09-18 04:56:00	SPY	ETF	443.96	443.96	443.91	443.91	302.0
2023-09-18 04:58:00	SPY	ETF	443.9	443.9	443.89	443.89	220.0
2023-09-18 04:59:00	SPY	ETF	443.85	443.85	443.85	443.85	100.0
2023-09-18 05:00:00	SPY	ETF	443.85	443.86	443.85	443.86	300.0
2023-09-18 05:01:00	SPY	ETF	443.86	443.88	443.86	443.88	320.0
2023-09-18 05:02:00	SPY	ETF	443.87	443.98	443.87	443.98	500.0
2023-09-18 05:03:00	SPY	ETF	443.9	443.9	443.9	443.9	100.0
2023-09-18 05:04:00	SPY	ETF	443.93	443.93	443.87	443.87	200.0
2023-09-18 05:05:00	SPY	ETF	443.87	443.9	443.87	443.9	400.0
2023-09-18 05:07:00	SPY	ETF	444.04	444.04	444.04	444.04	312.0
2023-09-18 05:11:00	SPY	ETF	443.95	443.95	443.95	443.95	100.0
2023-09-18 05:12:00	SPY	ETF	443.92	443.92	443.87	443.87	387.0
2023-09-18 05:13:00	SPY	ETF	443.89	443.95	443.89	443.95	200.0
2023-09-18 05:14:00	SPY	ETF	443.92	443.92	443.9	443.9	202.0

> showing 50 of 241,060 rows — these rows as CSV

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