PREVIEW / stock_1hour / 2012-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-19.parquet
  size:    914 KB
  rows:    43,431
  symbols: 3,485

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-07-19 04:00:00	AAPL	Stock	21.7839	21.8032	21.7839	21.8032	6020.0
2012-07-19 05:00:00	AAPL	Stock	21.7843	21.7846	21.7843	21.7846	19600.0
2012-07-19 06:00:00	AAPL	Stock	21.8	21.8143	21.7554	21.7821	79940.0
2012-07-19 07:00:00	AAPL	Stock	21.7786	21.7857	21.7286	21.7786	566272.0
2012-07-19 08:00:00	AAPL	Stock	21.7721	21.8129	21.75	21.7946	3001012.0
2012-07-19 09:00:00	AAPL	Stock	21.7996	21.8857	21.7232	21.7643	63477988.0
2012-07-19 10:00:00	AAPL	Stock	21.7632	21.8518	21.7411	21.7696	64127140.0
2012-07-19 11:00:00	AAPL	Stock	21.7739	21.87	21.7725	21.8257	51423064.0
2012-07-19 12:00:00	AAPL	Stock	21.8261	21.925	21.6429	21.8671	63838768.0
2012-07-19 13:00:00	AAPL	Stock	21.8675	21.9643	21.8664	21.8904	56707644.0
2012-07-19 14:00:00	AAPL	Stock	21.895	21.9643	21.8771	21.8896	49864836.0
2012-07-19 15:00:00	AAPL	Stock	21.8896	21.9768	21.8861	21.9436	65055200.0
2012-07-19 16:00:00	AAPL	Stock	21.9414	22.04	21.872	21.9429	10824156.0
2012-07-19 17:00:00	AAPL	Stock	21.9429	21.9589	21.9286	21.9554	432572.0
2012-07-19 18:00:00	AAPL	Stock	21.95	21.9782	21.9432	21.9782	261828.0
2012-07-19 19:00:00	AAPL	Stock	21.9732	22.0118	21.9732	22.0004	471940.0
2012-07-19 07:00:00	MSFT	Stock	30.5	30.62	30.5	30.62	1860.0
2012-07-19 08:00:00	MSFT	Stock	30.62	30.7	30.51	30.6	19866.0
2012-07-19 09:00:00	MSFT	Stock	30.61	30.8	30.38	30.72	4155436.0
2012-07-19 10:00:00	MSFT	Stock	30.71	30.74	30.47	30.642	6894576.0
2012-07-19 11:00:00	MSFT	Stock	30.65	30.71	30.58	30.67	5305617.0
2012-07-19 12:00:00	MSFT	Stock	30.67	30.75	30.47	30.71	4235155.0
2012-07-19 13:00:00	MSFT	Stock	30.71	30.72	30.46	30.53	4209732.0
2012-07-19 14:00:00	MSFT	Stock	30.54	30.67	30.53	30.625	3884461.0
2012-07-19 15:00:00	MSFT	Stock	30.63	30.74	30.57	30.61	9889773.0
2012-07-19 16:00:00	MSFT	Stock	30.61	31.5	29.79	31.45	6051880.0
2012-07-19 17:00:00	MSFT	Stock	31.44	31.48	31.35	31.42	302429.0
2012-07-19 18:00:00	MSFT	Stock	31.42	31.44	31.29	31.33	108046.0
2012-07-19 19:00:00	MSFT	Stock	31.33	31.33	31.27	31.32	36366.0
2012-07-19 08:00:00	NVDA	Stock	0.33	0.3313	0.3295	0.3308	253560.0
2012-07-19 09:00:00	NVDA	Stock	0.33	0.3321	0.3265	0.33	51261080.0
2012-07-19 10:00:00	NVDA	Stock	0.33	0.333	0.3283	0.3328	93042320.0
2012-07-19 11:00:00	NVDA	Stock	0.3326	0.3335	0.3315	0.3322	43528720.0
2012-07-19 12:00:00	NVDA	Stock	0.3322	0.334	0.3318	0.3325	43380720.0
2012-07-19 13:00:00	NVDA	Stock	0.3325	0.3338	0.3295	0.3304	47563320.0
2012-07-19 14:00:00	NVDA	Stock	0.3305	0.3318	0.3298	0.3305	29799400.0
2012-07-19 15:00:00	NVDA	Stock	0.3305	0.3309	0.3295	0.3298	78000960.0
2012-07-19 16:00:00	NVDA	Stock	0.3298	0.331	0.3265	0.3298	13689880.0
2012-07-19 17:00:00	NVDA	Stock	0.3298	0.3313	0.3298	0.3313	33400.0
2012-07-19 18:00:00	NVDA	Stock	0.33	0.3313	0.33	0.3313	102000.0
2012-07-19 06:00:00	AMZN	Stock	10.915	10.9155	10.915	10.9155	22000.0
2012-07-19 07:00:00	AMZN	Stock	10.95	10.9735	10.95	10.9625	24000.0
2012-07-19 08:00:00	AMZN	Stock	10.9735	11.01	10.95	11.01	826200.0
2012-07-19 09:00:00	AMZN	Stock	11.025	11.157	11.0125	11.137	16732040.0
2012-07-19 10:00:00	AMZN	Stock	11.1335	11.2025	11.069	11.1815	17758380.0
2012-07-19 11:00:00	AMZN	Stock	11.183	11.278	11.183	11.2605	14770140.0
2012-07-19 12:00:00	AMZN	Stock	11.2615	11.3645	11.2595	11.3035	14559120.0
2012-07-19 13:00:00	AMZN	Stock	11.307	11.3605	11.292	11.3045	10047320.0
2012-07-19 14:00:00	AMZN	Stock	11.3073	11.35	11.279	11.3325	6501780.0
2012-07-19 15:00:00	AMZN	Stock	11.334	11.375	11.305	11.308	16749520.0

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

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