PREVIEW / etf_1min / 2023-10-04

all etf 1-min files

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

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-04 04:00:00	SPY	ETF	420.33	420.45	420.33	420.45	1401.0
2023-10-04 04:01:00	SPY	ETF	420.39	420.48	420.39	420.43	2124.0
2023-10-04 04:02:00	SPY	ETF	420.31	420.31	420.13	420.13	950.0
2023-10-04 04:03:00	SPY	ETF	420.08	420.13	420.08	420.13	425.0
2023-10-04 04:04:00	SPY	ETF	420.1	420.3	420.07	420.3	3125.0
2023-10-04 04:05:00	SPY	ETF	420.17	420.17	420.17	420.17	200.0
2023-10-04 04:06:00	SPY	ETF	420.22	420.49	420.22	420.49	950.0
2023-10-04 04:07:00	SPY	ETF	420.54	420.54	420.54	420.54	600.0
2023-10-04 04:09:00	SPY	ETF	420.54	420.54	420.52	420.52	300.0
2023-10-04 04:10:00	SPY	ETF	420.49	420.49	420.42	420.42	1369.0
2023-10-04 04:11:00	SPY	ETF	420.48	420.52	420.48	420.52	781.0
2023-10-04 04:12:00	SPY	ETF	420.64	420.64	420.64	420.64	250.0
2023-10-04 04:13:00	SPY	ETF	420.81	420.83	420.71	420.71	844.0
2023-10-04 04:16:00	SPY	ETF	420.85	420.91	420.85	420.91	620.0
2023-10-04 04:17:00	SPY	ETF	420.81	420.81	420.81	420.81	175.0
2023-10-04 04:18:00	SPY	ETF	420.71	420.71	420.69	420.69	300.0
2023-10-04 04:19:00	SPY	ETF	420.68	420.68	420.68	420.68	100.0
2023-10-04 04:20:00	SPY	ETF	420.55	420.55	420.55	420.55	500.0
2023-10-04 04:21:00	SPY	ETF	420.64	420.64	420.64	420.64	350.0
2023-10-04 04:22:00	SPY	ETF	420.56	420.56	420.51	420.54	325.0
2023-10-04 04:23:00	SPY	ETF	420.58	420.63	420.54	420.63	550.0
2023-10-04 04:24:00	SPY	ETF	420.73	420.73	420.73	420.73	150.0
2023-10-04 04:26:00	SPY	ETF	420.77	420.86	420.77	420.86	300.0
2023-10-04 04:27:00	SPY	ETF	420.96	421.0	420.96	421.0	425.0
2023-10-04 04:28:00	SPY	ETF	420.91	420.95	420.91	420.95	2500.0
2023-10-04 04:29:00	SPY	ETF	420.96	420.99	420.85	420.98	1025.0
2023-10-04 04:30:00	SPY	ETF	421.04	421.04	420.98	420.99	1000.0
2023-10-04 04:31:00	SPY	ETF	421.0	421.03	421.0	421.03	700.0
2023-10-04 04:32:00	SPY	ETF	421.11	421.12	421.01	421.01	800.0
2023-10-04 04:33:00	SPY	ETF	421.04	421.05	421.0	421.0	1225.0
2023-10-04 04:34:00	SPY	ETF	420.95	421.08	420.95	421.08	1400.0
2023-10-04 04:36:00	SPY	ETF	420.92	420.92	420.86	420.9	2300.0
2023-10-04 04:37:00	SPY	ETF	420.85	420.85	420.84	420.84	600.0
2023-10-04 04:38:00	SPY	ETF	420.96	420.96	420.9	420.9	2500.0
2023-10-04 04:39:00	SPY	ETF	420.9	421.08	420.86	421.08	750.0
2023-10-04 04:40:00	SPY	ETF	421.05	421.21	421.05	421.19	900.0
2023-10-04 04:41:00	SPY	ETF	421.27	421.27	421.27	421.27	300.0
2023-10-04 04:42:00	SPY	ETF	421.19	421.31	421.19	421.3	2500.0
2023-10-04 04:43:00	SPY	ETF	421.3	421.31	421.23	421.23	2200.0
2023-10-04 04:44:00	SPY	ETF	421.17	421.17	421.09	421.09	400.0
2023-10-04 04:45:00	SPY	ETF	421.16	421.16	421.12	421.12	900.0
2023-10-04 04:46:00	SPY	ETF	421.0	421.0	421.0	421.0	125.0
2023-10-04 04:47:00	SPY	ETF	421.02	421.02	420.95	420.95	761.0
2023-10-04 04:49:00	SPY	ETF	421.01	421.07	421.01	421.07	925.0
2023-10-04 04:53:00	SPY	ETF	420.99	421.04	420.99	421.04	3200.0
2023-10-04 05:00:00	SPY	ETF	420.93	420.93	420.87	420.87	300.0
2023-10-04 05:02:00	SPY	ETF	420.92	420.92	420.92	420.92	300.0
2023-10-04 05:03:00	SPY	ETF	420.88	420.88	420.88	420.88	250.0
2023-10-04 05:04:00	SPY	ETF	420.89	420.89	420.89	420.89	1400.0
2023-10-04 05:05:00	SPY	ETF	421.0	421.0	421.0	421.0	100.0

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

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