PREVIEW / etf_1min / 2023-01-18

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-01-18.parquet
  size:    4.9 MB
  rows:    277,260

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-01-18 04:00:00	SPY	ETF	398.22	398.33	397.77	398.33	2905.0
2023-01-18 04:01:00	SPY	ETF	398.31	398.31	398.19	398.19	200.0
2023-01-18 04:02:00	SPY	ETF	398.22	398.22	398.22	398.22	200.0
2023-01-18 04:03:00	SPY	ETF	398.27	398.27	398.27	398.27	600.0
2023-01-18 04:04:00	SPY	ETF	398.02	398.08	398.02	398.08	455.0
2023-01-18 04:05:00	SPY	ETF	398.05	398.05	398.05	398.05	110.0
2023-01-18 04:06:00	SPY	ETF	398.12	398.12	397.93	397.94	2521.0
2023-01-18 04:08:00	SPY	ETF	397.9	397.91	397.9	397.91	600.0
2023-01-18 04:09:00	SPY	ETF	397.99	397.99	397.99	397.99	300.0
2023-01-18 04:10:00	SPY	ETF	398.04	398.04	398.03	398.03	472.0
2023-01-18 04:13:00	SPY	ETF	397.93	397.93	397.93	397.93	188.0
2023-01-18 04:14:00	SPY	ETF	397.89	397.89	397.89	397.89	300.0
2023-01-18 04:15:00	SPY	ETF	398.0	398.0	397.98	398.0	312.0
2023-01-18 04:16:00	SPY	ETF	397.89	397.89	397.89	397.89	150.0
2023-01-18 04:17:00	SPY	ETF	397.96	397.96	397.96	397.96	100.0
2023-01-18 04:18:00	SPY	ETF	398.07	398.07	398.07	398.07	100.0
2023-01-18 04:19:00	SPY	ETF	398.09	398.09	398.07	398.09	469.0
2023-01-18 04:23:00	SPY	ETF	398.09	398.09	398.09	398.09	100.0
2023-01-18 04:25:00	SPY	ETF	398.14	398.19	398.14	398.19	1307.0
2023-01-18 04:26:00	SPY	ETF	398.21	398.21	398.14	398.14	265.0
2023-01-18 04:27:00	SPY	ETF	398.13	398.14	398.13	398.14	2000.0
2023-01-18 04:28:00	SPY	ETF	398.1	398.1	397.99	397.99	731.0
2023-01-18 04:29:00	SPY	ETF	398.02	398.02	398.02	398.02	145.0
2023-01-18 04:31:00	SPY	ETF	397.91	397.91	397.91	397.91	200.0
2023-01-18 04:34:00	SPY	ETF	397.94	397.94	397.94	397.94	100.0
2023-01-18 04:35:00	SPY	ETF	397.97	397.97	397.85	397.85	483.0
2023-01-18 04:36:00	SPY	ETF	397.83	397.83	397.82	397.82	209.0
2023-01-18 04:37:00	SPY	ETF	397.97	397.97	397.97	397.97	200.0
2023-01-18 04:38:00	SPY	ETF	397.91	397.91	397.91	397.91	100.0
2023-01-18 04:39:00	SPY	ETF	397.92	397.92	397.83	397.83	252.0
2023-01-18 04:41:00	SPY	ETF	397.94	397.94	397.94	397.94	133.0
2023-01-18 04:49:00	SPY	ETF	397.96	397.96	397.96	397.96	300.0
2023-01-18 04:50:00	SPY	ETF	397.96	397.96	397.96	397.96	105.0
2023-01-18 04:51:00	SPY	ETF	398.0	398.0	398.0	398.0	800.0
2023-01-18 04:52:00	SPY	ETF	398.0	398.0	398.0	398.0	150.0
2023-01-18 04:53:00	SPY	ETF	398.02	398.02	398.02	398.02	500.0
2023-01-18 04:56:00	SPY	ETF	398.08	398.08	398.08	398.08	500.0
2023-01-18 05:00:00	SPY	ETF	397.95	397.95	397.95	397.95	200.0
2023-01-18 05:01:00	SPY	ETF	397.91	397.95	397.91	397.95	509.0
2023-01-18 05:02:00	SPY	ETF	398.01	398.01	397.96	397.96	324.0
2023-01-18 05:03:00	SPY	ETF	398.0	398.1	398.0	398.1	200.0
2023-01-18 05:07:00	SPY	ETF	397.99	397.99	397.98	397.98	204.0
2023-01-18 05:11:00	SPY	ETF	397.92	397.98	397.92	397.98	373.0
2023-01-18 05:13:00	SPY	ETF	397.94	397.94	397.94	397.94	225.0
2023-01-18 05:18:00	SPY	ETF	398.07	398.07	398.07	398.07	100.0
2023-01-18 05:20:00	SPY	ETF	398.06	398.06	398.06	398.06	100.0
2023-01-18 05:21:00	SPY	ETF	398.0	398.0	398.0	398.0	600.0
2023-01-18 05:22:00	SPY	ETF	398.03	398.03	398.03	398.03	103.0
2023-01-18 05:24:00	SPY	ETF	398.12	398.12	398.09	398.09	1600.0
2023-01-18 05:25:00	SPY	ETF	398.13	398.14	398.13	398.14	1000.0

> showing 50 of 277,260 rows — these rows as CSV

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