PREVIEW / etf_1min / 2023-03-23

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-03-23.parquet
  size:    4.9 MB
  rows:    279,855

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-03-23 04:00:00	SPY	ETF	395.02	395.19	394.03	395.18	21487.0
2023-03-23 04:01:00	SPY	ETF	395.1	395.17	395.1	395.15	13800.0
2023-03-23 04:02:00	SPY	ETF	395.22	395.27	395.2	395.2	10300.0
2023-03-23 04:03:00	SPY	ETF	395.25	395.25	395.25	395.25	200.0
2023-03-23 04:04:00	SPY	ETF	395.23	395.31	395.23	395.31	451.0
2023-03-23 04:05:00	SPY	ETF	395.3	395.35	395.3	395.35	900.0
2023-03-23 04:06:00	SPY	ETF	395.29	395.36	395.29	395.31	582.0
2023-03-23 04:07:00	SPY	ETF	395.33	395.33	395.3	395.3	1721.0
2023-03-23 04:08:00	SPY	ETF	395.3	395.3	395.29	395.29	2124.0
2023-03-23 04:09:00	SPY	ETF	395.37	395.37	395.37	395.37	100.0
2023-03-23 04:10:00	SPY	ETF	395.31	395.32	395.31	395.32	633.0
2023-03-23 04:11:00	SPY	ETF	395.36	395.36	395.29	395.29	800.0
2023-03-23 04:12:00	SPY	ETF	395.23	395.23	395.17	395.17	1601.0
2023-03-23 04:13:00	SPY	ETF	395.16	395.16	395.04	395.04	764.0
2023-03-23 04:14:00	SPY	ETF	395.04	395.17	395.04	395.17	1952.0
2023-03-23 04:15:00	SPY	ETF	395.26	395.28	395.2	395.2	1814.0
2023-03-23 04:16:00	SPY	ETF	395.35	395.35	395.35	395.35	507.0
2023-03-23 04:17:00	SPY	ETF	395.33	395.33	395.27	395.28	1074.0
2023-03-23 04:18:00	SPY	ETF	395.27	395.32	395.27	395.3	1637.0
2023-03-23 04:19:00	SPY	ETF	395.3	395.38	395.26	395.38	1501.0
2023-03-23 04:20:00	SPY	ETF	395.34	395.38	395.34	395.38	534.0
2023-03-23 04:21:00	SPY	ETF	395.32	395.34	395.32	395.34	236.0
2023-03-23 04:22:00	SPY	ETF	395.3	395.33	395.3	395.33	1909.0
2023-03-23 04:24:00	SPY	ETF	395.29	395.29	395.22	395.26	2050.0
2023-03-23 04:25:00	SPY	ETF	395.32	395.32	395.32	395.32	100.0
2023-03-23 04:26:00	SPY	ETF	395.33	395.33	395.31	395.31	228.0
2023-03-23 04:29:00	SPY	ETF	395.26	395.26	395.21	395.21	10095.0
2023-03-23 04:31:00	SPY	ETF	394.96	394.96	394.96	394.96	100.0
2023-03-23 04:32:00	SPY	ETF	395.02	395.05	395.02	395.05	350.0
2023-03-23 04:33:00	SPY	ETF	395.19	395.19	395.12	395.12	300.0
2023-03-23 04:34:00	SPY	ETF	395.14	395.14	395.14	395.14	500.0
2023-03-23 04:35:00	SPY	ETF	395.22	395.22	395.11	395.11	500.0
2023-03-23 04:36:00	SPY	ETF	395.05	395.05	395.05	395.05	100.0
2023-03-23 04:37:00	SPY	ETF	395.04	395.04	395.04	395.04	500.0
2023-03-23 04:39:00	SPY	ETF	395.07	395.07	395.07	395.07	400.0
2023-03-23 04:41:00	SPY	ETF	395.22	395.24	395.22	395.24	1050.0
2023-03-23 04:42:00	SPY	ETF	395.31	395.32	395.31	395.32	1200.0
2023-03-23 04:43:00	SPY	ETF	395.34	395.37	395.34	395.34	371.0
2023-03-23 04:44:00	SPY	ETF	395.37	395.37	395.37	395.37	137.0
2023-03-23 04:46:00	SPY	ETF	395.34	395.34	395.34	395.34	365.0
2023-03-23 04:47:00	SPY	ETF	395.33	395.33	395.33	395.33	100.0
2023-03-23 04:49:00	SPY	ETF	395.4	395.49	395.4	395.42	2750.0
2023-03-23 04:50:00	SPY	ETF	395.39	395.39	395.39	395.39	100.0
2023-03-23 04:51:00	SPY	ETF	395.32	395.32	395.32	395.32	100.0
2023-03-23 04:53:00	SPY	ETF	395.27	395.28	395.27	395.28	1200.0
2023-03-23 04:54:00	SPY	ETF	395.31	395.34	395.31	395.34	500.0
2023-03-23 04:55:00	SPY	ETF	395.3	395.3	395.3	395.3	241.0
2023-03-23 04:57:00	SPY	ETF	395.22	395.22	395.22	395.22	249.0
2023-03-23 04:58:00	SPY	ETF	395.15	395.17	395.15	395.15	1386.0
2023-03-23 04:59:00	SPY	ETF	395.16	395.17	395.16	395.17	800.0

> showing 50 of 279,855 rows — these rows as CSV

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