PREVIEW / etf_1min / 2023-08-16

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-08-16.parquet
  size:    4.7 MB
  rows:    265,553

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-08-16 04:00:00	SPY	ETF	443.71	443.8	443.71	443.76	2700.0
2023-08-16 04:01:00	SPY	ETF	443.8	443.81	443.75	443.8	2720.0
2023-08-16 04:02:00	SPY	ETF	443.81	443.84	443.81	443.84	211.0
2023-08-16 04:03:00	SPY	ETF	443.84	443.86	443.84	443.86	1892.0
2023-08-16 04:07:00	SPY	ETF	443.86	443.86	443.86	443.86	100.0
2023-08-16 04:08:00	SPY	ETF	443.9	443.9	443.9	443.9	980.0
2023-08-16 04:09:00	SPY	ETF	443.94	443.94	443.94	443.94	300.0
2023-08-16 04:10:00	SPY	ETF	443.85	443.85	443.85	443.85	130.0
2023-08-16 04:11:00	SPY	ETF	443.85	443.88	443.85	443.88	2060.0
2023-08-16 04:12:00	SPY	ETF	443.95	443.95	443.95	443.95	100.0
2023-08-16 04:13:00	SPY	ETF	443.96	443.96	443.96	443.96	100.0
2023-08-16 04:14:00	SPY	ETF	443.92	443.92	443.92	443.92	195.0
2023-08-16 04:15:00	SPY	ETF	443.98	444.01	443.98	444.01	800.0
2023-08-16 04:16:00	SPY	ETF	444.07	444.07	444.07	444.07	675.0
2023-08-16 04:18:00	SPY	ETF	443.97	443.97	443.9	443.9	4305.0
2023-08-16 04:22:00	SPY	ETF	444.02	444.02	444.02	444.02	830.0
2023-08-16 04:23:00	SPY	ETF	444.06	444.1	444.06	444.09	5500.0
2023-08-16 04:24:00	SPY	ETF	444.11	444.12	444.11	444.12	630.0
2023-08-16 04:25:00	SPY	ETF	444.1	444.11	444.1	444.11	640.0
2023-08-16 04:26:00	SPY	ETF	444.19	444.19	444.19	444.19	206.0
2023-08-16 04:27:00	SPY	ETF	444.24	444.26	444.24	444.26	990.0
2023-08-16 04:28:00	SPY	ETF	444.26	444.26	444.26	444.26	278.0
2023-08-16 04:29:00	SPY	ETF	444.24	444.29	444.24	444.29	409.0
2023-08-16 04:30:00	SPY	ETF	444.24	444.27	444.24	444.27	212.0
2023-08-16 04:31:00	SPY	ETF	444.29	444.33	444.29	444.32	1664.0
2023-08-16 04:34:00	SPY	ETF	444.23	444.23	444.19	444.19	1402.0
2023-08-16 04:35:00	SPY	ETF	444.18	444.18	444.08	444.11	3696.0
2023-08-16 04:36:00	SPY	ETF	444.02	444.02	444.0	444.0	600.0
2023-08-16 04:37:00	SPY	ETF	443.91	443.91	443.91	443.91	299.0
2023-08-16 04:38:00	SPY	ETF	443.95	444.04	443.95	444.04	200.0
2023-08-16 04:39:00	SPY	ETF	444.04	444.09	444.04	444.09	202.0
2023-08-16 04:41:00	SPY	ETF	444.13	444.22	444.13	444.22	7900.0
2023-08-16 04:42:00	SPY	ETF	444.16	444.19	444.16	444.19	495.0
2023-08-16 04:44:00	SPY	ETF	444.1	444.1	444.1	444.1	100.0
2023-08-16 04:45:00	SPY	ETF	444.15	444.15	444.15	444.15	300.0
2023-08-16 04:46:00	SPY	ETF	444.09	444.09	444.09	444.09	200.0
2023-08-16 04:48:00	SPY	ETF	444.1	444.1	444.1	444.1	100.0
2023-08-16 04:49:00	SPY	ETF	444.08	444.08	444.08	444.08	400.0
2023-08-16 04:51:00	SPY	ETF	443.98	443.98	443.98	443.98	500.0
2023-08-16 04:52:00	SPY	ETF	444.06	444.06	444.04	444.04	213.0
2023-08-16 04:54:00	SPY	ETF	444.14	444.14	444.14	444.14	100.0
2023-08-16 04:55:00	SPY	ETF	444.11	444.11	444.11	444.11	100.0
2023-08-16 04:56:00	SPY	ETF	444.07	444.07	444.07	444.07	230.0
2023-08-16 04:57:00	SPY	ETF	444.07	444.07	443.98	443.98	1500.0
2023-08-16 04:58:00	SPY	ETF	443.94	443.94	443.94	443.94	400.0
2023-08-16 05:01:00	SPY	ETF	443.98	443.98	443.98	443.98	400.0
2023-08-16 05:02:00	SPY	ETF	444.06	444.06	444.06	444.06	325.0
2023-08-16 05:05:00	SPY	ETF	444.0	444.0	443.88	443.91	6596.0
2023-08-16 05:07:00	SPY	ETF	443.75	443.77	443.75	443.77	600.0
2023-08-16 05:08:00	SPY	ETF	443.72	443.72	443.72	443.72	996.0

> showing 50 of 265,553 rows — these rows as CSV

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