PREVIEW / etf_1min / 2024-08-20

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-08-20.parquet
  size:    5.0 MB
  rows:    284,976

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-08-20 04:00:00	SPY	ETF	560.0	560.38	560.0	560.32	695.0
2024-08-20 04:03:00	SPY	ETF	560.22	560.22	560.22	560.22	400.0
2024-08-20 04:04:00	SPY	ETF	560.24	560.24	560.12	560.12	1064.0
2024-08-20 04:05:00	SPY	ETF	560.24	560.33	560.24	560.33	1250.0
2024-08-20 04:06:00	SPY	ETF	560.34	560.34	560.26	560.26	228.0
2024-08-20 04:07:00	SPY	ETF	560.28	560.28	560.28	560.28	156.0
2024-08-20 04:10:00	SPY	ETF	560.4	560.4	560.4	560.4	100.0
2024-08-20 04:11:00	SPY	ETF	560.43	560.43	560.43	560.43	111.0
2024-08-20 04:12:00	SPY	ETF	560.43	560.43	560.43	560.43	111.0
2024-08-20 04:13:00	SPY	ETF	560.26	560.28	560.22	560.28	659.0
2024-08-20 04:14:00	SPY	ETF	560.29	560.29	560.29	560.29	167.0
2024-08-20 04:15:00	SPY	ETF	560.28	560.28	560.28	560.28	111.0
2024-08-20 04:16:00	SPY	ETF	560.29	560.29	560.29	560.29	200.0
2024-08-20 04:17:00	SPY	ETF	560.15	560.17	560.15	560.17	203.0
2024-08-20 04:18:00	SPY	ETF	560.22	560.22	560.22	560.22	100.0
2024-08-20 04:19:00	SPY	ETF	560.14	560.14	560.14	560.14	125.0
2024-08-20 04:20:00	SPY	ETF	560.14	560.14	560.14	560.14	500.0
2024-08-20 04:21:00	SPY	ETF	560.11	560.11	560.0	560.0	50260.0
2024-08-20 04:25:00	SPY	ETF	559.95	559.95	559.95	559.95	206.0
2024-08-20 04:28:00	SPY	ETF	559.92	559.92	559.92	559.92	150.0
2024-08-20 04:33:00	SPY	ETF	559.91	559.91	559.91	559.91	100.0
2024-08-20 04:34:00	SPY	ETF	559.8	559.8	559.76	559.76	200.0
2024-08-20 04:35:00	SPY	ETF	559.62	559.62	559.62	559.62	101.0
2024-08-20 04:36:00	SPY	ETF	559.7	559.71	559.7	559.71	500.0
2024-08-20 04:38:00	SPY	ETF	559.62	559.62	559.62	559.62	1130.0
2024-08-20 04:39:00	SPY	ETF	559.65	559.65	559.65	559.65	104.0
2024-08-20 04:40:00	SPY	ETF	559.35	559.35	559.35	559.35	100.0
2024-08-20 04:42:00	SPY	ETF	559.45	559.51	559.44	559.51	2304.0
2024-08-20 04:45:00	SPY	ETF	559.31	559.31	559.31	559.31	150.0
2024-08-20 04:50:00	SPY	ETF	559.59	559.59	559.58	559.58	1600.0
2024-08-20 04:51:00	SPY	ETF	559.67	559.67	559.61	559.61	650.0
2024-08-20 04:52:00	SPY	ETF	559.61	559.61	559.61	559.61	300.0
2024-08-20 04:55:00	SPY	ETF	559.7	559.74	559.69	559.74	2493.0
2024-08-20 04:58:00	SPY	ETF	559.77	559.77	559.77	559.77	100.0
2024-08-20 05:00:00	SPY	ETF	559.89	559.91	559.89	559.91	910.0
2024-08-20 05:01:00	SPY	ETF	559.94	559.95	559.94	559.95	550.0
2024-08-20 05:03:00	SPY	ETF	559.91	559.99	559.91	559.99	334.0
2024-08-20 05:04:00	SPY	ETF	560.0	560.0	560.0	560.0	200.0
2024-08-20 05:05:00	SPY	ETF	560.0	560.0	560.0	560.0	100.0
2024-08-20 05:07:00	SPY	ETF	560.02	560.02	560.02	560.02	100.0
2024-08-20 05:08:00	SPY	ETF	560.0	560.0	560.0	560.0	194.0
2024-08-20 05:10:00	SPY	ETF	559.98	559.98	559.98	559.98	200.0
2024-08-20 05:16:00	SPY	ETF	560.0	560.0	560.0	560.0	500.0
2024-08-20 05:17:00	SPY	ETF	560.0	560.08	560.0	560.08	500.0
2024-08-20 05:18:00	SPY	ETF	560.19	560.19	560.15	560.19	847.0
2024-08-20 05:20:00	SPY	ETF	560.1	560.1	560.1	560.1	400.0
2024-08-20 05:21:00	SPY	ETF	560.12	560.12	560.06	560.06	2152.0
2024-08-20 05:24:00	SPY	ETF	560.11	560.11	560.11	560.11	250.0
2024-08-20 05:25:00	SPY	ETF	560.11	560.2	560.11	560.2	2500.0
2024-08-20 05:26:00	SPY	ETF	560.12	560.13	560.11	560.13	776.0

> showing 50 of 284,976 rows — these rows as CSV

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