PREVIEW / etf_1min / 2023-09-11

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-09-11.parquet
  size:    4.3 MB
  rows:    244,547

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-09-11 04:00:00	SPY	ETF	446.61	447.52	446.5	447.52	1730.0
2023-09-11 04:01:00	SPY	ETF	447.46	447.46	447.4	447.4	1200.0
2023-09-11 04:02:00	SPY	ETF	447.47	447.48	447.4	447.4	418.0
2023-09-11 04:03:00	SPY	ETF	447.31	447.33	447.31	447.33	761.0
2023-09-11 04:04:00	SPY	ETF	447.44	447.44	447.44	447.44	400.0
2023-09-11 04:05:00	SPY	ETF	447.42	447.42	447.38	447.38	249.0
2023-09-11 04:06:00	SPY	ETF	447.4	447.4	447.25	447.25	1091.0
2023-09-11 04:07:00	SPY	ETF	447.27	447.27	447.27	447.27	174.0
2023-09-11 04:08:00	SPY	ETF	447.29	447.29	447.29	447.29	100.0
2023-09-11 04:10:00	SPY	ETF	447.13	447.16	447.13	447.16	250.0
2023-09-11 04:14:00	SPY	ETF	447.3	447.3	447.3	447.3	240.0
2023-09-11 04:16:00	SPY	ETF	447.16	447.16	447.16	447.16	100.0
2023-09-11 04:19:00	SPY	ETF	447.26	447.26	447.26	447.26	100.0
2023-09-11 04:20:00	SPY	ETF	447.3	447.3	447.27	447.27	3000.0
2023-09-11 04:22:00	SPY	ETF	447.36	447.36	447.26	447.26	300.0
2023-09-11 04:23:00	SPY	ETF	447.22	447.23	447.17	447.17	913.0
2023-09-11 04:24:00	SPY	ETF	447.15	447.15	447.15	447.15	512.0
2023-09-11 04:25:00	SPY	ETF	447.29	447.29	447.29	447.29	257.0
2023-09-11 04:26:00	SPY	ETF	447.19	447.2	447.19	447.2	600.0
2023-09-11 04:27:00	SPY	ETF	447.27	447.27	447.27	447.27	135.0
2023-09-11 04:31:00	SPY	ETF	447.5	447.5	447.5	447.5	2545.0
2023-09-11 04:33:00	SPY	ETF	447.39	447.39	447.33	447.33	600.0
2023-09-11 04:34:00	SPY	ETF	447.42	447.42	447.41	447.41	507.0
2023-09-11 04:35:00	SPY	ETF	447.38	447.38	447.38	447.38	100.0
2023-09-11 04:36:00	SPY	ETF	447.29	447.3	447.29	447.3	635.0
2023-09-11 04:37:00	SPY	ETF	447.26	447.26	447.25	447.25	600.0
2023-09-11 04:39:00	SPY	ETF	447.26	447.26	447.26	447.26	125.0
2023-09-11 04:40:00	SPY	ETF	447.21	447.21	447.2	447.2	2100.0
2023-09-11 04:43:00	SPY	ETF	447.18	447.18	447.07	447.07	718.0
2023-09-11 04:44:00	SPY	ETF	447.04	447.04	447.04	447.04	100.0
2023-09-11 04:46:00	SPY	ETF	447.01	447.01	447.01	447.01	203.0
2023-09-11 04:47:00	SPY	ETF	447.0	447.0	447.0	447.0	398.0
2023-09-11 04:48:00	SPY	ETF	447.04	447.04	447.04	447.04	100.0
2023-09-11 04:50:00	SPY	ETF	447.0	447.0	446.99	446.99	721.0
2023-09-11 04:51:00	SPY	ETF	446.91	446.91	446.91	446.91	117.0
2023-09-11 04:52:00	SPY	ETF	446.89	446.89	446.89	446.89	100.0
2023-09-11 04:54:00	SPY	ETF	446.91	446.91	446.91	446.91	1500.0
2023-09-11 04:55:00	SPY	ETF	446.84	446.84	446.81	446.81	1998.0
2023-09-11 05:00:00	SPY	ETF	446.93	446.93	446.93	446.93	268.0
2023-09-11 05:01:00	SPY	ETF	446.97	447.03	446.97	447.0	3248.0
2023-09-11 05:03:00	SPY	ETF	447.08	447.18	447.08	447.18	370.0
2023-09-11 05:11:00	SPY	ETF	447.25	447.25	447.25	447.25	116.0
2023-09-11 05:16:00	SPY	ETF	447.2	447.2	447.2	447.2	110.0
2023-09-11 05:18:00	SPY	ETF	447.05	447.05	447.05	447.05	100.0
2023-09-11 05:25:00	SPY	ETF	447.2	447.2	447.2	447.2	450.0
2023-09-11 05:29:00	SPY	ETF	447.31	447.31	447.31	447.31	200.0
2023-09-11 05:30:00	SPY	ETF	447.22	447.22	447.22	447.22	126.0
2023-09-11 05:35:00	SPY	ETF	447.31	447.31	447.29	447.29	223.0
2023-09-11 05:36:00	SPY	ETF	447.26	447.26	447.24	447.26	314.0
2023-09-11 05:37:00	SPY	ETF	447.37	447.37	447.37	447.37	100.0

> showing 50 of 244,547 rows — these rows as CSV

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