PREVIEW / etf_1min / 2017-11-28

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-11-28.parquet
  size:    2.8 MB
  rows:    144,997

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-11-28 04:00:00	SPY	ETF	260.35	260.45	260.35	260.45	1299.0
2017-11-28 04:11:00	SPY	ETF	260.49	260.49	260.49	260.49	200.0
2017-11-28 04:14:00	SPY	ETF	260.5	260.5	260.5	260.5	100.0
2017-11-28 04:17:00	SPY	ETF	260.53	260.53	260.53	260.53	200.0
2017-11-28 04:27:00	SPY	ETF	260.5	260.5	260.5	260.5	130.0
2017-11-28 04:31:00	SPY	ETF	260.49	260.49	260.49	260.49	2500.0
2017-11-28 04:32:00	SPY	ETF	260.5	260.5	260.5	260.5	300.0
2017-11-28 04:38:00	SPY	ETF	260.53	260.53	260.53	260.53	500.0
2017-11-28 04:39:00	SPY	ETF	260.53	260.53	260.53	260.53	300.0
2017-11-28 04:40:00	SPY	ETF	260.52	260.52	260.52	260.52	300.0
2017-11-28 04:47:00	SPY	ETF	260.53	260.53	260.53	260.53	200.0
2017-11-28 04:48:00	SPY	ETF	260.5	260.52	260.5	260.52	700.0
2017-11-28 04:52:00	SPY	ETF	260.52	260.52	260.5	260.5	400.0
2017-11-28 04:58:00	SPY	ETF	260.53	260.53	260.53	260.53	500.0
2017-11-28 05:00:00	SPY	ETF	260.53	260.53	260.53	260.53	1000.0
2017-11-28 05:03:00	SPY	ETF	260.6	260.6	260.6	260.6	500.0
2017-11-28 05:07:00	SPY	ETF	260.63	260.63	260.63	260.63	300.0
2017-11-28 05:14:00	SPY	ETF	260.57	260.57	260.57	260.57	300.0
2017-11-28 05:17:00	SPY	ETF	260.56	260.56	260.56	260.56	100.0
2017-11-28 05:21:00	SPY	ETF	260.51	260.51	260.51	260.51	300.0
2017-11-28 05:55:00	SPY	ETF	260.61	260.61	260.61	260.61	2000.0
2017-11-28 06:00:00	SPY	ETF	260.62	260.62	260.62	260.62	201.0
2017-11-28 06:06:00	SPY	ETF	260.6	260.6	260.6	260.6	1051.0
2017-11-28 06:07:00	SPY	ETF	260.62	260.62	260.56	260.56	200.0
2017-11-28 06:12:00	SPY	ETF	260.59	260.59	260.59	260.59	500.0
2017-11-28 06:14:00	SPY	ETF	260.6	260.6	260.6	260.6	100.0
2017-11-28 06:16:00	SPY	ETF	260.56	260.56	260.56	260.56	200.0
2017-11-28 06:25:00	SPY	ETF	260.62	260.62	260.62	260.62	1000.0
2017-11-28 06:26:00	SPY	ETF	260.6	260.61	260.6	260.61	900.0
2017-11-28 06:28:00	SPY	ETF	260.61	260.61	260.61	260.61	300.0
2017-11-28 06:31:00	SPY	ETF	260.65	260.67	260.65	260.67	1001.0
2017-11-28 06:32:00	SPY	ETF	260.67	260.67	260.67	260.67	1000.0
2017-11-28 06:33:00	SPY	ETF	260.68	260.68	260.68	260.68	500.0
2017-11-28 06:36:00	SPY	ETF	260.68	260.68	260.68	260.68	500.0
2017-11-28 06:37:00	SPY	ETF	260.67	260.67	260.67	260.67	2000.0
2017-11-28 06:39:00	SPY	ETF	260.65	260.65	260.65	260.65	250.0
2017-11-28 06:41:00	SPY	ETF	260.67	260.7	260.67	260.7	4030.0
2017-11-28 06:44:00	SPY	ETF	260.65	260.65	260.65	260.65	100.0
2017-11-28 06:45:00	SPY	ETF	260.66	260.66	260.66	260.66	100.0
2017-11-28 06:46:00	SPY	ETF	260.65	260.65	260.65	260.65	500.0
2017-11-28 06:56:00	SPY	ETF	260.66	260.7	260.66	260.7	600.0
2017-11-28 07:00:00	SPY	ETF	260.65	260.65	260.64	260.65	12000.0
2017-11-28 07:01:00	SPY	ETF	260.65	260.67	260.65	260.67	8250.0
2017-11-28 07:02:00	SPY	ETF	260.67	260.67	260.67	260.67	800.0
2017-11-28 07:03:00	SPY	ETF	260.69	260.69	260.69	260.69	500.0
2017-11-28 07:04:00	SPY	ETF	260.69	260.69	260.68	260.69	4800.0
2017-11-28 07:05:00	SPY	ETF	260.68	260.69	260.68	260.69	3300.0
2017-11-28 07:06:00	SPY	ETF	260.69	260.69	260.69	260.69	800.0
2017-11-28 07:09:00	SPY	ETF	260.69	260.69	260.67	260.69	45000.0
2017-11-28 07:10:00	SPY	ETF	260.69	260.69	260.68	260.68	1338.0

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

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