PREVIEW / stock_5min / 2014-05-20

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-05-20.parquet
  size:    5.4 MB
  rows:    363,103
  symbols: 3,541

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-05-20 04:05:00	AAPL	Stock	21.6071	21.6071	21.6071	21.6071	2800.0
2014-05-20 05:05:00	AAPL	Stock	21.5996	21.5996	21.5996	21.5996	2800.0
2014-05-20 05:25:00	AAPL	Stock	21.6007	21.6007	21.6007	21.6007	2800.0
2014-05-20 05:50:00	AAPL	Stock	21.6271	21.6296	21.6271	21.6296	11200.0
2014-05-20 06:05:00	AAPL	Stock	21.6507	21.6604	21.6507	21.6604	78400.0
2014-05-20 06:20:00	AAPL	Stock	21.6554	21.6554	21.6554	21.6554	2800.0
2014-05-20 06:40:00	AAPL	Stock	21.6311	21.6311	21.6311	21.6311	2800.0
2014-05-20 06:45:00	AAPL	Stock	21.6182	21.6182	21.6161	21.6161	11200.0
2014-05-20 06:50:00	AAPL	Stock	21.65	21.6561	21.65	21.6561	14000.0
2014-05-20 07:00:00	AAPL	Stock	21.6482	21.6625	21.6218	21.65	110320.0
2014-05-20 07:05:00	AAPL	Stock	21.6429	21.6482	21.6429	21.6482	5600.0
2014-05-20 07:10:00	AAPL	Stock	21.6518	21.6536	21.6429	21.6429	19600.0
2014-05-20 07:15:00	AAPL	Stock	21.6429	21.6429	21.6339	21.6418	28000.0
2014-05-20 07:20:00	AAPL	Stock	21.6429	21.6429	21.6279	21.6279	16800.0
2014-05-20 07:25:00	AAPL	Stock	21.6336	21.6336	21.6336	21.6336	2800.0
2014-05-20 07:30:00	AAPL	Stock	21.6286	21.6286	21.6093	21.6093	64176.0
2014-05-20 07:40:00	AAPL	Stock	21.6154	21.6196	21.6121	21.6189	28700.0
2014-05-20 07:45:00	AAPL	Stock	21.6111	21.6125	21.6079	21.6079	33600.0
2014-05-20 07:55:00	AAPL	Stock	21.6061	21.6061	21.6061	21.6061	2800.0
2014-05-20 08:00:00	AAPL	Stock	21.6036	21.6554	21.5943	21.5943	110964.0
2014-05-20 08:05:00	AAPL	Stock	21.5893	21.5893	21.5821	21.5857	35840.0
2014-05-20 08:10:00	AAPL	Stock	21.575	21.5857	21.5718	21.5836	16800.0
2014-05-20 08:15:00	AAPL	Stock	21.5857	21.5893	21.5857	21.5893	37800.0
2014-05-20 08:20:00	AAPL	Stock	21.5971	21.5971	21.5911	21.5911	16856.0
2014-05-20 08:25:00	AAPL	Stock	21.5964	21.5964	21.5857	21.5882	22708.0
2014-05-20 08:30:00	AAPL	Stock	21.5804	21.5804	21.56	21.5804	128548.0
2014-05-20 08:35:00	AAPL	Stock	21.5736	21.5761	21.5721	21.5761	28000.0
2014-05-20 08:40:00	AAPL	Stock	21.5961	21.5982	21.5929	21.5964	36260.0
2014-05-20 08:45:00	AAPL	Stock	21.5929	21.5986	21.5914	21.5982	39508.0
2014-05-20 08:55:00	AAPL	Stock	21.5986	21.5986	21.5904	21.5982	24696.0
2014-05-20 09:00:00	AAPL	Stock	21.5989	21.6018	21.5989	21.6	50400.0
2014-05-20 09:05:00	AAPL	Stock	21.5918	21.5929	21.5904	21.5904	8400.0
2014-05-20 09:10:00	AAPL	Stock	21.5971	21.5971	21.5893	21.5893	47320.0
2014-05-20 09:15:00	AAPL	Stock	21.595	21.5964	21.595	21.5964	84000.0
2014-05-20 09:20:00	AAPL	Stock	21.5893	21.5893	21.5807	21.5807	37828.0
2014-05-20 09:25:00	AAPL	Stock	21.5886	21.5904	21.5754	21.5893	46900.0
2014-05-20 09:30:00	AAPL	Stock	21.5896	21.635	21.5614	21.5807	10717056.0
2014-05-20 09:35:00	AAPL	Stock	21.5825	21.6339	21.5529	21.6143	6153140.0
2014-05-20 09:40:00	AAPL	Stock	21.6104	21.6121	21.5361	21.5525	3900848.0
2014-05-20 09:45:00	AAPL	Stock	21.5571	21.5882	21.5386	21.5679	4095784.0
2014-05-20 09:50:00	AAPL	Stock	21.5714	21.6393	21.545	21.6107	5847828.0
2014-05-20 09:55:00	AAPL	Stock	21.6054	21.6104	21.5557	21.5821	3081064.0
2014-05-20 10:00:00	AAPL	Stock	21.5843	21.65	21.5722	21.625	7970284.0
2014-05-20 10:05:00	AAPL	Stock	21.6218	21.6246	21.5736	21.5889	6902168.0
2014-05-20 10:10:00	AAPL	Stock	21.5889	21.6246	21.5811	21.6014	2789864.0
2014-05-20 10:15:00	AAPL	Stock	21.5989	21.6071	21.5611	21.5679	4587884.0
2014-05-20 10:20:00	AAPL	Stock	21.5764	21.6032	21.5693	21.5843	1677648.0
2014-05-20 10:25:00	AAPL	Stock	21.5857	21.6068	21.5746	21.5864	3668084.0
2014-05-20 10:30:00	AAPL	Stock	21.5886	21.6279	21.5843	21.6186	2771972.0
2014-05-20 10:35:00	AAPL	Stock	21.6193	21.6429	21.6121	21.6157	4289572.0

> showing 50 of 363,103 rows — these rows as CSV

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