PREVIEW / etf_1min / 2022-12-20

all etf 1-min files

  file:    by_date/etf_1min/2022/2022-12-20.parquet
  size:    5.0 MB
  rows:    285,186

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
2022-12-20 04:00:00	SPY	ETF	379.69	379.97	379.64	379.64	1900.0
2022-12-20 04:01:00	SPY	ETF	379.81	379.86	379.8	379.8	1400.0
2022-12-20 04:02:00	SPY	ETF	379.72	379.88	379.72	379.86	3700.0
2022-12-20 04:03:00	SPY	ETF	379.6	379.6	379.45	379.56	5396.0
2022-12-20 04:04:00	SPY	ETF	379.68	379.68	379.44	379.44	1384.0
2022-12-20 04:05:00	SPY	ETF	379.44	379.54	379.44	379.45	450.0
2022-12-20 04:06:00	SPY	ETF	379.45	379.67	379.45	379.61	3543.0
2022-12-20 04:07:00	SPY	ETF	379.56	379.56	379.44	379.44	550.0
2022-12-20 04:08:00	SPY	ETF	379.4	379.4	379.32	379.32	2908.0
2022-12-20 04:09:00	SPY	ETF	379.26	379.26	379.25	379.25	1400.0
2022-12-20 04:10:00	SPY	ETF	379.27	379.45	379.27	379.45	984.0
2022-12-20 04:11:00	SPY	ETF	379.44	379.44	379.44	379.44	400.0
2022-12-20 04:12:00	SPY	ETF	379.26	379.26	379.26	379.26	500.0
2022-12-20 04:13:00	SPY	ETF	379.44	379.62	379.44	379.62	2180.0
2022-12-20 04:15:00	SPY	ETF	379.64	379.64	379.51	379.51	662.0
2022-12-20 04:16:00	SPY	ETF	379.49	379.49	379.42	379.42	741.0
2022-12-20 04:18:00	SPY	ETF	379.41	379.41	379.16	379.17	3832.0
2022-12-20 04:19:00	SPY	ETF	379.27	379.35	379.27	379.35	506.0
2022-12-20 04:20:00	SPY	ETF	379.25	379.39	379.25	379.36	1422.0
2022-12-20 04:22:00	SPY	ETF	379.37	379.37	379.37	379.37	121.0
2022-12-20 04:23:00	SPY	ETF	379.5	379.5	379.5	379.5	1200.0
2022-12-20 04:24:00	SPY	ETF	379.52	379.55	379.48	379.48	600.0
2022-12-20 04:25:00	SPY	ETF	379.45	379.45	379.45	379.45	200.0
2022-12-20 04:26:00	SPY	ETF	379.45	379.45	379.45	379.45	850.0
2022-12-20 04:27:00	SPY	ETF	379.65	379.7	379.65	379.7	400.0
2022-12-20 04:28:00	SPY	ETF	379.7	379.7	379.66	379.66	1550.0
2022-12-20 04:30:00	SPY	ETF	379.71	379.97	379.71	379.91	1716.0
2022-12-20 04:31:00	SPY	ETF	380.0	380.06	379.93	379.93	2085.0
2022-12-20 04:32:00	SPY	ETF	379.92	380.25	379.92	380.25	1439.0
2022-12-20 04:33:00	SPY	ETF	380.11	380.15	380.11	380.15	20074.0
2022-12-20 04:34:00	SPY	ETF	380.18	380.18	380.18	380.18	400.0
2022-12-20 04:35:00	SPY	ETF	380.04	380.04	379.85	379.85	1211.0
2022-12-20 04:36:00	SPY	ETF	379.8	379.8	379.8	379.8	200.0
2022-12-20 04:37:00	SPY	ETF	379.7	379.74	379.7	379.74	215.0
2022-12-20 04:38:00	SPY	ETF	379.76	379.76	379.76	379.76	100.0
2022-12-20 04:39:00	SPY	ETF	379.75	379.75	379.75	379.75	100.0
2022-12-20 04:41:00	SPY	ETF	379.89	379.89	379.82	379.83	700.0
2022-12-20 04:43:00	SPY	ETF	379.81	379.81	379.81	379.81	600.0
2022-12-20 04:44:00	SPY	ETF	379.89	379.96	379.89	379.96	979.0
2022-12-20 04:45:00	SPY	ETF	379.99	379.99	379.99	379.99	300.0
2022-12-20 04:46:00	SPY	ETF	379.9	379.9	379.9	379.9	250.0
2022-12-20 04:47:00	SPY	ETF	379.91	379.91	379.91	379.91	141.0
2022-12-20 04:48:00	SPY	ETF	379.77	379.77	379.45	379.45	2188.0
2022-12-20 04:51:00	SPY	ETF	379.53	379.53	379.53	379.53	150.0
2022-12-20 04:52:00	SPY	ETF	379.58	379.6	379.58	379.6	614.0
2022-12-20 04:53:00	SPY	ETF	379.47	379.47	379.33	379.4	2398.0
2022-12-20 04:55:00	SPY	ETF	379.67	379.7	379.67	379.7	260.0
2022-12-20 04:57:00	SPY	ETF	379.67	379.86	379.67	379.86	2905.0
2022-12-20 04:58:00	SPY	ETF	379.83	379.83	379.78	379.78	600.0
2022-12-20 04:59:00	SPY	ETF	379.83	379.92	379.83	379.92	3358.0

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

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