PREVIEW / stock_1hour / 2013-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-20.parquet
  size:    1.0 MB
  rows:    47,959
  symbols: 3,533

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-20 04:00:00	AAPL	Stock	18.2143	18.2143	17.9839	18.0146	105000.0
2013-08-20 05:00:00	AAPL	Stock	18.0146	18.08	18.0146	18.08	63756.0
2013-08-20 06:00:00	AAPL	Stock	18.08	18.1357	18.08	18.1357	44128.0
2013-08-20 07:00:00	AAPL	Stock	18.1339	18.2529	18.11	18.2268	677012.0
2013-08-20 08:00:00	AAPL	Stock	18.2357	18.2457	18.1429	18.2118	2558388.0
2013-08-20 09:00:00	AAPL	Stock	18.2143	18.2346	18.0096	18.0354	76714848.0
2013-08-20 10:00:00	AAPL	Stock	18.0354	18.0693	17.8864	17.9675	108320044.0
2013-08-20 11:00:00	AAPL	Stock	17.9675	18.0482	17.9593	17.9986	33859896.0
2013-08-20 12:00:00	AAPL	Stock	17.9986	18.0179	17.9464	18.0	23511600.0
2013-08-20 13:00:00	AAPL	Stock	18.0011	18.0096	17.9471	17.9914	22052576.0
2013-08-20 14:00:00	AAPL	Stock	17.9895	17.9993	17.9525	17.9668	20599908.0
2013-08-20 15:00:00	AAPL	Stock	17.9682	17.9918	17.8875	17.8961	54471844.0
2013-08-20 16:00:00	AAPL	Stock	17.9028	18.0036	17.895	17.9232	9936416.0
2013-08-20 17:00:00	AAPL	Stock	17.9204	17.9339	17.8954	17.9336	430472.0
2013-08-20 18:00:00	AAPL	Stock	17.9264	17.9318	17.9175	17.9214	154392.0
2013-08-20 19:00:00	AAPL	Stock	17.9161	17.9464	17.9139	17.9464	405496.0
2013-08-20 08:00:00	MSFT	Stock	31.44	31.49	31.42	31.49	1800.0
2013-08-20 09:00:00	MSFT	Stock	31.45	31.78	31.37	31.77	3526677.0
2013-08-20 10:00:00	MSFT	Stock	31.77	31.79	31.6	31.67	4477914.0
2013-08-20 11:00:00	MSFT	Stock	31.67	31.9	31.61	31.81	3517464.0
2013-08-20 12:00:00	MSFT	Stock	31.81	31.895	31.67	31.743	2311988.0
2013-08-20 13:00:00	MSFT	Stock	31.74	31.81	31.62	31.655	1589524.0
2013-08-20 14:00:00	MSFT	Stock	31.654	31.78	31.63	31.69	2051955.0
2013-08-20 15:00:00	MSFT	Stock	31.69	31.77	31.6	31.63	3292638.0
2013-08-20 16:00:00	MSFT	Stock	31.62	31.87	31.61	31.7	1897094.0
2013-08-20 17:00:00	MSFT	Stock	31.7	31.7	31.63	31.63	359.0
2013-08-20 09:00:00	NVDA	Stock	0.3718	0.3755	0.3713	0.3743	36503480.0
2013-08-20 10:00:00	NVDA	Stock	0.3743	0.3763	0.3735	0.375	36089320.0
2013-08-20 11:00:00	NVDA	Stock	0.3748	0.3755	0.374	0.3751	25057160.0
2013-08-20 12:00:00	NVDA	Stock	0.3751	0.3754	0.3745	0.3749	29380320.0
2013-08-20 13:00:00	NVDA	Stock	0.375	0.376	0.3745	0.3746	33625160.0
2013-08-20 14:00:00	NVDA	Stock	0.3745	0.3748	0.3731	0.3739	20350160.0
2013-08-20 15:00:00	NVDA	Stock	0.374	0.3753	0.3738	0.374	45451760.0
2013-08-20 16:00:00	NVDA	Stock	0.3738	0.3738	0.3735	0.3738	679800.0
2013-08-20 06:00:00	AMZN	Stock	14.278	14.2825	14.278	14.2825	4000.0
2013-08-20 07:00:00	AMZN	Stock	14.3	14.3425	14.3	14.3425	10000.0
2013-08-20 08:00:00	AMZN	Stock	14.314	14.35	14.3105	14.3105	64000.0
2013-08-20 09:00:00	AMZN	Stock	14.3405	14.422	14.287	14.3625	4370980.0
2013-08-20 10:00:00	AMZN	Stock	14.36	14.4466	14.3185	14.425	4794680.0
2013-08-20 11:00:00	AMZN	Stock	14.4205	14.4758	14.4177	14.434	4964960.0
2013-08-20 12:00:00	AMZN	Stock	14.431	14.4575	14.3645	14.404	2151420.0
2013-08-20 13:00:00	AMZN	Stock	14.4045	14.4675	14.3948	14.4195	3665640.0
2013-08-20 14:00:00	AMZN	Stock	14.416	14.4544	14.406	14.4282	3763300.0
2013-08-20 15:00:00	AMZN	Stock	14.4312	14.44	14.35	14.364	5401480.0
2013-08-20 16:00:00	AMZN	Stock	14.3545	14.4315	14.297	14.314	2488800.0
2013-08-20 17:00:00	AMZN	Stock	14.3215	14.3215	14.3215	14.3215	2000.0
2013-08-20 18:00:00	AMZN	Stock	14.3715	14.384	14.3715	14.384	16000.0
2013-08-20 19:00:00	AMZN	Stock	14.3605	14.3605	14.3605	14.3605	3520.0
2013-08-20 04:00:00	META	Stock	37.86	37.99	37.86	37.98	5390.0
2013-08-20 05:00:00	META	Stock	37.87	37.91	37.87	37.91	783.0

> showing 50 of 47,959 rows — these rows as CSV

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