PREVIEW / etf_1min / 2020-04-17

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-04-17.parquet
  size:    4.4 MB
  rows:    227,884

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-17 04:00:00	SPY	ETF	286.15	286.56	286.15	286.46	8733.0
2020-04-17 04:01:00	SPY	ETF	286.38	286.57	286.35	286.5	11702.0
2020-04-17 04:02:00	SPY	ETF	286.56	286.58	286.5	286.52	2314.0
2020-04-17 04:03:00	SPY	ETF	286.66	286.66	286.46	286.46	1645.0
2020-04-17 04:04:00	SPY	ETF	286.6	286.7	286.6	286.67	1286.0
2020-04-17 04:05:00	SPY	ETF	286.58	286.67	286.56	286.58	1112.0
2020-04-17 04:06:00	SPY	ETF	286.62	286.62	286.51	286.51	1618.0
2020-04-17 04:07:00	SPY	ETF	286.57	286.79	286.57	286.79	755.0
2020-04-17 04:08:00	SPY	ETF	286.83	287.0	286.83	287.0	1591.0
2020-04-17 04:09:00	SPY	ETF	287.14	287.52	287.14	287.52	7013.0
2020-04-17 04:10:00	SPY	ETF	287.54	287.54	287.33	287.41	2951.0
2020-04-17 04:11:00	SPY	ETF	287.3	287.3	287.1	287.15	8430.0
2020-04-17 04:12:00	SPY	ETF	287.15	287.17	286.93	287.06	12352.0
2020-04-17 04:13:00	SPY	ETF	287.03	287.09	286.96	286.99	4109.0
2020-04-17 04:14:00	SPY	ETF	286.96	287.05	286.88	286.88	2928.0
2020-04-17 04:15:00	SPY	ETF	286.93	286.93	286.72	286.72	6997.0
2020-04-17 04:16:00	SPY	ETF	286.72	286.96	286.66	286.81	11020.0
2020-04-17 04:17:00	SPY	ETF	286.8	286.96	286.8	286.85	4621.0
2020-04-17 04:18:00	SPY	ETF	286.85	286.85	286.85	286.85	570.0
2020-04-17 04:19:00	SPY	ETF	286.94	287.05	286.94	287.0	1717.0
2020-04-17 04:20:00	SPY	ETF	286.95	286.99	286.93	286.99	2970.0
2020-04-17 04:21:00	SPY	ETF	287.01	287.01	286.81	286.81	2708.0
2020-04-17 04:22:00	SPY	ETF	286.98	286.98	286.98	286.98	2415.0
2020-04-17 04:23:00	SPY	ETF	286.75	286.79	286.75	286.79	1210.0
2020-04-17 04:24:00	SPY	ETF	286.73	286.73	286.55	286.6	1152.0
2020-04-17 04:25:00	SPY	ETF	286.55	286.61	286.45	286.5	5765.0
2020-04-17 04:26:00	SPY	ETF	286.37	286.37	286.35	286.35	1047.0
2020-04-17 04:27:00	SPY	ETF	286.41	286.43	286.35	286.36	7366.0
2020-04-17 04:28:00	SPY	ETF	286.4	286.53	286.4	286.4	4501.0
2020-04-17 04:29:00	SPY	ETF	286.35	286.35	286.21	286.32	2870.0
2020-04-17 04:30:00	SPY	ETF	286.3	286.36	286.11	286.12	6543.0
2020-04-17 04:31:00	SPY	ETF	286.1	286.11	286.01	286.11	3101.0
2020-04-17 04:32:00	SPY	ETF	286.1	286.17	286.05	286.13	4828.0
2020-04-17 04:33:00	SPY	ETF	286.18	286.35	286.18	286.35	955.0
2020-04-17 04:34:00	SPY	ETF	286.37	286.41	286.37	286.41	1150.0
2020-04-17 04:35:00	SPY	ETF	286.32	286.32	286.22	286.22	11355.0
2020-04-17 04:36:00	SPY	ETF	286.63	286.63	286.3	286.59	14062.0
2020-04-17 04:37:00	SPY	ETF	286.59	286.59	286.44	286.44	4099.0
2020-04-17 04:38:00	SPY	ETF	286.51	286.51	286.29	286.29	4505.0
2020-04-17 04:39:00	SPY	ETF	286.42	286.42	286.09	286.14	3217.0
2020-04-17 04:40:00	SPY	ETF	286.11	286.11	286.0	286.04	2343.0
2020-04-17 04:41:00	SPY	ETF	286.28	286.28	286.26	286.27	853.0
2020-04-17 04:42:00	SPY	ETF	286.43	286.5	286.43	286.5	524.0
2020-04-17 04:43:00	SPY	ETF	286.5	286.5	286.47	286.48	910.0
2020-04-17 04:44:00	SPY	ETF	286.42	286.46	286.42	286.46	714.0
2020-04-17 04:45:00	SPY	ETF	286.46	286.5	286.46	286.5	450.0
2020-04-17 04:46:00	SPY	ETF	286.58	286.6	286.58	286.6	620.0
2020-04-17 04:47:00	SPY	ETF	286.62	286.62	286.5	286.5	799.0
2020-04-17 04:48:00	SPY	ETF	286.47	286.47	286.47	286.47	204.0
2020-04-17 04:49:00	SPY	ETF	286.59	286.64	286.59	286.64	505.0

> showing 50 of 227,884 rows — these rows as CSV

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