PREVIEW / stock_5min / 2014-07-14

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-07-14.parquet
  size:    5.3 MB
  rows:    356,950
  symbols: 3,583

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-14 04:00:00	AAPL	Stock	23.805	24.0675	23.805	24.05	18224.0
2014-07-14 04:05:00	AAPL	Stock	24.0875	24.1	24.0775	24.1	11100.0
2014-07-14 04:10:00	AAPL	Stock	24.105	24.125	24.105	24.1125	15588.0
2014-07-14 04:15:00	AAPL	Stock	24.115	24.125	24.115	24.125	2400.0
2014-07-14 04:20:00	AAPL	Stock	24.1025	24.1025	24.1025	24.1025	400.0
2014-07-14 04:25:00	AAPL	Stock	24.1025	24.1025	24.1025	24.1025	400.0
2014-07-14 04:35:00	AAPL	Stock	24.1025	24.1125	24.1025	24.1025	13488.0
2014-07-14 05:00:00	AAPL	Stock	24.105	24.105	24.1025	24.1025	4380.0
2014-07-14 05:05:00	AAPL	Stock	24.0825	24.0825	24.0825	24.0825	31800.0
2014-07-14 05:15:00	AAPL	Stock	24.085	24.1225	24.085	24.1225	31400.0
2014-07-14 05:20:00	AAPL	Stock	24.1225	24.1225	24.12	24.12	6360.0
2014-07-14 05:25:00	AAPL	Stock	24.105	24.105	24.105	24.105	800.0
2014-07-14 05:30:00	AAPL	Stock	24.1	24.1	24.1	24.1	8000.0
2014-07-14 05:40:00	AAPL	Stock	24.085	24.085	24.085	24.085	400.0
2014-07-14 05:45:00	AAPL	Stock	24.0775	24.08	24.0725	24.0725	1200.0
2014-07-14 05:50:00	AAPL	Stock	24.08	24.08	24.08	24.08	400.0
2014-07-14 05:55:00	AAPL	Stock	24.065	24.065	24.065	24.065	4200.0
2014-07-14 06:00:00	AAPL	Stock	24.0625	24.065	24.0625	24.065	3800.0
2014-07-14 06:05:00	AAPL	Stock	24.065	24.0725	24.065	24.0725	2400.0
2014-07-14 06:10:00	AAPL	Stock	24.06	24.075	24.0275	24.075	23640.0
2014-07-14 06:15:00	AAPL	Stock	24.0725	24.0725	24.0725	24.0725	1200.0
2014-07-14 06:30:00	AAPL	Stock	24.0625	24.0625	24.045	24.045	2400.0
2014-07-14 06:35:00	AAPL	Stock	24.0375	24.0375	24.0375	24.0375	1600.0
2014-07-14 06:40:00	AAPL	Stock	24.035	24.06	24.035	24.06	3740.0
2014-07-14 06:50:00	AAPL	Stock	24.06	24.06	24.045	24.05	3008.0
2014-07-14 06:55:00	AAPL	Stock	24.05	24.05	24.0425	24.0425	1200.0
2014-07-14 07:00:00	AAPL	Stock	24.04	24.04	24.0125	24.03	37340.0
2014-07-14 07:05:00	AAPL	Stock	24.0325	24.0625	24.0325	24.05	72604.0
2014-07-14 07:10:00	AAPL	Stock	24.05	24.05	24.0325	24.05	23680.0
2014-07-14 07:15:00	AAPL	Stock	24.0625	24.065	24.0375	24.0625	9772.0
2014-07-14 07:20:00	AAPL	Stock	24.0625	24.075	24.06	24.06	42088.0
2014-07-14 07:25:00	AAPL	Stock	24.06	24.06	24.06	24.06	800.0
2014-07-14 07:30:00	AAPL	Stock	24.0625	24.0675	24.0625	24.0625	17932.0
2014-07-14 07:35:00	AAPL	Stock	24.065	24.065	24.0125	24.025	92976.0
2014-07-14 07:40:00	AAPL	Stock	24.0175	24.025	23.9925	24.0	114768.0
2014-07-14 07:45:00	AAPL	Stock	23.9925	24.0125	23.9925	24.005	1600.0
2014-07-14 07:50:00	AAPL	Stock	24.0125	24.0375	24.01	24.035	4400.0
2014-07-14 07:55:00	AAPL	Stock	24.025	24.05	24.025	24.04	81360.0
2014-07-14 08:00:00	AAPL	Stock	24.03	24.0725	23.97	24.01	435352.0
2014-07-14 08:05:00	AAPL	Stock	24.0	24.0425	24.0	24.0	291060.0
2014-07-14 08:10:00	AAPL	Stock	24.0	24.0025	23.9775	23.9875	115172.0
2014-07-14 08:15:00	AAPL	Stock	23.985	23.985	23.9575	23.9775	105584.0
2014-07-14 08:20:00	AAPL	Stock	23.9775	23.9975	23.975	23.9875	77428.0
2014-07-14 08:25:00	AAPL	Stock	23.9875	23.995	23.97	23.995	34176.0
2014-07-14 08:30:00	AAPL	Stock	23.995	23.995	23.9625	23.97	55472.0
2014-07-14 08:35:00	AAPL	Stock	23.975	24.0275	23.96	23.97	74452.0
2014-07-14 08:40:00	AAPL	Stock	23.97	23.9975	23.9675	23.9925	90100.0
2014-07-14 08:45:00	AAPL	Stock	23.9925	24.0	23.9875	23.9875	117776.0
2014-07-14 08:50:00	AAPL	Stock	23.99	23.9975	23.9775	23.9875	50600.0
2014-07-14 08:55:00	AAPL	Stock	23.805	23.9925	23.805	23.9838	111164.0

> showing 50 of 356,950 rows — these rows as CSV

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