PREVIEW / etf_1min / 2023-10-19

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-10-19.parquet
  size:    5.0 MB
  rows:    285,306

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-19 04:00:00	SPY	ETF	429.0	429.12	428.89	429.12	6254.0
2023-10-19 04:01:00	SPY	ETF	429.05	429.05	429.05	429.05	700.0
2023-10-19 04:02:00	SPY	ETF	429.05	429.05	428.94	428.94	2000.0
2023-10-19 04:03:00	SPY	ETF	428.9	428.92	428.87	428.92	1000.0
2023-10-19 04:04:00	SPY	ETF	428.83	428.86	428.83	428.86	463.0
2023-10-19 04:05:00	SPY	ETF	428.98	428.98	428.9	428.96	1409.0
2023-10-19 04:06:00	SPY	ETF	429.0	429.02	428.96	428.97	776.0
2023-10-19 04:07:00	SPY	ETF	429.05	429.23	429.05	429.22	5284.0
2023-10-19 04:08:00	SPY	ETF	429.2	429.22	429.2	429.2	1700.0
2023-10-19 04:09:00	SPY	ETF	429.03	429.03	429.03	429.03	100.0
2023-10-19 04:10:00	SPY	ETF	429.07	429.07	429.07	429.07	551.0
2023-10-19 04:11:00	SPY	ETF	428.95	429.0	428.92	428.92	500.0
2023-10-19 04:12:00	SPY	ETF	428.88	429.0	428.88	429.0	200.0
2023-10-19 04:13:00	SPY	ETF	428.91	428.91	428.91	428.91	400.0
2023-10-19 04:15:00	SPY	ETF	428.81	428.81	428.81	428.81	200.0
2023-10-19 04:16:00	SPY	ETF	428.85	429.02	428.85	429.02	325.0
2023-10-19 04:17:00	SPY	ETF	429.0	429.06	429.0	429.06	250.0
2023-10-19 04:18:00	SPY	ETF	429.05	429.05	429.05	429.05	500.0
2023-10-19 04:19:00	SPY	ETF	429.24	429.26	429.2	429.2	1800.0
2023-10-19 04:20:00	SPY	ETF	429.19	429.19	429.14	429.14	1100.0
2023-10-19 04:21:00	SPY	ETF	429.21	429.23	429.18	429.22	1600.0
2023-10-19 04:22:00	SPY	ETF	429.16	429.19	429.11	429.11	350.0
2023-10-19 04:23:00	SPY	ETF	429.0	429.0	429.0	429.0	250.0
2023-10-19 04:24:00	SPY	ETF	429.09	429.09	429.04	429.04	300.0
2023-10-19 04:25:00	SPY	ETF	429.13	429.13	429.13	429.13	250.0
2023-10-19 04:26:00	SPY	ETF	429.19	429.35	429.19	429.31	500.0
2023-10-19 04:27:00	SPY	ETF	429.34	429.36	429.23	429.32	2600.0
2023-10-19 04:28:00	SPY	ETF	429.24	429.24	429.24	429.24	200.0
2023-10-19 04:29:00	SPY	ETF	429.21	429.31	429.11	429.31	1100.0
2023-10-19 04:30:00	SPY	ETF	429.19	429.19	429.19	429.19	1200.0
2023-10-19 04:31:00	SPY	ETF	429.19	429.22	429.15	429.19	9200.0
2023-10-19 04:32:00	SPY	ETF	429.28	429.34	429.28	429.34	400.0
2023-10-19 04:33:00	SPY	ETF	429.21	429.32	429.21	429.32	200.0
2023-10-19 04:34:00	SPY	ETF	429.24	429.24	429.21	429.23	1115.0
2023-10-19 04:35:00	SPY	ETF	429.26	429.36	429.26	429.36	650.0
2023-10-19 04:36:00	SPY	ETF	429.37	429.37	429.24	429.25	1600.0
2023-10-19 04:37:00	SPY	ETF	429.22	429.22	429.22	429.22	100.0
2023-10-19 04:38:00	SPY	ETF	429.19	429.19	429.19	429.19	200.0
2023-10-19 04:40:00	SPY	ETF	428.93	429.15	428.93	429.15	2500.0
2023-10-19 04:41:00	SPY	ETF	429.21	429.27	429.21	429.27	300.0
2023-10-19 04:42:00	SPY	ETF	429.31	429.31	429.28	429.3	400.0
2023-10-19 04:43:00	SPY	ETF	429.41	429.41	429.41	429.41	100.0
2023-10-19 04:44:00	SPY	ETF	429.42	429.43	429.39	429.4	1105.0
2023-10-19 04:45:00	SPY	ETF	429.31	429.31	429.3	429.3	268.0
2023-10-19 04:48:00	SPY	ETF	429.15	429.15	429.13	429.13	1300.0
2023-10-19 04:49:00	SPY	ETF	429.09	429.13	429.03	429.05	800.0
2023-10-19 04:50:00	SPY	ETF	429.05	429.1	429.05	429.1	19280.0
2023-10-19 04:51:00	SPY	ETF	429.02	429.02	429.0	429.0	1287.0
2023-10-19 04:55:00	SPY	ETF	429.1	429.1	429.1	429.1	100.0
2023-10-19 04:56:00	SPY	ETF	429.16	429.16	429.16	429.16	100.0

> showing 50 of 285,306 rows — these rows as CSV

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