PREVIEW / stock_1min / 2016-09-28

all stock 1-min files

  file:    by_date/stock_1min/2016/2016-09-28.parquet
  size:    14.1 MB
  rows:    1,030,149
  symbols: 2,660

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
2016-09-28 04:00:00	AAPL	Stock	28.275	28.275	28.275	28.275	480.0
2016-09-28 05:31:00	AAPL	Stock	28.3275	28.3275	28.3275	28.3275	400.0
2016-09-28 05:32:00	AAPL	Stock	28.27	28.27	28.27	28.27	800.0
2016-09-28 05:35:00	AAPL	Stock	28.27	28.27	28.27	28.27	800.0
2016-09-28 06:03:00	AAPL	Stock	28.27	28.2725	28.27	28.2725	800.0
2016-09-28 06:04:00	AAPL	Stock	28.2925	28.2925	28.2925	28.2925	4000.0
2016-09-28 06:26:00	AAPL	Stock	28.32	28.325	28.32	28.325	2000.0
2016-09-28 06:28:00	AAPL	Stock	28.3225	28.3425	28.3225	28.3425	12776.0
2016-09-28 06:44:00	AAPL	Stock	28.3375	28.3375	28.3375	28.3375	400.0
2016-09-28 06:47:00	AAPL	Stock	28.3425	28.3425	28.3425	28.3425	1600.0
2016-09-28 06:52:00	AAPL	Stock	28.315	28.315	28.315	28.315	4000.0
2016-09-28 06:57:00	AAPL	Stock	28.3	28.3	28.3	28.3	4000.0
2016-09-28 07:09:00	AAPL	Stock	28.3125	28.3125	28.3125	28.3125	4400.0
2016-09-28 07:10:00	AAPL	Stock	28.3125	28.3125	28.3125	28.3125	400.0
2016-09-28 07:13:00	AAPL	Stock	28.3125	28.3125	28.3125	28.3125	800.0
2016-09-28 07:21:00	AAPL	Stock	28.35	28.35	28.35	28.35	2000.0
2016-09-28 07:29:00	AAPL	Stock	28.355	28.355	28.355	28.355	400.0
2016-09-28 07:35:00	AAPL	Stock	28.3525	28.3525	28.3525	28.3525	400.0
2016-09-28 07:37:00	AAPL	Stock	28.355	28.355	28.355	28.355	400.0
2016-09-28 07:41:00	AAPL	Stock	28.355	28.355	28.355	28.355	400.0
2016-09-28 07:42:00	AAPL	Stock	28.355	28.355	28.355	28.355	1200.0
2016-09-28 07:43:00	AAPL	Stock	28.355	28.355	28.355	28.355	800.0
2016-09-28 07:44:00	AAPL	Stock	28.3575	28.3625	28.3575	28.3625	9600.0
2016-09-28 07:46:00	AAPL	Stock	28.3625	28.3675	28.3625	28.3675	2400.0
2016-09-28 07:47:00	AAPL	Stock	28.3675	28.37	28.3675	28.37	1888.0
2016-09-28 07:48:00	AAPL	Stock	28.37	28.37	28.365	28.365	8668.0
2016-09-28 07:49:00	AAPL	Stock	28.37	28.37	28.3525	28.3675	17000.0
2016-09-28 07:50:00	AAPL	Stock	28.3675	28.38	28.3675	28.38	7600.0
2016-09-28 07:51:00	AAPL	Stock	28.38	28.38	28.38	28.38	800.0
2016-09-28 07:53:00	AAPL	Stock	28.3875	28.4	28.3875	28.3875	10800.0
2016-09-28 07:54:00	AAPL	Stock	28.3975	28.3975	28.3975	28.3975	400.0
2016-09-28 07:55:00	AAPL	Stock	28.4	28.405	28.4	28.4	3600.0
2016-09-28 07:56:00	AAPL	Stock	28.4	28.41	28.4	28.4	8000.0
2016-09-28 07:58:00	AAPL	Stock	28.4	28.415	28.4	28.4	9600.0
2016-09-28 07:59:00	AAPL	Stock	28.4	28.4	28.4	28.4	1600.0
2016-09-28 08:00:00	AAPL	Stock	28.385	28.3875	28.355	28.3825	25216.0
2016-09-28 08:01:00	AAPL	Stock	28.3825	28.3825	28.3825	28.3825	800.0
2016-09-28 08:02:00	AAPL	Stock	28.3875	28.3975	28.3875	28.3975	2800.0
2016-09-28 08:03:00	AAPL	Stock	28.395	28.415	28.395	28.4	15120.0
2016-09-28 08:04:00	AAPL	Stock	28.4125	28.415	28.4125	28.415	6600.0
2016-09-28 08:05:00	AAPL	Stock	28.415	28.425	28.415	28.425	7252.0
2016-09-28 08:06:00	AAPL	Stock	28.425	28.4325	28.425	28.4325	7892.0
2016-09-28 08:07:00	AAPL	Stock	28.4275	28.4275	28.4125	28.4125	20272.0
2016-09-28 08:08:00	AAPL	Stock	28.415	28.415	28.415	28.415	2000.0
2016-09-28 08:09:00	AAPL	Stock	28.4225	28.4225	28.3875	28.4225	21224.0
2016-09-28 08:12:00	AAPL	Stock	28.4025	28.4025	28.4025	28.4025	400.0
2016-09-28 08:13:00	AAPL	Stock	28.4025	28.4025	28.4	28.4	7280.0
2016-09-28 08:14:00	AAPL	Stock	28.4	28.425	28.395	28.425	25240.0
2016-09-28 08:15:00	AAPL	Stock	28.435	28.435	28.435	28.435	400.0
2016-09-28 08:16:00	AAPL	Stock	28.425	28.425	28.425	28.425	1000.0

> showing 50 of 1,030,149 rows — these rows as CSV

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