PREVIEW / stock_5min / 2014-04-14

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-04-14.parquet
  size:    5.4 MB
  rows:    360,774
  symbols: 3,558

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-14 04:00:00	AAPL	Stock	18.5375	18.5375	18.5375	18.5375	2800.0
2014-04-14 04:30:00	AAPL	Stock	18.5382	18.5382	18.5382	18.5382	2800.0
2014-04-14 05:55:00	AAPL	Stock	18.5039	18.5039	18.4989	18.4989	8400.0
2014-04-14 06:00:00	AAPL	Stock	18.4825	18.4825	18.4643	18.4643	5600.0
2014-04-14 06:15:00	AAPL	Stock	18.4707	18.4743	18.4707	18.4743	8400.0
2014-04-14 06:20:00	AAPL	Stock	18.4725	18.4725	18.4725	18.4725	2800.0
2014-04-14 06:30:00	AAPL	Stock	18.4796	18.4804	18.4736	18.4736	25200.0
2014-04-14 06:35:00	AAPL	Stock	18.4786	18.5004	18.4779	18.5004	33320.0
2014-04-14 06:40:00	AAPL	Stock	18.5	18.5	18.5	18.5	8400.0
2014-04-14 07:00:00	AAPL	Stock	18.5357	18.5357	18.5357	18.5357	6160.0
2014-04-14 07:10:00	AAPL	Stock	18.5107	18.5107	18.5107	18.5107	5600.0
2014-04-14 07:25:00	AAPL	Stock	18.5132	18.5132	18.5125	18.5125	5600.0
2014-04-14 07:30:00	AAPL	Stock	18.5336	18.5336	18.5336	18.5336	2800.0
2014-04-14 07:45:00	AAPL	Stock	18.5536	18.5536	18.5536	18.5536	8400.0
2014-04-14 07:50:00	AAPL	Stock	18.5686	18.6036	18.5686	18.5893	15232.0
2014-04-14 07:55:00	AAPL	Stock	18.5757	18.6071	18.5757	18.6071	11200.0
2014-04-14 08:00:00	AAPL	Stock	18.5893	18.6321	18.5232	18.625	26908.0
2014-04-14 08:05:00	AAPL	Stock	18.625	18.6418	18.625	18.6418	11200.0
2014-04-14 08:10:00	AAPL	Stock	18.6418	18.6643	18.6418	18.6429	67480.0
2014-04-14 08:15:00	AAPL	Stock	18.6354	18.6439	18.6354	18.6429	27888.0
2014-04-14 08:20:00	AAPL	Stock	18.6439	18.6439	18.6307	18.6307	36400.0
2014-04-14 08:25:00	AAPL	Stock	18.6264	18.6368	18.6264	18.6368	8400.0
2014-04-14 08:30:00	AAPL	Stock	18.6621	18.6643	18.6521	18.6536	28000.0
2014-04-14 08:35:00	AAPL	Stock	18.6525	18.6596	18.6518	18.6586	55580.0
2014-04-14 08:40:00	AAPL	Stock	18.6586	18.6607	18.6429	18.6429	46900.0
2014-04-14 08:45:00	AAPL	Stock	18.6511	18.6696	18.645	18.6611	43120.0
2014-04-14 08:50:00	AAPL	Stock	18.6664	18.6689	18.6596	18.6689	90356.0
2014-04-14 08:55:00	AAPL	Stock	18.6571	18.6689	18.6571	18.6668	25200.0
2014-04-14 09:00:00	AAPL	Stock	18.6579	18.6636	18.6571	18.6571	77224.0
2014-04-14 09:05:00	AAPL	Stock	18.6607	18.6607	18.6571	18.6575	45584.0
2014-04-14 09:10:00	AAPL	Stock	18.6579	18.6607	18.6571	18.6593	103488.0
2014-04-14 09:15:00	AAPL	Stock	18.6586	18.6607	18.6586	18.6604	22400.0
2014-04-14 09:20:00	AAPL	Stock	18.6607	18.6718	18.6607	18.6718	91560.0
2014-04-14 09:25:00	AAPL	Stock	18.6729	18.6761	18.6261	18.6489	582344.0
2014-04-14 09:30:00	AAPL	Stock	18.6393	18.6429	18.5643	18.5968	9381736.0
2014-04-14 09:35:00	AAPL	Stock	18.5964	18.61	18.5571	18.5714	4741548.0
2014-04-14 09:40:00	AAPL	Stock	18.5682	18.5771	18.544	18.5643	3952480.0
2014-04-14 09:45:00	AAPL	Stock	18.5589	18.5643	18.5227	18.5486	3820068.0
2014-04-14 09:50:00	AAPL	Stock	18.5486	18.5617	18.5296	18.5296	2836344.0
2014-04-14 09:55:00	AAPL	Stock	18.5297	18.5357	18.4821	18.4965	4710888.0
2014-04-14 10:00:00	AAPL	Stock	18.4964	18.5318	18.4875	18.5182	2483180.0
2014-04-14 10:05:00	AAPL	Stock	18.5204	18.5446	18.5121	18.5382	2432808.0
2014-04-14 10:10:00	AAPL	Stock	18.5393	18.545	18.5111	18.5293	1474116.0
2014-04-14 10:15:00	AAPL	Stock	18.5321	18.5421	18.5186	18.5279	1999676.0
2014-04-14 10:20:00	AAPL	Stock	18.5254	18.5279	18.5013	18.5157	1875720.0
2014-04-14 10:25:00	AAPL	Stock	18.515	18.525	18.5046	18.5214	3486308.0
2014-04-14 10:30:00	AAPL	Stock	18.5205	18.53	18.5071	18.5071	2149056.0
2014-04-14 10:35:00	AAPL	Stock	18.5075	18.5214	18.4943	18.5014	2521204.0
2014-04-14 10:40:00	AAPL	Stock	18.5056	18.5325	18.4993	18.5282	2826460.0
2014-04-14 10:45:00	AAPL	Stock	18.5282	18.555	18.5193	18.5229	2774716.0

> showing 50 of 360,774 rows — these rows as CSV

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