PREVIEW / stock_5min / 2014-04-07

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-04-07.parquet
  size:    5.6 MB
  rows:    371,573
  symbols: 3,551

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-04-07 04:00:00	AAPL	Stock	18.8532	18.8532	18.8532	18.8532	2800.0
2014-04-07 04:15:00	AAPL	Stock	18.8793	18.8793	18.8793	18.8793	3080.0
2014-04-07 04:20:00	AAPL	Stock	18.8686	18.8686	18.8668	18.8686	30800.0
2014-04-07 04:25:00	AAPL	Stock	18.8886	18.8886	18.8886	18.8886	2800.0
2014-04-07 04:45:00	AAPL	Stock	18.9054	18.9054	18.9054	18.9054	5600.0
2014-04-07 06:20:00	AAPL	Stock	18.9004	18.9004	18.8571	18.8571	9128.0
2014-04-07 07:00:00	AAPL	Stock	18.8671	18.8671	18.8671	18.8671	4200.0
2014-04-07 07:10:00	AAPL	Stock	18.8714	18.8714	18.8571	18.8571	53200.0
2014-04-07 07:15:00	AAPL	Stock	18.8621	18.8629	18.8571	18.8571	11200.0
2014-04-07 07:25:00	AAPL	Stock	18.8571	18.8571	18.8571	18.8571	17360.0
2014-04-07 07:30:00	AAPL	Stock	18.8571	18.8571	18.8571	18.8571	25200.0
2014-04-07 07:35:00	AAPL	Stock	18.8693	18.8714	18.8661	18.8661	14000.0
2014-04-07 07:45:00	AAPL	Stock	18.875	18.8829	18.8661	18.8664	28700.0
2014-04-07 07:50:00	AAPL	Stock	18.8611	18.8618	18.8568	18.8571	36540.0
2014-04-07 07:55:00	AAPL	Stock	18.8679	18.8679	18.8679	18.8679	2800.0
2014-04-07 08:00:00	AAPL	Stock	18.8607	18.8914	18.8461	18.8839	109228.0
2014-04-07 08:05:00	AAPL	Stock	18.8814	18.8929	18.8768	18.8839	25396.0
2014-04-07 08:10:00	AAPL	Stock	18.8786	18.8786	18.8679	18.8679	15120.0
2014-04-07 08:15:00	AAPL	Stock	18.875	18.875	18.8714	18.875	33600.0
2014-04-07 08:20:00	AAPL	Stock	18.8732	18.8893	18.8732	18.8893	55776.0
2014-04-07 08:25:00	AAPL	Stock	18.8764	18.8929	18.8764	18.8854	26180.0
2014-04-07 08:30:00	AAPL	Stock	18.8925	18.8929	18.8886	18.8925	61180.0
2014-04-07 08:35:00	AAPL	Stock	18.8925	18.9029	18.8854	18.9029	36400.0
2014-04-07 08:40:00	AAPL	Stock	18.915	18.9282	18.915	18.9232	97440.0
2014-04-07 08:45:00	AAPL	Stock	18.9125	18.9125	18.9	18.9018	24920.0
2014-04-07 08:50:00	AAPL	Stock	18.9107	18.9182	18.9011	18.9182	58072.0
2014-04-07 08:55:00	AAPL	Stock	18.9107	18.9189	18.9089	18.9179	97860.0
2014-04-07 09:00:00	AAPL	Stock	18.9121	18.9121	18.9114	18.9114	14000.0
2014-04-07 09:05:00	AAPL	Stock	18.9107	18.9121	18.9089	18.9089	103124.0
2014-04-07 09:10:00	AAPL	Stock	18.9036	18.9036	18.8929	18.8929	62440.0
2014-04-07 09:15:00	AAPL	Stock	18.8871	18.8871	18.875	18.8825	37940.0
2014-04-07 09:20:00	AAPL	Stock	18.875	18.89	18.8675	18.8675	151032.0
2014-04-07 09:25:00	AAPL	Stock	18.8675	18.8707	18.8507	18.8575	407988.0
2014-04-07 09:30:00	AAPL	Stock	18.8618	18.9461	18.8293	18.9429	9832956.0
2014-04-07 09:35:00	AAPL	Stock	18.9425	18.9607	18.8771	18.8932	4139660.0
2014-04-07 09:40:00	AAPL	Stock	18.9021	18.9139	18.8418	18.8507	4130840.0
2014-04-07 09:45:00	AAPL	Stock	18.845	18.8679	18.8082	18.8421	5044564.0
2014-04-07 09:50:00	AAPL	Stock	18.8386	18.8714	18.8293	18.8554	4365340.0
2014-04-07 09:55:00	AAPL	Stock	18.8579	18.9068	18.8518	18.9029	4128628.0
2014-04-07 10:00:00	AAPL	Stock	18.9014	18.9114	18.8825	18.8825	3517752.0
2014-04-07 10:05:00	AAPL	Stock	18.8879	18.9043	18.8582	18.8822	2732716.0
2014-04-07 10:10:00	AAPL	Stock	18.8836	18.8839	18.8257	18.8664	4157944.0
2014-04-07 10:15:00	AAPL	Stock	18.8664	18.8904	18.8393	18.8452	3235120.0
2014-04-07 10:20:00	AAPL	Stock	18.8452	18.8593	18.8357	18.8446	2468536.0
2014-04-07 10:25:00	AAPL	Stock	18.8446	18.8664	18.8193	18.8218	3935344.0
2014-04-07 10:30:00	AAPL	Stock	18.8193	18.8286	18.7921	18.8172	4467792.0
2014-04-07 10:35:00	AAPL	Stock	18.8125	18.83	18.7864	18.8014	2885708.0
2014-04-07 10:40:00	AAPL	Stock	18.8006	18.8107	18.7861	18.8064	2648716.0
2014-04-07 10:45:00	AAPL	Stock	18.8014	18.8036	18.7679	18.7771	4177460.0
2014-04-07 10:50:00	AAPL	Stock	18.7755	18.7825	18.7614	18.7744	2490544.0

> showing 50 of 371,573 rows — these rows as CSV

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