PREVIEW / etf_1min / 2022-03-24

all etf 1-min files

  file:    by_date/etf_1min/2022/2022-03-24.parquet
  size:    4.4 MB
  rows:    250,497

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-03-24 04:00:00	SPY	ETF	445.29	445.4	445.21	445.4	2700.0
2022-03-24 04:01:00	SPY	ETF	445.5	445.6	445.5	445.53	1730.0
2022-03-24 04:02:00	SPY	ETF	445.8	445.8	445.72	445.73	416.0
2022-03-24 04:04:00	SPY	ETF	445.86	445.87	445.86	445.87	372.0
2022-03-24 04:05:00	SPY	ETF	446.08	446.17	446.08	446.17	1200.0
2022-03-24 04:06:00	SPY	ETF	446.25	446.25	446.25	446.25	500.0
2022-03-24 04:07:00	SPY	ETF	446.48	446.58	446.48	446.58	840.0
2022-03-24 04:08:00	SPY	ETF	446.47	446.47	446.47	446.47	1000.0
2022-03-24 04:10:00	SPY	ETF	446.43	446.43	446.43	446.43	200.0
2022-03-24 04:11:00	SPY	ETF	446.37	446.37	446.25	446.25	890.0
2022-03-24 04:12:00	SPY	ETF	446.06	446.06	446.06	446.06	100.0
2022-03-24 04:13:00	SPY	ETF	446.15	446.15	446.07	446.11	421.0
2022-03-24 04:14:00	SPY	ETF	446.06	446.06	446.06	446.06	100.0
2022-03-24 04:15:00	SPY	ETF	446.18	446.18	446.1	446.1	250.0
2022-03-24 04:16:00	SPY	ETF	446.19	446.19	446.19	446.19	100.0
2022-03-24 04:19:00	SPY	ETF	446.37	446.42	446.37	446.42	1000.0
2022-03-24 04:20:00	SPY	ETF	446.32	446.32	446.26	446.26	202.0
2022-03-24 04:21:00	SPY	ETF	446.23	446.31	446.23	446.31	698.0
2022-03-24 04:24:00	SPY	ETF	446.55	446.55	446.55	446.55	476.0
2022-03-24 04:25:00	SPY	ETF	446.56	446.56	446.56	446.56	380.0
2022-03-24 04:26:00	SPY	ETF	446.6	446.6	446.6	446.6	100.0
2022-03-24 04:30:00	SPY	ETF	446.62	446.62	446.62	446.62	678.0
2022-03-24 04:31:00	SPY	ETF	446.65	446.75	446.65	446.75	6332.0
2022-03-24 04:32:00	SPY	ETF	446.91	447.0	446.81	446.81	1513.0
2022-03-24 04:33:00	SPY	ETF	446.71	446.71	446.71	446.71	141.0
2022-03-24 04:36:00	SPY	ETF	446.7	446.7	446.7	446.7	100.0
2022-03-24 04:37:00	SPY	ETF	446.81	446.81	446.81	446.81	500.0
2022-03-24 04:38:00	SPY	ETF	446.81	446.85	446.81	446.85	1100.0
2022-03-24 04:40:00	SPY	ETF	446.78	446.78	446.78	446.78	300.0
2022-03-24 04:41:00	SPY	ETF	446.74	446.74	446.69	446.69	350.0
2022-03-24 04:44:00	SPY	ETF	446.64	446.66	446.64	446.66	1000.0
2022-03-24 04:46:00	SPY	ETF	446.5	446.5	446.5	446.5	197.0
2022-03-24 04:47:00	SPY	ETF	446.48	446.52	446.48	446.52	200.0
2022-03-24 04:52:00	SPY	ETF	446.66	446.66	446.66	446.66	167.0
2022-03-24 04:54:00	SPY	ETF	446.64	446.64	446.64	446.64	100.0
2022-03-24 04:55:00	SPY	ETF	446.63	446.63	446.63	446.63	900.0
2022-03-24 04:56:00	SPY	ETF	446.73	446.74	446.71	446.71	500.0
2022-03-24 04:57:00	SPY	ETF	446.7	446.73	446.7	446.72	300.0
2022-03-24 05:01:00	SPY	ETF	446.65	446.76	446.65	446.76	606.0
2022-03-24 05:02:00	SPY	ETF	446.82	446.82	446.82	446.82	100.0
2022-03-24 05:03:00	SPY	ETF	446.85	446.85	446.82	446.82	200.0
2022-03-24 05:04:00	SPY	ETF	446.88	446.93	446.88	446.93	200.0
2022-03-24 05:06:00	SPY	ETF	446.93	446.93	446.9	446.9	1600.0
2022-03-24 05:07:00	SPY	ETF	446.83	446.83	446.67	446.67	537.0
2022-03-24 05:09:00	SPY	ETF	446.75	446.75	446.75	446.75	400.0
2022-03-24 05:10:00	SPY	ETF	446.65	446.65	446.65	446.65	800.0
2022-03-24 05:25:00	SPY	ETF	446.55	446.55	446.55	446.55	5844.0
2022-03-24 05:26:00	SPY	ETF	446.51	446.51	446.51	446.51	199.0
2022-03-24 05:32:00	SPY	ETF	446.5	446.5	446.5	446.5	1399.0
2022-03-24 05:33:00	SPY	ETF	446.6	446.6	446.6	446.6	520.0

> showing 50 of 250,497 rows — these rows as CSV

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