PREVIEW / etf_1min / 2023-03-06

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-03-06.parquet
  size:    4.4 MB
  rows:    251,401

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-06 04:00:00	SPY	ETF	404.58	404.58	404.57	404.57	616.0
2023-03-06 04:01:00	SPY	ETF	404.43	404.61	404.43	404.61	1250.0
2023-03-06 04:02:00	SPY	ETF	404.69	404.69	404.65	404.65	301.0
2023-03-06 04:03:00	SPY	ETF	404.62	404.71	404.62	404.69	7695.0
2023-03-06 04:04:00	SPY	ETF	404.53	404.53	404.45	404.45	3131.0
2023-03-06 04:05:00	SPY	ETF	404.53	404.53	404.53	404.53	425.0
2023-03-06 04:06:00	SPY	ETF	404.54	404.54	404.47	404.48	796.0
2023-03-06 04:07:00	SPY	ETF	404.4	404.4	404.4	404.4	111.0
2023-03-06 04:09:00	SPY	ETF	404.3	404.3	404.26	404.26	299.0
2023-03-06 04:11:00	SPY	ETF	404.46	404.52	404.46	404.52	1000.0
2023-03-06 04:12:00	SPY	ETF	404.55	404.55	404.48	404.48	213.0
2023-03-06 04:13:00	SPY	ETF	404.45	404.52	404.45	404.52	256.0
2023-03-06 04:14:00	SPY	ETF	404.47	404.47	404.47	404.47	143.0
2023-03-06 04:16:00	SPY	ETF	404.35	404.35	404.35	404.35	200.0
2023-03-06 04:17:00	SPY	ETF	404.24	404.24	404.24	404.24	500.0
2023-03-06 04:18:00	SPY	ETF	404.19	404.21	404.19	404.21	500.0
2023-03-06 04:19:00	SPY	ETF	404.19	404.19	404.19	404.19	1200.0
2023-03-06 04:20:00	SPY	ETF	404.16	404.16	404.16	404.16	160.0
2023-03-06 04:21:00	SPY	ETF	404.23	404.29	404.23	404.28	683.0
2023-03-06 04:22:00	SPY	ETF	404.36	404.36	404.35	404.35	247.0
2023-03-06 04:23:00	SPY	ETF	404.33	404.33	404.33	404.33	400.0
2023-03-06 04:24:00	SPY	ETF	404.33	404.33	404.33	404.33	100.0
2023-03-06 04:25:00	SPY	ETF	404.26	404.26	404.26	404.26	100.0
2023-03-06 04:26:00	SPY	ETF	404.3	404.3	404.16	404.16	800.0
2023-03-06 04:27:00	SPY	ETF	404.19	404.19	404.19	404.19	285.0
2023-03-06 04:28:00	SPY	ETF	404.15	404.15	404.15	404.15	100.0
2023-03-06 04:31:00	SPY	ETF	404.08	404.09	404.08	404.09	506.0
2023-03-06 04:32:00	SPY	ETF	404.14	404.14	404.09	404.11	500.0
2023-03-06 04:33:00	SPY	ETF	404.07	404.07	404.07	404.07	124.0
2023-03-06 04:35:00	SPY	ETF	404.22	404.22	404.22	404.22	150.0
2023-03-06 04:36:00	SPY	ETF	404.15	404.15	404.15	404.15	1200.0
2023-03-06 04:37:00	SPY	ETF	404.23	404.25	404.23	404.25	700.0
2023-03-06 04:38:00	SPY	ETF	404.23	404.23	404.17	404.17	600.0
2023-03-06 04:41:00	SPY	ETF	404.2	404.2	404.17	404.17	940.0
2023-03-06 04:43:00	SPY	ETF	404.26	404.26	404.26	404.26	120.0
2023-03-06 04:45:00	SPY	ETF	404.24	404.24	404.17	404.17	2510.0
2023-03-06 04:46:00	SPY	ETF	404.16	404.16	404.16	404.16	200.0
2023-03-06 04:47:00	SPY	ETF	404.12	404.12	404.11	404.11	200.0
2023-03-06 04:50:00	SPY	ETF	404.19	404.19	404.19	404.19	600.0
2023-03-06 04:53:00	SPY	ETF	404.07	404.11	404.07	404.11	202.0
2023-03-06 04:54:00	SPY	ETF	404.04	404.04	404.04	404.04	200.0
2023-03-06 04:57:00	SPY	ETF	404.0	404.01	404.0	404.01	200.0
2023-03-06 04:58:00	SPY	ETF	404.1	404.1	404.1	404.1	400.0
2023-03-06 05:00:00	SPY	ETF	404.13	404.13	404.13	404.13	800.0
2023-03-06 05:01:00	SPY	ETF	404.26	404.26	404.26	404.26	113.0
2023-03-06 05:03:00	SPY	ETF	404.19	404.19	404.19	404.19	600.0
2023-03-06 05:04:00	SPY	ETF	404.16	404.16	404.16	404.16	100.0
2023-03-06 05:06:00	SPY	ETF	404.17	404.21	404.17	404.19	1060.0
2023-03-06 05:07:00	SPY	ETF	404.09	404.09	404.0	404.0	719.0
2023-03-06 05:11:00	SPY	ETF	404.06	404.07	404.06	404.07	491.0

> showing 50 of 251,401 rows — these rows as CSV

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