PREVIEW / stock_5min / 2014-07-28

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-07-28.parquet
  size:    5.3 MB
  rows:    358,493
  symbols: 3,562

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
2014-07-28 04:00:00	AAPL	Stock	24.4	24.4	24.4	24.4	800.0
2014-07-28 05:05:00	AAPL	Stock	24.4525	24.4525	24.4525	24.4525	1760.0
2014-07-28 05:10:00	AAPL	Stock	24.4625	24.4625	24.4625	24.4625	2000.0
2014-07-28 05:35:00	AAPL	Stock	24.4425	24.4425	24.4425	24.4425	420.0
2014-07-28 05:40:00	AAPL	Stock	24.4425	24.4425	24.4425	24.4425	4108.0
2014-07-28 05:45:00	AAPL	Stock	24.4425	24.4425	24.4425	24.4425	4400.0
2014-07-28 05:50:00	AAPL	Stock	24.4425	24.4425	24.4425	24.4425	508.0
2014-07-28 06:00:00	AAPL	Stock	24.4375	24.4375	24.43	24.43	11848.0
2014-07-28 06:05:00	AAPL	Stock	24.43	24.43	24.4275	24.4275	4400.0
2014-07-28 06:10:00	AAPL	Stock	24.43	24.43	24.43	24.43	16000.0
2014-07-28 06:15:00	AAPL	Stock	24.4225	24.4225	24.405	24.405	1704.0
2014-07-28 06:40:00	AAPL	Stock	24.4025	24.4025	24.4025	24.4025	400.0
2014-07-28 07:00:00	AAPL	Stock	24.4375	24.44	24.42	24.44	4248.0
2014-07-28 07:05:00	AAPL	Stock	24.44	24.45	24.44	24.45	4720.0
2014-07-28 07:10:00	AAPL	Stock	24.45	24.45	24.4425	24.45	11496.0
2014-07-28 07:15:00	AAPL	Stock	24.4475	24.45	24.4375	24.4375	43600.0
2014-07-28 07:20:00	AAPL	Stock	24.4475	24.4475	24.4475	24.4475	3600.0
2014-07-28 07:25:00	AAPL	Stock	24.44	24.4425	24.4375	24.4375	6832.0
2014-07-28 07:30:00	AAPL	Stock	24.4425	24.4425	24.435	24.435	1912.0
2014-07-28 07:35:00	AAPL	Stock	24.4425	24.45	24.435	24.45	8148.0
2014-07-28 07:40:00	AAPL	Stock	24.45	24.45	24.4425	24.4425	5600.0
2014-07-28 07:45:00	AAPL	Stock	24.4375	24.4375	24.425	24.425	8800.0
2014-07-28 07:50:00	AAPL	Stock	24.425	24.425	24.42	24.425	8068.0
2014-07-28 07:55:00	AAPL	Stock	24.425	24.425	24.425	24.425	4100.0
2014-07-28 08:00:00	AAPL	Stock	24.425	24.45	24.35	24.4175	134252.0
2014-07-28 08:05:00	AAPL	Stock	24.4175	24.43	24.4125	24.43	42924.0
2014-07-28 08:10:00	AAPL	Stock	24.435	24.45	24.4325	24.44	31116.0
2014-07-28 08:15:00	AAPL	Stock	24.44	24.44	24.4325	24.4375	25168.0
2014-07-28 08:20:00	AAPL	Stock	24.435	24.4375	24.435	24.4375	8800.0
2014-07-28 08:25:00	AAPL	Stock	24.4375	24.4475	24.4375	24.4475	13716.0
2014-07-28 08:30:00	AAPL	Stock	24.4425	24.445	24.4375	24.4375	16972.0
2014-07-28 08:35:00	AAPL	Stock	24.4425	24.4575	24.4375	24.455	103880.0
2014-07-28 08:40:00	AAPL	Stock	24.46	24.46	24.4475	24.4575	41124.0
2014-07-28 08:45:00	AAPL	Stock	24.4575	24.4675	24.45	24.4675	61180.0
2014-07-28 08:50:00	AAPL	Stock	24.47	24.475	24.46	24.4725	94232.0
2014-07-28 08:55:00	AAPL	Stock	24.4725	24.4775	24.4675	24.47	51880.0
2014-07-28 09:00:00	AAPL	Stock	24.4675	24.4725	24.46	24.4625	31744.0
2014-07-28 09:05:00	AAPL	Stock	24.4625	24.4725	24.455	24.47	69428.0
2014-07-28 09:10:00	AAPL	Stock	24.4675	24.4675	24.455	24.4625	14188.0
2014-07-28 09:15:00	AAPL	Stock	24.4625	24.465	24.45	24.45	117180.0
2014-07-28 09:20:00	AAPL	Stock	24.4525	24.4625	24.45	24.4525	21864.0
2014-07-28 09:25:00	AAPL	Stock	24.4525	24.495	24.45	24.455	183324.0
2014-07-28 09:30:00	AAPL	Stock	24.455	24.535	24.45	24.53	10024276.0
2014-07-28 09:35:00	AAPL	Stock	24.53	24.6	24.53	24.5568	7191192.0
2014-07-28 09:40:00	AAPL	Stock	24.5575	24.5775	24.42	24.42	6820948.0
2014-07-28 09:45:00	AAPL	Stock	24.42	24.4875	24.3875	24.39	4483320.0
2014-07-28 09:50:00	AAPL	Stock	24.39	24.495	24.39	24.4775	3908180.0
2014-07-28 09:55:00	AAPL	Stock	24.481	24.53	24.465	24.53	3570412.0
2014-07-28 10:00:00	AAPL	Stock	24.5275	24.5425	24.465	24.48	3521596.0
2014-07-28 10:05:00	AAPL	Stock	24.4825	24.52	24.455	24.46	3081296.0

> showing 50 of 358,493 rows — these rows as CSV

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