PREVIEW / stock_1hour / 2011-11-11

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-11.parquet
  size:    914 KB
  rows:    43,766
  symbols: 3,502

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
2011-11-11 04:00:00	AAPL	Stock	13.8393	13.8393	13.8393	13.8393	2800.0
2011-11-11 05:00:00	AAPL	Stock	13.8214	13.8214	13.8214	13.8214	2800.0
2011-11-11 06:00:00	AAPL	Stock	13.8143	13.8143	13.8143	13.8143	2800.0
2011-11-11 07:00:00	AAPL	Stock	13.8107	13.8375	13.8086	13.8375	403536.0
2011-11-11 08:00:00	AAPL	Stock	13.8375	13.9093	13.7786	13.8696	3988740.0
2011-11-11 09:00:00	AAPL	Stock	13.8664	13.8843	13.5807	13.6414	126284872.0
2011-11-11 10:00:00	AAPL	Stock	13.6414	13.7304	13.6157	13.6444	121516976.0
2011-11-11 11:00:00	AAPL	Stock	13.6461	13.7975	13.6382	13.7632	81965828.0
2011-11-11 12:00:00	AAPL	Stock	13.7636	13.8821	13.7607	13.8254	77039984.0
2011-11-11 13:00:00	AAPL	Stock	13.8254	13.8389	13.6904	13.6968	75733756.0
2011-11-11 14:00:00	AAPL	Stock	13.6996	13.7425	13.6536	13.6732	65120888.0
2011-11-11 15:00:00	AAPL	Stock	13.6732	13.7382	13.655	13.7382	87480400.0
2011-11-11 16:00:00	AAPL	Stock	13.7354	13.7367	13.6521	13.7214	10739232.0
2011-11-11 17:00:00	AAPL	Stock	13.725	13.7321	13.7143	13.7164	271404.0
2011-11-11 18:00:00	AAPL	Stock	13.7179	13.7364	13.7143	13.7296	60228.0
2011-11-11 19:00:00	AAPL	Stock	13.7243	13.7293	13.7129	13.7182	273728.0
2011-11-11 07:00:00	MSFT	Stock	26.45	26.45	26.45	26.45	500.0
2011-11-11 08:00:00	MSFT	Stock	26.37	26.52	26.37	26.47	29661.0
2011-11-11 09:00:00	MSFT	Stock	26.49	26.81	26.48	26.73	5895853.0
2011-11-11 10:00:00	MSFT	Stock	26.73	26.96	26.73	26.96	5783882.0
2011-11-11 11:00:00	MSFT	Stock	26.96	27.075	26.9	27.004	6043619.0
2011-11-11 12:00:00	MSFT	Stock	27.005	27.07	26.94	26.985	3092121.0
2011-11-11 13:00:00	MSFT	Stock	26.985	27.05	26.96	26.98	3093732.0
2011-11-11 14:00:00	MSFT	Stock	26.98	27.04	26.94	26.97	2982590.0
2011-11-11 15:00:00	MSFT	Stock	26.97	27.0	26.9	26.915	8224947.0
2011-11-11 16:00:00	MSFT	Stock	26.92	26.99	26.79	26.91	2327803.0
2011-11-11 17:00:00	MSFT	Stock	26.89	26.92	26.85	26.85	7610.0
2011-11-11 18:00:00	MSFT	Stock	26.92	26.92	26.85	26.85	12050.0
2011-11-11 04:00:00	NVDA	Stock	0.3838	0.3838	0.3838	0.3838	40000.0
2011-11-11 05:00:00	NVDA	Stock	0.375	0.375	0.375	0.375	16000.0
2011-11-11 06:00:00	NVDA	Stock	0.3775	0.3775	0.3775	0.3775	4000.0
2011-11-11 07:00:00	NVDA	Stock	0.3775	0.3813	0.375	0.375	905520.0
2011-11-11 08:00:00	NVDA	Stock	0.3773	0.3788	0.365	0.3688	13230520.0
2011-11-11 09:00:00	NVDA	Stock	0.3698	0.3745	0.3518	0.3541	377110720.0
2011-11-11 10:00:00	NVDA	Stock	0.3541	0.3648	0.354	0.3635	310862640.0
2011-11-11 11:00:00	NVDA	Stock	0.3633	0.3718	0.3632	0.37	243491960.0
2011-11-11 12:00:00	NVDA	Stock	0.37	0.3775	0.3695	0.3738	198249960.0
2011-11-11 13:00:00	NVDA	Stock	0.3738	0.3775	0.373	0.3735	140218360.0
2011-11-11 14:00:00	NVDA	Stock	0.3738	0.3749	0.372	0.3723	139936480.0
2011-11-11 15:00:00	NVDA	Stock	0.3723	0.3753	0.3708	0.3743	284697480.0
2011-11-11 16:00:00	NVDA	Stock	0.3743	0.3753	0.3675	0.3743	14569480.0
2011-11-11 17:00:00	NVDA	Stock	0.3738	0.3738	0.3733	0.3733	252000.0
2011-11-11 19:00:00	NVDA	Stock	0.3745	0.3748	0.3745	0.3748	366280.0
2011-11-11 07:00:00	AMZN	Stock	10.595	10.595	10.5945	10.595	10000.0
2011-11-11 08:00:00	AMZN	Stock	10.606	10.6125	10.5915	10.6025	101600.0
2011-11-11 09:00:00	AMZN	Stock	10.6085	10.6495	10.518	10.533	14137180.0
2011-11-11 10:00:00	AMZN	Stock	10.5325	10.8095	10.5155	10.7818	27381300.0
2011-11-11 11:00:00	AMZN	Stock	10.7818	10.847	10.7725	10.839	14049300.0
2011-11-11 12:00:00	AMZN	Stock	10.835	10.8778	10.8135	10.8435	11422060.0
2011-11-11 13:00:00	AMZN	Stock	10.842	10.894	10.837	10.87	9702240.0

> showing 50 of 43,766 rows — these rows as CSV

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