PREVIEW / etf_1min / 2019-05-03

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-05-03.parquet
  size:    3.0 MB
  rows:    159,181

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
2019-05-03 04:00:00	SPY	ETF	291.97	292.0	291.97	292.0	312.0
2019-05-03 04:05:00	SPY	ETF	292.13	292.13	292.13	292.13	200.0
2019-05-03 04:06:00	SPY	ETF	292.13	292.16	292.13	292.16	930.0
2019-05-03 04:13:00	SPY	ETF	292.14	292.14	292.14	292.14	1000.0
2019-05-03 04:19:00	SPY	ETF	292.24	292.24	292.24	292.24	300.0
2019-05-03 04:20:00	SPY	ETF	292.26	292.26	292.26	292.26	525.0
2019-05-03 04:21:00	SPY	ETF	292.29	292.29	292.29	292.29	1000.0
2019-05-03 04:37:00	SPY	ETF	292.17	292.17	292.17	292.17	325.0
2019-05-03 04:40:00	SPY	ETF	292.19	292.19	292.19	292.19	500.0
2019-05-03 04:45:00	SPY	ETF	292.15	292.15	292.15	292.15	260.0
2019-05-03 04:55:00	SPY	ETF	292.16	292.16	292.16	292.16	500.0
2019-05-03 04:57:00	SPY	ETF	292.16	292.16	292.16	292.16	550.0
2019-05-03 05:00:00	SPY	ETF	292.19	292.19	292.19	292.19	950.0
2019-05-03 05:02:00	SPY	ETF	292.15	292.21	292.15	292.21	1100.0
2019-05-03 05:05:00	SPY	ETF	292.22	292.22	292.22	292.22	1000.0
2019-05-03 05:08:00	SPY	ETF	292.21	292.21	292.21	292.21	1000.0
2019-05-03 05:14:00	SPY	ETF	292.2	292.2	292.2	292.2	1000.0
2019-05-03 05:16:00	SPY	ETF	292.24	292.25	292.24	292.25	1300.0
2019-05-03 05:17:00	SPY	ETF	292.26	292.26	292.26	292.26	400.0
2019-05-03 05:21:00	SPY	ETF	292.21	292.21	292.21	292.21	200.0
2019-05-03 05:23:00	SPY	ETF	292.19	292.19	292.19	292.19	200.0
2019-05-03 05:31:00	SPY	ETF	292.14	292.14	292.14	292.14	1000.0
2019-05-03 05:33:00	SPY	ETF	292.16	292.16	292.16	292.16	125.0
2019-05-03 05:34:00	SPY	ETF	292.16	292.16	292.15	292.15	775.0
2019-05-03 05:36:00	SPY	ETF	292.15	292.15	292.15	292.15	300.0
2019-05-03 05:41:00	SPY	ETF	292.14	292.14	292.13	292.14	1002.0
2019-05-03 05:42:00	SPY	ETF	292.14	292.14	292.14	292.14	198.0
2019-05-03 05:43:00	SPY	ETF	292.18	292.18	292.18	292.18	1000.0
2019-05-03 05:48:00	SPY	ETF	292.17	292.17	292.17	292.17	100.0
2019-05-03 05:50:00	SPY	ETF	292.07	292.07	292.07	292.07	100.0
2019-05-03 05:51:00	SPY	ETF	292.1	292.1	292.1	292.1	840.0
2019-05-03 05:52:00	SPY	ETF	292.1	292.1	292.1	292.1	200.0
2019-05-03 05:54:00	SPY	ETF	291.97	291.97	291.97	291.97	200.0
2019-05-03 05:58:00	SPY	ETF	291.95	291.96	291.95	291.96	300.0
2019-05-03 06:01:00	SPY	ETF	291.96	291.96	291.96	291.96	100.0
2019-05-03 06:09:00	SPY	ETF	291.94	291.94	291.94	291.94	300.0
2019-05-03 06:14:00	SPY	ETF	291.91	291.91	291.91	291.91	200.0
2019-05-03 06:17:00	SPY	ETF	291.94	291.96	291.94	291.96	2030.0
2019-05-03 06:18:00	SPY	ETF	292.0	292.0	292.0	292.0	1323.0
2019-05-03 06:19:00	SPY	ETF	292.06	292.06	292.06	292.06	400.0
2019-05-03 06:20:00	SPY	ETF	292.06	292.06	292.06	292.06	300.0
2019-05-03 06:23:00	SPY	ETF	292.03	292.03	292.03	292.03	280.0
2019-05-03 06:26:00	SPY	ETF	292.03	292.03	292.03	292.03	700.0
2019-05-03 06:28:00	SPY	ETF	292.02	292.03	292.02	292.03	1700.0
2019-05-03 06:30:00	SPY	ETF	292.05	292.05	292.05	292.05	100.0
2019-05-03 06:31:00	SPY	ETF	292.03	292.03	292.03	292.03	350.0
2019-05-03 06:32:00	SPY	ETF	292.03	292.03	292.03	292.03	1000.0
2019-05-03 06:34:00	SPY	ETF	292.06	292.07	292.02	292.05	26900.0
2019-05-03 06:36:00	SPY	ETF	292.02	292.02	292.02	292.02	450.0
2019-05-03 06:38:00	SPY	ETF	291.99	291.99	291.99	291.99	100.0

> showing 50 of 159,181 rows — these rows as CSV

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