PREVIEW / etf_1min / 2024-07-05

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-07-05.parquet
  size:    5.0 MB
  rows:    281,465

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-07-05 04:00:00	SPY	ETF	551.95	551.98	551.89	551.92	7917.0
2024-07-05 04:01:00	SPY	ETF	551.92	552.04	551.92	552.04	2299.0
2024-07-05 04:02:00	SPY	ETF	551.95	551.95	551.95	551.95	100.0
2024-07-05 04:03:00	SPY	ETF	551.94	551.94	551.94	551.94	100.0
2024-07-05 04:04:00	SPY	ETF	551.95	551.96	551.92	551.92	423.0
2024-07-05 04:05:00	SPY	ETF	551.97	551.97	551.93	551.93	500.0
2024-07-05 04:06:00	SPY	ETF	551.97	551.99	551.91	551.91	1229.0
2024-07-05 04:07:00	SPY	ETF	551.94	552.06	551.94	552.06	621.0
2024-07-05 04:08:00	SPY	ETF	552.05	552.05	552.02	552.02	320.0
2024-07-05 04:09:00	SPY	ETF	551.99	551.99	551.99	551.99	200.0
2024-07-05 04:12:00	SPY	ETF	552.14	552.14	552.14	552.14	125.0
2024-07-05 04:13:00	SPY	ETF	552.07	552.16	552.07	552.16	221.0
2024-07-05 04:14:00	SPY	ETF	552.11	552.13	552.11	552.13	215.0
2024-07-05 04:17:00	SPY	ETF	551.98	551.98	551.98	551.98	107.0
2024-07-05 04:19:00	SPY	ETF	552.03	552.03	552.03	552.03	100.0
2024-07-05 04:20:00	SPY	ETF	552.01	552.01	552.0	552.01	416.0
2024-07-05 04:21:00	SPY	ETF	551.97	551.97	551.92	551.92	220.0
2024-07-05 04:23:00	SPY	ETF	551.92	551.94	551.92	551.94	900.0
2024-07-05 04:41:00	SPY	ETF	551.7	551.7	551.7	551.7	998.0
2024-07-05 04:42:00	SPY	ETF	551.7	551.74	551.7	551.74	1199.0
2024-07-05 04:43:00	SPY	ETF	551.7	551.7	551.7	551.7	316.0
2024-07-05 04:47:00	SPY	ETF	551.75	551.75	551.75	551.75	100.0
2024-07-05 05:00:00	SPY	ETF	551.68	551.69	551.68	551.69	200.0
2024-07-05 05:16:00	SPY	ETF	551.63	551.63	551.63	551.63	100.0
2024-07-05 05:17:00	SPY	ETF	551.66	551.66	551.66	551.66	100.0
2024-07-05 05:18:00	SPY	ETF	551.68	551.68	551.68	551.68	107.0
2024-07-05 05:21:00	SPY	ETF	551.83	551.83	551.83	551.83	600.0
2024-07-05 05:26:00	SPY	ETF	551.83	551.83	551.83	551.83	200.0
2024-07-05 05:32:00	SPY	ETF	551.76	551.76	551.76	551.76	103.0
2024-07-05 05:37:00	SPY	ETF	551.87	551.87	551.87	551.87	111.0
2024-07-05 05:54:00	SPY	ETF	551.83	551.83	551.83	551.83	100.0
2024-07-05 06:12:00	SPY	ETF	551.74	551.75	551.74	551.74	1800.0
2024-07-05 06:16:00	SPY	ETF	551.74	551.74	551.74	551.74	800.0
2024-07-05 06:17:00	SPY	ETF	551.7	551.7	551.68	551.68	500.0
2024-07-05 06:19:00	SPY	ETF	551.68	551.68	551.68	551.68	199.0
2024-07-05 06:20:00	SPY	ETF	551.71	551.71	551.71	551.71	100.0
2024-07-05 06:25:00	SPY	ETF	551.73	551.73	551.73	551.73	100.0
2024-07-05 06:27:00	SPY	ETF	551.76	551.76	551.76	551.76	200.0
2024-07-05 06:29:00	SPY	ETF	551.74	551.74	551.74	551.74	100.0
2024-07-05 06:35:00	SPY	ETF	551.73	551.73	551.73	551.73	198.0
2024-07-05 06:39:00	SPY	ETF	551.77	551.77	551.77	551.77	1500.0
2024-07-05 06:43:00	SPY	ETF	551.8	551.8	551.8	551.8	900.0
2024-07-05 06:44:00	SPY	ETF	551.76	551.76	551.76	551.76	100.0
2024-07-05 06:46:00	SPY	ETF	551.76	551.76	551.76	551.76	100.0
2024-07-05 06:47:00	SPY	ETF	551.71	551.71	551.71	551.71	200.0
2024-07-05 06:48:00	SPY	ETF	551.67	551.67	551.67	551.67	100.0
2024-07-05 06:55:00	SPY	ETF	551.7	551.71	551.7	551.71	2000.0
2024-07-05 07:00:00	SPY	ETF	551.62	551.64	551.6	551.6	469.0
2024-07-05 07:01:00	SPY	ETF	551.6	551.66	551.6	551.66	414.0
2024-07-05 07:02:00	SPY	ETF	551.68	551.68	551.68	551.68	200.0

> showing 50 of 281,465 rows — these rows as CSV

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