PREVIEW / stock_1hour / 2016-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-01.parquet
  size:    1.0 MB
  rows:    48,392
  symbols: 3,303

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-01 04:00:00	AAPL	Stock	24.97	24.995	24.825	24.875	6368.0
2016-06-01 05:00:00	AAPL	Stock	24.845	24.88	24.8175	24.825	16872.0
2016-06-01 06:00:00	AAPL	Stock	24.8375	24.8425	24.7525	24.815	37556.0
2016-06-01 07:00:00	AAPL	Stock	24.85	24.9225	24.85	24.9225	57060.0
2016-06-01 08:00:00	AAPL	Stock	24.85	24.925	24.85	24.8775	205912.0
2016-06-01 09:00:00	AAPL	Stock	24.8875	24.89	24.69	24.7475	17369396.0
2016-06-01 10:00:00	AAPL	Stock	24.7475	24.8625	24.7175	24.826	16217160.0
2016-06-01 11:00:00	AAPL	Stock	24.8275	24.885	24.72	24.7925	16463108.0
2016-06-01 12:00:00	AAPL	Stock	24.79	24.8065	24.7638	24.805	7123304.0
2016-06-01 13:00:00	AAPL	Stock	24.805	24.81	24.7225	24.7475	8496700.0
2016-06-01 14:00:00	AAPL	Stock	24.75	24.795	24.725	24.7512	9534440.0
2016-06-01 15:00:00	AAPL	Stock	24.7525	24.7575	24.5825	24.6125	27235112.0
2016-06-01 16:00:00	AAPL	Stock	24.615	24.784	24.5775	24.595	5765916.0
2016-06-01 17:00:00	AAPL	Stock	24.5925	24.615	24.5625	24.57	90848.0
2016-06-01 18:00:00	AAPL	Stock	24.57	24.595	24.565	24.575	40216.0
2016-06-01 19:00:00	AAPL	Stock	24.575	24.585	24.565	24.575	34944.0
2016-06-01 04:00:00	MSFT	Stock	52.75	52.81	52.6	52.6	2099.0
2016-06-01 05:00:00	MSFT	Stock	52.73	52.73	52.73	52.73	100.0
2016-06-01 06:00:00	MSFT	Stock	52.51	52.51	52.51	52.51	1000.0
2016-06-01 07:00:00	MSFT	Stock	52.68	52.68	52.58	52.58	1875.0
2016-06-01 08:00:00	MSFT	Stock	52.6	53.0	52.41	53.0	18878.0
2016-06-01 09:00:00	MSFT	Stock	52.6	52.76	52.44	52.702	2177216.0
2016-06-01 10:00:00	MSFT	Stock	52.685	52.9	52.67	52.87	3170251.0
2016-06-01 11:00:00	MSFT	Stock	52.87	52.95	52.59	52.685	2761491.0
2016-06-01 12:00:00	MSFT	Stock	52.69	52.82	52.65	52.805	1946056.0
2016-06-01 13:00:00	MSFT	Stock	52.805	52.83	52.55	52.605	1501658.0
2016-06-01 14:00:00	MSFT	Stock	52.6	52.89	52.54	52.81	2801568.0
2016-06-01 15:00:00	MSFT	Stock	52.81	52.94	52.74	52.85	6506770.0
2016-06-01 16:00:00	MSFT	Stock	52.85	53.02	52.84	53.01	2611192.0
2016-06-01 17:00:00	MSFT	Stock	53.01	53.01	52.95	52.95	1660.0
2016-06-01 18:00:00	MSFT	Stock	52.89	52.89	52.89	52.89	401.0
2016-06-01 05:00:00	NVDA	Stock	1.168	1.168	1.168	1.168	16000.0
2016-06-01 07:00:00	NVDA	Stock	1.1675	1.168	1.151	1.151	63640.0
2016-06-01 08:00:00	NVDA	Stock	1.1658	1.1668	1.1592	1.1598	254040.0
2016-06-01 09:00:00	NVDA	Stock	1.162	1.1698	1.1602	1.1648	37284120.0
2016-06-01 10:00:00	NVDA	Stock	1.1648	1.169	1.159	1.1622	57575560.0
2016-06-01 11:00:00	NVDA	Stock	1.1625	1.1672	1.1621	1.164	27629520.0
2016-06-01 12:00:00	NVDA	Stock	1.1642	1.1671	1.1642	1.1663	17953840.0
2016-06-01 13:00:00	NVDA	Stock	1.1662	1.1773	1.1662	1.175	41386520.0
2016-06-01 14:00:00	NVDA	Stock	1.1751	1.1815	1.1714	1.1721	50487520.0
2016-06-01 15:00:00	NVDA	Stock	1.1722	1.173	1.169	1.1702	70215800.0
2016-06-01 16:00:00	NVDA	Stock	1.1702	1.1718	1.1682	1.1695	14580800.0
2016-06-01 17:00:00	NVDA	Stock	1.1715	1.1715	1.1702	1.1702	407040.0
2016-06-01 18:00:00	NVDA	Stock	1.171	1.1728	1.171	1.1728	80000.0
2016-06-01 19:00:00	NVDA	Stock	1.1728	1.175	1.1713	1.175	56000.0
2016-06-01 05:00:00	AMZN	Stock	35.999	35.999	35.999	35.999	2000.0
2016-06-01 06:00:00	AMZN	Stock	35.958	35.958	35.9475	35.9475	16000.0
2016-06-01 07:00:00	AMZN	Stock	35.925	36.011	35.925	36.0105	46000.0
2016-06-01 08:00:00	AMZN	Stock	35.828	36.05	35.828	35.9835	197720.0
2016-06-01 09:00:00	AMZN	Stock	35.992	36.168	35.951	36.05	8519260.0

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

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