PREVIEW / etf_1min / 2024-11-06

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-11-06.parquet
  size:    6.7 MB
  rows:    376,638

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
2024-11-06 04:00:00	SPY	ETF	583.0	590.0	583.0	589.52	19297.0
2024-11-06 04:01:00	SPY	ETF	589.47	589.78	589.47	589.66	4282.0
2024-11-06 04:02:00	SPY	ETF	589.7	589.83	589.6	589.7	5357.0
2024-11-06 04:03:00	SPY	ETF	589.67	589.67	589.4	589.55	3640.0
2024-11-06 04:04:00	SPY	ETF	589.58	589.6	589.38	589.4	4217.0
2024-11-06 04:05:00	SPY	ETF	589.05	589.23	589.04	589.16	4992.0
2024-11-06 04:06:00	SPY	ETF	589.21	589.36	589.13	589.31	8473.0
2024-11-06 04:07:00	SPY	ETF	589.32	590.6	589.3	589.3	33384.0
2024-11-06 04:08:00	SPY	ETF	589.24	589.24	589.11	589.17	3570.0
2024-11-06 04:09:00	SPY	ETF	589.1	589.23	589.1	589.23	1330.0
2024-11-06 04:10:00	SPY	ETF	589.23	589.23	589.13	589.13	2609.0
2024-11-06 04:11:00	SPY	ETF	589.07	589.08	588.86	589.0	4933.0
2024-11-06 04:12:00	SPY	ETF	588.98	589.08	588.98	589.04	3588.0
2024-11-06 04:13:00	SPY	ETF	588.95	588.99	588.79	588.79	3384.0
2024-11-06 04:14:00	SPY	ETF	588.92	589.12	588.92	589.04	4837.0
2024-11-06 04:15:00	SPY	ETF	589.02	589.04	589.0	589.04	1641.0
2024-11-06 04:16:00	SPY	ETF	589.04	589.06	588.85	588.93	1942.0
2024-11-06 04:17:00	SPY	ETF	588.93	588.97	588.91	588.97	1132.0
2024-11-06 04:18:00	SPY	ETF	588.87	589.02	588.87	588.92	4421.0
2024-11-06 04:19:00	SPY	ETF	588.8	588.8	588.75	588.76	3044.0
2024-11-06 04:20:00	SPY	ETF	588.64	588.66	588.56	588.66	7992.0
2024-11-06 04:21:00	SPY	ETF	588.68	588.68	588.67	588.67	383.0
2024-11-06 04:22:00	SPY	ETF	588.85	589.01	588.79	589.01	4461.0
2024-11-06 04:23:00	SPY	ETF	589.08	589.1	588.96	588.96	3570.0
2024-11-06 04:24:00	SPY	ETF	589.06	589.06	588.88	588.95	4350.0
2024-11-06 04:25:00	SPY	ETF	588.86	588.96	588.86	588.9	5782.0
2024-11-06 04:26:00	SPY	ETF	588.91	588.95	588.9	588.93	1974.0
2024-11-06 04:27:00	SPY	ETF	588.92	588.98	588.78	588.91	3603.0
2024-11-06 04:28:00	SPY	ETF	588.9	588.9	588.83	588.83	574.0
2024-11-06 04:29:00	SPY	ETF	588.9	588.95	588.9	588.95	1070.0
2024-11-06 04:30:00	SPY	ETF	589.0	589.0	588.96	589.0	850.0
2024-11-06 04:31:00	SPY	ETF	589.12	589.13	589.0	589.12	4321.0
2024-11-06 04:32:00	SPY	ETF	589.12	589.36	589.12	589.32	4433.0
2024-11-06 04:33:00	SPY	ETF	589.32	589.6	589.32	589.5	5868.0
2024-11-06 04:34:00	SPY	ETF	589.26	589.34	589.26	589.34	2400.0
2024-11-06 04:35:00	SPY	ETF	589.24	589.32	589.16	589.29	4201.0
2024-11-06 04:36:00	SPY	ETF	589.46	589.46	589.37	589.4	4310.0
2024-11-06 04:37:00	SPY	ETF	589.62	589.64	589.56	589.58	2324.0
2024-11-06 04:38:00	SPY	ETF	589.5	589.5	589.43	589.46	598.0
2024-11-06 04:39:00	SPY	ETF	589.3	589.3	589.01	589.01	1282.0
2024-11-06 04:41:00	SPY	ETF	589.23	589.24	589.22	589.24	1452.0
2024-11-06 04:42:00	SPY	ETF	589.09	589.19	589.09	589.19	587.0
2024-11-06 04:43:00	SPY	ETF	589.33	589.79	589.19	589.19	19519.0
2024-11-06 04:44:00	SPY	ETF	589.2	589.27	589.13	589.13	9139.0
2024-11-06 04:45:00	SPY	ETF	589.11	589.25	589.1	589.25	800.0
2024-11-06 04:46:00	SPY	ETF	589.4	589.41	589.4	589.41	2790.0
2024-11-06 04:47:00	SPY	ETF	589.35	589.35	589.3	589.3	514.0
2024-11-06 04:49:00	SPY	ETF	589.31	589.31	589.31	589.31	100.0
2024-11-06 04:50:00	SPY	ETF	589.3	590.0	589.3	589.47	27354.0
2024-11-06 04:51:00	SPY	ETF	589.36	590.0	589.36	589.44	9938.0

> showing 50 of 376,638 rows — these rows as CSV

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