PREVIEW / stock_5min / 2012-06-22

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-06-22.parquet
  size:    5.3 MB
  rows:    355,231
  symbols: 3,530

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
2012-06-22 05:30:00	AAPL	Stock	20.7	20.7	20.7	20.7	12600.0
2012-06-22 05:55:00	AAPL	Stock	20.6964	20.6964	20.6964	20.6964	2800.0
2012-06-22 06:15:00	AAPL	Stock	20.6961	20.6961	20.6961	20.6961	2800.0
2012-06-22 06:25:00	AAPL	Stock	20.6982	20.7	20.6982	20.7	33600.0
2012-06-22 07:00:00	AAPL	Stock	20.7036	20.7043	20.6964	20.6964	25480.0
2012-06-22 07:05:00	AAPL	Stock	20.6961	20.6961	20.6961	20.6961	2800.0
2012-06-22 07:20:00	AAPL	Stock	20.6786	20.6786	20.6786	20.6786	8400.0
2012-06-22 07:25:00	AAPL	Stock	20.6789	20.6789	20.6607	20.6607	49000.0
2012-06-22 07:30:00	AAPL	Stock	20.6614	20.6614	20.6518	20.6518	33600.0
2012-06-22 07:35:00	AAPL	Stock	20.6696	20.6786	20.6696	20.6786	12404.0
2012-06-22 07:40:00	AAPL	Stock	20.6932	20.6932	20.6814	20.6814	12460.0
2012-06-22 07:45:00	AAPL	Stock	20.6875	20.6875	20.6814	20.6814	8400.0
2012-06-22 07:50:00	AAPL	Stock	20.6943	20.6982	20.6943	20.6982	64344.0
2012-06-22 07:55:00	AAPL	Stock	20.6929	20.695	20.6929	20.695	25200.0
2012-06-22 08:00:00	AAPL	Stock	20.6893	20.6975	20.6821	20.6936	132720.0
2012-06-22 08:05:00	AAPL	Stock	20.6832	20.695	20.6718	20.695	67480.0
2012-06-22 08:10:00	AAPL	Stock	20.6857	20.6857	20.6696	20.6696	34244.0
2012-06-22 08:15:00	AAPL	Stock	20.6786	20.6786	20.6643	20.6643	18088.0
2012-06-22 08:20:00	AAPL	Stock	20.6661	20.6786	20.6661	20.6786	31948.0
2012-06-22 08:25:00	AAPL	Stock	20.6861	20.6864	20.6861	20.6864	8400.0
2012-06-22 08:30:00	AAPL	Stock	20.6829	20.7	20.6821	20.6986	78680.0
2012-06-22 08:35:00	AAPL	Stock	20.6971	20.6971	20.6843	20.6893	118188.0
2012-06-22 08:40:00	AAPL	Stock	20.6904	20.6904	20.6904	20.6904	14000.0
2012-06-22 08:45:00	AAPL	Stock	20.6864	20.6875	20.675	20.6775	117600.0
2012-06-22 08:50:00	AAPL	Stock	20.6775	20.6854	20.63	20.63	18620.0
2012-06-22 08:55:00	AAPL	Stock	20.6786	20.6832	20.6786	20.6832	39200.0
2012-06-22 09:00:00	AAPL	Stock	20.6789	20.705	20.6789	20.7018	184408.0
2012-06-22 09:05:00	AAPL	Stock	20.7018	20.7107	20.6964	20.6968	142548.0
2012-06-22 09:10:00	AAPL	Stock	20.6968	20.7075	20.6964	20.7071	98980.0
2012-06-22 09:15:00	AAPL	Stock	20.7093	20.7093	20.7036	20.7061	42784.0
2012-06-22 09:20:00	AAPL	Stock	20.7068	20.7211	20.7061	20.7089	258132.0
2012-06-22 09:25:00	AAPL	Stock	20.71	20.71	20.665	20.6768	476168.0
2012-06-22 09:30:00	AAPL	Stock	20.6757	20.7054	20.6071	20.6689	13601532.0
2012-06-22 09:35:00	AAPL	Stock	20.6689	20.7232	20.6543	20.6732	7287476.0
2012-06-22 09:40:00	AAPL	Stock	20.6725	20.6846	20.6475	20.6668	4639544.0
2012-06-22 09:45:00	AAPL	Stock	20.6646	20.6689	20.6286	20.6461	6560932.0
2012-06-22 09:50:00	AAPL	Stock	20.6454	20.6536	20.6089	20.6482	7471548.0
2012-06-22 09:55:00	AAPL	Stock	20.6429	20.6693	20.6336	20.6489	4331236.0
2012-06-22 10:00:00	AAPL	Stock	20.6436	20.7139	20.6429	20.6857	7778484.0
2012-06-22 10:05:00	AAPL	Stock	20.6857	20.6993	20.6625	20.6714	3751636.0
2012-06-22 10:10:00	AAPL	Stock	20.6714	20.6921	20.6564	20.6786	3752336.0
2012-06-22 10:15:00	AAPL	Stock	20.6786	20.6786	20.655	20.6579	2265060.0
2012-06-22 10:20:00	AAPL	Stock	20.6589	20.6871	20.6557	20.6761	2815036.0
2012-06-22 10:25:00	AAPL	Stock	20.6786	20.6829	20.6364	20.6384	3365796.0
2012-06-22 10:30:00	AAPL	Stock	20.6371	20.6479	20.6257	20.6315	3709384.0
2012-06-22 10:35:00	AAPL	Stock	20.6346	20.6411	20.5832	20.5946	6576808.0
2012-06-22 10:40:00	AAPL	Stock	20.595	20.6111	20.5554	20.5554	5157460.0
2012-06-22 10:45:00	AAPL	Stock	20.5575	20.5789	20.5507	20.5659	5011328.0
2012-06-22 10:50:00	AAPL	Stock	20.5689	20.5986	20.5632	20.5961	4184656.0
2012-06-22 10:55:00	AAPL	Stock	20.5904	20.6104	20.5704	20.5735	3359328.0

> showing 50 of 355,231 rows — these rows as CSV

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