PREVIEW / stock_1hour / 2013-04-09

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-09.parquet
  size:    973 KB
  rows:    45,213
  symbols: 3,494

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-09 05:00:00	AAPL	Stock	15.2668	15.2668	15.25	15.25	32172.0
2013-04-09 06:00:00	AAPL	Stock	15.25	15.25	15.2464	15.2464	5600.0
2013-04-09 07:00:00	AAPL	Stock	15.2464	15.28	15.2464	15.2521	168084.0
2013-04-09 08:00:00	AAPL	Stock	15.2486	15.28	15.1786	15.2364	1171968.0
2013-04-09 09:00:00	AAPL	Stock	15.2386	15.2761	15.1164	15.1402	41526884.0
2013-04-09 10:00:00	AAPL	Stock	15.1346	15.1693	15.1136	15.1399	38032008.0
2013-04-09 11:00:00	AAPL	Stock	15.1339	15.1446	15.0982	15.1143	30335396.0
2013-04-09 12:00:00	AAPL	Stock	15.1161	15.1911	15.1032	15.1796	26731880.0
2013-04-09 13:00:00	AAPL	Stock	15.1793	15.3036	15.1743	15.2371	46520908.0
2013-04-09 14:00:00	AAPL	Stock	15.2375	15.2643	15.1964	15.2211	29433488.0
2013-04-09 15:00:00	AAPL	Stock	15.2246	15.2796	15.2068	15.2493	51147124.0
2013-04-09 16:00:00	AAPL	Stock	15.2489	15.2679	15.114	15.2525	34571712.0
2013-04-09 17:00:00	AAPL	Stock	15.2543	15.3029	15.2493	15.2661	396592.0
2013-04-09 18:00:00	AAPL	Stock	15.2582	15.2729	15.2582	15.2679	205492.0
2013-04-09 19:00:00	AAPL	Stock	15.2679	15.2711	15.2575	15.2632	84952.0
2013-04-09 07:00:00	MSFT	Stock	28.79	28.85	28.7	28.7	3394.0
2013-04-09 08:00:00	MSFT	Stock	28.7	28.7	28.67	28.69	6700.0
2013-04-09 09:00:00	MSFT	Stock	28.66	28.87	28.66	28.795	4273594.0
2013-04-09 10:00:00	MSFT	Stock	28.8	29.19	28.77	29.109	11768465.0
2013-04-09 11:00:00	MSFT	Stock	29.105	29.25	28.96	29.226	7949452.0
2013-04-09 12:00:00	MSFT	Stock	29.23	29.5	29.21	29.485	7890504.0
2013-04-09 13:00:00	MSFT	Stock	29.49	29.815	29.47	29.6	16975308.0
2013-04-09 14:00:00	MSFT	Stock	29.6	29.73	29.455	29.695	9589096.0
2013-04-09 15:00:00	MSFT	Stock	29.7	29.76	29.61	29.638	14582668.0
2013-04-09 16:00:00	MSFT	Stock	29.61	29.72	28.59	29.61	3694497.0
2013-04-09 17:00:00	MSFT	Stock	29.59	29.61	29.58	29.58	79836.0
2013-04-09 18:00:00	MSFT	Stock	29.59	29.61	29.58	29.61	722.0
2013-04-09 19:00:00	MSFT	Stock	29.61	29.61	29.58	29.58	3522.0
2013-04-09 08:00:00	NVDA	Stock	0.31	0.31	0.3098	0.3098	40360.0
2013-04-09 09:00:00	NVDA	Stock	0.311	0.3125	0.3088	0.3098	25048680.0
2013-04-09 10:00:00	NVDA	Stock	0.3096	0.312	0.3095	0.3105	49054040.0
2013-04-09 11:00:00	NVDA	Stock	0.3105	0.3108	0.3089	0.3105	18800120.0
2013-04-09 12:00:00	NVDA	Stock	0.3105	0.3123	0.31	0.312	19361040.0
2013-04-09 13:00:00	NVDA	Stock	0.3119	0.3165	0.3118	0.316	74564680.0
2013-04-09 14:00:00	NVDA	Stock	0.316	0.318	0.3158	0.3178	52025040.0
2013-04-09 15:00:00	NVDA	Stock	0.3176	0.3178	0.3155	0.3158	125318440.0
2013-04-09 16:00:00	NVDA	Stock	0.3158	0.316	0.3143	0.3158	2430600.0
2013-04-09 18:00:00	NVDA	Stock	0.3153	0.3153	0.3153	0.3153	8000.0
2013-04-09 08:00:00	AMZN	Stock	13.056	13.056	12.975	12.978	45800.0
2013-04-09 09:00:00	AMZN	Stock	12.984	12.9925	12.85	12.8675	6648020.0
2013-04-09 10:00:00	AMZN	Stock	12.8715	13.013	12.8685	12.9385	8694160.0
2013-04-09 11:00:00	AMZN	Stock	12.943	13.05	12.9275	13.0475	5998280.0
2013-04-09 12:00:00	AMZN	Stock	13.047	13.09	13.0305	13.0355	3728080.0
2013-04-09 13:00:00	AMZN	Stock	13.035	13.0995	13.032	13.07	3089600.0
2013-04-09 14:00:00	AMZN	Stock	13.0755	13.1305	13.0715	13.1035	4857180.0
2013-04-09 15:00:00	AMZN	Stock	13.1035	13.1125	13.05	13.059	6901260.0
2013-04-09 16:00:00	AMZN	Stock	13.0555	13.0645	13.0082	13.057	391120.0
2013-04-09 17:00:00	AMZN	Stock	13.064	13.064	13.057	13.063	9920.0
2013-04-09 18:00:00	AMZN	Stock	13.064	13.064	13.064	13.064	12000.0
2013-04-09 19:00:00	AMZN	Stock	13.064	13.0645	13.058	13.058	24500.0

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

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