PREVIEW / etf_1min / 2020-04-28

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-04-28.parquet
  size:    4.2 MB
  rows:    217,673

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-28 04:00:00	SPY	ETF	288.2	288.2	288.1	288.11	2353.0
2020-04-28 04:01:00	SPY	ETF	288.1	288.1	288.1	288.1	1007.0
2020-04-28 04:02:00	SPY	ETF	288.06	288.06	288.04	288.06	1624.0
2020-04-28 04:03:00	SPY	ETF	288.0	288.0	288.0	288.0	211.0
2020-04-28 04:04:00	SPY	ETF	287.98	287.98	287.94	287.94	3550.0
2020-04-28 04:05:00	SPY	ETF	287.93	287.93	287.93	287.93	105.0
2020-04-28 04:06:00	SPY	ETF	287.82	287.82	287.76	287.76	1320.0
2020-04-28 04:08:00	SPY	ETF	287.65	287.65	287.63	287.63	5900.0
2020-04-28 04:11:00	SPY	ETF	287.58	287.58	287.58	287.58	500.0
2020-04-28 04:13:00	SPY	ETF	287.73	287.83	287.73	287.82	3330.0
2020-04-28 04:15:00	SPY	ETF	287.84	287.84	287.84	287.84	111.0
2020-04-28 04:17:00	SPY	ETF	287.92	287.92	287.92	287.92	320.0
2020-04-28 04:18:00	SPY	ETF	287.84	287.84	287.84	287.84	529.0
2020-04-28 04:19:00	SPY	ETF	287.85	287.85	287.85	287.85	1000.0
2020-04-28 04:22:00	SPY	ETF	287.92	287.92	287.92	287.92	1006.0
2020-04-28 04:23:00	SPY	ETF	287.95	287.95	287.95	287.95	206.0
2020-04-28 04:25:00	SPY	ETF	288.06	288.06	288.03	288.04	2729.0
2020-04-28 04:27:00	SPY	ETF	288.03	288.04	288.03	288.04	3022.0
2020-04-28 04:28:00	SPY	ETF	287.92	287.92	287.92	287.92	1000.0
2020-04-28 04:31:00	SPY	ETF	287.8	287.8	287.8	287.8	125.0
2020-04-28 04:32:00	SPY	ETF	287.71	287.74	287.71	287.74	250.0
2020-04-28 04:33:00	SPY	ETF	287.83	287.83	287.83	287.83	800.0
2020-04-28 04:34:00	SPY	ETF	287.76	287.76	287.76	287.76	1231.0
2020-04-28 04:35:00	SPY	ETF	287.8	287.8	287.8	287.8	500.0
2020-04-28 04:36:00	SPY	ETF	288.0	288.0	288.0	288.0	201.0
2020-04-28 04:38:00	SPY	ETF	288.2	288.23	288.18	288.18	1005.0
2020-04-28 04:40:00	SPY	ETF	288.2	288.2	288.2	288.2	2725.0
2020-04-28 04:42:00	SPY	ETF	288.06	288.13	288.06	288.13	3018.0
2020-04-28 04:43:00	SPY	ETF	288.12	288.2	288.12	288.2	200.0
2020-04-28 04:44:00	SPY	ETF	288.26	288.26	288.26	288.26	200.0
2020-04-28 04:45:00	SPY	ETF	288.14	288.14	288.14	288.14	205.0
2020-04-28 04:46:00	SPY	ETF	288.18	288.18	288.08	288.08	800.0
2020-04-28 04:47:00	SPY	ETF	288.0	288.0	288.0	288.0	100.0
2020-04-28 04:49:00	SPY	ETF	287.78	287.78	287.78	287.78	107.0
2020-04-28 04:52:00	SPY	ETF	287.97	288.06	287.97	288.06	315.0
2020-04-28 04:54:00	SPY	ETF	287.96	287.96	287.96	287.96	300.0
2020-04-28 04:57:00	SPY	ETF	287.96	287.96	287.96	287.96	100.0
2020-04-28 04:58:00	SPY	ETF	287.88	287.88	287.88	287.88	1007.0
2020-04-28 04:59:00	SPY	ETF	287.88	287.88	287.88	287.88	280.0
2020-04-28 05:01:00	SPY	ETF	287.91	287.91	287.91	287.91	225.0
2020-04-28 05:03:00	SPY	ETF	288.18	288.18	288.11	288.11	1000.0
2020-04-28 05:05:00	SPY	ETF	288.2	288.2	288.14	288.14	1100.0
2020-04-28 05:06:00	SPY	ETF	288.15	288.15	288.15	288.15	100.0
2020-04-28 05:09:00	SPY	ETF	288.15	288.15	288.15	288.15	100.0
2020-04-28 05:10:00	SPY	ETF	288.24	288.26	288.24	288.26	650.0
2020-04-28 05:14:00	SPY	ETF	288.2	288.29	288.2	288.29	1327.0
2020-04-28 05:15:00	SPY	ETF	288.38	288.38	288.36	288.36	1310.0
2020-04-28 05:16:00	SPY	ETF	288.4	288.86	288.4	288.86	4853.0
2020-04-28 05:17:00	SPY	ETF	288.63	288.63	288.63	288.63	204.0
2020-04-28 05:18:00	SPY	ETF	288.72	288.79	288.67	288.79	1100.0

> showing 50 of 217,673 rows — these rows as CSV

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