PREVIEW / etf_1min / 2020-04-16

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-04-16.parquet
  size:    4.4 MB
  rows:    228,428

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
2020-04-16 04:00:00	SPY	ETF	279.89	280.18	279.79	279.85	11445.0
2020-04-16 04:01:00	SPY	ETF	279.81	279.84	279.6	279.6	6409.0
2020-04-16 04:02:00	SPY	ETF	279.55	279.73	279.55	279.73	2530.0
2020-04-16 04:03:00	SPY	ETF	279.74	279.86	279.73	279.86	4716.0
2020-04-16 04:04:00	SPY	ETF	279.8	279.81	279.69	279.69	1292.0
2020-04-16 04:05:00	SPY	ETF	279.61	279.94	279.61	279.94	1420.0
2020-04-16 04:06:00	SPY	ETF	280.08	280.08	279.94	279.94	974.0
2020-04-16 04:07:00	SPY	ETF	280.0	280.07	279.96	279.96	1492.0
2020-04-16 04:08:00	SPY	ETF	280.0	280.11	280.0	280.04	5370.0
2020-04-16 04:09:00	SPY	ETF	280.0	280.26	280.0	280.13	6153.0
2020-04-16 04:10:00	SPY	ETF	279.9	279.91	279.9	279.91	845.0
2020-04-16 04:11:00	SPY	ETF	279.98	280.05	279.91	280.05	1618.0
2020-04-16 04:12:00	SPY	ETF	280.11	280.11	280.11	280.11	595.0
2020-04-16 04:13:00	SPY	ETF	279.96	279.96	279.96	279.96	613.0
2020-04-16 04:15:00	SPY	ETF	279.98	279.98	279.98	279.98	550.0
2020-04-16 04:16:00	SPY	ETF	279.98	280.06	279.95	280.06	1716.0
2020-04-16 04:17:00	SPY	ETF	280.13	280.13	280.13	280.13	959.0
2020-04-16 04:18:00	SPY	ETF	280.2	280.22	280.2	280.22	373.0
2020-04-16 04:19:00	SPY	ETF	279.99	279.99	279.95	279.95	8161.0
2020-04-16 04:20:00	SPY	ETF	279.87	279.87	279.83	279.83	842.0
2020-04-16 04:21:00	SPY	ETF	279.68	279.68	279.68	279.68	362.0
2020-04-16 04:22:00	SPY	ETF	279.67	279.76	279.67	279.76	1103.0
2020-04-16 04:23:00	SPY	ETF	279.81	279.89	279.81	279.89	2761.0
2020-04-16 04:24:00	SPY	ETF	279.85	279.85	279.85	279.85	353.0
2020-04-16 04:26:00	SPY	ETF	279.66	279.74	279.66	279.74	1103.0
2020-04-16 04:27:00	SPY	ETF	279.74	279.81	279.74	279.81	1015.0
2020-04-16 04:28:00	SPY	ETF	279.7	279.7	279.66	279.66	2180.0
2020-04-16 04:29:00	SPY	ETF	279.69	279.73	279.69	279.73	1138.0
2020-04-16 04:30:00	SPY	ETF	279.71	279.72	279.71	279.72	958.0
2020-04-16 04:31:00	SPY	ETF	279.72	279.76	279.6	279.6	730.0
2020-04-16 04:33:00	SPY	ETF	279.54	279.67	279.54	279.67	1634.0
2020-04-16 04:34:00	SPY	ETF	279.69	279.81	279.69	279.81	653.0
2020-04-16 04:35:00	SPY	ETF	279.88	280.0	279.88	280.0	2013.0
2020-04-16 04:36:00	SPY	ETF	279.9	279.9	279.9	279.9	2557.0
2020-04-16 04:37:00	SPY	ETF	279.84	279.84	279.83	279.84	560.0
2020-04-16 04:38:00	SPY	ETF	279.89	279.9	279.89	279.9	618.0
2020-04-16 04:39:00	SPY	ETF	279.7	279.7	279.65	279.65	401.0
2020-04-16 04:40:00	SPY	ETF	279.57	279.57	279.57	279.57	460.0
2020-04-16 04:41:00	SPY	ETF	279.56	279.56	279.56	279.56	200.0
2020-04-16 04:43:00	SPY	ETF	279.55	279.56	279.55	279.56	1013.0
2020-04-16 04:44:00	SPY	ETF	279.54	279.54	279.54	279.54	500.0
2020-04-16 04:45:00	SPY	ETF	279.62	279.62	279.62	279.62	1030.0
2020-04-16 04:48:00	SPY	ETF	279.46	279.46	279.46	279.46	500.0
2020-04-16 04:50:00	SPY	ETF	279.5	279.5	279.46	279.46	600.0
2020-04-16 04:51:00	SPY	ETF	279.55	279.68	279.55	279.68	1100.0
2020-04-16 04:53:00	SPY	ETF	279.46	279.46	279.37	279.37	620.0
2020-04-16 04:54:00	SPY	ETF	279.35	279.43	279.35	279.43	300.0
2020-04-16 04:55:00	SPY	ETF	279.37	279.38	279.37	279.38	630.0
2020-04-16 04:57:00	SPY	ETF	279.46	279.46	279.46	279.46	600.0
2020-04-16 04:58:00	SPY	ETF	279.39	279.39	279.39	279.39	530.0

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

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