PREVIEW / stock_1hour / 2011-03-25

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-25.parquet
  size:    930 KB
  rows:    43,791
  symbols: 3,514

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-25 04:00:00	AAPL	Stock	12.395	12.4032	12.3886	12.3893	42000.0
2011-03-25 05:00:00	AAPL	Stock	12.3982	12.3982	12.3982	12.3982	2800.0
2011-03-25 06:00:00	AAPL	Stock	12.3982	12.4446	12.3982	12.425	71400.0
2011-03-25 07:00:00	AAPL	Stock	12.4286	12.4289	12.4054	12.4143	577892.0
2011-03-25 08:00:00	AAPL	Stock	12.4111	12.4286	12.3929	12.4143	2659188.0
2011-03-25 09:00:00	AAPL	Stock	12.4143	12.5261	12.3936	12.5053	96064080.0
2011-03-25 10:00:00	AAPL	Stock	12.5029	12.5411	12.4621	12.5366	77570892.0
2011-03-25 11:00:00	AAPL	Stock	12.5375	12.5657	12.5204	12.5625	54299196.0
2011-03-25 12:00:00	AAPL	Stock	12.5614	12.5643	12.5214	12.5231	37224180.0
2011-03-25 13:00:00	AAPL	Stock	12.5234	12.5482	12.5096	12.5261	36642620.0
2011-03-25 14:00:00	AAPL	Stock	12.5243	12.53	12.4943	12.5232	38212300.0
2011-03-25 15:00:00	AAPL	Stock	12.5229	12.5736	12.5061	12.5568	84923580.0
2011-03-25 16:00:00	AAPL	Stock	12.555	12.57	12.4182	12.5589	9456384.0
2011-03-25 17:00:00	AAPL	Stock	12.565	12.5871	12.555	12.575	1396332.0
2011-03-25 18:00:00	AAPL	Stock	12.5807	12.5818	12.555	12.5793	193564.0
2011-03-25 19:00:00	AAPL	Stock	12.5771	12.5829	12.5714	12.5821	395612.0
2011-03-25 06:00:00	MSFT	Stock	26.0	26.0	25.95	25.95	480.0
2011-03-25 07:00:00	MSFT	Stock	25.86	25.97	25.86	25.93	800.0
2011-03-25 08:00:00	MSFT	Stock	25.92	25.96	25.86	25.89	15037.0
2011-03-25 09:00:00	MSFT	Stock	25.89	25.97	25.71	25.72	5496026.0
2011-03-25 10:00:00	MSFT	Stock	25.72	25.76	25.68	25.718	8546646.0
2011-03-25 11:00:00	MSFT	Stock	25.715	25.721	25.65	25.67	7951046.0
2011-03-25 12:00:00	MSFT	Stock	25.67	25.73	25.66	25.705	4399326.0
2011-03-25 13:00:00	MSFT	Stock	25.7	25.71	25.62	25.64	4657542.0
2011-03-25 14:00:00	MSFT	Stock	25.64	25.66	25.59	25.639	7903461.0
2011-03-25 15:00:00	MSFT	Stock	25.64	25.64	25.59	25.63	14038436.0
2011-03-25 16:00:00	MSFT	Stock	25.622	25.686	25.59	25.61	2136130.0
2011-03-25 17:00:00	MSFT	Stock	25.6	25.62	25.59	25.62	38819.0
2011-03-25 18:00:00	MSFT	Stock	25.61	25.62	25.6	25.61	2303.0
2011-03-25 19:00:00	MSFT	Stock	25.6	25.6	25.59	25.6	1235.0
2011-03-25 07:00:00	NVDA	Stock	0.4862	0.4902	0.4862	0.487	313120.0
2011-03-25 08:00:00	NVDA	Stock	0.4875	0.4888	0.486	0.4875	2364440.0
2011-03-25 09:00:00	NVDA	Stock	0.4875	0.4878	0.4728	0.4753	169142880.0
2011-03-25 10:00:00	NVDA	Stock	0.475	0.4861	0.4735	0.4848	242146560.0
2011-03-25 11:00:00	NVDA	Stock	0.4848	0.4855	0.479	0.48	130392440.0
2011-03-25 12:00:00	NVDA	Stock	0.4798	0.4815	0.4742	0.4744	95468560.0
2011-03-25 13:00:00	NVDA	Stock	0.4745	0.4763	0.4725	0.474	150526560.0
2011-03-25 14:00:00	NVDA	Stock	0.474	0.4742	0.4655	0.4674	201479320.0
2011-03-25 15:00:00	NVDA	Stock	0.4675	0.4692	0.465	0.466	189615440.0
2011-03-25 16:00:00	NVDA	Stock	0.4668	0.481	0.4648	0.4662	3640480.0
2011-03-25 17:00:00	NVDA	Stock	0.4673	0.4673	0.4658	0.4658	244160.0
2011-03-25 18:00:00	NVDA	Stock	0.4658	0.4662	0.4658	0.4662	128600.0
2011-03-25 19:00:00	NVDA	Stock	0.466	0.466	0.465	0.4652	627560.0
2011-03-25 08:00:00	AMZN	Stock	8.609	8.6125	8.572	8.572	128520.0
2011-03-25 09:00:00	AMZN	Stock	8.57	8.5915	8.515	8.5628	10978320.0
2011-03-25 10:00:00	AMZN	Stock	8.5615	8.668	8.5615	8.6673	19396800.0
2011-03-25 11:00:00	AMZN	Stock	8.668	8.6745	8.64	8.654	11881340.0
2011-03-25 12:00:00	AMZN	Stock	8.6565	8.6629	8.6225	8.6265	7177760.0
2011-03-25 13:00:00	AMZN	Stock	8.6275	8.629	8.563	8.575	9467480.0
2011-03-25 14:00:00	AMZN	Stock	8.575	8.5835	8.546	8.5675	8297460.0

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

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