PREVIEW / stock_5min / 2016-09-28

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-09-28.parquet
  size:    5.3 MB
  rows:    348,922
  symbols: 3,235

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:30:00	AAPL	Stock	28.3275	28.3275	28.27	28.27	1200.0
2016-09-28 05:35:00	AAPL	Stock	28.27	28.27	28.27	28.27	800.0
2016-09-28 06:00:00	AAPL	Stock	28.27	28.2925	28.27	28.2925	4800.0
2016-09-28 06:25:00	AAPL	Stock	28.32	28.3425	28.32	28.3425	14776.0
2016-09-28 06:40:00	AAPL	Stock	28.3375	28.3375	28.3375	28.3375	400.0
2016-09-28 06:45:00	AAPL	Stock	28.3425	28.3425	28.3425	28.3425	1600.0
2016-09-28 06:50:00	AAPL	Stock	28.315	28.315	28.315	28.315	4000.0
2016-09-28 06:55:00	AAPL	Stock	28.3	28.3	28.3	28.3	4000.0
2016-09-28 07:05: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	1200.0
2016-09-28 07:20:00	AAPL	Stock	28.35	28.35	28.35	28.35	2000.0
2016-09-28 07:25:00	AAPL	Stock	28.355	28.355	28.355	28.355	400.0
2016-09-28 07:35:00	AAPL	Stock	28.3525	28.355	28.3525	28.355	800.0
2016-09-28 07:40:00	AAPL	Stock	28.355	28.3625	28.355	28.3625	12000.0
2016-09-28 07:45:00	AAPL	Stock	28.3625	28.37	28.3525	28.3675	29956.0
2016-09-28 07:50:00	AAPL	Stock	28.3675	28.4	28.3675	28.3975	19600.0
2016-09-28 07:55:00	AAPL	Stock	28.4	28.415	28.4	28.4	22800.0
2016-09-28 08:00:00	AAPL	Stock	28.385	28.415	28.355	28.415	50536.0
2016-09-28 08:05:00	AAPL	Stock	28.415	28.4325	28.3875	28.4225	58640.0
2016-09-28 08:10:00	AAPL	Stock	28.4025	28.425	28.395	28.425	32920.0
2016-09-28 08:15:00	AAPL	Stock	28.435	28.435	28.4175	28.425	27800.0
2016-09-28 08:20:00	AAPL	Stock	28.425	28.4275	28.4175	28.425	14076.0
2016-09-28 08:25:00	AAPL	Stock	28.425	28.4375	28.4125	28.425	52380.0
2016-09-28 08:30:00	AAPL	Stock	28.4375	28.4375	28.4175	28.4175	30220.0
2016-09-28 08:35:00	AAPL	Stock	28.4175	28.435	28.4025	28.4125	24000.0
2016-09-28 08:40:00	AAPL	Stock	28.415	28.415	28.4125	28.4125	4400.0
2016-09-28 08:45:00	AAPL	Stock	28.41	28.41	28.3925	28.3925	17000.0
2016-09-28 08:50:00	AAPL	Stock	28.395	28.4225	28.3925	28.4	35500.0
2016-09-28 08:55:00	AAPL	Stock	28.4075	28.4125	28.4	28.41	14172.0
2016-09-28 09:00:00	AAPL	Stock	28.41	28.41	28.39	28.4	12340.0
2016-09-28 09:05:00	AAPL	Stock	28.4025	28.425	28.4	28.4225	24204.0
2016-09-28 09:10:00	AAPL	Stock	28.4225	28.45	28.4125	28.4425	96000.0
2016-09-28 09:15:00	AAPL	Stock	28.4425	28.4425	28.425	28.4375	42000.0
2016-09-28 09:20:00	AAPL	Stock	28.4325	28.45	28.4275	28.4325	19684.0
2016-09-28 09:25:00	AAPL	Stock	28.4325	28.46	28.415	28.4325	114320.0
2016-09-28 09:30:00	AAPL	Stock	28.42	28.55	28.4125	28.5475	5798704.0
2016-09-28 09:35:00	AAPL	Stock	28.5475	28.5625	28.4875	28.55	3662856.0
2016-09-28 09:40:00	AAPL	Stock	28.55	28.57	28.5325	28.5625	3456480.0
2016-09-28 09:45:00	AAPL	Stock	28.56	28.5975	28.545	28.5925	3133392.0
2016-09-28 09:50:00	AAPL	Stock	28.595	28.6125	28.57	28.585	2341132.0
2016-09-28 09:55:00	AAPL	Stock	28.5875	28.61	28.575	28.6075	2332672.0
2016-09-28 10:00:00	AAPL	Stock	28.6088	28.66	28.606	28.6455	3877212.0
2016-09-28 10:05:00	AAPL	Stock	28.645	28.6468	28.5725	28.58	2112112.0
2016-09-28 10:10:00	AAPL	Stock	28.58	28.5875	28.5375	28.5488	2847148.0
2016-09-28 10:15:00	AAPL	Stock	28.5512	28.59	28.525	28.5798	2645240.0
2016-09-28 10:20:00	AAPL	Stock	28.5775	28.585	28.5125	28.55	1885104.0
2016-09-28 10:25:00	AAPL	Stock	28.55	28.595	28.535	28.5875	1451828.0
2016-09-28 10:30:00	AAPL	Stock	28.5875	28.6088	28.545	28.55	1771084.0
2016-09-28 10:35:00	AAPL	Stock	28.55	28.565	28.5175	28.53	1795556.0

> showing 50 of 348,922 rows — these rows as CSV

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