PREVIEW / stock_1hour / 2012-02-09

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-09.parquet
  size:    957 KB
  rows:    45,593
  symbols: 3,546

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
2012-02-09 04:00:00	AAPL	Stock	17.0754	17.1007	17.05	17.0632	132888.0
2012-02-09 05:00:00	AAPL	Stock	17.0825	17.0825	17.0714	17.0714	25200.0
2012-02-09 06:00:00	AAPL	Stock	17.0632	17.0714	17.0357	17.0357	107380.0
2012-02-09 07:00:00	AAPL	Stock	17.0382	17.0954	17.0357	17.0775	694596.0
2012-02-09 08:00:00	AAPL	Stock	17.0714	17.1507	16.9893	17.1464	5858132.0
2012-02-09 09:00:00	AAPL	Stock	17.1482	17.3579	17.1429	17.3485	140984116.0
2012-02-09 10:00:00	AAPL	Stock	17.3486	17.4979	17.2243	17.4625	165634588.0
2012-02-09 11:00:00	AAPL	Stock	17.4629	17.6829	17.4518	17.6253	204177680.0
2012-02-09 12:00:00	AAPL	Stock	17.6229	17.7411	17.6229	17.6796	108668924.0
2012-02-09 13:00:00	AAPL	Stock	17.6816	17.6818	17.5864	17.6012	74015200.0
2012-02-09 14:00:00	AAPL	Stock	17.6019	17.6964	17.5982	17.683	62119036.0
2012-02-09 15:00:00	AAPL	Stock	17.6837	17.6882	17.5729	17.6129	93577512.0
2012-02-09 16:00:00	AAPL	Stock	17.6132	17.6797	17.5289	17.6321	11196192.0
2012-02-09 17:00:00	AAPL	Stock	17.6282	17.6339	17.5914	17.6071	821240.0
2012-02-09 18:00:00	AAPL	Stock	17.6071	17.6421	17.6	17.6375	904288.0
2012-02-09 19:00:00	AAPL	Stock	17.6375	17.6675	17.6343	17.6675	1148140.0
2012-02-09 07:00:00	MSFT	Stock	30.55	30.55	30.48	30.55	9406.0
2012-02-09 08:00:00	MSFT	Stock	30.58	30.65	30.51	30.63	42349.0
2012-02-09 09:00:00	MSFT	Stock	30.59	30.75	30.56	30.655	5195856.0
2012-02-09 10:00:00	MSFT	Stock	30.66	30.69	30.5	30.59	8129177.0
2012-02-09 11:00:00	MSFT	Stock	30.59	30.69	30.48	30.65	6453076.0
2012-02-09 12:00:00	MSFT	Stock	30.65	30.72	30.59	30.65	5283960.0
2012-02-09 13:00:00	MSFT	Stock	30.65	30.8	30.624	30.74	5845274.0
2012-02-09 14:00:00	MSFT	Stock	30.75	30.76	30.68	30.719	3980760.0
2012-02-09 15:00:00	MSFT	Stock	30.72	30.78	30.7	30.77	9559645.0
2012-02-09 16:00:00	MSFT	Stock	30.77	30.8	30.514	30.78	4304050.0
2012-02-09 17:00:00	MSFT	Stock	30.75	30.77	30.75	30.77	11000.0
2012-02-09 18:00:00	MSFT	Stock	30.77	30.79	30.75	30.78	14286.0
2012-02-09 19:00:00	MSFT	Stock	30.78	30.79	30.76	30.76	14358.0
2012-02-09 07:00:00	NVDA	Stock	0.4032	0.4032	0.4032	0.4032	60000.0
2012-02-09 08:00:00	NVDA	Stock	0.4085	0.4108	0.4085	0.4088	108000.0
2012-02-09 09:00:00	NVDA	Stock	0.41	0.415	0.4088	0.4112	103539080.0
2012-02-09 10:00:00	NVDA	Stock	0.4112	0.4133	0.409	0.4129	93992920.0
2012-02-09 11:00:00	NVDA	Stock	0.4128	0.4133	0.409	0.4122	85194480.0
2012-02-09 12:00:00	NVDA	Stock	0.412	0.4125	0.4108	0.4115	28094000.0
2012-02-09 13:00:00	NVDA	Stock	0.4115	0.4125	0.4108	0.4115	33624120.0
2012-02-09 14:00:00	NVDA	Stock	0.4115	0.4122	0.408	0.408	65144160.0
2012-02-09 15:00:00	NVDA	Stock	0.4082	0.4088	0.4068	0.4072	134893800.0
2012-02-09 16:00:00	NVDA	Stock	0.4072	0.4127	0.4062	0.4075	13788560.0
2012-02-09 17:00:00	NVDA	Stock	0.4078	0.409	0.4078	0.409	120400.0
2012-02-09 18:00:00	NVDA	Stock	0.4075	0.4075	0.4075	0.4075	86000.0
2012-02-09 19:00:00	NVDA	Stock	0.4072	0.4072	0.4072	0.4072	12000.0
2012-02-09 06:00:00	AMZN	Stock	9.2875	9.2875	9.2875	9.2875	2000.0
2012-02-09 07:00:00	AMZN	Stock	9.273	9.2745	9.27	9.27	6000.0
2012-02-09 08:00:00	AMZN	Stock	9.2675	9.2975	9.2515	9.2715	188000.0
2012-02-09 09:00:00	AMZN	Stock	9.275	9.275	9.1285	9.1625	24776780.0
2012-02-09 10:00:00	AMZN	Stock	9.1655	9.1845	9.088	9.122	30328600.0
2012-02-09 11:00:00	AMZN	Stock	9.1245	9.1525	9.113	9.145	16345260.0
2012-02-09 12:00:00	AMZN	Stock	9.1495	9.2035	9.143	9.1742	17386420.0
2012-02-09 13:00:00	AMZN	Stock	9.1723	9.2415	9.161	9.2305	10838320.0

> showing 50 of 45,593 rows — these rows as CSV

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