PREVIEW / stock_5min / 2014-07-02

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-07-02.parquet
  size:    5.4 MB
  rows:    364,503
  symbols: 3,570

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-02 05:00:00	AAPL	Stock	23.465	23.465	23.465	23.465	800.0
2014-07-02 05:05:00	AAPL	Stock	23.465	23.465	23.465	23.465	400.0
2014-07-02 05:15:00	AAPL	Stock	23.45	23.45	23.4425	23.4425	3016.0
2014-07-02 05:20:00	AAPL	Stock	23.425	23.425	23.425	23.425	2800.0
2014-07-02 05:45:00	AAPL	Stock	23.4325	23.4325	23.4325	23.4325	400.0
2014-07-02 05:55:00	AAPL	Stock	23.4275	23.4275	23.4275	23.4275	1976.0
2014-07-02 06:00:00	AAPL	Stock	23.42	23.42	23.42	23.42	1800.0
2014-07-02 06:10:00	AAPL	Stock	23.42	23.4325	23.42	23.4325	2548.0
2014-07-02 06:15:00	AAPL	Stock	23.41	23.41	23.41	23.41	800.0
2014-07-02 06:20:00	AAPL	Stock	23.43	23.43	23.43	23.43	9120.0
2014-07-02 06:25:00	AAPL	Stock	23.4425	23.4725	23.4425	23.4725	1384.0
2014-07-02 06:30:00	AAPL	Stock	23.46	23.46	23.46	23.46	9200.0
2014-07-02 06:40:00	AAPL	Stock	23.43	23.43	23.43	23.43	4000.0
2014-07-02 06:50:00	AAPL	Stock	23.4375	23.4375	23.4375	23.4375	400.0
2014-07-02 07:00:00	AAPL	Stock	23.4675	23.48	23.4675	23.48	19600.0
2014-07-02 07:05:00	AAPL	Stock	23.4575	23.4575	23.4575	23.4575	2800.0
2014-07-02 07:10:00	AAPL	Stock	23.4725	23.4725	23.4725	23.4725	1920.0
2014-07-02 07:15:00	AAPL	Stock	23.4725	23.4725	23.4725	23.4725	400.0
2014-07-02 07:20:00	AAPL	Stock	23.475	23.475	23.475	23.475	2000.0
2014-07-02 07:25:00	AAPL	Stock	23.4825	23.485	23.475	23.475	6400.0
2014-07-02 07:30:00	AAPL	Stock	23.4675	23.4675	23.4675	23.4675	3088.0
2014-07-02 07:35:00	AAPL	Stock	23.47	23.47	23.4675	23.4675	4912.0
2014-07-02 07:40:00	AAPL	Stock	23.465	23.475	23.465	23.475	13800.0
2014-07-02 07:45:00	AAPL	Stock	23.475	23.475	23.4625	23.4625	11932.0
2014-07-02 07:50:00	AAPL	Stock	23.4675	23.475	23.45	23.45	21400.0
2014-07-02 07:55:00	AAPL	Stock	23.4625	23.4625	23.45	23.45	3200.0
2014-07-02 08:00:00	AAPL	Stock	23.45	23.485	23.445	23.4525	130952.0
2014-07-02 08:05:00	AAPL	Stock	23.4525	23.4525	23.445	23.445	14092.0
2014-07-02 08:10:00	AAPL	Stock	23.46	23.4675	23.45	23.45	20060.0
2014-07-02 08:15:00	AAPL	Stock	23.4625	23.4625	23.4575	23.4625	48748.0
2014-07-02 08:20:00	AAPL	Stock	23.4575	23.525	23.4575	23.475	55496.0
2014-07-02 08:25:00	AAPL	Stock	23.4675	23.5	23.4675	23.485	31696.0
2014-07-02 08:30:00	AAPL	Stock	23.4825	23.4825	23.4725	23.475	34664.0
2014-07-02 08:35:00	AAPL	Stock	23.475	23.48	23.4675	23.48	33600.0
2014-07-02 08:40:00	AAPL	Stock	23.48	23.4875	23.4625	23.4725	46064.0
2014-07-02 08:45:00	AAPL	Stock	23.47	23.4775	23.465	23.4725	35400.0
2014-07-02 08:50:00	AAPL	Stock	23.4725	23.4725	23.455	23.465	52148.0
2014-07-02 08:55:00	AAPL	Stock	23.46	23.46	23.455	23.455	7200.0
2014-07-02 09:00:00	AAPL	Stock	23.455	23.46	23.455	23.455	18000.0
2014-07-02 09:05:00	AAPL	Stock	23.455	23.455	23.445	23.445	72340.0
2014-07-02 09:10:00	AAPL	Stock	23.445	23.445	23.44	23.445	31900.0
2014-07-02 09:15:00	AAPL	Stock	23.445	23.4475	23.44	23.44	47332.0
2014-07-02 09:20:00	AAPL	Stock	23.44	23.44	23.4275	23.4325	116276.0
2014-07-02 09:25:00	AAPL	Stock	23.435	23.465	23.43	23.465	185148.0
2014-07-02 09:30:00	AAPL	Stock	23.4675	23.51	23.46	23.5075	6110552.0
2014-07-02 09:35:00	AAPL	Stock	23.5075	23.515	23.4675	23.4925	3548600.0
2014-07-02 09:40:00	AAPL	Stock	23.495	23.5125	23.4925	23.4955	2275048.0
2014-07-02 09:45:00	AAPL	Stock	23.495	23.4975	23.4775	23.4775	2702580.0
2014-07-02 09:50:00	AAPL	Stock	23.4775	23.4875	23.415	23.4172	2575900.0
2014-07-02 09:55:00	AAPL	Stock	23.415	23.46	23.4125	23.4575	2138520.0

> showing 50 of 364,503 rows — these rows as CSV

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