PREVIEW / etf_1min / 2018-05-01

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-05-01.parquet
  size:    3.0 MB
  rows:    150,716

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
2018-05-01 04:01:00	SPY	ETF	264.59	264.59	264.59	264.59	365.0
2018-05-01 04:05:00	SPY	ETF	264.57	264.57	264.57	264.57	500.0
2018-05-01 04:06:00	SPY	ETF	264.54	264.54	264.54	264.54	2000.0
2018-05-01 04:08:00	SPY	ETF	264.54	264.54	264.54	264.54	2000.0
2018-05-01 04:09:00	SPY	ETF	264.5	264.5	264.5	264.5	400.0
2018-05-01 04:10:00	SPY	ETF	264.54	264.54	264.54	264.54	5000.0
2018-05-01 04:11:00	SPY	ETF	264.51	264.51	264.51	264.51	300.0
2018-05-01 04:13:00	SPY	ETF	264.47	264.47	264.47	264.47	500.0
2018-05-01 04:14:00	SPY	ETF	264.38	264.38	264.38	264.38	7600.0
2018-05-01 04:15:00	SPY	ETF	264.44	264.44	264.44	264.44	516.0
2018-05-01 04:17:00	SPY	ETF	264.47	264.47	264.47	264.47	2700.0
2018-05-01 04:18:00	SPY	ETF	264.47	264.47	264.47	264.47	600.0
2018-05-01 04:20:00	SPY	ETF	264.42	264.42	264.42	264.42	800.0
2018-05-01 04:22:00	SPY	ETF	264.51	264.51	264.51	264.51	500.0
2018-05-01 04:24:00	SPY	ETF	264.55	264.55	264.55	264.55	200.0
2018-05-01 04:25:00	SPY	ETF	264.53	264.53	264.53	264.53	300.0
2018-05-01 04:26:00	SPY	ETF	264.5	264.5	264.49	264.49	600.0
2018-05-01 04:31:00	SPY	ETF	264.45	264.45	264.45	264.45	600.0
2018-05-01 04:32:00	SPY	ETF	264.49	264.49	264.49	264.49	100.0
2018-05-01 04:34:00	SPY	ETF	264.44	264.44	264.44	264.44	1600.0
2018-05-01 04:35:00	SPY	ETF	264.43	264.43	264.43	264.43	300.0
2018-05-01 04:38:00	SPY	ETF	264.3	264.3	264.3	264.3	700.0
2018-05-01 04:40:00	SPY	ETF	264.22	264.22	264.22	264.22	1900.0
2018-05-01 04:41:00	SPY	ETF	264.22	264.22	264.22	264.22	1500.0
2018-05-01 04:42:00	SPY	ETF	264.25	264.25	264.25	264.25	102.0
2018-05-01 04:47:00	SPY	ETF	264.16	264.16	264.14	264.14	3351.0
2018-05-01 04:48:00	SPY	ETF	264.13	264.13	264.13	264.13	100.0
2018-05-01 04:49:00	SPY	ETF	264.18	264.18	264.18	264.18	400.0
2018-05-01 04:52:00	SPY	ETF	264.19	264.19	264.1	264.12	2850.0
2018-05-01 04:54:00	SPY	ETF	264.21	264.21	264.21	264.21	900.0
2018-05-01 04:58:00	SPY	ETF	264.14	264.14	264.1	264.1	2000.0
2018-05-01 04:59:00	SPY	ETF	264.1	264.1	264.1	264.1	1000.0
2018-05-01 05:00:00	SPY	ETF	264.08	264.08	264.05	264.05	1000.0
2018-05-01 05:03:00	SPY	ETF	264.06	264.06	264.06	264.06	101.0
2018-05-01 05:04:00	SPY	ETF	264.08	264.08	264.08	264.08	100.0
2018-05-01 05:07:00	SPY	ETF	264.11	264.11	264.11	264.11	1000.0
2018-05-01 05:08:00	SPY	ETF	264.1	264.1	264.1	264.1	100.0
2018-05-01 05:10:00	SPY	ETF	264.12	264.13	264.12	264.13	600.0
2018-05-01 05:15:00	SPY	ETF	264.13	264.13	264.13	264.13	1940.0
2018-05-01 05:16:00	SPY	ETF	264.18	264.18	264.18	264.18	265.0
2018-05-01 05:18:00	SPY	ETF	264.18	264.18	264.18	264.18	350.0
2018-05-01 05:24:00	SPY	ETF	264.18	264.18	264.18	264.18	400.0
2018-05-01 05:26:00	SPY	ETF	264.19	264.19	264.19	264.19	550.0
2018-05-01 05:27:00	SPY	ETF	264.18	264.18	264.18	264.18	402.0
2018-05-01 05:33:00	SPY	ETF	264.22	264.22	264.18	264.18	800.0
2018-05-01 05:37:00	SPY	ETF	264.15	264.15	264.15	264.15	1000.0
2018-05-01 05:49:00	SPY	ETF	264.27	264.27	264.27	264.27	1000.0
2018-05-01 05:53:00	SPY	ETF	264.28	264.28	264.28	264.28	1000.0
2018-05-01 06:00:00	SPY	ETF	264.35	264.35	264.35	264.35	250.0
2018-05-01 06:01:00	SPY	ETF	264.3	264.3	264.3	264.3	1100.0

> showing 50 of 150,716 rows — these rows as CSV

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