PREVIEW / stock_1hour / 2013-04-29

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-29.parquet
  size:    976 KB
  rows:    45,772
  symbols: 3,507

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
2013-04-29 04:00:00	AAPL	Stock	14.9464	15.3286	14.9464	14.9607	42364.0
2013-04-29 06:00:00	AAPL	Stock	14.9786	14.9829	14.9643	14.9754	38528.0
2013-04-29 07:00:00	AAPL	Stock	14.9732	15.0232	14.9546	14.9818	603736.0
2013-04-29 08:00:00	AAPL	Stock	14.9729	15.0243	14.9643	14.9893	1861468.0
2013-04-29 09:00:00	AAPL	Stock	14.9893	15.213	14.975	15.1389	92760052.0
2013-04-29 10:00:00	AAPL	Stock	15.1389	15.3179	15.1336	15.2686	97769112.0
2013-04-29 11:00:00	AAPL	Stock	15.2633	15.3525	15.2618	15.3511	53916436.0
2013-04-29 12:00:00	AAPL	Stock	15.3511	15.4863	15.3375	15.4075	96405372.0
2013-04-29 13:00:00	AAPL	Stock	15.4078	15.4586	15.365	15.4214	51855944.0
2013-04-29 14:00:00	AAPL	Stock	15.4214	15.4732	15.4025	15.4604	37179044.0
2013-04-29 15:00:00	AAPL	Stock	15.4607	15.4704	15.3571	15.3611	82689880.0
2013-04-29 16:00:00	AAPL	Stock	15.3614	15.4304	15.1307	15.3571	53250988.0
2013-04-29 17:00:00	AAPL	Stock	15.3571	15.3735	15.2412	15.3618	422352.0
2013-04-29 18:00:00	AAPL	Stock	15.3586	15.3657	15.3571	15.3589	181160.0
2013-04-29 19:00:00	AAPL	Stock	15.3571	15.3661	15.3554	15.3643	307776.0
2013-04-29 05:00:00	MSFT	Stock	32.1	32.12	32.1	32.12	990.0
2013-04-29 07:00:00	MSFT	Stock	31.84	31.84	31.82	31.82	900.0
2013-04-29 08:00:00	MSFT	Stock	31.82	31.86	31.82	31.85	7629.0
2013-04-29 09:00:00	MSFT	Stock	31.85	32.33	31.76	32.25	8032439.0
2013-04-29 10:00:00	MSFT	Stock	32.255	32.63	32.255	32.501	11493050.0
2013-04-29 11:00:00	MSFT	Stock	32.5	32.52	32.41	32.5	6323176.0
2013-04-29 12:00:00	MSFT	Stock	32.49	32.52	32.44	32.45	4385094.0
2013-04-29 13:00:00	MSFT	Stock	32.45	32.55	32.44	32.545	4191313.0
2013-04-29 14:00:00	MSFT	Stock	32.545	32.68	32.54	32.655	6024672.0
2013-04-29 15:00:00	MSFT	Stock	32.655	32.67	32.44	32.62	11777601.0
2013-04-29 16:00:00	MSFT	Stock	32.61	32.65	32.456	32.6	2214915.0
2013-04-29 17:00:00	MSFT	Stock	32.6	32.62	32.475	32.61	174819.0
2013-04-29 18:00:00	MSFT	Stock	32.58	32.58	32.57	32.57	234.0
2013-04-29 19:00:00	MSFT	Stock	32.57	32.59	32.56	32.59	5744.0
2013-04-29 09:00:00	NVDA	Stock	0.3358	0.3382	0.3342	0.3376	24082880.0
2013-04-29 10:00:00	NVDA	Stock	0.3378	0.3398	0.3368	0.3376	60011480.0
2013-04-29 11:00:00	NVDA	Stock	0.3378	0.339	0.3375	0.3389	57500200.0
2013-04-29 12:00:00	NVDA	Stock	0.339	0.3405	0.3388	0.3395	25639880.0
2013-04-29 13:00:00	NVDA	Stock	0.3395	0.3402	0.339	0.339	20828960.0
2013-04-29 14:00:00	NVDA	Stock	0.339	0.3393	0.3382	0.339	18878000.0
2013-04-29 15:00:00	NVDA	Stock	0.3393	0.3395	0.338	0.3393	40820520.0
2013-04-29 16:00:00	NVDA	Stock	0.3393	0.3395	0.3388	0.3388	2369600.0
2013-04-29 17:00:00	NVDA	Stock	0.3393	0.3393	0.3393	0.3393	21000.0
2013-04-29 18:00:00	NVDA	Stock	0.3405	0.3405	0.3405	0.3405	21600.0
2013-04-29 04:00:00	AMZN	Stock	12.743	12.743	12.726	12.726	18480.0
2013-04-29 05:00:00	AMZN	Stock	12.772	12.772	12.772	12.772	4000.0
2013-04-29 07:00:00	AMZN	Stock	12.736	12.7695	12.708	12.708	90140.0
2013-04-29 08:00:00	AMZN	Stock	12.725	12.75	12.7055	12.725	535740.0
2013-04-29 09:00:00	AMZN	Stock	12.729	12.8505	12.6125	12.7145	26726860.0
2013-04-29 10:00:00	AMZN	Stock	12.721	12.7935	12.5835	12.6915	26231720.0
2013-04-29 11:00:00	AMZN	Stock	12.6957	12.7875	12.642	12.6625	14564440.0
2013-04-29 12:00:00	AMZN	Stock	12.666	12.668	12.575	12.61	14308940.0
2013-04-29 13:00:00	AMZN	Stock	12.611	12.6665	12.555	12.5557	13630440.0
2013-04-29 14:00:00	AMZN	Stock	12.558	12.59	12.531	12.5475	14324780.0
2013-04-29 15:00:00	AMZN	Stock	12.548	12.553	12.4575	12.481	29520560.0

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

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