PREVIEW / stock_1hour / 2017-02-16

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-16.parquet
  size:    1.1 MB
  rows:    48,608
  symbols: 3,103

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-02-16 04:00:00	AAPL	Stock	33.9125	33.925	33.9025	33.925	5052.0
2017-02-16 05:00:00	AAPL	Stock	33.925	33.925	33.925	33.925	552.0
2017-02-16 06:00:00	AAPL	Stock	33.8875	33.9025	33.885	33.89	14536.0
2017-02-16 07:00:00	AAPL	Stock	33.885	34.005	33.8575	33.8575	149544.0
2017-02-16 08:00:00	AAPL	Stock	33.9025	33.9225	33.7875	33.8475	262676.0
2017-02-16 09:00:00	AAPL	Stock	33.8675	33.975	33.77	33.7835	15874236.0
2017-02-16 10:00:00	AAPL	Stock	33.7838	33.85	33.71	33.7625	16338204.0
2017-02-16 11:00:00	AAPL	Stock	33.7625	33.8275	33.7225	33.8005	8681108.0
2017-02-16 12:00:00	AAPL	Stock	33.8	33.8675	33.7875	33.81	6643104.0
2017-02-16 13:00:00	AAPL	Stock	33.8125	33.8325	33.7775	33.81	4787820.0
2017-02-16 14:00:00	AAPL	Stock	33.81	33.8452	33.76	33.8112	6967104.0
2017-02-16 15:00:00	AAPL	Stock	33.8112	33.86	33.7775	33.8362	15727204.0
2017-02-16 16:00:00	AAPL	Stock	33.8362	33.8375	33.8075	33.8125	4843352.0
2017-02-16 17:00:00	AAPL	Stock	33.8125	33.82	33.8125	33.815	24616.0
2017-02-16 18:00:00	AAPL	Stock	33.815	33.8225	33.815	33.8225	5200.0
2017-02-16 19:00:00	AAPL	Stock	33.815	33.825	33.8125	33.825	35816.0
2017-02-16 06:00:00	MSFT	Stock	64.58	64.58	64.58	64.58	100.0
2017-02-16 07:00:00	MSFT	Stock	64.57	64.57	64.47	64.47	1004.0
2017-02-16 08:00:00	MSFT	Stock	64.5	64.53	64.45	64.5	4029.0
2017-02-16 09:00:00	MSFT	Stock	64.55	64.99	64.55	64.85	2273253.0
2017-02-16 10:00:00	MSFT	Stock	64.85	65.24	64.81	64.974	3928696.0
2017-02-16 11:00:00	MSFT	Stock	64.98	65.03	64.86	64.93	1863692.0
2017-02-16 12:00:00	MSFT	Stock	64.935	64.95	64.7	64.7	1262228.0
2017-02-16 13:00:00	MSFT	Stock	64.695	64.71	64.51	64.534	2041742.0
2017-02-16 14:00:00	MSFT	Stock	64.54	64.57	64.44	64.535	1941156.0
2017-02-16 15:00:00	MSFT	Stock	64.54	64.62	64.47	64.51	3916166.0
2017-02-16 16:00:00	MSFT	Stock	64.51	64.57	64.42	64.57	1607382.0
2017-02-16 17:00:00	MSFT	Stock	64.48	64.48	64.4	64.4	900.0
2017-02-16 18:00:00	MSFT	Stock	64.52	64.52	64.52	64.52	350.0
2017-02-16 19:00:00	MSFT	Stock	64.52	64.52	64.52	64.52	100.0
2017-02-16 05:00:00	NVDA	Stock	2.7238	2.7238	2.7238	2.7238	4000.0
2017-02-16 07:00:00	NVDA	Stock	2.7152	2.7253	2.7152	2.7225	21240.0
2017-02-16 08:00:00	NVDA	Stock	2.7225	2.7225	2.705	2.7063	886760.0
2017-02-16 09:00:00	NVDA	Stock	2.715	2.7372	2.69	2.696	83400040.0
2017-02-16 10:00:00	NVDA	Stock	2.6957	2.709	2.6625	2.675	143828480.0
2017-02-16 11:00:00	NVDA	Stock	2.6755	2.6872	2.6625	2.6708	78045520.0
2017-02-16 12:00:00	NVDA	Stock	2.6705	2.6788	2.664	2.669	45554480.0
2017-02-16 13:00:00	NVDA	Stock	2.669	2.6722	2.659	2.6663	47079240.0
2017-02-16 14:00:00	NVDA	Stock	2.6665	2.6675	2.6415	2.6583	96367040.0
2017-02-16 15:00:00	NVDA	Stock	2.6585	2.6813	2.6538	2.681	99701400.0
2017-02-16 16:00:00	NVDA	Stock	2.6813	2.6813	2.6775	2.68	7144560.0
2017-02-16 17:00:00	NVDA	Stock	2.6798	2.6818	2.675	2.6813	753760.0
2017-02-16 18:00:00	NVDA	Stock	2.6813	2.6818	2.6775	2.6813	358160.0
2017-02-16 19:00:00	NVDA	Stock	2.6813	2.6818	2.6783	2.6783	80880.0
2017-02-16 06:00:00	AMZN	Stock	42.2415	42.2415	42.2415	42.2415	2000.0
2017-02-16 07:00:00	AMZN	Stock	42.1505	42.1505	42.075	42.09	21600.0
2017-02-16 08:00:00	AMZN	Stock	42.1205	42.1945	42.04	42.11	71600.0
2017-02-16 09:00:00	AMZN	Stock	42.1	42.2275	41.9688	42.091	10271400.0
2017-02-16 10:00:00	AMZN	Stock	42.0905	42.2475	42.021	42.1155	11457120.0
2017-02-16 11:00:00	AMZN	Stock	42.1123	42.1363	42.0234	42.0925	5186680.0

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

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