PREVIEW / stock_1hour / 2017-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-07.parquet
  size:    1.0 MB
  rows:    48,033
  symbols: 3,099

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-07 04:00:00	AAPL	Stock	32.5625	32.5625	32.515	32.555	9116.0
2017-02-07 05:00:00	AAPL	Stock	32.5625	32.5625	32.5625	32.5625	6964.0
2017-02-07 06:00:00	AAPL	Stock	32.57	32.6325	32.57	32.62	18356.0
2017-02-07 07:00:00	AAPL	Stock	32.6125	32.6725	32.61	32.6525	91184.0
2017-02-07 08:00:00	AAPL	Stock	32.65	32.67	32.4875	32.62	208740.0
2017-02-07 09:00:00	AAPL	Stock	32.63	32.785	32.585	32.7675	22595964.0
2017-02-07 10:00:00	AAPL	Stock	32.765	33.0	32.765	32.9638	25890584.0
2017-02-07 11:00:00	AAPL	Stock	32.9625	33.0	32.94	32.96	12071956.0
2017-02-07 12:00:00	AAPL	Stock	32.9615	33.0225	32.875	32.875	18221084.0
2017-02-07 13:00:00	AAPL	Stock	32.875	33.01	32.8575	32.9375	11784860.0
2017-02-07 14:00:00	AAPL	Stock	32.9392	32.95	32.7925	32.85	15983084.0
2017-02-07 15:00:00	AAPL	Stock	32.8512	32.9075	32.8488	32.8775	18455732.0
2017-02-07 16:00:00	AAPL	Stock	32.875	32.895	32.8575	32.875	7282920.0
2017-02-07 17:00:00	AAPL	Stock	32.875	32.875	32.8675	32.8675	62772.0
2017-02-07 18:00:00	AAPL	Stock	32.8675	32.8825	32.855	32.875	12508.0
2017-02-07 19:00:00	AAPL	Stock	32.8825	32.8825	32.845	32.87	56028.0
2017-02-07 06:00:00	MSFT	Stock	63.74	63.75	63.74	63.75	721.0
2017-02-07 08:00:00	MSFT	Stock	63.81	63.81	63.7	63.7	13291.0
2017-02-07 09:00:00	MSFT	Stock	63.75	63.8	63.23	63.45	2758453.0
2017-02-07 10:00:00	MSFT	Stock	63.452	63.63	63.34	63.54	2593108.0
2017-02-07 11:00:00	MSFT	Stock	63.53	63.55	63.36	63.45	1714069.0
2017-02-07 12:00:00	MSFT	Stock	63.444	63.51	63.32	63.405	1461835.0
2017-02-07 13:00:00	MSFT	Stock	63.4	63.49	63.35	63.42	1277778.0
2017-02-07 14:00:00	MSFT	Stock	63.43	63.445	63.33	63.36	1734546.0
2017-02-07 15:00:00	MSFT	Stock	63.35	63.43	63.235	63.42	4193135.0
2017-02-07 16:00:00	MSFT	Stock	63.43	63.54	63.3	63.43	3407892.0
2017-02-07 17:00:00	MSFT	Stock	63.39	63.39	63.39	63.39	1000.0
2017-02-07 04:00:00	NVDA	Stock	2.9495	2.9495	2.9495	2.9495	4000.0
2017-02-07 05:00:00	NVDA	Stock	2.9495	2.9495	2.9495	2.9495	16400.0
2017-02-07 06:00:00	NVDA	Stock	2.9485	2.956	2.9473	2.955	77560.0
2017-02-07 07:00:00	NVDA	Stock	2.9545	2.956	2.9438	2.9525	493720.0
2017-02-07 08:00:00	NVDA	Stock	2.9508	2.9735	2.9462	2.9718	4176080.0
2017-02-07 09:00:00	NVDA	Stock	2.9712	3.023	2.9475	3.0133	193120280.0
2017-02-07 10:00:00	NVDA	Stock	3.0132	3.0195	2.9905	3.0035	132764440.0
2017-02-07 11:00:00	NVDA	Stock	3.003	3.0142	2.995	3.0088	68473000.0
2017-02-07 12:00:00	NVDA	Stock	3.009	3.009	2.965	2.9668	90698200.0
2017-02-07 13:00:00	NVDA	Stock	2.9668	2.9925	2.957	2.9912	73777680.0
2017-02-07 14:00:00	NVDA	Stock	2.9918	2.995	2.9705	2.9775	43400400.0
2017-02-07 15:00:00	NVDA	Stock	2.9774	2.9823	2.9625	2.9782	86752240.0
2017-02-07 16:00:00	NVDA	Stock	2.9793	2.9918	2.9782	2.98	4618840.0
2017-02-07 17:00:00	NVDA	Stock	2.9823	2.9868	2.9812	2.9825	519200.0
2017-02-07 18:00:00	NVDA	Stock	2.9812	2.9838	2.979	2.98	260480.0
2017-02-07 19:00:00	NVDA	Stock	2.9812	2.9838	2.98	2.9838	400200.0
2017-02-07 07:00:00	AMZN	Stock	40.434	40.46	40.4195	40.45	50580.0
2017-02-07 08:00:00	AMZN	Stock	40.45	40.4675	40.3165	40.3685	203100.0
2017-02-07 09:00:00	AMZN	Stock	40.35	40.55	40.3295	40.4305	11945900.0
2017-02-07 10:00:00	AMZN	Stock	40.428	40.808	40.4275	40.7254	18845140.0
2017-02-07 11:00:00	AMZN	Stock	40.7215	40.7825	40.6125	40.7136	7884360.0
2017-02-07 12:00:00	AMZN	Stock	40.7135	40.7485	40.549	40.573	6261800.0
2017-02-07 13:00:00	AMZN	Stock	40.5765	40.619	40.5405	40.5888	3706880.0

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

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