PREVIEW / stock_1hour / 2016-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-20.parquet
  size:    1.0 MB
  rows:    48,958
  symbols: 3,295

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-20 04:00:00	AAPL	Stock	23.8625	24.0875	23.8625	24.0875	17624.0
2016-06-20 05:00:00	AAPL	Stock	24.075	24.1	24.075	24.0975	19568.0
2016-06-20 06:00:00	AAPL	Stock	24.0875	24.095	24.065	24.0875	30740.0
2016-06-20 07:00:00	AAPL	Stock	24.1	24.12	24.025	24.0475	213900.0
2016-06-20 08:00:00	AAPL	Stock	24.0475	24.1125	23.9825	23.9975	746116.0
2016-06-20 09:00:00	AAPL	Stock	23.99	24.1425	23.975	24.0725	23854236.0
2016-06-20 10:00:00	AAPL	Stock	24.075	24.1375	24.03	24.0575	21472740.0
2016-06-20 11:00:00	AAPL	Stock	24.055	24.0622	23.905	23.9422	18144876.0
2016-06-20 12:00:00	AAPL	Stock	23.9422	23.9975	23.935	23.9925	11795448.0
2016-06-20 13:00:00	AAPL	Stock	23.9925	24.0175	23.9575	23.9875	9841064.0
2016-06-20 14:00:00	AAPL	Stock	23.988	24.005	23.9375	23.9675	9853940.0
2016-06-20 15:00:00	AAPL	Stock	23.9675	23.9725	23.7575	23.775	24290100.0
2016-06-20 16:00:00	AAPL	Stock	23.775	23.9725	23.7675	23.845	8487684.0
2016-06-20 17:00:00	AAPL	Stock	23.85	23.85	23.78	23.8175	64116.0
2016-06-20 18:00:00	AAPL	Stock	23.8175	23.8175	23.79	23.8125	77052.0
2016-06-20 19:00:00	AAPL	Stock	23.79	23.8125	23.77	23.77	44596.0
2016-06-20 07:00:00	MSFT	Stock	50.6	50.7	50.6	50.7	2755.0
2016-06-20 08:00:00	MSFT	Stock	50.74	50.74	50.62	50.62	7021.0
2016-06-20 09:00:00	MSFT	Stock	50.54	50.83	50.48	50.595	4798772.0
2016-06-20 10:00:00	MSFT	Stock	50.59	50.645	50.43	50.485	6908345.0
2016-06-20 11:00:00	MSFT	Stock	50.48	50.73	50.46	50.55	4237909.0
2016-06-20 12:00:00	MSFT	Stock	50.54	50.59	50.37	50.55	3140011.0
2016-06-20 13:00:00	MSFT	Stock	50.54	50.65	50.47	50.595	2274563.0
2016-06-20 14:00:00	MSFT	Stock	50.592	50.64	50.495	50.605	2596960.0
2016-06-20 15:00:00	MSFT	Stock	50.608	50.62	50.03	50.07	6694763.0
2016-06-20 16:00:00	MSFT	Stock	50.07	50.225	50.01	50.1	3335759.0
2016-06-20 17:00:00	MSFT	Stock	50.1	50.1	50.08	50.08	1000.0
2016-06-20 19:00:00	MSFT	Stock	50.2	50.2	50.2	50.2	150.0
2016-06-20 07:00:00	NVDA	Stock	1.1768	1.1785	1.1765	1.1785	72000.0
2016-06-20 08:00:00	NVDA	Stock	1.1785	1.1905	1.1785	1.1875	754240.0
2016-06-20 09:00:00	NVDA	Stock	1.1862	1.2042	1.1825	1.1922	49208040.0
2016-06-20 10:00:00	NVDA	Stock	1.1921	1.2036	1.1912	1.1992	57236640.0
2016-06-20 11:00:00	NVDA	Stock	1.1992	1.2012	1.1935	1.1964	35912760.0
2016-06-20 12:00:00	NVDA	Stock	1.1962	1.1976	1.1938	1.1966	21555680.0
2016-06-20 13:00:00	NVDA	Stock	1.1962	1.1975	1.1925	1.1939	19654160.0
2016-06-20 14:00:00	NVDA	Stock	1.1939	1.198	1.193	1.1975	34236760.0
2016-06-20 15:00:00	NVDA	Stock	1.1975	1.198	1.1873	1.1888	55704360.0
2016-06-20 16:00:00	NVDA	Stock	1.1882	1.1895	1.188	1.1895	860400.0
2016-06-20 18:00:00	NVDA	Stock	1.189	1.189	1.189	1.189	800000.0
2016-06-20 04:00:00	AMZN	Stock	35.4165	35.726	35.4165	35.726	6200.0
2016-06-20 07:00:00	AMZN	Stock	35.6755	35.845	35.6755	35.7155	163140.0
2016-06-20 08:00:00	AMZN	Stock	35.7255	35.8025	35.66	35.66	441760.0
2016-06-20 09:00:00	AMZN	Stock	35.682	35.8065	35.5405	35.8045	12363080.0
2016-06-20 10:00:00	AMZN	Stock	35.804	36.0355	35.802	36.0285	15994860.0
2016-06-20 11:00:00	AMZN	Stock	36.0295	36.0655	35.896	35.92	7282340.0
2016-06-20 12:00:00	AMZN	Stock	35.925	35.9645	35.818	35.9115	4390280.0
2016-06-20 13:00:00	AMZN	Stock	35.9035	35.9165	35.8178	35.9165	3690620.0
2016-06-20 14:00:00	AMZN	Stock	35.9152	35.9755	35.8742	35.953	3404500.0
2016-06-20 15:00:00	AMZN	Stock	35.9505	35.969	35.6628	35.7005	8826880.0
2016-06-20 16:00:00	AMZN	Stock	35.7005	35.7795	35.67	35.7795	4363340.0

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

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