PREVIEW / etf_1min / 2017-04-26

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-04-26.parquet
  size:    2.8 MB
  rows:    147,489

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-04-26 04:00:00	SPY	ETF	238.47	238.47	238.41	238.41	1050.0
2017-04-26 04:13:00	SPY	ETF	238.42	238.42	238.42	238.42	800.0
2017-04-26 04:19:00	SPY	ETF	238.38	238.38	238.38	238.38	500.0
2017-04-26 04:21:00	SPY	ETF	238.41	238.41	238.41	238.41	1000.0
2017-04-26 04:22:00	SPY	ETF	238.47	238.47	238.47	238.47	300.0
2017-04-26 04:23:00	SPY	ETF	238.43	238.43	238.43	238.43	500.0
2017-04-26 04:25:00	SPY	ETF	238.42	238.42	238.42	238.42	1200.0
2017-04-26 04:26:00	SPY	ETF	238.38	238.38	238.38	238.38	500.0
2017-04-26 04:40:00	SPY	ETF	238.4	238.4	238.4	238.4	100.0
2017-04-26 04:46:00	SPY	ETF	238.42	238.42	238.41	238.42	1300.0
2017-04-26 04:52:00	SPY	ETF	238.49	238.49	238.49	238.49	400.0
2017-04-26 05:00:00	SPY	ETF	238.46	238.46	238.46	238.46	300.0
2017-04-26 05:01:00	SPY	ETF	238.43	238.43	238.43	238.43	100.0
2017-04-26 05:05:00	SPY	ETF	238.49	238.49	238.49	238.49	1100.0
2017-04-26 05:15:00	SPY	ETF	238.49	238.49	238.49	238.49	1100.0
2017-04-26 05:16:00	SPY	ETF	238.49	238.49	238.49	238.49	200.0
2017-04-26 05:19:00	SPY	ETF	238.47	238.47	238.46	238.46	200.0
2017-04-26 05:20:00	SPY	ETF	238.49	238.49	238.49	238.49	100.0
2017-04-26 05:30:00	SPY	ETF	238.49	238.49	238.49	238.49	2100.0
2017-04-26 05:31:00	SPY	ETF	238.49	238.49	238.49	238.49	300.0
2017-04-26 05:33:00	SPY	ETF	238.48	238.48	238.48	238.48	100.0
2017-04-26 05:35:00	SPY	ETF	238.49	238.49	238.49	238.49	1100.0
2017-04-26 05:36:00	SPY	ETF	238.49	238.5	238.49	238.5	1900.0
2017-04-26 05:45:00	SPY	ETF	238.56	238.59	238.56	238.59	615.0
2017-04-26 05:47:00	SPY	ETF	238.62	238.62	238.62	238.62	2050.0
2017-04-26 05:49:00	SPY	ETF	238.62	238.62	238.62	238.62	100.0
2017-04-26 05:51:00	SPY	ETF	238.64	238.64	238.64	238.64	200.0
2017-04-26 05:52:00	SPY	ETF	238.63	238.63	238.63	238.63	800.0
2017-04-26 05:53:00	SPY	ETF	238.65	238.65	238.65	238.65	900.0
2017-04-26 06:02:00	SPY	ETF	238.67	238.67	238.67	238.67	200.0
2017-04-26 06:04:00	SPY	ETF	238.72	238.72	238.72	238.72	300.0
2017-04-26 06:11:00	SPY	ETF	238.65	238.65	238.65	238.65	100.0
2017-04-26 06:22:00	SPY	ETF	238.56	238.56	238.56	238.56	200.0
2017-04-26 06:23:00	SPY	ETF	238.56	238.56	238.56	238.56	200.0
2017-04-26 06:25:00	SPY	ETF	238.65	238.65	238.65	238.65	100.0
2017-04-26 06:27:00	SPY	ETF	238.63	238.63	238.63	238.63	400.0
2017-04-26 06:28:00	SPY	ETF	238.56	238.56	238.56	238.56	2000.0
2017-04-26 06:38:00	SPY	ETF	238.58	238.58	238.58	238.58	500.0
2017-04-26 06:39:00	SPY	ETF	238.53	238.53	238.53	238.53	1000.0
2017-04-26 06:41:00	SPY	ETF	238.53	238.53	238.53	238.53	2147.0
2017-04-26 07:00:00	SPY	ETF	238.41	238.41	238.41	238.41	1200.0
2017-04-26 07:02:00	SPY	ETF	238.41	238.41	238.4	238.4	25000.0
2017-04-26 07:04:00	SPY	ETF	238.41	238.41	238.41	238.41	300.0
2017-04-26 07:05:00	SPY	ETF	238.41	238.42	238.41	238.42	1400.0
2017-04-26 07:06:00	SPY	ETF	238.42	238.42	238.42	238.42	141.0
2017-04-26 07:08:00	SPY	ETF	238.4	238.41	238.4	238.41	6645.0
2017-04-26 07:11:00	SPY	ETF	238.4	238.4	238.4	238.4	5096.0
2017-04-26 07:12:00	SPY	ETF	238.42	238.42	238.42	238.42	271.0
2017-04-26 07:14:00	SPY	ETF	238.41	238.44	238.41	238.44	800.0
2017-04-26 07:16:00	SPY	ETF	238.4	238.4	238.4	238.4	239.0

> showing 50 of 147,489 rows — these rows as CSV

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