PREVIEW / etf_1min / 2017-02-23

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-02-23.parquet
  size:    2.9 MB
  rows:    152,400

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-02-23 04:00:00	SPY	ETF	236.27	236.27	236.27	236.27	388.0
2017-02-23 04:20:00	SPY	ETF	236.46	236.46	236.46	236.46	100.0
2017-02-23 04:42:00	SPY	ETF	236.5	236.5	236.5	236.5	325.0
2017-02-23 04:44:00	SPY	ETF	236.53	236.54	236.53	236.54	600.0
2017-02-23 04:51:00	SPY	ETF	236.54	236.58	236.54	236.58	2400.0
2017-02-23 05:16:00	SPY	ETF	236.49	236.49	236.49	236.49	400.0
2017-02-23 05:20:00	SPY	ETF	236.44	236.44	236.44	236.44	1000.0
2017-02-23 05:21:00	SPY	ETF	236.47	236.47	236.47	236.47	300.0
2017-02-23 05:33:00	SPY	ETF	236.52	236.52	236.52	236.52	300.0
2017-02-23 05:43:00	SPY	ETF	236.52	236.52	236.52	236.52	100.0
2017-02-23 05:57:00	SPY	ETF	236.47	236.47	236.47	236.47	300.0
2017-02-23 06:09:00	SPY	ETF	236.38	236.38	236.38	236.38	400.0
2017-02-23 06:19:00	SPY	ETF	236.42	236.42	236.42	236.42	1000.0
2017-02-23 06:21:00	SPY	ETF	236.42	236.42	236.39	236.39	1100.0
2017-02-23 06:26:00	SPY	ETF	236.39	236.39	236.39	236.39	100.0
2017-02-23 06:30:00	SPY	ETF	236.37	236.37	236.37	236.37	500.0
2017-02-23 06:34:00	SPY	ETF	236.4	236.41	236.4	236.41	25000.0
2017-02-23 06:47:00	SPY	ETF	236.45	236.45	236.45	236.45	100.0
2017-02-23 07:00:00	SPY	ETF	236.46	236.46	236.44	236.44	500.0
2017-02-23 07:01:00	SPY	ETF	236.44	236.44	236.44	236.44	4000.0
2017-02-23 07:02:00	SPY	ETF	236.46	236.5	236.46	236.5	2500.0
2017-02-23 07:04:00	SPY	ETF	236.54	236.58	236.54	236.56	3500.0
2017-02-23 07:05:00	SPY	ETF	236.41	236.41	236.41	236.41	600.0
2017-02-23 07:06:00	SPY	ETF	236.37	236.37	236.36	236.36	1000.0
2017-02-23 07:10:00	SPY	ETF	236.39	236.39	236.39	236.39	500.0
2017-02-23 07:11:00	SPY	ETF	236.42	236.42	236.41	236.42	2200.0
2017-02-23 07:12:00	SPY	ETF	236.42	236.42	236.42	236.42	600.0
2017-02-23 07:17:00	SPY	ETF	236.42	236.42	236.41	236.41	1500.0
2017-02-23 07:18:00	SPY	ETF	236.41	236.42	236.41	236.42	2100.0
2017-02-23 07:20:00	SPY	ETF	236.44	236.46	236.44	236.46	25200.0
2017-02-23 07:21:00	SPY	ETF	236.46	236.46	236.46	236.46	1150.0
2017-02-23 07:22:00	SPY	ETF	236.46	236.48	236.46	236.48	1000.0
2017-02-23 07:23:00	SPY	ETF	236.48	236.48	236.48	236.48	500.0
2017-02-23 07:24:00	SPY	ETF	236.48	236.49	236.48	236.48	1500.0
2017-02-23 07:25:00	SPY	ETF	236.45	236.45	236.44	236.44	1100.0
2017-02-23 07:26:00	SPY	ETF	236.45	236.48	236.45	236.47	700.0
2017-02-23 07:27:00	SPY	ETF	236.48	236.48	236.48	236.48	1000.0
2017-02-23 07:29:00	SPY	ETF	236.48	236.48	236.48	236.48	600.0
2017-02-23 07:31:00	SPY	ETF	236.46	236.49	236.46	236.49	524.0
2017-02-23 07:32:00	SPY	ETF	236.5	236.52	236.5	236.52	1750.0
2017-02-23 07:33:00	SPY	ETF	236.52	236.52	236.5	236.5	900.0
2017-02-23 07:34:00	SPY	ETF	236.5	236.5	236.5	236.5	500.0
2017-02-23 07:36:00	SPY	ETF	236.46	236.46	236.45	236.45	2100.0
2017-02-23 07:41:00	SPY	ETF	236.51	236.51	236.51	236.51	1250.0
2017-02-23 07:42:00	SPY	ETF	236.53	236.58	236.53	236.58	9700.0
2017-02-23 07:43:00	SPY	ETF	236.59	236.62	236.59	236.62	10492.0
2017-02-23 07:44:00	SPY	ETF	236.64	236.64	236.61	236.61	608.0
2017-02-23 07:45:00	SPY	ETF	236.56	236.57	236.56	236.57	2800.0
2017-02-23 07:46:00	SPY	ETF	236.59	236.59	236.59	236.59	100.0
2017-02-23 07:47:00	SPY	ETF	236.59	236.62	236.59	236.62	3100.0

> showing 50 of 152,400 rows — these rows as CSV

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