PREVIEW / etf_1min / 2023-10-27

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-10-27.parquet
  size:    4.9 MB
  rows:    277,555

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-10-27 04:00:00	SPY	ETF	414.5	414.51	414.4	414.51	930.0
2023-10-27 04:01:00	SPY	ETF	414.56	414.56	414.56	414.56	1000.0
2023-10-27 04:02:00	SPY	ETF	414.48	414.6	414.47	414.6	1056.0
2023-10-27 04:03:00	SPY	ETF	414.65	414.78	414.65	414.78	449.0
2023-10-27 04:04:00	SPY	ETF	414.74	414.74	414.74	414.74	100.0
2023-10-27 04:05:00	SPY	ETF	414.77	414.77	414.77	414.77	117.0
2023-10-27 04:06:00	SPY	ETF	414.78	414.78	414.74	414.78	775.0
2023-10-27 04:07:00	SPY	ETF	414.79	414.79	414.79	414.79	100.0
2023-10-27 04:09:00	SPY	ETF	414.69	414.69	414.69	414.69	100.0
2023-10-27 04:10:00	SPY	ETF	414.62	414.62	414.62	414.62	100.0
2023-10-27 04:11:00	SPY	ETF	414.5	414.58	414.5	414.58	336.0
2023-10-27 04:12:00	SPY	ETF	414.58	414.58	414.58	414.58	143.0
2023-10-27 04:13:00	SPY	ETF	414.67	414.67	414.67	414.67	124.0
2023-10-27 04:14:00	SPY	ETF	414.67	414.67	414.67	414.67	608.0
2023-10-27 04:15:00	SPY	ETF	414.67	414.77	414.67	414.72	700.0
2023-10-27 04:16:00	SPY	ETF	414.67	414.72	414.67	414.72	326.0
2023-10-27 04:17:00	SPY	ETF	414.75	414.77	414.75	414.76	550.0
2023-10-27 04:18:00	SPY	ETF	414.83	414.83	414.77	414.77	600.0
2023-10-27 04:19:00	SPY	ETF	414.89	414.89	414.89	414.89	100.0
2023-10-27 04:20:00	SPY	ETF	414.86	414.86	414.86	414.86	250.0
2023-10-27 04:21:00	SPY	ETF	414.8	414.9	414.8	414.9	900.0
2023-10-27 04:23:00	SPY	ETF	414.95	414.96	414.87	414.87	2300.0
2023-10-27 04:24:00	SPY	ETF	414.89	414.92	414.89	414.92	950.0
2023-10-27 04:25:00	SPY	ETF	414.83	414.83	414.77	414.81	3942.0
2023-10-27 04:26:00	SPY	ETF	414.85	414.85	414.85	414.85	100.0
2023-10-27 04:27:00	SPY	ETF	414.89	414.92	414.88	414.88	500.0
2023-10-27 04:28:00	SPY	ETF	414.88	414.88	414.88	414.88	100.0
2023-10-27 04:29:00	SPY	ETF	414.92	414.92	414.89	414.89	1250.0
2023-10-27 04:30:00	SPY	ETF	414.95	414.96	414.87	414.92	1525.0
2023-10-27 04:31:00	SPY	ETF	414.97	415.09	414.97	414.98	792.0
2023-10-27 04:32:00	SPY	ETF	415.07	415.07	415.02	415.02	850.0
2023-10-27 04:33:00	SPY	ETF	415.05	415.05	415.05	415.05	650.0
2023-10-27 04:34:00	SPY	ETF	415.06	415.08	415.06	415.07	750.0
2023-10-27 04:35:00	SPY	ETF	415.04	415.05	415.04	415.05	700.0
2023-10-27 04:36:00	SPY	ETF	415.07	415.1	415.07	415.07	750.0
2023-10-27 04:38:00	SPY	ETF	415.04	415.04	414.97	414.97	260.0
2023-10-27 04:39:00	SPY	ETF	415.12	415.12	415.12	415.12	487.0
2023-10-27 04:40:00	SPY	ETF	415.14	415.14	415.04	415.04	700.0
2023-10-27 04:41:00	SPY	ETF	415.1	415.18	415.1	415.15	850.0
2023-10-27 04:42:00	SPY	ETF	415.2	415.2	415.19	415.19	462.0
2023-10-27 04:45:00	SPY	ETF	415.18	415.18	415.18	415.18	150.0
2023-10-27 04:46:00	SPY	ETF	415.15	415.15	415.15	415.15	200.0
2023-10-27 04:47:00	SPY	ETF	415.18	415.18	415.18	415.18	250.0
2023-10-27 04:48:00	SPY	ETF	415.08	415.08	415.04	415.08	1750.0
2023-10-27 04:49:00	SPY	ETF	415.05	415.08	415.01	415.01	800.0
2023-10-27 04:50:00	SPY	ETF	415.08	415.08	415.06	415.06	450.0
2023-10-27 04:51:00	SPY	ETF	415.04	415.13	415.02	415.13	1602.0
2023-10-27 04:52:00	SPY	ETF	415.13	415.14	415.13	415.14	750.0
2023-10-27 04:54:00	SPY	ETF	415.14	415.14	415.14	415.14	393.0
2023-10-27 04:55:00	SPY	ETF	415.09	415.09	415.09	415.09	150.0

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

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