PREVIEW / stock_1hour / 2016-06-16

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-16.parquet
  size:    1.0 MB
  rows:    48,387
  symbols: 3,284

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-16 04:00:00	AAPL	Stock	24.285	24.285	24.025	24.0375	25044.0
2016-06-16 05:00:00	AAPL	Stock	24.0725	24.11	24.0725	24.11	9860.0
2016-06-16 06:00:00	AAPL	Stock	24.12	24.1375	24.075	24.1225	25360.0
2016-06-16 07:00:00	AAPL	Stock	24.1475	24.1475	24.075	24.085	106008.0
2016-06-16 08:00:00	AAPL	Stock	24.145	24.145	24.075	24.08	441072.0
2016-06-16 09:00:00	AAPL	Stock	24.075	24.1792	24.05	24.11	17474496.0
2016-06-16 10:00:00	AAPL	Stock	24.1078	24.19	24.0175	24.075	20011824.0
2016-06-16 11:00:00	AAPL	Stock	24.0725	24.1475	24.0462	24.1	12064040.0
2016-06-16 12:00:00	AAPL	Stock	24.1	24.275	24.085	24.2697	14021340.0
2016-06-16 13:00:00	AAPL	Stock	24.2697	24.3825	24.2635	24.2888	15742760.0
2016-06-16 14:00:00	AAPL	Stock	24.29	24.3968	24.275	24.375	11595824.0
2016-06-16 15:00:00	AAPL	Stock	24.375	24.4375	24.355	24.3925	18277540.0
2016-06-16 16:00:00	AAPL	Stock	24.39	24.435	24.365	24.3875	5375112.0
2016-06-16 17:00:00	AAPL	Stock	24.3875	24.39	24.37	24.3875	36632.0
2016-06-16 18:00:00	AAPL	Stock	24.3925	24.395	24.375	24.3875	49024.0
2016-06-16 19:00:00	AAPL	Stock	24.3875	24.4025	24.385	24.4025	72952.0
2016-06-16 04:00:00	MSFT	Stock	49.73	49.73	49.73	49.73	100.0
2016-06-16 08:00:00	MSFT	Stock	49.64	49.64	49.5	49.52	11930.0
2016-06-16 09:00:00	MSFT	Stock	49.53	49.77	49.5	49.64	3067046.0
2016-06-16 10:00:00	MSFT	Stock	49.645	49.76	49.6	49.685	4444462.0
2016-06-16 11:00:00	MSFT	Stock	49.68	49.99	49.66	49.9	3995205.0
2016-06-16 12:00:00	MSFT	Stock	49.9	50.3	49.87	50.2	3225741.0
2016-06-16 13:00:00	MSFT	Stock	50.21	50.35	50.1	50.127	2921378.0
2016-06-16 14:00:00	MSFT	Stock	50.13	50.38	50.08	50.203	3843267.0
2016-06-16 15:00:00	MSFT	Stock	50.21	50.47	50.17	50.39	6332407.0
2016-06-16 16:00:00	MSFT	Stock	50.39	50.44	50.37	50.39	1820775.0
2016-06-16 17:00:00	MSFT	Stock	50.39	50.39	50.39	50.39	200.0
2016-06-16 18:00:00	MSFT	Stock	50.39	50.39	50.39	50.39	73628.0
2016-06-16 19:00:00	MSFT	Stock	50.39	50.42	50.39	50.42	300.0
2016-06-16 05:00:00	NVDA	Stock	1.175	1.175	1.175	1.175	104000.0
2016-06-16 06:00:00	NVDA	Stock	1.175	1.175	1.175	1.175	12000.0
2016-06-16 07:00:00	NVDA	Stock	1.1752	1.1752	1.175	1.175	13200.0
2016-06-16 08:00:00	NVDA	Stock	1.1832	1.1832	1.175	1.1765	77200.0
2016-06-16 09:00:00	NVDA	Stock	1.18	1.18	1.1685	1.1713	23810320.0
2016-06-16 10:00:00	NVDA	Stock	1.1715	1.1749	1.1638	1.166	30978080.0
2016-06-16 11:00:00	NVDA	Stock	1.1662	1.174	1.165	1.1715	29995440.0
2016-06-16 12:00:00	NVDA	Stock	1.1715	1.1806	1.1693	1.178	23819840.0
2016-06-16 13:00:00	NVDA	Stock	1.178	1.1815	1.1748	1.175	48412600.0
2016-06-16 14:00:00	NVDA	Stock	1.175	1.1815	1.1745	1.1809	23965240.0
2016-06-16 15:00:00	NVDA	Stock	1.181	1.1908	1.181	1.1888	54675960.0
2016-06-16 16:00:00	NVDA	Stock	1.1888	1.1888	1.1805	1.1805	1044080.0
2016-06-16 17:00:00	NVDA	Stock	1.1905	1.1905	1.1858	1.1858	602640.0
2016-06-16 18:00:00	NVDA	Stock	1.1858	1.1898	1.1858	1.1895	52000.0
2016-06-16 19:00:00	NVDA	Stock	1.1895	1.1908	1.1895	1.1908	28400.0
2016-06-16 04:00:00	AMZN	Stock	35.6135	35.6135	35.6	35.6	4920.0
2016-06-16 07:00:00	AMZN	Stock	35.605	35.605	35.5845	35.589	6100.0
2016-06-16 08:00:00	AMZN	Stock	35.61	35.62	35.582	35.62	105640.0
2016-06-16 09:00:00	AMZN	Stock	35.6225	35.775	35.407	35.4395	9004060.0
2016-06-16 10:00:00	AMZN	Stock	35.4368	35.475	35.2655	35.3124	9876060.0
2016-06-16 11:00:00	AMZN	Stock	35.3055	35.435	35.265	35.333	5599660.0

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

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