PREVIEW / stock_1hour / 2011-04-25

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-25.parquet
  size:    928 KB
  rows:    43,899
  symbols: 3,560

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-04-25 07:00:00	AAPL	Stock	12.5893	12.5893	12.5589	12.5589	138460.0
2011-04-25 08:00:00	AAPL	Stock	12.5639	12.5893	12.5143	12.5321	1759660.0
2011-04-25 09:00:00	AAPL	Stock	12.5321	12.6157	12.5093	12.61	59955140.0
2011-04-25 10:00:00	AAPL	Stock	12.6095	12.6136	12.5411	12.5707	49016800.0
2011-04-25 11:00:00	AAPL	Stock	12.5704	12.5836	12.5611	12.575	22622012.0
2011-04-25 12:00:00	AAPL	Stock	12.5754	12.5925	12.565	12.5771	15326388.0
2011-04-25 13:00:00	AAPL	Stock	12.5766	12.5886	12.5629	12.5796	18964932.0
2011-04-25 14:00:00	AAPL	Stock	12.5801	12.6339	12.5782	12.626	42474768.0
2011-04-25 15:00:00	AAPL	Stock	12.6261	12.6261	12.6	12.6107	39693108.0
2011-04-25 16:00:00	AAPL	Stock	12.6089	12.6153	12.5257	12.6089	11203528.0
2011-04-25 17:00:00	AAPL	Stock	12.6089	12.6132	12.6011	12.6132	248612.0
2011-04-25 18:00:00	AAPL	Stock	12.6139	12.6193	12.5932	12.6007	488264.0
2011-04-25 19:00:00	AAPL	Stock	12.6011	12.6107	12.6	12.6071	310212.0
2011-04-25 07:00:00	MSFT	Stock	25.67	25.67	25.61	25.61	3100.0
2011-04-25 08:00:00	MSFT	Stock	25.63	25.63	25.57	25.58	26217.0
2011-04-25 09:00:00	MSFT	Stock	25.59	25.61	25.4	25.42	3691392.0
2011-04-25 10:00:00	MSFT	Stock	25.429	25.45	25.34	25.425	6511780.0
2011-04-25 11:00:00	MSFT	Stock	25.42	25.44	25.36	25.43	3989310.0
2011-04-25 12:00:00	MSFT	Stock	25.43	25.52	25.42	25.502	3400615.0
2011-04-25 13:00:00	MSFT	Stock	25.5	25.56	25.46	25.54	4190377.0
2011-04-25 14:00:00	MSFT	Stock	25.55	25.56	25.51	25.54	3076046.0
2011-04-25 15:00:00	MSFT	Stock	25.54	25.62	25.52	25.61	6172983.0
2011-04-25 16:00:00	MSFT	Stock	25.6	25.62	25.425	25.55	2208223.0
2011-04-25 17:00:00	MSFT	Stock	25.58	25.58	25.58	25.58	293.0
2011-04-25 18:00:00	MSFT	Stock	25.61	25.61	25.56	25.61	12566.0
2011-04-25 19:00:00	MSFT	Stock	25.61	25.62	25.59	25.61	6970.0
2011-04-25 08:00:00	NVDA	Stock	0.465	0.465	0.465	0.465	20000.0
2011-04-25 09:00:00	NVDA	Stock	0.462	0.476	0.462	0.4753	95758320.0
2011-04-25 10:00:00	NVDA	Stock	0.4755	0.4772	0.4738	0.4753	139013120.0
2011-04-25 11:00:00	NVDA	Stock	0.475	0.478	0.474	0.4777	79181080.0
2011-04-25 12:00:00	NVDA	Stock	0.4776	0.4778	0.471	0.4715	100753080.0
2011-04-25 13:00:00	NVDA	Stock	0.4716	0.4718	0.469	0.4695	61952400.0
2011-04-25 14:00:00	NVDA	Stock	0.4696	0.4715	0.4688	0.471	54418960.0
2011-04-25 15:00:00	NVDA	Stock	0.4708	0.4718	0.4695	0.4702	75901280.0
2011-04-25 16:00:00	NVDA	Stock	0.47	0.473	0.463	0.4698	9848960.0
2011-04-25 17:00:00	NVDA	Stock	0.4702	0.4702	0.47	0.47	32000.0
2011-04-25 18:00:00	NVDA	Stock	0.4702	0.4723	0.4702	0.4723	199400.0
2011-04-25 08:00:00	AMZN	Stock	9.3125	9.3275	9.2875	9.2875	253500.0
2011-04-25 09:00:00	AMZN	Stock	9.2885	9.3175	9.25	9.284	12584740.0
2011-04-25 10:00:00	AMZN	Stock	9.2875	9.289	9.1885	9.2675	13494900.0
2011-04-25 11:00:00	AMZN	Stock	9.268	9.2945	9.252	9.2805	6248940.0
2011-04-25 12:00:00	AMZN	Stock	9.281	9.286	9.2465	9.264	4852480.0
2011-04-25 13:00:00	AMZN	Stock	9.264	9.269	9.2505	9.2644	5723780.0
2011-04-25 14:00:00	AMZN	Stock	9.264	9.294	9.251	9.283	7909320.0
2011-04-25 15:00:00	AMZN	Stock	9.283	9.294	9.2665	9.271	12424900.0
2011-04-25 16:00:00	AMZN	Stock	9.271	9.2878	9.2505	9.26	4296880.0
2011-04-25 17:00:00	AMZN	Stock	9.25	9.2695	9.24	9.2675	35380.0
2011-04-25 18:00:00	AMZN	Stock	9.2675	9.271	9.26	9.2685	80400.0
2011-04-25 19:00:00	AMZN	Stock	9.26	9.26	9.241	9.25	9000.0
2011-04-25 08:00:00	TSLA	Stock	1.78	1.7867	1.7767	1.7867	41250.0

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

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