PREVIEW / stock_1hour / 2016-12-01

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-01.parquet
  size:    1.1 MB
  rows:    49,121
  symbols: 3,167

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-12-01 04:00:00	AAPL	Stock	27.56	27.56	27.56	27.56	880.0
2016-12-01 06:00:00	AAPL	Stock	27.5575	27.5575	27.5	27.5	22336.0
2016-12-01 07:00:00	AAPL	Stock	27.495	27.555	27.475	27.525	105736.0
2016-12-01 08:00:00	AAPL	Stock	27.525	27.5875	27.4875	27.5775	230172.0
2016-12-01 09:00:00	AAPL	Stock	27.57	27.695	27.475	27.555	21245616.0
2016-12-01 10:00:00	AAPL	Stock	27.5625	27.735	27.3125	27.4425	28245020.0
2016-12-01 11:00:00	AAPL	Stock	27.4425	27.5638	27.39	27.5375	14034980.0
2016-12-01 12:00:00	AAPL	Stock	27.5358	27.5675	27.4275	27.44	8286512.0
2016-12-01 13:00:00	AAPL	Stock	27.44	27.4425	27.3525	27.3725	10426276.0
2016-12-01 14:00:00	AAPL	Stock	27.3725	27.4862	27.36	27.44	10347392.0
2016-12-01 15:00:00	AAPL	Stock	27.44	27.46	27.2575	27.3675	26701584.0
2016-12-01 16:00:00	AAPL	Stock	27.3725	27.4225	27.3355	27.4	14613576.0
2016-12-01 17:00:00	AAPL	Stock	27.3975	27.4125	27.3875	27.3875	39648.0
2016-12-01 18:00:00	AAPL	Stock	27.3925	27.3925	27.37	27.3725	94204.0
2016-12-01 19:00:00	AAPL	Stock	27.3875	27.425	27.3875	27.425	45676.0
2016-12-01 05:00:00	MSFT	Stock	60.31	60.31	60.3	60.3	656.0
2016-12-01 06:00:00	MSFT	Stock	60.29	60.29	60.29	60.29	145.0
2016-12-01 07:00:00	MSFT	Stock	60.2	60.2	60.2	60.2	300.0
2016-12-01 08:00:00	MSFT	Stock	60.21	60.3	60.19	60.3	7100.0
2016-12-01 09:00:00	MSFT	Stock	60.33	60.37	59.82	59.95	3712214.0
2016-12-01 10:00:00	MSFT	Stock	59.95	60.07	59.21	59.426	5798264.0
2016-12-01 11:00:00	MSFT	Stock	59.42	59.566	59.28	59.36	4201398.0
2016-12-01 12:00:00	MSFT	Stock	59.36	59.36	58.95	59.006	4248584.0
2016-12-01 13:00:00	MSFT	Stock	59.0	59.205	58.935	59.11	2466293.0
2016-12-01 14:00:00	MSFT	Stock	59.11	59.36	59.105	59.255	2413506.0
2016-12-01 15:00:00	MSFT	Stock	59.25	59.28	58.99	59.18	4747985.0
2016-12-01 16:00:00	MSFT	Stock	59.19	59.298	59.01	59.2	4390777.0
2016-12-01 17:00:00	MSFT	Stock	59.2	59.2	59.18	59.18	6579.0
2016-12-01 18:00:00	MSFT	Stock	59.2	59.3	59.2	59.25	1220.0
2016-12-01 04:00:00	NVDA	Stock	2.305	2.305	2.305	2.305	28000.0
2016-12-01 06:00:00	NVDA	Stock	2.313	2.313	2.31	2.31	14800.0
2016-12-01 07:00:00	NVDA	Stock	2.3138	2.3138	2.3062	2.3062	52000.0
2016-12-01 08:00:00	NVDA	Stock	2.3125	2.32	2.3075	2.318	333080.0
2016-12-01 09:00:00	NVDA	Stock	2.3188	2.32	2.222	2.2445	136179680.0
2016-12-01 10:00:00	NVDA	Stock	2.2425	2.253	2.1192	2.1622	308168520.0
2016-12-01 11:00:00	NVDA	Stock	2.1618	2.1965	2.155	2.1652	174232600.0
2016-12-01 12:00:00	NVDA	Stock	2.1648	2.186	2.154	2.1814	79818680.0
2016-12-01 13:00:00	NVDA	Stock	2.182	2.2035	2.169	2.1868	77174360.0
2016-12-01 14:00:00	NVDA	Stock	2.1868	2.2018	2.1812	2.191	60793040.0
2016-12-01 15:00:00	NVDA	Stock	2.1908	2.193	2.1765	2.191	93851280.0
2016-12-01 16:00:00	NVDA	Stock	2.191	2.191	2.1888	2.191	25350800.0
2016-12-01 17:00:00	NVDA	Stock	2.1922	2.1968	2.189	2.19	184920.0
2016-12-01 18:00:00	NVDA	Stock	2.19	2.1912	2.179	2.1812	320880.0
2016-12-01 19:00:00	NVDA	Stock	2.1815	2.185	2.1788	2.185	110400.0
2016-12-01 05:00:00	AMZN	Stock	37.521	37.521	37.5	37.521	22120.0
2016-12-01 07:00:00	AMZN	Stock	37.5285	37.6035	37.5285	37.5915	37360.0
2016-12-01 08:00:00	AMZN	Stock	37.555	37.715	37.555	37.715	158060.0
2016-12-01 09:00:00	AMZN	Stock	37.7025	37.7025	37.201	37.3635	17114500.0
2016-12-01 10:00:00	AMZN	Stock	37.3735	37.4985	36.9015	37.0115	17868860.0
2016-12-01 11:00:00	AMZN	Stock	37.023	37.303	36.9655	37.1555	10589280.0

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

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