PREVIEW / stock_1hour / 2012-03-30

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-30.parquet
  size:    952 KB
  rows:    44,696
  symbols: 3,557

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-03-30 04:00:00	AAPL	Stock	21.6193	21.655	21.6193	21.655	26600.0
2012-03-30 05:00:00	AAPL	Stock	21.6189	21.6782	21.6189	21.6782	34188.0
2012-03-30 06:00:00	AAPL	Stock	21.6789	21.7143	21.6432	21.7104	66864.0
2012-03-30 07:00:00	AAPL	Stock	21.7068	21.8429	21.7068	21.8111	2202956.0
2012-03-30 08:00:00	AAPL	Stock	21.8179	21.8661	21.7	21.7036	6233640.0
2012-03-30 09:00:00	AAPL	Stock	21.7064	21.8057	21.6171	21.6407	110397812.0
2012-03-30 10:00:00	AAPL	Stock	21.6399	21.6857	21.355	21.5224	226094120.0
2012-03-30 11:00:00	AAPL	Stock	21.5218	21.5868	21.5004	21.5311	81201988.0
2012-03-30 12:00:00	AAPL	Stock	21.5307	21.5339	21.4393	21.4725	61058676.0
2012-03-30 13:00:00	AAPL	Stock	21.4686	21.5179	21.4572	21.4746	31156020.0
2012-03-30 14:00:00	AAPL	Stock	21.4739	21.5046	21.4125	21.442	62056708.0
2012-03-30 15:00:00	AAPL	Stock	21.4431	21.475	21.3939	21.4096	116481988.0
2012-03-30 16:00:00	AAPL	Stock	21.4121	21.5312	21.4004	21.4196	24074176.0
2012-03-30 17:00:00	AAPL	Stock	21.4214	21.445	21.4111	21.445	1092980.0
2012-03-30 18:00:00	AAPL	Stock	21.4457	21.4875	21.4329	21.4793	1335404.0
2012-03-30 19:00:00	AAPL	Stock	21.4793	21.4882	21.4668	21.475	681996.0
2012-03-30 07:00:00	MSFT	Stock	32.28	32.28	32.1	32.25	15953.0
2012-03-30 08:00:00	MSFT	Stock	32.25	32.4	32.2	32.34	25613.0
2012-03-30 09:00:00	MSFT	Stock	32.32	32.42	32.14	32.15	2601465.0
2012-03-30 10:00:00	MSFT	Stock	32.143	32.23	32.04	32.13	3902694.0
2012-03-30 11:00:00	MSFT	Stock	32.135	32.4	32.125	32.35	3610099.0
2012-03-30 12:00:00	MSFT	Stock	32.345	32.36	32.28	32.28	3577872.0
2012-03-30 13:00:00	MSFT	Stock	32.29	32.31	32.24	32.245	2512223.0
2012-03-30 14:00:00	MSFT	Stock	32.25	32.31	32.22	32.22	2250888.0
2012-03-30 15:00:00	MSFT	Stock	32.23	32.27	32.12	32.24	7320498.0
2012-03-30 16:00:00	MSFT	Stock	32.24	32.3	32.2	32.26	5526752.0
2012-03-30 17:00:00	MSFT	Stock	32.26	32.26	32.25	32.26	3172.0
2012-03-30 18:00:00	MSFT	Stock	32.26	32.26	32.26	32.26	200.0
2012-03-30 19:00:00	MSFT	Stock	32.25	32.26	32.1	32.26	5200.0
2012-03-30 09:00:00	NVDA	Stock	0.3825	0.386	0.3822	0.3826	63531960.0
2012-03-30 10:00:00	NVDA	Stock	0.3825	0.384	0.3785	0.3801	86282040.0
2012-03-30 11:00:00	NVDA	Stock	0.38	0.3858	0.38	0.3858	60689360.0
2012-03-30 12:00:00	NVDA	Stock	0.3856	0.386	0.3845	0.3849	59097000.0
2012-03-30 13:00:00	NVDA	Stock	0.3849	0.3862	0.3848	0.3858	46849040.0
2012-03-30 14:00:00	NVDA	Stock	0.3858	0.3873	0.3858	0.3862	53715280.0
2012-03-30 15:00:00	NVDA	Stock	0.3862	0.3862	0.3835	0.385	119622280.0
2012-03-30 16:00:00	NVDA	Stock	0.3848	0.3849	0.3839	0.3848	34441080.0
2012-03-30 19:00:00	NVDA	Stock	0.3848	0.3848	0.3848	0.3848	40000.0
2012-03-30 07:00:00	AMZN	Stock	10.2535	10.275	10.2325	10.275	20000.0
2012-03-30 08:00:00	AMZN	Stock	10.2725	10.3	10.251	10.2838	242260.0
2012-03-30 09:00:00	AMZN	Stock	10.2735	10.3425	10.1825	10.189	18011780.0
2012-03-30 10:00:00	AMZN	Stock	10.1831	10.255	10.0935	10.1606	24041900.0
2012-03-30 11:00:00	AMZN	Stock	10.1585	10.215	10.158	10.188	10583600.0
2012-03-30 12:00:00	AMZN	Stock	10.1875	10.2115	10.173	10.1805	5341780.0
2012-03-30 13:00:00	AMZN	Stock	10.1805	10.22	10.179	10.217	3713400.0
2012-03-30 14:00:00	AMZN	Stock	10.2165	10.2234	10.137	10.1435	7242540.0
2012-03-30 15:00:00	AMZN	Stock	10.1445	10.174	10.125	10.1325	12982000.0
2012-03-30 16:00:00	AMZN	Stock	10.1215	10.1957	10.102	10.135	766860.0
2012-03-30 17:00:00	AMZN	Stock	10.1315	10.1355	10.1295	10.1295	38000.0
2012-03-30 18:00:00	AMZN	Stock	10.13	10.1325	10.129	10.13	17060.0

> showing 50 of 44,696 rows — these rows as CSV

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