PREVIEW / stock_1hour / 2013-11-11

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-11.parquet
  size:    1008 KB
  rows:    46,558
  symbols: 3,523

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
2013-11-11 04:00:00	AAPL	Stock	18.6071	18.6071	18.5714	18.5714	21476.0
2013-11-11 05:00:00	AAPL	Stock	18.5843	18.5843	18.5714	18.5714	47600.0
2013-11-11 06:00:00	AAPL	Stock	18.5714	18.5714	18.5393	18.5393	105000.0
2013-11-11 07:00:00	AAPL	Stock	18.5707	18.6789	18.5696	18.6746	294616.0
2013-11-11 08:00:00	AAPL	Stock	18.6714	18.6746	18.5714	18.5786	2429756.0
2013-11-11 09:00:00	AAPL	Stock	18.5786	18.6311	18.4564	18.4786	41250748.0
2013-11-11 10:00:00	AAPL	Stock	18.4821	18.5057	18.3843	18.4332	49654108.0
2013-11-11 11:00:00	AAPL	Stock	18.4368	18.5257	18.3718	18.5168	41378288.0
2013-11-11 12:00:00	AAPL	Stock	18.5146	18.5321	18.4707	18.5211	15568224.0
2013-11-11 13:00:00	AAPL	Stock	18.5225	18.5368	18.4739	18.505	15745016.0
2013-11-11 14:00:00	AAPL	Stock	18.5036	18.5725	18.4846	18.5483	17203844.0
2013-11-11 15:00:00	AAPL	Stock	18.55	18.6014	18.5325	18.5437	31051104.0
2013-11-11 16:00:00	AAPL	Stock	18.5461	18.5525	18.4896	18.5461	10248588.0
2013-11-11 17:00:00	AAPL	Stock	18.5368	18.5457	18.5275	18.5321	123872.0
2013-11-11 18:00:00	AAPL	Stock	18.5343	18.5461	18.5179	18.5286	326704.0
2013-11-11 19:00:00	AAPL	Stock	18.5286	18.5286	18.5218	18.5218	59948.0
2013-11-11 04:00:00	MSFT	Stock	37.8	37.8	37.8	37.8	250.0
2013-11-11 07:00:00	MSFT	Stock	37.72	37.72	37.7	37.7	3050.0
2013-11-11 08:00:00	MSFT	Stock	37.78	37.8	37.71	37.78	3016.0
2013-11-11 09:00:00	MSFT	Stock	37.71	37.77	37.525	37.63	3484464.0
2013-11-11 10:00:00	MSFT	Stock	37.63	37.64	37.355	37.575	4628327.0
2013-11-11 11:00:00	MSFT	Stock	37.575	37.605	37.397	37.575	6676207.0
2013-11-11 12:00:00	MSFT	Stock	37.57	37.58	37.5	37.53	2073578.0
2013-11-11 13:00:00	MSFT	Stock	37.536	37.775	37.5	37.7	2192542.0
2013-11-11 14:00:00	MSFT	Stock	37.7	37.74	37.66	37.685	1725376.0
2013-11-11 15:00:00	MSFT	Stock	37.69	37.705	37.57	37.58	4228460.0
2013-11-11 16:00:00	MSFT	Stock	37.58	37.65	37.497	37.497	1309779.0
2013-11-11 17:00:00	MSFT	Stock	37.52	37.669	37.52	37.61	6518.0
2013-11-11 18:00:00	MSFT	Stock	37.63	37.64	37.53	37.6	32569.0
2013-11-11 19:00:00	MSFT	Stock	37.64	37.64	37.64	37.64	100.0
2013-11-11 09:00:00	NVDA	Stock	0.3875	0.3918	0.3868	0.3905	37013680.0
2013-11-11 10:00:00	NVDA	Stock	0.3908	0.3911	0.3888	0.389	39643360.0
2013-11-11 11:00:00	NVDA	Stock	0.389	0.3918	0.3888	0.3914	42000560.0
2013-11-11 12:00:00	NVDA	Stock	0.3913	0.3933	0.3905	0.3928	29025040.0
2013-11-11 13:00:00	NVDA	Stock	0.3928	0.3933	0.3905	0.3919	52199200.0
2013-11-11 14:00:00	NVDA	Stock	0.3919	0.392	0.391	0.3916	24691800.0
2013-11-11 15:00:00	NVDA	Stock	0.3916	0.3925	0.391	0.3922	57246320.0
2013-11-11 16:00:00	NVDA	Stock	0.3922	0.3925	0.392	0.392	1027240.0
2013-11-11 19:00:00	NVDA	Stock	0.3938	0.3938	0.3938	0.3938	64000.0
2013-11-11 04:00:00	AMZN	Stock	17.5215	17.5215	17.5215	17.5215	2000.0
2013-11-11 05:00:00	AMZN	Stock	17.527	17.527	17.527	17.527	10000.0
2013-11-11 06:00:00	AMZN	Stock	17.533	17.533	17.533	17.533	2000.0
2013-11-11 08:00:00	AMZN	Stock	17.5915	17.5915	17.45	17.475	209100.0
2013-11-11 09:00:00	AMZN	Stock	17.5495	17.7345	17.403	17.7118	7665540.0
2013-11-11 10:00:00	AMZN	Stock	17.7145	17.7685	17.62	17.7035	9495980.0
2013-11-11 11:00:00	AMZN	Stock	17.7077	17.7077	17.6005	17.614	6314980.0
2013-11-11 12:00:00	AMZN	Stock	17.6115	17.661	17.575	17.653	3047540.0
2013-11-11 13:00:00	AMZN	Stock	17.6456	17.6899	17.6065	17.656	2235340.0
2013-11-11 14:00:00	AMZN	Stock	17.653	17.716	17.6335	17.6995	3169600.0
2013-11-11 15:00:00	AMZN	Stock	17.6915	17.7375	17.6586	17.7185	10412120.0

> showing 50 of 46,558 rows — these rows as CSV

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