PREVIEW / stock_1hour / 2016-07-05

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-05.parquet
  size:    1.0 MB
  rows:    48,614
  symbols: 3,255

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-07-05 04:00:00	AAPL	Stock	23.95	23.95	23.8075	23.8075	25508.0
2016-07-05 05:00:00	AAPL	Stock	23.79	23.79	23.7175	23.7475	47304.0
2016-07-05 06:00:00	AAPL	Stock	23.745	23.7575	23.7275	23.7575	27948.0
2016-07-05 07:00:00	AAPL	Stock	23.7725	23.8	23.7125	23.74	202280.0
2016-07-05 08:00:00	AAPL	Stock	23.7512	23.83	23.7275	23.8075	299796.0
2016-07-05 09:00:00	AAPL	Stock	23.8075	23.85	23.6588	23.7125	19220636.0
2016-07-05 10:00:00	AAPL	Stock	23.714	23.72	23.6275	23.6375	16013000.0
2016-07-05 11:00:00	AAPL	Stock	23.64	23.695	23.615	23.6762	10543100.0
2016-07-05 12:00:00	AAPL	Stock	23.6775	23.75	23.6725	23.705	7658292.0
2016-07-05 13:00:00	AAPL	Stock	23.7057	23.7075	23.63	23.665	6952796.0
2016-07-05 14:00:00	AAPL	Stock	23.6675	23.7078	23.6538	23.7013	6781820.0
2016-07-05 15:00:00	AAPL	Stock	23.7025	23.76	23.6875	23.755	17962116.0
2016-07-05 16:00:00	AAPL	Stock	23.745	23.7725	23.6447	23.765	14338280.0
2016-07-05 17:00:00	AAPL	Stock	23.7575	23.775	23.7575	23.7575	564936.0
2016-07-05 18:00:00	AAPL	Stock	23.7625	23.7625	23.7625	23.7625	12076.0
2016-07-05 19:00:00	AAPL	Stock	23.765	23.7675	23.7575	23.7575	54956.0
2016-07-05 04:00:00	MSFT	Stock	51.08	51.08	50.95	50.95	400.0
2016-07-05 06:00:00	MSFT	Stock	50.93	50.93	50.93	50.93	200.0
2016-07-05 07:00:00	MSFT	Stock	50.96	50.96	50.89	50.89	200.0
2016-07-05 08:00:00	MSFT	Stock	50.97	51.01	50.83	50.95	13980.0
2016-07-05 09:00:00	MSFT	Stock	50.95	51.12	50.74	51.005	3889309.0
2016-07-05 10:00:00	MSFT	Stock	51.005	51.195	50.92	50.99	3593507.0
2016-07-05 11:00:00	MSFT	Stock	50.99	51.07	50.83	51.015	2688407.0
2016-07-05 12:00:00	MSFT	Stock	51.015	51.11	50.91	50.97	2023276.0
2016-07-05 13:00:00	MSFT	Stock	50.98	51.02	50.84	50.94	1607824.0
2016-07-05 14:00:00	MSFT	Stock	50.935	51.025	50.83	50.95	1559795.0
2016-07-05 15:00:00	MSFT	Stock	50.94	51.28	50.91	51.16	4838427.0
2016-07-05 16:00:00	MSFT	Stock	51.17	51.2	51.041	51.2	2706764.0
2016-07-05 17:00:00	MSFT	Stock	51.18	51.18	51.18	51.18	1300.0
2016-07-05 18:00:00	MSFT	Stock	51.2	51.27	51.2	51.27	995.0
2016-07-05 19:00:00	MSFT	Stock	51.21	51.21	51.2	51.2	3500.0
2016-07-05 08:00:00	NVDA	Stock	1.1602	1.1625	1.1592	1.1608	99800.0
2016-07-05 09:00:00	NVDA	Stock	1.1592	1.1655	1.1508	1.165	31951960.0
2016-07-05 10:00:00	NVDA	Stock	1.1653	1.1773	1.16	1.172	69850320.0
2016-07-05 11:00:00	NVDA	Stock	1.172	1.1798	1.1693	1.1795	42771400.0
2016-07-05 12:00:00	NVDA	Stock	1.1795	1.1858	1.1788	1.183	44970240.0
2016-07-05 13:00:00	NVDA	Stock	1.183	1.1835	1.173	1.1759	37657800.0
2016-07-05 14:00:00	NVDA	Stock	1.1758	1.1846	1.1756	1.183	32361320.0
2016-07-05 15:00:00	NVDA	Stock	1.1828	1.1848	1.1813	1.1838	75815360.0
2016-07-05 16:00:00	NVDA	Stock	1.1838	1.1845	1.1765	1.1845	9617080.0
2016-07-05 17:00:00	NVDA	Stock	1.1845	1.1845	1.1838	1.1838	420000.0
2016-07-05 18:00:00	NVDA	Stock	1.185	1.19	1.185	1.1895	115040.0
2016-07-05 04:00:00	AMZN	Stock	36.175	36.175	36.175	36.175	6000.0
2016-07-05 06:00:00	AMZN	Stock	36.1385	36.1385	36.1385	36.1385	8400.0
2016-07-05 07:00:00	AMZN	Stock	36.1385	36.2	36.0605	36.1	109520.0
2016-07-05 08:00:00	AMZN	Stock	36.149	36.161	36.0625	36.0875	95440.0
2016-07-05 09:00:00	AMZN	Stock	36.1	36.25	36.0775	36.1905	7911000.0
2016-07-05 10:00:00	AMZN	Stock	36.199	36.222	36.03	36.09	7030980.0
2016-07-05 11:00:00	AMZN	Stock	36.085	36.1625	36.0125	36.068	4314680.0
2016-07-05 12:00:00	AMZN	Stock	36.0555	36.167	36.0488	36.1065	2658340.0

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

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