PREVIEW / etf_1min / 2023-08-18

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-08-18.parquet
  size:    4.6 MB
  rows:    262,347

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-18 04:00:00	SPY	ETF	435.87	435.96	435.87	435.92	500.0
2023-08-18 04:01:00	SPY	ETF	435.97	436.04	435.97	436.02	9049.0
2023-08-18 04:02:00	SPY	ETF	436.04	436.04	435.94	436.02	1225.0
2023-08-18 04:03:00	SPY	ETF	436.02	436.22	436.02	436.22	1323.0
2023-08-18 04:04:00	SPY	ETF	436.35	436.35	436.27	436.27	200.0
2023-08-18 04:05:00	SPY	ETF	436.27	436.37	436.27	436.37	3000.0
2023-08-18 04:06:00	SPY	ETF	436.36	436.36	436.24	436.3	875.0
2023-08-18 04:07:00	SPY	ETF	436.35	436.35	436.35	436.35	100.0
2023-08-18 04:09:00	SPY	ETF	436.13	436.13	436.13	436.13	100.0
2023-08-18 04:10:00	SPY	ETF	436.06	436.11	436.06	436.11	262.0
2023-08-18 04:11:00	SPY	ETF	436.21	436.25	436.21	436.25	350.0
2023-08-18 04:12:00	SPY	ETF	436.22	436.22	436.22	436.22	100.0
2023-08-18 04:13:00	SPY	ETF	436.23	436.23	436.23	436.23	100.0
2023-08-18 04:14:00	SPY	ETF	436.31	436.31	436.31	436.31	200.0
2023-08-18 04:16:00	SPY	ETF	436.3	436.31	436.3	436.31	699.0
2023-08-18 04:17:00	SPY	ETF	436.12	436.12	436.06	436.07	1175.0
2023-08-18 04:18:00	SPY	ETF	436.1	436.1	436.1	436.1	250.0
2023-08-18 04:19:00	SPY	ETF	436.16	436.16	436.06	436.06	950.0
2023-08-18 04:20:00	SPY	ETF	436.06	436.06	436.02	436.02	200.0
2023-08-18 04:21:00	SPY	ETF	436.08	436.16	436.08	436.16	200.0
2023-08-18 04:23:00	SPY	ETF	436.18	436.18	436.08	436.08	325.0
2023-08-18 04:24:00	SPY	ETF	436.01	436.01	436.01	436.01	775.0
2023-08-18 04:26:00	SPY	ETF	436.02	436.02	435.97	435.97	255.0
2023-08-18 04:27:00	SPY	ETF	435.93	435.93	435.89	435.9	1290.0
2023-08-18 04:29:00	SPY	ETF	435.8	435.83	435.8	435.83	2977.0
2023-08-18 04:30:00	SPY	ETF	435.9	435.9	435.9	435.9	125.0
2023-08-18 04:31:00	SPY	ETF	435.84	435.89	435.84	435.89	2064.0
2023-08-18 04:32:00	SPY	ETF	435.87	435.87	435.87	435.87	250.0
2023-08-18 04:33:00	SPY	ETF	435.97	435.97	435.96	435.96	725.0
2023-08-18 04:34:00	SPY	ETF	436.14	436.14	436.14	436.14	100.0
2023-08-18 04:38:00	SPY	ETF	435.88	435.88	435.88	435.88	100.0
2023-08-18 04:39:00	SPY	ETF	435.85	435.85	435.85	435.85	1000.0
2023-08-18 04:41:00	SPY	ETF	435.92	436.0	435.92	435.95	1250.0
2023-08-18 04:42:00	SPY	ETF	435.94	435.94	435.94	435.94	298.0
2023-08-18 04:43:00	SPY	ETF	435.94	436.0	435.94	436.0	3999.0
2023-08-18 04:44:00	SPY	ETF	436.0	436.0	436.0	436.0	4125.0
2023-08-18 04:45:00	SPY	ETF	435.93	435.93	435.93	435.93	350.0
2023-08-18 04:47:00	SPY	ETF	435.77	435.77	435.77	435.77	525.0
2023-08-18 04:49:00	SPY	ETF	435.86	435.86	435.86	435.86	350.0
2023-08-18 04:51:00	SPY	ETF	435.81	435.91	435.81	435.91	775.0
2023-08-18 04:52:00	SPY	ETF	435.94	435.94	435.94	435.94	1200.0
2023-08-18 04:54:00	SPY	ETF	436.04	436.04	436.03	436.03	525.0
2023-08-18 04:55:00	SPY	ETF	436.13	436.14	436.13	436.14	525.0
2023-08-18 04:56:00	SPY	ETF	436.15	436.15	436.15	436.15	100.0
2023-08-18 04:58:00	SPY	ETF	436.15	436.16	436.14	436.16	1600.0
2023-08-18 04:59:00	SPY	ETF	436.19	436.19	436.19	436.19	8200.0
2023-08-18 05:00:00	SPY	ETF	436.15	436.15	436.12	436.12	4800.0
2023-08-18 05:01:00	SPY	ETF	436.26	436.26	436.26	436.26	1400.0
2023-08-18 05:02:00	SPY	ETF	436.17	436.17	436.17	436.17	100.0
2023-08-18 05:03:00	SPY	ETF	436.13	436.13	436.08	436.08	800.0

> showing 50 of 262,347 rows — these rows as CSV

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