PREVIEW / stock_1hour / 2013-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-09.parquet
  size:    999 KB
  rows:    45,994
  symbols: 3,522

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-08-09 04:00:00	AAPL	Stock	16.4446	16.4446	16.4446	16.4446	10640.0
2013-08-09 05:00:00	AAPL	Stock	16.4268	16.4268	16.3786	16.3786	11032.0
2013-08-09 07:00:00	AAPL	Stock	16.3929	16.425	16.3896	16.4161	91672.0
2013-08-09 08:00:00	AAPL	Stock	16.3679	16.4211	16.3661	16.4132	395640.0
2013-08-09 09:00:00	AAPL	Stock	16.42	16.445	16.3525	16.3793	42732116.0
2013-08-09 10:00:00	AAPL	Stock	16.3775	16.3971	16.2268	16.2439	66593408.0
2013-08-09 11:00:00	AAPL	Stock	16.2446	16.2982	16.2329	16.2932	39409748.0
2013-08-09 12:00:00	AAPL	Stock	16.2932	16.3007	16.2649	16.2761	16212672.0
2013-08-09 13:00:00	AAPL	Stock	16.2796	16.2964	16.2464	16.2611	16979984.0
2013-08-09 14:00:00	AAPL	Stock	16.2611	16.2764	16.2396	16.2586	19000156.0
2013-08-09 15:00:00	AAPL	Stock	16.2586	16.2614	16.2018	16.2293	43048880.0
2013-08-09 16:00:00	AAPL	Stock	16.2304	16.2916	16.1975	16.2071	7856324.0
2013-08-09 17:00:00	AAPL	Stock	16.2143	16.2746	16.2136	16.2746	1201284.0
2013-08-09 18:00:00	AAPL	Stock	16.2696	16.2746	16.2514	16.2654	375732.0
2013-08-09 19:00:00	AAPL	Stock	16.2654	16.2714	16.2593	16.2614	153160.0
2013-08-09 08:00:00	MSFT	Stock	32.71	32.82	32.71	32.78	13400.0
2013-08-09 09:00:00	MSFT	Stock	32.78	32.85	32.71	32.76	3249428.0
2013-08-09 10:00:00	MSFT	Stock	32.76	32.815	32.6	32.63	4431485.0
2013-08-09 11:00:00	MSFT	Stock	32.623	32.73	32.47	32.699	4361283.0
2013-08-09 12:00:00	MSFT	Stock	32.69	32.81	32.69	32.77	3298729.0
2013-08-09 13:00:00	MSFT	Stock	32.78	32.9	32.75	32.847	2860310.0
2013-08-09 14:00:00	MSFT	Stock	32.85	32.86	32.62	32.666	2586747.0
2013-08-09 15:00:00	MSFT	Stock	32.66	32.71	32.6	32.7	4083103.0
2013-08-09 16:00:00	MSFT	Stock	32.7	32.77	32.65	32.76	1566916.0
2013-08-09 17:00:00	MSFT	Stock	32.71	32.82	32.71	32.71	1086.0
2013-08-09 18:00:00	MSFT	Stock	32.74	32.74	32.66	32.66	2407.0
2013-08-09 19:00:00	MSFT	Stock	32.7	32.7	32.7	32.7	385.0
2013-08-09 04:00:00	NVDA	Stock	0.3625	0.3625	0.3625	0.3625	8000.0
2013-08-09 05:00:00	NVDA	Stock	0.3625	0.3625	0.3625	0.3625	4000.0
2013-08-09 06:00:00	NVDA	Stock	0.3625	0.3625	0.3625	0.3625	4000.0
2013-08-09 07:00:00	NVDA	Stock	0.3588	0.3588	0.3575	0.3575	220000.0
2013-08-09 08:00:00	NVDA	Stock	0.3575	0.3575	0.35	0.3538	1947000.0
2013-08-09 09:00:00	NVDA	Stock	0.3548	0.3625	0.3513	0.356	170058040.0
2013-08-09 10:00:00	NVDA	Stock	0.356	0.3678	0.3553	0.3651	212528440.0
2013-08-09 11:00:00	NVDA	Stock	0.3651	0.3652	0.3598	0.3648	118894120.0
2013-08-09 12:00:00	NVDA	Stock	0.3648	0.365	0.3602	0.3612	93820000.0
2013-08-09 13:00:00	NVDA	Stock	0.3612	0.3615	0.3585	0.3588	62326200.0
2013-08-09 14:00:00	NVDA	Stock	0.3588	0.3598	0.3575	0.3582	83007640.0
2013-08-09 15:00:00	NVDA	Stock	0.3582	0.3635	0.3582	0.3625	131626120.0
2013-08-09 16:00:00	NVDA	Stock	0.3622	0.3622	0.3618	0.3618	9488840.0
2013-08-09 17:00:00	NVDA	Stock	0.362	0.362	0.362	0.362	8000.0
2013-08-09 07:00:00	AMZN	Stock	14.766	14.766	14.76	14.76	4000.0
2013-08-09 08:00:00	AMZN	Stock	14.7545	14.76	14.7375	14.7375	15700.0
2013-08-09 09:00:00	AMZN	Stock	14.755	14.9305	14.715	14.8882	8086100.0
2013-08-09 10:00:00	AMZN	Stock	14.8964	14.9615	14.8168	14.9	6806000.0
2013-08-09 11:00:00	AMZN	Stock	14.903	14.917	14.825	14.877	7104440.0
2013-08-09 12:00:00	AMZN	Stock	14.8765	14.9635	14.8675	14.935	3548660.0
2013-08-09 13:00:00	AMZN	Stock	14.935	14.95	14.8754	14.8754	2389540.0
2013-08-09 14:00:00	AMZN	Stock	14.879	14.894	14.851	14.8695	2553000.0
2013-08-09 15:00:00	AMZN	Stock	14.876	14.889	14.851	14.868	6548400.0

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

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