PREVIEW / stock_1hour / 2011-12-02

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-02.parquet
  size:    923 KB
  rows:    43,919
  symbols: 3,536

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-12-02 04:00:00	AAPL	Stock	13.9321	14.0193	13.8768	14.0193	53620.0
2011-12-02 05:00:00	AAPL	Stock	14.0179	14.0357	14.0071	14.0071	42000.0
2011-12-02 06:00:00	AAPL	Stock	13.9929	14.0	13.9482	13.9607	56560.0
2011-12-02 07:00:00	AAPL	Stock	13.9468	13.9957	13.9411	13.975	820260.0
2011-12-02 08:00:00	AAPL	Stock	13.9643	13.9907	13.9289	13.9304	6339368.0
2011-12-02 09:00:00	AAPL	Stock	13.9293	13.9982	13.8779	13.9975	67152792.0
2011-12-02 10:00:00	AAPL	Stock	13.9964	14.0582	13.9782	14.025	71833244.0
2011-12-02 11:00:00	AAPL	Stock	14.0239	14.0429	13.9271	13.9532	47340468.0
2011-12-02 12:00:00	AAPL	Stock	13.9568	13.9932	13.9404	13.9868	26423348.0
2011-12-02 13:00:00	AAPL	Stock	13.9868	14.0	13.9561	13.9754	24321780.0
2011-12-02 14:00:00	AAPL	Stock	13.9736	13.9796	13.9296	13.9675	37186212.0
2011-12-02 15:00:00	AAPL	Stock	13.9646	13.9746	13.9157	13.9179	70736932.0
2011-12-02 16:00:00	AAPL	Stock	13.9261	14.0157	13.9179	13.9261	18486440.0
2011-12-02 17:00:00	AAPL	Stock	13.9264	13.9264	13.9154	13.9175	289268.0
2011-12-02 18:00:00	AAPL	Stock	13.9179	13.925	13.9107	13.9179	263480.0
2011-12-02 19:00:00	AAPL	Stock	13.9179	13.9279	13.915	13.9229	90580.0
2011-12-02 04:00:00	MSFT	Stock	25.49	25.51	25.49	25.51	2221.0
2011-12-02 05:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	100.0
2011-12-02 07:00:00	MSFT	Stock	25.49	25.58	25.49	25.58	23760.0
2011-12-02 08:00:00	MSFT	Stock	25.54	25.6	25.5	25.54	109348.0
2011-12-02 09:00:00	MSFT	Stock	25.55	25.64	25.35	25.43	4826888.0
2011-12-02 10:00:00	MSFT	Stock	25.42	25.45	25.29	25.316	7243542.0
2011-12-02 11:00:00	MSFT	Stock	25.315	25.33	25.16	25.23	10759929.0
2011-12-02 12:00:00	MSFT	Stock	25.24	25.35	25.2	25.25	6385710.0
2011-12-02 13:00:00	MSFT	Stock	25.25	25.26	25.19	25.248	4540914.0
2011-12-02 14:00:00	MSFT	Stock	25.245	25.28	25.22	25.244	4671279.0
2011-12-02 15:00:00	MSFT	Stock	25.245	25.29	25.21	25.22	8994821.0
2011-12-02 16:00:00	MSFT	Stock	25.22	25.292	25.18	25.22	2324499.0
2011-12-02 17:00:00	MSFT	Stock	25.2	25.2	25.2	25.2	6161.0
2011-12-02 18:00:00	MSFT	Stock	25.2	25.22	25.19	25.2	2400.0
2011-12-02 19:00:00	MSFT	Stock	25.2	25.2	25.19	25.2	1200.0
2011-12-02 07:00:00	NVDA	Stock	0.4013	0.404	0.4013	0.404	59000.0
2011-12-02 08:00:00	NVDA	Stock	0.4043	0.4043	0.3975	0.402	1168400.0
2011-12-02 09:00:00	NVDA	Stock	0.4015	0.402	0.392	0.3982	83659760.0
2011-12-02 10:00:00	NVDA	Stock	0.3985	0.4013	0.3955	0.396	106050560.0
2011-12-02 11:00:00	NVDA	Stock	0.3958	0.3965	0.3893	0.3918	95653200.0
2011-12-02 12:00:00	NVDA	Stock	0.3922	0.3953	0.392	0.3942	37410360.0
2011-12-02 13:00:00	NVDA	Stock	0.394	0.396	0.3938	0.3958	41337680.0
2011-12-02 14:00:00	NVDA	Stock	0.3958	0.3964	0.3938	0.3953	49256280.0
2011-12-02 15:00:00	NVDA	Stock	0.3953	0.3962	0.3922	0.393	118743720.0
2011-12-02 16:00:00	NVDA	Stock	0.3933	0.3958	0.3928	0.3958	3279920.0
2011-12-02 17:00:00	NVDA	Stock	0.3922	0.3925	0.3922	0.3925	45120.0
2011-12-02 18:00:00	NVDA	Stock	0.3925	0.3925	0.3925	0.3925	18160.0
2011-12-02 19:00:00	NVDA	Stock	0.393	0.393	0.393	0.393	38160.0
2011-12-02 04:00:00	AMZN	Stock	9.925	9.95	9.925	9.95	8000.0
2011-12-02 07:00:00	AMZN	Stock	9.9375	9.94	9.9305	9.9325	73500.0
2011-12-02 08:00:00	AMZN	Stock	9.9325	9.9925	9.8905	9.905	1057060.0
2011-12-02 09:00:00	AMZN	Stock	9.904	9.9265	9.759	9.8505	28750800.0
2011-12-02 10:00:00	AMZN	Stock	9.8495	9.983	9.8465	9.9415	28875660.0
2011-12-02 11:00:00	AMZN	Stock	9.94	9.96	9.8635	9.8915	17466100.0

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

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