PREVIEW / etf_1min / 2021-07-20

all etf 1-min files

  file:    by_date/etf_1min/2021/2021-07-20.parquet
  size:    4.1 MB
  rows:    228,151

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
2021-07-20 04:00:00	SPY	ETF	426.74	426.84	426.73	426.83	10834.0
2021-07-20 04:01:00	SPY	ETF	426.88	426.94	426.86	426.93	1100.0
2021-07-20 04:02:00	SPY	ETF	426.94	427.0	426.93	426.99	3200.0
2021-07-20 04:03:00	SPY	ETF	427.0	427.0	426.92	426.95	4700.0
2021-07-20 04:04:00	SPY	ETF	426.94	426.99	426.94	426.97	3446.0
2021-07-20 04:05:00	SPY	ETF	426.99	427.04	426.97	427.0	3949.0
2021-07-20 04:06:00	SPY	ETF	426.94	426.94	426.9	426.92	2000.0
2021-07-20 04:07:00	SPY	ETF	426.9	426.95	426.88	426.89	4600.0
2021-07-20 04:08:00	SPY	ETF	426.9	426.9	426.81	426.83	2400.0
2021-07-20 04:09:00	SPY	ETF	426.81	426.83	426.72	426.73	3300.0
2021-07-20 04:10:00	SPY	ETF	426.73	426.73	426.54	426.57	3500.0
2021-07-20 04:11:00	SPY	ETF	426.68	426.79	426.68	426.79	500.0
2021-07-20 04:12:00	SPY	ETF	426.88	427.02	426.88	427.02	6700.0
2021-07-20 04:13:00	SPY	ETF	427.01	427.02	427.01	427.02	600.0
2021-07-20 04:14:00	SPY	ETF	427.02	427.12	427.02	427.12	6100.0
2021-07-20 04:15:00	SPY	ETF	427.17	427.17	427.17	427.17	1000.0
2021-07-20 04:17:00	SPY	ETF	427.08	427.11	427.08	427.11	2961.0
2021-07-20 04:19:00	SPY	ETF	427.18	427.18	427.17	427.17	2253.0
2021-07-20 04:22:00	SPY	ETF	427.06	427.1	427.06	427.07	3050.0
2021-07-20 04:23:00	SPY	ETF	427.06	427.07	427.06	427.07	500.0
2021-07-20 04:25:00	SPY	ETF	427.01	427.01	427.01	427.01	2000.0
2021-07-20 04:27:00	SPY	ETF	427.18	427.18	427.15	427.15	800.0
2021-07-20 04:28:00	SPY	ETF	427.22	427.22	427.22	427.22	300.0
2021-07-20 04:31:00	SPY	ETF	427.37	427.37	427.37	427.37	280.0
2021-07-20 04:32:00	SPY	ETF	427.32	427.34	427.32	427.34	2500.0
2021-07-20 04:35:00	SPY	ETF	427.19	427.19	427.15	427.15	800.0
2021-07-20 04:36:00	SPY	ETF	427.21	427.21	427.21	427.21	100.0
2021-07-20 04:39:00	SPY	ETF	427.25	427.25	427.25	427.25	549.0
2021-07-20 04:41:00	SPY	ETF	427.22	427.22	427.22	427.22	100.0
2021-07-20 04:43:00	SPY	ETF	427.18	427.18	427.18	427.18	154.0
2021-07-20 04:47:00	SPY	ETF	427.0	427.0	426.8	426.8	405.0
2021-07-20 04:48:00	SPY	ETF	426.77	426.77	426.77	426.77	200.0
2021-07-20 04:49:00	SPY	ETF	426.71	426.71	426.71	426.71	200.0
2021-07-20 04:51:00	SPY	ETF	426.7	426.77	426.68	426.68	2500.0
2021-07-20 04:52:00	SPY	ETF	426.8	426.8	426.8	426.8	200.0
2021-07-20 04:54:00	SPY	ETF	426.77	426.78	426.77	426.78	921.0
2021-07-20 04:55:00	SPY	ETF	426.81	426.81	426.81	426.81	800.0
2021-07-20 04:56:00	SPY	ETF	426.83	426.83	426.83	426.83	300.0
2021-07-20 04:59:00	SPY	ETF	426.86	426.86	426.86	426.86	200.0
2021-07-20 05:00:00	SPY	ETF	426.92	426.92	426.92	426.92	100.0
2021-07-20 05:01:00	SPY	ETF	427.05	427.05	427.05	427.05	100.0
2021-07-20 05:02:00	SPY	ETF	427.06	427.06	426.8	426.8	900.0
2021-07-20 05:03:00	SPY	ETF	426.78	426.78	426.78	426.78	1200.0
2021-07-20 05:04:00	SPY	ETF	426.7	426.7	426.65	426.65	1300.0
2021-07-20 05:05:00	SPY	ETF	426.57	426.57	426.54	426.54	900.0
2021-07-20 05:07:00	SPY	ETF	426.56	426.56	426.56	426.56	200.0
2021-07-20 05:09:00	SPY	ETF	426.84	426.84	426.84	426.84	200.0
2021-07-20 05:11:00	SPY	ETF	426.84	426.84	426.84	426.84	400.0
2021-07-20 05:13:00	SPY	ETF	426.9	426.9	426.9	426.9	300.0
2021-07-20 05:14:00	SPY	ETF	426.98	426.98	426.98	426.98	100.0

> showing 50 of 228,151 rows — these rows as CSV

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