PREVIEW / etf_1min / 2017-01-18

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-01-18.parquet
  size:    2.8 MB
  rows:    144,219

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
2017-01-18 04:00:00	SPY	ETF	226.43	226.58	226.43	226.57	8750.0
2017-01-18 04:03:00	SPY	ETF	226.58	226.62	226.58	226.62	300.0
2017-01-18 04:04:00	SPY	ETF	226.62	226.62	226.56	226.56	1300.0
2017-01-18 04:05:00	SPY	ETF	226.56	226.56	226.56	226.56	2000.0
2017-01-18 04:06:00	SPY	ETF	226.56	226.56	226.56	226.56	3000.0
2017-01-18 04:07:00	SPY	ETF	226.56	226.56	226.56	226.56	1000.0
2017-01-18 04:08:00	SPY	ETF	226.56	226.56	226.56	226.56	2000.0
2017-01-18 04:12:00	SPY	ETF	226.6	226.6	226.6	226.6	1300.0
2017-01-18 04:13:00	SPY	ETF	226.6	226.6	226.6	226.6	500.0
2017-01-18 04:16:00	SPY	ETF	226.57	226.57	226.57	226.57	1700.0
2017-01-18 04:17:00	SPY	ETF	226.55	226.55	226.55	226.55	300.0
2017-01-18 04:25:00	SPY	ETF	226.54	226.54	226.54	226.54	1000.0
2017-01-18 04:26:00	SPY	ETF	226.57	226.57	226.57	226.57	801.0
2017-01-18 04:28:00	SPY	ETF	226.57	226.57	226.57	226.57	500.0
2017-01-18 04:31:00	SPY	ETF	226.6	226.6	226.6	226.6	2302.0
2017-01-18 04:32:00	SPY	ETF	226.57	226.57	226.57	226.57	400.0
2017-01-18 04:37:00	SPY	ETF	226.6	226.6	226.6	226.6	301.0
2017-01-18 04:39:00	SPY	ETF	226.6	226.6	226.6	226.6	1900.0
2017-01-18 04:40:00	SPY	ETF	226.6	226.6	226.6	226.6	1901.0
2017-01-18 04:42:00	SPY	ETF	226.6	226.6	226.6	226.6	1100.0
2017-01-18 04:43:00	SPY	ETF	226.6	226.6	226.6	226.6	700.0
2017-01-18 04:44:00	SPY	ETF	226.58	226.58	226.58	226.58	300.0
2017-01-18 04:48:00	SPY	ETF	226.58	226.58	226.58	226.58	200.0
2017-01-18 04:51:00	SPY	ETF	226.55	226.55	226.55	226.55	301.0
2017-01-18 04:57:00	SPY	ETF	226.55	226.55	226.55	226.55	800.0
2017-01-18 05:01:00	SPY	ETF	226.58	226.58	226.58	226.58	301.0
2017-01-18 05:03:00	SPY	ETF	226.55	226.55	226.55	226.55	313.0
2017-01-18 05:05:00	SPY	ETF	226.5	226.5	226.5	226.5	1400.0
2017-01-18 05:06:00	SPY	ETF	226.53	226.53	226.53	226.53	310.0
2017-01-18 05:13:00	SPY	ETF	226.53	226.53	226.53	226.53	400.0
2017-01-18 05:14:00	SPY	ETF	226.55	226.55	226.55	226.55	301.0
2017-01-18 05:20:00	SPY	ETF	226.58	226.58	226.58	226.58	805.0
2017-01-18 05:22:00	SPY	ETF	226.6	226.6	226.6	226.6	301.0
2017-01-18 05:26:00	SPY	ETF	226.6	226.6	226.6	226.6	3200.0
2017-01-18 05:34:00	SPY	ETF	226.52	226.53	226.52	226.53	500.0
2017-01-18 05:36:00	SPY	ETF	226.55	226.55	226.55	226.55	300.0
2017-01-18 05:40:00	SPY	ETF	226.58	226.58	226.58	226.58	1105.0
2017-01-18 05:57:00	SPY	ETF	226.63	226.64	226.63	226.64	302.0
2017-01-18 06:01:00	SPY	ETF	226.6	226.6	226.6	226.6	302.0
2017-01-18 06:04:00	SPY	ETF	226.58	226.58	226.58	226.58	502.0
2017-01-18 06:09:00	SPY	ETF	226.55	226.55	226.55	226.55	501.0
2017-01-18 06:23:00	SPY	ETF	226.47	226.47	226.47	226.47	100.0
2017-01-18 06:28:00	SPY	ETF	226.47	226.48	226.47	226.48	300.0
2017-01-18 06:31:00	SPY	ETF	226.42	226.42	226.42	226.42	300.0
2017-01-18 06:32:00	SPY	ETF	226.42	226.42	226.42	226.42	300.0
2017-01-18 06:33:00	SPY	ETF	226.42	226.42	226.42	226.42	300.0
2017-01-18 06:34:00	SPY	ETF	226.42	226.48	226.42	226.48	2600.0
2017-01-18 06:35:00	SPY	ETF	226.48	226.48	226.48	226.48	381.0
2017-01-18 06:43:00	SPY	ETF	226.4	226.4	226.4	226.4	300.0
2017-01-18 06:44:00	SPY	ETF	226.37	226.37	226.37	226.37	1629.0

> showing 50 of 144,219 rows — these rows as CSV

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