PREVIEW / stock_1hour / 2017-12-01

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-01.parquet
  size:    1.1 MB
  rows:    49,340
  symbols: 2,941

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
2017-12-01 04:00:00	AAPL	Stock	42.7375	42.7875	42.7375	42.7875	2536.0
2017-12-01 05:00:00	AAPL	Stock	42.755	42.8075	42.675	42.675	14172.0
2017-12-01 06:00:00	AAPL	Stock	42.5775	42.6475	42.5	42.5875	55252.0
2017-12-01 07:00:00	AAPL	Stock	42.595	42.7925	42.5125	42.65	407088.0
2017-12-01 08:00:00	AAPL	Stock	42.585	42.6975	42.57	42.595	1082876.0
2017-12-01 09:00:00	AAPL	Stock	42.59	42.74	42.2875	42.5462	19771900.0
2017-12-01 10:00:00	AAPL	Stock	42.55	42.9175	42.51	42.74	17945580.0
2017-12-01 11:00:00	AAPL	Stock	42.7375	42.8475	42.125	42.4645	29261540.0
2017-12-01 12:00:00	AAPL	Stock	42.47	42.6625	42.365	42.56	17115876.0
2017-12-01 13:00:00	AAPL	Stock	42.56	42.7075	42.54	42.615	7329868.0
2017-12-01 14:00:00	AAPL	Stock	42.6175	42.7675	42.568	42.6392	8108028.0
2017-12-01 15:00:00	AAPL	Stock	42.6375	42.8	42.5575	42.75	16918312.0
2017-12-01 16:00:00	AAPL	Stock	42.7625	42.785	42.4598	42.7725	16007628.0
2017-12-01 17:00:00	AAPL	Stock	42.7875	42.81	42.7625	42.7625	22352.0
2017-12-01 18:00:00	AAPL	Stock	42.7625	42.7675	42.75	42.7675	32832.0
2017-12-01 19:00:00	AAPL	Stock	42.7675	42.7725	42.75	42.75	33504.0
2017-12-01 06:00:00	MSFT	Stock	83.51	83.51	83.51	83.51	300.0
2017-12-01 07:00:00	MSFT	Stock	83.88	83.88	83.62	83.63	2890.0
2017-12-01 08:00:00	MSFT	Stock	83.51	83.93	83.51	83.82	20119.0
2017-12-01 09:00:00	MSFT	Stock	83.83	84.42	83.2	84.3	2596625.0
2017-12-01 10:00:00	MSFT	Stock	84.31	84.81	84.18	84.39	2661474.0
2017-12-01 11:00:00	MSFT	Stock	84.39	84.58	83.22	83.935	7618795.0
2017-12-01 12:00:00	MSFT	Stock	83.93	83.96	83.29	83.87	3531698.0
2017-12-01 13:00:00	MSFT	Stock	83.86	83.96	83.68	83.94	1733652.0
2017-12-01 14:00:00	MSFT	Stock	83.94	84.13	83.85	83.935	1373515.0
2017-12-01 15:00:00	MSFT	Stock	83.93	84.346	83.83	84.26	3516811.0
2017-12-01 16:00:00	MSFT	Stock	84.19	84.41	84.19	84.29	3860395.0
2017-12-01 17:00:00	MSFT	Stock	84.37	84.37	84.26	84.26	386.0
2017-12-01 18:00:00	MSFT	Stock	84.26	84.26	84.2	84.25	2145.0
2017-12-01 19:00:00	MSFT	Stock	84.3	84.3	84.15	84.2	8100.0
2017-12-01 04:00:00	NVDA	Stock	5.0075	5.0075	4.9875	4.9875	185800.0
2017-12-01 05:00:00	NVDA	Stock	4.9875	4.9875	4.9558	4.9558	57520.0
2017-12-01 06:00:00	NVDA	Stock	4.95	4.962	4.9312	4.954	94000.0
2017-12-01 07:00:00	NVDA	Stock	4.9525	4.9698	4.95	4.9698	705840.0
2017-12-01 08:00:00	NVDA	Stock	4.95	5.0	4.95	4.984	2673400.0
2017-12-01 09:00:00	NVDA	Stock	4.9825	5.0033	4.8953	4.9311	97556440.0
2017-12-01 10:00:00	NVDA	Stock	4.9332	4.9772	4.918	4.96	92164680.0
2017-12-01 11:00:00	NVDA	Stock	4.9606	4.9718	4.8118	4.8944	171559080.0
2017-12-01 12:00:00	NVDA	Stock	4.8958	4.9335	4.8725	4.9175	81378840.0
2017-12-01 13:00:00	NVDA	Stock	4.9175	4.9308	4.8992	4.912	42497280.0
2017-12-01 14:00:00	NVDA	Stock	4.908	4.9343	4.8918	4.9139	43260640.0
2017-12-01 15:00:00	NVDA	Stock	4.9139	4.95	4.9042	4.942	91755520.0
2017-12-01 16:00:00	NVDA	Stock	4.942	4.9442	4.935	4.94	15765400.0
2017-12-01 17:00:00	NVDA	Stock	4.942	4.9462	4.94	4.943	153026080.0
2017-12-01 18:00:00	NVDA	Stock	4.9425	4.943	4.936	4.9385	758000.0
2017-12-01 19:00:00	NVDA	Stock	4.941	4.9455	4.936	4.9455	521000.0
2017-12-01 05:00:00	AMZN	Stock	58.5205	58.5205	58.465	58.465	7200.0
2017-12-01 06:00:00	AMZN	Stock	58.4985	58.555	58.4975	58.555	26640.0
2017-12-01 07:00:00	AMZN	Stock	58.5	58.7365	58.5	58.7	119480.0
2017-12-01 08:00:00	AMZN	Stock	58.6615	58.99	58.525	58.85	309640.0

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

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