PREVIEW / etf_1min / 2017-09-12

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-09-12.parquet
  size:    2.5 MB
  rows:    132,598

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-09-12 04:00:00	SPY	ETF	249.41	249.41	249.4	249.4	2926.0
2017-09-12 04:04:00	SPY	ETF	249.4	249.4	249.4	249.4	100.0
2017-09-12 04:09:00	SPY	ETF	249.46	249.46	249.46	249.46	400.0
2017-09-12 04:12:00	SPY	ETF	249.51	249.52	249.5	249.52	17600.0
2017-09-12 04:15:00	SPY	ETF	249.51	249.51	249.51	249.51	1000.0
2017-09-12 04:16:00	SPY	ETF	249.49	249.49	249.49	249.49	500.0
2017-09-12 04:21:00	SPY	ETF	249.55	249.55	249.55	249.55	100.0
2017-09-12 04:26:00	SPY	ETF	249.48	249.48	249.48	249.48	300.0
2017-09-12 04:29:00	SPY	ETF	249.5	249.52	249.5	249.52	4300.0
2017-09-12 04:30:00	SPY	ETF	249.53	249.53	249.53	249.53	1000.0
2017-09-12 04:36:00	SPY	ETF	249.53	249.53	249.53	249.53	1100.0
2017-09-12 04:38:00	SPY	ETF	249.58	249.58	249.58	249.58	200.0
2017-09-12 04:39:00	SPY	ETF	249.58	249.58	249.58	249.58	300.0
2017-09-12 04:47:00	SPY	ETF	249.54	249.54	249.52	249.52	400.0
2017-09-12 04:54:00	SPY	ETF	249.55	249.57	249.53	249.57	600.0
2017-09-12 04:56:00	SPY	ETF	249.57	249.57	249.57	249.57	100.0
2017-09-12 05:04:00	SPY	ETF	249.51	249.51	249.51	249.51	300.0
2017-09-12 05:07:00	SPY	ETF	249.53	249.53	249.53	249.53	100.0
2017-09-12 05:17:00	SPY	ETF	249.57	249.57	249.57	249.57	100.0
2017-09-12 05:20:00	SPY	ETF	249.58	249.58	249.58	249.58	100.0
2017-09-12 05:28:00	SPY	ETF	249.49	249.49	249.49	249.49	300.0
2017-09-12 05:33:00	SPY	ETF	249.51	249.51	249.51	249.51	14300.0
2017-09-12 05:45:00	SPY	ETF	249.53	249.53	249.53	249.53	100.0
2017-09-12 05:46:00	SPY	ETF	249.53	249.53	249.53	249.53	300.0
2017-09-12 06:09:00	SPY	ETF	249.56	249.56	249.56	249.56	300.0
2017-09-12 06:13:00	SPY	ETF	249.56	249.56	249.56	249.56	4000.0
2017-09-12 06:20:00	SPY	ETF	249.59	249.59	249.59	249.59	725.0
2017-09-12 06:25:00	SPY	ETF	249.59	249.59	249.59	249.59	100.0
2017-09-12 06:30:00	SPY	ETF	249.58	249.58	249.58	249.58	300.0
2017-09-12 06:31:00	SPY	ETF	249.58	249.58	249.58	249.58	120.0
2017-09-12 06:32:00	SPY	ETF	249.58	249.58	249.58	249.58	100.0
2017-09-12 06:39:00	SPY	ETF	249.61	249.61	249.61	249.61	1300.0
2017-09-12 06:49:00	SPY	ETF	249.62	249.62	249.62	249.62	100.0
2017-09-12 06:50:00	SPY	ETF	249.62	249.62	249.62	249.62	3000.0
2017-09-12 06:52:00	SPY	ETF	249.6	249.6	249.6	249.6	100.0
2017-09-12 06:59:00	SPY	ETF	249.59	249.59	249.59	249.59	1100.0
2017-09-12 07:02:00	SPY	ETF	249.58	249.62	249.58	249.62	320.0
2017-09-12 07:03:00	SPY	ETF	249.62	249.62	249.58	249.58	4200.0
2017-09-12 07:04:00	SPY	ETF	249.62	249.62	249.62	249.62	400.0
2017-09-12 07:07:00	SPY	ETF	249.61	249.61	249.61	249.61	1300.0
2017-09-12 07:16:00	SPY	ETF	249.59	249.59	249.58	249.58	5500.0
2017-09-12 07:17:00	SPY	ETF	249.6	249.61	249.6	249.6	15969.0
2017-09-12 07:18:00	SPY	ETF	249.63	249.65	249.63	249.65	1948.0
2017-09-12 07:19:00	SPY	ETF	249.67	249.69	249.67	249.69	7591.0
2017-09-12 07:20:00	SPY	ETF	249.67	249.67	249.67	249.67	253.0
2017-09-12 07:21:00	SPY	ETF	249.67	249.67	249.67	249.67	105.0
2017-09-12 07:22:00	SPY	ETF	249.65	249.65	249.65	249.65	200.0
2017-09-12 07:28:00	SPY	ETF	249.69	249.69	249.69	249.69	1844.0
2017-09-12 07:29:00	SPY	ETF	249.67	249.67	249.67	249.67	500.0
2017-09-12 07:31:00	SPY	ETF	249.67	249.67	249.67	249.67	650.0

> showing 50 of 132,598 rows — these rows as CSV

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