PREVIEW / etf_1min / 2017-06-07

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-06-07.parquet
  size:    2.6 MB
  rows:    136,052

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-06-07 04:00:00	SPY	ETF	243.5	243.5	243.5	243.5	1998.0
2017-06-07 04:01:00	SPY	ETF	243.5	243.5	243.5	243.5	398.0
2017-06-07 04:25:00	SPY	ETF	243.33	243.33	243.33	243.33	100.0
2017-06-07 05:08:00	SPY	ETF	243.41	243.41	243.41	243.41	400.0
2017-06-07 05:13:00	SPY	ETF	243.41	243.41	243.41	243.41	400.0
2017-06-07 05:32:00	SPY	ETF	243.42	243.42	243.42	243.42	200.0
2017-06-07 05:34:00	SPY	ETF	243.41	243.41	243.41	243.41	200.0
2017-06-07 06:14:00	SPY	ETF	243.54	243.54	243.53	243.53	200.0
2017-06-07 06:16:00	SPY	ETF	243.6	243.6	243.6	243.6	600.0
2017-06-07 06:19:00	SPY	ETF	243.61	243.61	243.61	243.61	410.0
2017-06-07 06:21:00	SPY	ETF	243.61	243.61	243.61	243.61	600.0
2017-06-07 06:29:00	SPY	ETF	243.58	243.6	243.58	243.6	4500.0
2017-06-07 06:32:00	SPY	ETF	243.59	243.59	243.59	243.59	1000.0
2017-06-07 06:35:00	SPY	ETF	243.62	243.66	243.62	243.66	5100.0
2017-06-07 06:40:00	SPY	ETF	243.64	243.64	243.64	243.64	5000.0
2017-06-07 06:43:00	SPY	ETF	243.6	243.6	243.6	243.6	1000.0
2017-06-07 06:45:00	SPY	ETF	243.57	243.57	243.57	243.57	500.0
2017-06-07 06:59:00	SPY	ETF	243.48	243.48	243.48	243.48	740.0
2017-06-07 07:00:00	SPY	ETF	243.54	243.54	243.54	243.54	100.0
2017-06-07 07:03:00	SPY	ETF	243.56	243.56	243.56	243.56	200.0
2017-06-07 07:04:00	SPY	ETF	243.56	243.56	243.56	243.56	869.0
2017-06-07 07:05:00	SPY	ETF	243.56	243.56	243.56	243.56	869.0
2017-06-07 07:06:00	SPY	ETF	243.56	243.56	243.55	243.55	7026.0
2017-06-07 07:07:00	SPY	ETF	243.54	243.54	243.54	243.54	769.0
2017-06-07 07:09:00	SPY	ETF	243.56	243.56	243.56	243.56	2000.0
2017-06-07 07:10:00	SPY	ETF	243.56	243.56	243.56	243.56	4000.0
2017-06-07 07:13:00	SPY	ETF	243.56	243.56	243.56	243.56	6000.0
2017-06-07 07:14:00	SPY	ETF	243.52	243.52	243.52	243.52	1369.0
2017-06-07 07:21:00	SPY	ETF	243.55	243.56	243.55	243.55	700.0
2017-06-07 07:22:00	SPY	ETF	243.55	243.55	243.55	243.55	569.0
2017-06-07 07:23:00	SPY	ETF	243.57	243.57	243.57	243.57	400.0
2017-06-07 07:24:00	SPY	ETF	243.56	243.56	243.56	243.56	800.0
2017-06-07 07:25:00	SPY	ETF	243.56	243.56	243.55	243.55	200.0
2017-06-07 07:27:00	SPY	ETF	243.55	243.55	243.52	243.53	800.0
2017-06-07 07:28:00	SPY	ETF	243.53	243.54	243.52	243.54	1569.0
2017-06-07 07:29:00	SPY	ETF	243.54	243.54	243.54	243.54	5000.0
2017-06-07 07:31:00	SPY	ETF	243.53	243.53	243.53	243.53	300.0
2017-06-07 07:33:00	SPY	ETF	243.53	243.53	243.53	243.53	500.0
2017-06-07 07:34:00	SPY	ETF	243.53	243.53	243.52	243.52	255.0
2017-06-07 07:35:00	SPY	ETF	243.51	243.51	243.46	243.48	7083.0
2017-06-07 07:37:00	SPY	ETF	243.47	243.47	243.46	243.46	1500.0
2017-06-07 07:40:00	SPY	ETF	243.47	243.47	243.47	243.47	1094.0
2017-06-07 07:41:00	SPY	ETF	243.47	243.47	243.47	243.47	1738.0
2017-06-07 07:43:00	SPY	ETF	243.47	243.47	243.47	243.47	2168.0
2017-06-07 07:45:00	SPY	ETF	243.51	243.56	243.51	243.55	2707.0
2017-06-07 07:46:00	SPY	ETF	243.57	243.57	243.57	243.57	100.0
2017-06-07 07:47:00	SPY	ETF	243.57	243.57	243.57	243.57	700.0
2017-06-07 07:48:00	SPY	ETF	243.57	243.57	243.57	243.57	600.0
2017-06-07 07:50:00	SPY	ETF	243.57	243.58	243.57	243.58	369.0
2017-06-07 07:53:00	SPY	ETF	243.59	243.59	243.59	243.59	120.0

> showing 50 of 136,052 rows — these rows as CSV

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