PREVIEW / stock_1hour / 2016-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-09.parquet
  size:    1.0 MB
  rows:    48,194
  symbols: 3,288

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
2016-06-09 04:00:00	AAPL	Stock	24.625	24.625	24.625	24.625	800.0
2016-06-09 05:00:00	AAPL	Stock	24.615	24.6325	24.615	24.625	8800.0
2016-06-09 06:00:00	AAPL	Stock	24.625	24.625	24.625	24.625	4800.0
2016-06-09 07:00:00	AAPL	Stock	24.6375	24.66	24.635	24.6375	18260.0
2016-06-09 08:00:00	AAPL	Stock	24.625	24.695	24.625	24.67	181624.0
2016-06-09 09:00:00	AAPL	Stock	24.6675	24.8875	24.615	24.8475	18003724.0
2016-06-09 10:00:00	AAPL	Stock	24.8498	24.925	24.795	24.8975	17392128.0
2016-06-09 11:00:00	AAPL	Stock	24.8955	24.995	24.8825	24.9682	13673732.0
2016-06-09 12:00:00	AAPL	Stock	24.9675	24.9688	24.878	24.9325	8687224.0
2016-06-09 13:00:00	AAPL	Stock	24.93	24.9975	24.89	24.927	10567244.0
2016-06-09 14:00:00	AAPL	Stock	24.9275	24.9725	24.8875	24.91	9946768.0
2016-06-09 15:00:00	AAPL	Stock	24.9125	24.9475	24.9	24.915	13403644.0
2016-06-09 16:00:00	AAPL	Stock	24.9125	24.92	24.828	24.9	4470576.0
2016-06-09 17:00:00	AAPL	Stock	24.9	24.91	24.89	24.9025	19496.0
2016-06-09 18:00:00	AAPL	Stock	24.895	24.9075	24.89	24.9025	30092.0
2016-06-09 19:00:00	AAPL	Stock	24.905	24.9225	24.9	24.92	39136.0
2016-06-09 08:00:00	MSFT	Stock	52.05	52.05	51.83	51.83	2349.0
2016-06-09 09:00:00	MSFT	Stock	51.8	52.0	51.71	51.903	1849246.0
2016-06-09 10:00:00	MSFT	Stock	51.905	51.965	51.73	51.745	2739312.0
2016-06-09 11:00:00	MSFT	Stock	51.745	51.78	51.58	51.633	1890608.0
2016-06-09 12:00:00	MSFT	Stock	51.635	51.74	51.49	51.725	1568564.0
2016-06-09 13:00:00	MSFT	Stock	51.725	51.86	51.595	51.67	1602388.0
2016-06-09 14:00:00	MSFT	Stock	51.664	51.81	51.615	51.725	1560480.0
2016-06-09 15:00:00	MSFT	Stock	51.73	51.77	51.62	51.62	4248999.0
2016-06-09 16:00:00	MSFT	Stock	51.62	51.65	51.62	51.63	3578992.0
2016-06-09 17:00:00	MSFT	Stock	51.63	51.63	51.5	51.62	3600.0
2016-06-09 18:00:00	MSFT	Stock	51.62	51.62	51.52	51.52	300.0
2016-06-09 19:00:00	MSFT	Stock	51.54	51.65	51.54	51.56	300.0
2016-06-09 06:00:00	NVDA	Stock	1.1528	1.1528	1.1528	1.1528	20000.0
2016-06-09 07:00:00	NVDA	Stock	1.1528	1.1528	1.1525	1.1525	24000.0
2016-06-09 08:00:00	NVDA	Stock	1.1588	1.1588	1.1555	1.1555	35600.0
2016-06-09 09:00:00	NVDA	Stock	1.1525	1.1574	1.148	1.1535	24693000.0
2016-06-09 10:00:00	NVDA	Stock	1.1536	1.1721	1.1495	1.1702	65102920.0
2016-06-09 11:00:00	NVDA	Stock	1.1705	1.1828	1.17	1.1745	70387920.0
2016-06-09 12:00:00	NVDA	Stock	1.1745	1.1808	1.1718	1.1805	33066480.0
2016-06-09 13:00:00	NVDA	Stock	1.181	1.1813	1.1758	1.1795	36579120.0
2016-06-09 14:00:00	NVDA	Stock	1.1794	1.1862	1.1765	1.1861	83037120.0
2016-06-09 15:00:00	NVDA	Stock	1.186	1.1862	1.1815	1.1845	87456160.0
2016-06-09 16:00:00	NVDA	Stock	1.1845	1.1848	1.1838	1.1848	34669440.0
2016-06-09 17:00:00	NVDA	Stock	1.1838	1.185	1.1838	1.1845	179000.0
2016-06-09 18:00:00	NVDA	Stock	1.1845	1.1845	1.1838	1.1838	42000.0
2016-06-09 19:00:00	NVDA	Stock	1.1825	1.184	1.1825	1.184	17280.0
2016-06-09 06:00:00	AMZN	Stock	36.226	36.226	36.226	36.226	2000.0
2016-06-09 07:00:00	AMZN	Stock	36.201	36.201	36.2	36.2	4240.0
2016-06-09 08:00:00	AMZN	Stock	36.2595	36.2595	36.1355	36.1455	89820.0
2016-06-09 09:00:00	AMZN	Stock	36.1575	36.336	36.115	36.308	6016140.0
2016-06-09 10:00:00	AMZN	Stock	36.294	36.4455	36.24	36.377	8549560.0
2016-06-09 11:00:00	AMZN	Stock	36.3795	36.383	36.2565	36.2995	3877460.0
2016-06-09 12:00:00	AMZN	Stock	36.3	36.366	36.206	36.3605	3385400.0
2016-06-09 13:00:00	AMZN	Stock	36.363	36.409	36.3005	36.3445	2664960.0

> showing 50 of 48,194 rows — these rows as CSV

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