PREVIEW / etf_1min / 2023-08-14

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-08-14.parquet
  size:    4.4 MB
  rows:    248,752

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-14 04:00:00	SPY	ETF	447.06	447.3	446.0	447.3	2038.0
2023-08-14 04:01:00	SPY	ETF	447.31	447.31	447.19	447.2	850.0
2023-08-14 04:02:00	SPY	ETF	447.01	447.02	447.0	447.02	600.0
2023-08-14 04:03:00	SPY	ETF	447.06	447.13	447.06	447.09	996.0
2023-08-14 04:05:00	SPY	ETF	446.95	447.09	446.95	447.07	689.0
2023-08-14 04:06:00	SPY	ETF	447.09	447.1	447.0	447.0	967.0
2023-08-14 04:07:00	SPY	ETF	447.01	447.12	447.0	447.07	1300.0
2023-08-14 04:08:00	SPY	ETF	446.88	446.89	446.88	446.89	800.0
2023-08-14 04:09:00	SPY	ETF	447.13	447.13	447.13	447.13	118.0
2023-08-14 04:10:00	SPY	ETF	447.36	447.36	447.23	447.23	1283.0
2023-08-14 04:11:00	SPY	ETF	447.11	447.11	447.08	447.08	250.0
2023-08-14 04:12:00	SPY	ETF	446.98	446.98	446.85	446.85	1400.0
2023-08-14 04:13:00	SPY	ETF	446.65	446.7	446.63	446.63	800.0
2023-08-14 04:15:00	SPY	ETF	446.71	446.71	446.69	446.7	322.0
2023-08-14 04:18:00	SPY	ETF	446.61	446.63	446.43	446.43	813.0
2023-08-14 04:19:00	SPY	ETF	446.49	446.5	446.45	446.45	1000.0
2023-08-14 04:20:00	SPY	ETF	446.58	446.58	446.58	446.58	100.0
2023-08-14 04:21:00	SPY	ETF	446.64	446.64	446.63	446.63	500.0
2023-08-14 04:22:00	SPY	ETF	446.61	446.73	446.61	446.73	210.0
2023-08-14 04:24:00	SPY	ETF	446.7	446.7	446.7	446.7	200.0
2023-08-14 04:25:00	SPY	ETF	446.61	446.61	446.61	446.61	100.0
2023-08-14 04:26:00	SPY	ETF	446.63	446.63	446.52	446.52	1000.0
2023-08-14 04:27:00	SPY	ETF	446.55	446.66	446.55	446.65	4000.0
2023-08-14 04:28:00	SPY	ETF	446.6	446.6	446.6	446.6	600.0
2023-08-14 04:30:00	SPY	ETF	446.5	446.5	446.5	446.5	600.0
2023-08-14 04:34:00	SPY	ETF	446.47	446.47	446.34	446.34	1504.0
2023-08-14 04:35:00	SPY	ETF	446.39	446.39	446.39	446.39	400.0
2023-08-14 04:37:00	SPY	ETF	446.5	446.5	446.5	446.5	500.0
2023-08-14 04:38:00	SPY	ETF	446.6	446.6	446.6	446.6	600.0
2023-08-14 04:39:00	SPY	ETF	446.6	446.65	446.6	446.65	395.0
2023-08-14 04:43:00	SPY	ETF	446.6	446.6	446.5	446.5	2900.0
2023-08-14 04:45:00	SPY	ETF	446.61	446.61	446.61	446.61	400.0
2023-08-14 04:48:00	SPY	ETF	446.6	446.6	446.6	446.6	300.0
2023-08-14 04:49:00	SPY	ETF	446.6	446.6	446.6	446.6	211.0
2023-08-14 04:50:00	SPY	ETF	446.63	446.67	446.63	446.67	600.0
2023-08-14 04:52:00	SPY	ETF	446.67	446.67	446.67	446.67	120.0
2023-08-14 04:54:00	SPY	ETF	446.63	446.63	446.63	446.63	200.0
2023-08-14 04:55:00	SPY	ETF	446.53	446.53	446.53	446.53	100.0
2023-08-14 04:57:00	SPY	ETF	446.49	446.49	446.46	446.47	1500.0
2023-08-14 04:58:00	SPY	ETF	446.47	446.47	446.47	446.47	200.0
2023-08-14 05:00:00	SPY	ETF	446.37	446.37	446.29	446.29	3398.0
2023-08-14 05:02:00	SPY	ETF	446.26	446.26	446.26	446.26	200.0
2023-08-14 05:04:00	SPY	ETF	446.37	446.37	446.37	446.37	200.0
2023-08-14 05:05:00	SPY	ETF	446.39	446.39	446.36	446.39	400.0
2023-08-14 05:06:00	SPY	ETF	446.43	446.43	446.43	446.43	200.0
2023-08-14 05:10:00	SPY	ETF	446.14	446.17	446.14	446.17	431.0
2023-08-14 05:12:00	SPY	ETF	446.37	446.4	446.37	446.4	683.0
2023-08-14 05:16:00	SPY	ETF	446.43	446.43	446.43	446.43	100.0
2023-08-14 05:17:00	SPY	ETF	446.49	446.49	446.49	446.49	114.0
2023-08-14 05:18:00	SPY	ETF	446.6	446.6	446.6	446.6	300.0

> showing 50 of 248,752 rows — these rows as CSV

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