PREVIEW / stock_1hour / 2011-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-09.parquet
  size:    920 KB
  rows:    43,696
  symbols: 3,532

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-03-09 04:00:00	AAPL	Stock	12.7104	12.7193	12.7104	12.7193	11200.0
2011-03-09 06:00:00	AAPL	Stock	12.7143	12.7675	12.7143	12.7661	42000.0
2011-03-09 07:00:00	AAPL	Stock	12.7639	12.7639	12.7318	12.7464	193508.0
2011-03-09 08:00:00	AAPL	Stock	12.7464	12.7496	12.6993	12.7079	1185828.0
2011-03-09 09:00:00	AAPL	Stock	12.7082	12.7082	12.5532	12.6036	63888048.0
2011-03-09 10:00:00	AAPL	Stock	12.6014	12.6364	12.5479	12.5707	147050428.0
2011-03-09 11:00:00	AAPL	Stock	12.5707	12.6204	12.5214	12.6036	75705476.0
2011-03-09 12:00:00	AAPL	Stock	12.6064	12.6282	12.5593	12.5843	38844652.0
2011-03-09 13:00:00	AAPL	Stock	12.5832	12.5979	12.5429	12.5525	27865992.0
2011-03-09 14:00:00	AAPL	Stock	12.5546	12.5939	12.5464	12.5793	36099616.0
2011-03-09 15:00:00	AAPL	Stock	12.5821	12.5946	12.5539	12.5875	51441656.0
2011-03-09 16:00:00	AAPL	Stock	12.5875	12.5893	12.5634	12.5786	8857968.0
2011-03-09 17:00:00	AAPL	Stock	12.5786	12.5929	12.57	12.5718	367052.0
2011-03-09 18:00:00	AAPL	Stock	12.5711	12.5882	12.5711	12.5768	261352.0
2011-03-09 19:00:00	AAPL	Stock	12.58	12.58	12.5714	12.5743	177156.0
2011-03-09 04:00:00	MSFT	Stock	25.9	25.9	25.9	25.9	200.0
2011-03-09 06:00:00	MSFT	Stock	26.09	26.09	26.02	26.02	500.0
2011-03-09 07:00:00	MSFT	Stock	26.03	26.03	25.95	25.97	2700.0
2011-03-09 08:00:00	MSFT	Stock	25.95	25.97	25.89	25.91	26380.0
2011-03-09 09:00:00	MSFT	Stock	25.86	25.9	25.66	25.71	4774489.0
2011-03-09 10:00:00	MSFT	Stock	25.71	25.98	25.69	25.74	8377291.0
2011-03-09 11:00:00	MSFT	Stock	25.74	25.88	25.69	25.88	5192926.0
2011-03-09 12:00:00	MSFT	Stock	25.875	25.94	25.75	25.79	4639934.0
2011-03-09 13:00:00	MSFT	Stock	25.798	25.82	25.695	25.74	3639874.0
2011-03-09 14:00:00	MSFT	Stock	25.75	25.85	25.75	25.82	3427866.0
2011-03-09 15:00:00	MSFT	Stock	25.82	25.89	25.76	25.88	6843066.0
2011-03-09 16:00:00	MSFT	Stock	25.88	25.91	25.79	25.86	1902157.0
2011-03-09 17:00:00	MSFT	Stock	25.87	25.87	25.85	25.87	715.0
2011-03-09 18:00:00	MSFT	Stock	25.87	25.89	25.85	25.85	7860.0
2011-03-09 19:00:00	MSFT	Stock	25.85	25.87	25.85	25.87	3351.0
2011-03-09 07:00:00	NVDA	Stock	0.4888	0.4888	0.4888	0.4888	24520.0
2011-03-09 08:00:00	NVDA	Stock	0.4865	0.4908	0.4862	0.4908	1291880.0
2011-03-09 09:00:00	NVDA	Stock	0.49	0.49	0.479	0.4862	197730200.0
2011-03-09 10:00:00	NVDA	Stock	0.486	0.492	0.4809	0.4832	269542280.0
2011-03-09 11:00:00	NVDA	Stock	0.4832	0.4878	0.4812	0.4822	153839800.0
2011-03-09 12:00:00	NVDA	Stock	0.4825	0.4838	0.4763	0.4772	173065440.0
2011-03-09 13:00:00	NVDA	Stock	0.477	0.4795	0.4742	0.4755	171652360.0
2011-03-09 14:00:00	NVDA	Stock	0.4756	0.479	0.4745	0.479	143743880.0
2011-03-09 15:00:00	NVDA	Stock	0.479	0.4795	0.477	0.4785	181632680.0
2011-03-09 16:00:00	NVDA	Stock	0.4785	0.4888	0.4765	0.4775	16689680.0
2011-03-09 17:00:00	NVDA	Stock	0.4788	0.4798	0.4775	0.4788	344000.0
2011-03-09 18:00:00	NVDA	Stock	0.4795	0.4798	0.4795	0.4798	20400.0
2011-03-09 19:00:00	NVDA	Stock	0.4798	0.4798	0.4795	0.4795	50680.0
2011-03-09 07:00:00	AMZN	Stock	8.345	8.345	8.345	8.345	2000.0
2011-03-09 08:00:00	AMZN	Stock	8.3465	8.3875	8.3465	8.3575	64800.0
2011-03-09 09:00:00	AMZN	Stock	8.3565	8.3615	8.195	8.2754	25405000.0
2011-03-09 10:00:00	AMZN	Stock	8.2775	8.4635	8.271	8.3598	33643640.0
2011-03-09 11:00:00	AMZN	Stock	8.3595	8.436	8.3295	8.431	16275760.0
2011-03-09 12:00:00	AMZN	Stock	8.431	8.4875	8.429	8.4555	15306420.0
2011-03-09 13:00:00	AMZN	Stock	8.4515	8.4655	8.409	8.4325	11209260.0

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

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