PREVIEW / stock_1hour / 2011-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-22.parquet
  size:    934 KB
  rows:    44,090
  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
2011-06-22 06:00:00	AAPL	Stock	11.5939	11.6054	11.5821	11.5821	33600.0
2011-06-22 07:00:00	AAPL	Stock	11.5825	11.6007	11.5521	11.6007	586712.0
2011-06-22 08:00:00	AAPL	Stock	11.5968	11.6146	11.5689	11.5796	1131564.0
2011-06-22 09:00:00	AAPL	Stock	11.58	11.7464	11.5729	11.721	77329168.0
2011-06-22 10:00:00	AAPL	Stock	11.7211	11.7229	11.6607	11.6766	65311624.0
2011-06-22 11:00:00	AAPL	Stock	11.6742	11.6957	11.5821	11.5857	52686088.0
2011-06-22 12:00:00	AAPL	Stock	11.585	11.6907	11.5818	11.6671	48904912.0
2011-06-22 13:00:00	AAPL	Stock	11.6689	11.6739	11.6375	11.6675	25655812.0
2011-06-22 14:00:00	AAPL	Stock	11.6671	11.6696	11.5986	11.6143	35270340.0
2011-06-22 15:00:00	AAPL	Stock	11.6143	11.6346	11.5136	11.5214	70626136.0
2011-06-22 16:00:00	AAPL	Stock	11.5239	11.6465	11.5107	11.5175	8208256.0
2011-06-22 17:00:00	AAPL	Stock	11.5161	11.5189	11.51	11.5189	227668.0
2011-06-22 18:00:00	AAPL	Stock	11.5107	11.5218	11.4911	11.5011	367864.0
2011-06-22 19:00:00	AAPL	Stock	11.5011	11.5011	11.4786	11.4814	261352.0
2011-06-22 07:00:00	MSFT	Stock	24.71	24.71	24.71	24.71	500.0
2011-06-22 08:00:00	MSFT	Stock	24.71	24.74	24.65	24.67	6493.0
2011-06-22 09:00:00	MSFT	Stock	24.68	24.81	24.59	24.76	4341567.0
2011-06-22 10:00:00	MSFT	Stock	24.766	24.79	24.68	24.75	6232989.0
2011-06-22 11:00:00	MSFT	Stock	24.747	24.78	24.66	24.722	7449285.0
2011-06-22 12:00:00	MSFT	Stock	24.72	24.78	24.7	24.78	3575804.0
2011-06-22 13:00:00	MSFT	Stock	24.77	24.78	24.72	24.75	2627496.0
2011-06-22 14:00:00	MSFT	Stock	24.76	24.78	24.71	24.74	6237115.0
2011-06-22 15:00:00	MSFT	Stock	24.74	24.78	24.63	24.65	10112611.0
2011-06-22 16:00:00	MSFT	Stock	24.64	24.731	24.62	24.62	2002360.0
2011-06-22 17:00:00	MSFT	Stock	24.61	24.63	24.55	24.63	10763.0
2011-06-22 18:00:00	MSFT	Stock	24.63	24.65	24.6	24.6	3983.0
2011-06-22 19:00:00	MSFT	Stock	24.55	24.6	24.54	24.56	3409.0
2011-06-22 07:00:00	NVDA	Stock	0.395	0.3973	0.395	0.3973	12000.0
2011-06-22 08:00:00	NVDA	Stock	0.3973	0.3973	0.3973	0.3973	4000.0
2011-06-22 09:00:00	NVDA	Stock	0.3958	0.3988	0.3955	0.398	79601880.0
2011-06-22 10:00:00	NVDA	Stock	0.3978	0.4011	0.3953	0.4003	92107840.0
2011-06-22 11:00:00	NVDA	Stock	0.4003	0.4008	0.3995	0.4	111692720.0
2011-06-22 12:00:00	NVDA	Stock	0.4001	0.4015	0.3995	0.4001	88415000.0
2011-06-22 13:00:00	NVDA	Stock	0.4001	0.401	0.3998	0.4001	74237720.0
2011-06-22 14:00:00	NVDA	Stock	0.4003	0.4003	0.397	0.397	64220080.0
2011-06-22 15:00:00	NVDA	Stock	0.3971	0.3981	0.3928	0.3933	128313080.0
2011-06-22 16:00:00	NVDA	Stock	0.3935	0.3983	0.3933	0.3963	12529080.0
2011-06-22 17:00:00	NVDA	Stock	0.3938	0.3938	0.3938	0.3938	8000.0
2011-06-22 19:00:00	NVDA	Stock	0.3938	0.3938	0.3938	0.3938	4000.0
2011-06-22 07:00:00	AMZN	Stock	9.69	9.69	9.69	9.69	2000.0
2011-06-22 08:00:00	AMZN	Stock	9.7	9.7	9.697	9.6995	16160.0
2011-06-22 09:00:00	AMZN	Stock	9.692	9.76	9.6275	9.681	10633880.0
2011-06-22 10:00:00	AMZN	Stock	9.6755	9.6995	9.6285	9.6585	8336020.0
2011-06-22 11:00:00	AMZN	Stock	9.659	9.6875	9.634	9.6483	5319360.0
2011-06-22 12:00:00	AMZN	Stock	9.6435	9.6595	9.6068	9.6495	4635700.0
2011-06-22 13:00:00	AMZN	Stock	9.652	9.6595	9.61	9.6435	4855780.0
2011-06-22 14:00:00	AMZN	Stock	9.6415	9.6544	9.587	9.5976	9736420.0
2011-06-22 15:00:00	AMZN	Stock	9.5975	9.6095	9.566	9.581	15990140.0
2011-06-22 16:00:00	AMZN	Stock	9.581	9.6393	9.5755	9.593	2724840.0
2011-06-22 17:00:00	AMZN	Stock	9.593	9.595	9.5735	9.5735	131000.0

> showing 50 of 44,090 rows — these rows as CSV

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