PREVIEW / stock_1hour / 2012-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-15.parquet
  size:    953 KB
  rows:    45,101
  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
2012-06-15 04:00:00	AAPL	Stock	20.4714	20.4714	20.4714	20.4714	2800.0
2012-06-15 05:00:00	AAPL	Stock	20.48	20.48	20.48	20.48	2800.0
2012-06-15 06:00:00	AAPL	Stock	20.4821	20.4821	20.4821	20.4821	28560.0
2012-06-15 07:00:00	AAPL	Stock	20.4804	20.4964	20.4679	20.4679	121240.0
2012-06-15 08:00:00	AAPL	Stock	20.4793	20.4921	20.4186	20.4214	1257816.0
2012-06-15 09:00:00	AAPL	Stock	20.4214	20.4418	20.3411	20.4366	42779716.0
2012-06-15 10:00:00	AAPL	Stock	20.4314	20.4514	20.3514	20.3893	43285480.0
2012-06-15 11:00:00	AAPL	Stock	20.3889	20.4454	20.3664	20.4043	32475968.0
2012-06-15 12:00:00	AAPL	Stock	20.4061	20.4218	20.3693	20.375	17982244.0
2012-06-15 13:00:00	AAPL	Stock	20.3771	20.4011	20.3518	20.3679	20836564.0
2012-06-15 14:00:00	AAPL	Stock	20.3675	20.3836	20.3504	20.3639	19607728.0
2012-06-15 15:00:00	AAPL	Stock	20.3637	20.5221	20.3618	20.5046	79122092.0
2012-06-15 16:00:00	AAPL	Stock	20.5046	20.5268	20.4146	20.5079	29926400.0
2012-06-15 17:00:00	AAPL	Stock	20.5079	20.5143	20.5046	20.5079	402080.0
2012-06-15 18:00:00	AAPL	Stock	20.5079	20.5154	20.5071	20.5125	195552.0
2012-06-15 19:00:00	AAPL	Stock	20.5104	20.5139	20.5054	20.5125	393568.0
2012-06-15 07:00:00	MSFT	Stock	29.43	29.45	29.43	29.45	1800.0
2012-06-15 08:00:00	MSFT	Stock	29.43	29.49	29.41	29.47	17395.0
2012-06-15 09:00:00	MSFT	Stock	29.47	29.87	29.43	29.86	16076197.0
2012-06-15 10:00:00	MSFT	Stock	29.86	29.95	29.82	29.92	7189387.0
2012-06-15 11:00:00	MSFT	Stock	29.925	29.98	29.87	29.94	4026416.0
2012-06-15 12:00:00	MSFT	Stock	29.94	29.96	29.86	29.91	2769965.0
2012-06-15 13:00:00	MSFT	Stock	29.91	29.99	29.9	29.99	2859515.0
2012-06-15 14:00:00	MSFT	Stock	29.984	30.08	29.92	29.97	5474475.0
2012-06-15 15:00:00	MSFT	Stock	29.97	30.05	29.93	30.02	15038609.0
2012-06-15 16:00:00	MSFT	Stock	30.02	30.04	29.881	30.03	8050730.0
2012-06-15 17:00:00	MSFT	Stock	30.03	30.05	30.0	30.05	84085.0
2012-06-15 18:00:00	MSFT	Stock	30.05	30.09	30.04	30.09	2540.0
2012-06-15 19:00:00	MSFT	Stock	30.13	30.13	30.02	30.1	10438.0
2012-06-15 08:00:00	NVDA	Stock	0.3025	0.3038	0.3025	0.3038	68000.0
2012-06-15 09:00:00	NVDA	Stock	0.303	0.3038	0.3002	0.3022	64860480.0
2012-06-15 10:00:00	NVDA	Stock	0.3022	0.3042	0.3015	0.3035	43497800.0
2012-06-15 11:00:00	NVDA	Stock	0.3035	0.3042	0.303	0.3035	37603120.0
2012-06-15 12:00:00	NVDA	Stock	0.3035	0.305	0.3032	0.3045	40808240.0
2012-06-15 13:00:00	NVDA	Stock	0.3046	0.3058	0.3045	0.305	25721480.0
2012-06-15 14:00:00	NVDA	Stock	0.3052	0.307	0.305	0.3055	27931320.0
2012-06-15 15:00:00	NVDA	Stock	0.3052	0.3075	0.3052	0.3073	72179480.0
2012-06-15 16:00:00	NVDA	Stock	0.3073	0.3078	0.3047	0.3073	65711040.0
2012-06-15 17:00:00	NVDA	Stock	0.306	0.306	0.306	0.306	4000.0
2012-06-15 18:00:00	NVDA	Stock	0.308	0.308	0.308	0.308	132000.0
2012-06-15 19:00:00	NVDA	Stock	0.3078	0.3078	0.3078	0.3078	68600.0
2012-06-15 07:00:00	AMZN	Stock	10.79	10.79	10.7805	10.7815	6000.0
2012-06-15 08:00:00	AMZN	Stock	10.69	10.753	10.69	10.75	40980.0
2012-06-15 09:00:00	AMZN	Stock	10.7435	10.7935	10.723	10.7935	16825180.0
2012-06-15 10:00:00	AMZN	Stock	10.7928	10.8625	10.7855	10.8625	12728520.0
2012-06-15 11:00:00	AMZN	Stock	10.862	10.875	10.825	10.8255	5047180.0
2012-06-15 12:00:00	AMZN	Stock	10.825	10.843	10.8165	10.839	2423580.0
2012-06-15 13:00:00	AMZN	Stock	10.843	10.863	10.8307	10.8605	2438300.0
2012-06-15 14:00:00	AMZN	Stock	10.86	10.875	10.8395	10.8625	3233640.0
2012-06-15 15:00:00	AMZN	Stock	10.8645	10.9665	10.861	10.9175	18000480.0

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

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