PREVIEW / stock_1hour / 2016-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-30.parquet
  size:    1.1 MB
  rows:    49,706
  symbols: 3,306

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-30 04:00:00	AAPL	Stock	23.5875	23.5875	23.5875	23.5875	2120.0
2016-06-30 05:00:00	AAPL	Stock	23.5875	23.5875	23.5875	23.5875	9188.0
2016-06-30 06:00:00	AAPL	Stock	23.6	23.6	23.5975	23.6	3024.0
2016-06-30 07:00:00	AAPL	Stock	23.585	23.5875	23.525	23.525	30664.0
2016-06-30 08:00:00	AAPL	Stock	23.575	23.585	23.5	23.5525	201716.0
2016-06-30 09:00:00	AAPL	Stock	23.5425	23.7025	23.5375	23.63	16364472.0
2016-06-30 10:00:00	AAPL	Stock	23.631	23.755	23.5925	23.7512	18256932.0
2016-06-30 11:00:00	AAPL	Stock	23.7525	23.8725	23.7375	23.865	16680640.0
2016-06-30 12:00:00	AAPL	Stock	23.865	23.895	23.8075	23.8725	15974336.0
2016-06-30 13:00:00	AAPL	Stock	23.874	23.89	23.835	23.8675	10343208.0
2016-06-30 14:00:00	AAPL	Stock	23.87	23.9375	23.8662	23.92	11654292.0
2016-06-30 15:00:00	AAPL	Stock	23.9225	23.9425	23.8425	23.9025	21315468.0
2016-06-30 16:00:00	AAPL	Stock	23.9025	23.9025	23.8525	23.8675	16543572.0
2016-06-30 17:00:00	AAPL	Stock	23.897	23.9	23.8425	23.86	2450772.0
2016-06-30 18:00:00	AAPL	Stock	23.86	23.9	23.86	23.875	28136.0
2016-06-30 19:00:00	AAPL	Stock	23.8925	23.8925	23.8475	23.85	30656.0
2016-06-30 07:00:00	MSFT	Stock	50.62	50.63	50.43	50.43	1425.0
2016-06-30 08:00:00	MSFT	Stock	50.56	50.66	50.55	50.66	2688.0
2016-06-30 09:00:00	MSFT	Stock	50.69	50.83	50.5	50.52	2365538.0
2016-06-30 10:00:00	MSFT	Stock	50.525	50.96	50.5	50.92	2363930.0
2016-06-30 11:00:00	MSFT	Stock	50.925	51.175	50.85	51.075	2630049.0
2016-06-30 12:00:00	MSFT	Stock	51.08	51.3	51.06	51.09	3214317.0
2016-06-30 13:00:00	MSFT	Stock	51.09	51.13	50.85	51.0	2746278.0
2016-06-30 14:00:00	MSFT	Stock	51.0	51.13	50.97	51.08	2172087.0
2016-06-30 15:00:00	MSFT	Stock	51.08	51.19	50.96	51.17	5567034.0
2016-06-30 16:00:00	MSFT	Stock	51.17	51.2	51.07	51.17	5792085.0
2016-06-30 17:00:00	MSFT	Stock	51.164	51.17	51.08	51.08	126483.0
2016-06-30 18:00:00	MSFT	Stock	51.07	51.07	51.07	51.07	1178.0
2016-06-30 19:00:00	MSFT	Stock	51.1	51.11	51.09	51.11	1650.0
2016-06-30 06:00:00	NVDA	Stock	1.1728	1.1728	1.1728	1.1728	4000.0
2016-06-30 08:00:00	NVDA	Stock	1.1668	1.1668	1.1668	1.1668	44000.0
2016-06-30 09:00:00	NVDA	Stock	1.17	1.1722	1.1615	1.1668	26277480.0
2016-06-30 10:00:00	NVDA	Stock	1.1668	1.1682	1.1588	1.1613	40035480.0
2016-06-30 11:00:00	NVDA	Stock	1.1615	1.1725	1.1613	1.17	31946960.0
2016-06-30 12:00:00	NVDA	Stock	1.17	1.1755	1.1695	1.1709	40733200.0
2016-06-30 13:00:00	NVDA	Stock	1.1709	1.1765	1.1705	1.1765	24069000.0
2016-06-30 14:00:00	NVDA	Stock	1.1764	1.1825	1.1742	1.1773	65733480.0
2016-06-30 15:00:00	NVDA	Stock	1.1775	1.1785	1.1722	1.1752	111396240.0
2016-06-30 16:00:00	NVDA	Stock	1.1752	1.178	1.1742	1.175	26672120.0
2016-06-30 17:00:00	NVDA	Stock	1.1751	1.1752	1.1751	1.1752	1022040.0
2016-06-30 18:00:00	NVDA	Stock	1.175	1.1752	1.175	1.175	173760.0
2016-06-30 19:00:00	NVDA	Stock	1.1725	1.1725	1.1725	1.1725	92000.0
2016-06-30 07:00:00	AMZN	Stock	35.947	35.975	35.863	35.8685	90480.0
2016-06-30 08:00:00	AMZN	Stock	35.85	35.8675	35.827	35.85	104720.0
2016-06-30 09:00:00	AMZN	Stock	35.882	35.9345	35.627	35.66	8558440.0
2016-06-30 10:00:00	AMZN	Stock	35.664	35.88	35.639	35.8615	5678960.0
2016-06-30 11:00:00	AMZN	Stock	35.862	35.9685	35.82	35.848	4910940.0
2016-06-30 12:00:00	AMZN	Stock	35.8565	35.94	35.8184	35.8755	5777240.0
2016-06-30 13:00:00	AMZN	Stock	35.8818	35.8995	35.734	35.7725	5051600.0
2016-06-30 14:00:00	AMZN	Stock	35.7855	35.8625	35.75	35.8095	4395320.0

> showing 50 of 49,706 rows — these rows as CSV

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