PREVIEW / stock_1hour / 2017-02-08

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-08.parquet
  size:    1.1 MB
  rows:    49,480
  symbols: 3,097

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-08 05:00:00	AAPL	Stock	32.9125	32.9475	32.8975	32.9475	8716.0
2017-02-08 06:00:00	AAPL	Stock	32.9475	32.97	32.92	32.9325	14344.0
2017-02-08 07:00:00	AAPL	Stock	32.925	32.9325	32.9	32.9	81692.0
2017-02-08 08:00:00	AAPL	Stock	32.925	32.925	32.8	32.8975	202548.0
2017-02-08 09:00:00	AAPL	Stock	32.8975	32.95	32.805	32.8375	16025804.0
2017-02-08 10:00:00	AAPL	Stock	32.8375	32.905	32.805	32.8685	11597968.0
2017-02-08 11:00:00	AAPL	Stock	32.869	32.9	32.855	32.855	6734924.0
2017-02-08 12:00:00	AAPL	Stock	32.8562	32.925	32.8552	32.8775	7699104.0
2017-02-08 13:00:00	AAPL	Stock	32.875	32.925	32.8675	32.919	5594540.0
2017-02-08 14:00:00	AAPL	Stock	32.9188	32.9575	32.9125	32.9388	6370112.0
2017-02-08 15:00:00	AAPL	Stock	32.9375	33.055	32.935	33.01	18424784.0
2017-02-08 16:00:00	AAPL	Stock	33.01	33.025	33.0025	33.015	3975336.0
2017-02-08 17:00:00	AAPL	Stock	33.015	33.0325	33.01	33.0325	1586964.0
2017-02-08 18:00:00	AAPL	Stock	33.03	33.0375	33.0275	33.0375	42064.0
2017-02-08 19:00:00	AAPL	Stock	33.045	33.05	33.025	33.025	68064.0
2017-02-08 08:00:00	MSFT	Stock	63.44	63.58	63.42	63.58	6455.0
2017-02-08 09:00:00	MSFT	Stock	63.55	63.81	63.22	63.445	2237709.0
2017-02-08 10:00:00	MSFT	Stock	63.446	63.73	63.4	63.6	3124037.0
2017-02-08 11:00:00	MSFT	Stock	63.6	63.62	63.45	63.48	1587965.0
2017-02-08 12:00:00	MSFT	Stock	63.48	63.59	63.41	63.42	1194433.0
2017-02-08 13:00:00	MSFT	Stock	63.41	63.54	63.39	63.5	1634719.0
2017-02-08 14:00:00	MSFT	Stock	63.49	63.53	63.35	63.35	1680398.0
2017-02-08 15:00:00	MSFT	Stock	63.35	63.48	63.28	63.33	2775247.0
2017-02-08 16:00:00	MSFT	Stock	63.34	63.34	63.29	63.3	2182422.0
2017-02-08 17:00:00	MSFT	Stock	63.36	63.38	63.34	63.37	202445.0
2017-02-08 18:00:00	MSFT	Stock	63.37	63.37	63.37	63.37	700.0
2017-02-08 19:00:00	MSFT	Stock	63.36	63.36	63.32	63.32	4384.0
2017-02-08 04:00:00	NVDA	Stock	2.9998	2.9998	2.9998	2.9998	8000.0
2017-02-08 05:00:00	NVDA	Stock	3.007	3.0195	3.0	3.0	360040.0
2017-02-08 06:00:00	NVDA	Stock	2.9975	2.9988	2.98	2.9825	521760.0
2017-02-08 07:00:00	NVDA	Stock	2.9843	2.9858	2.965	2.9688	658480.0
2017-02-08 08:00:00	NVDA	Stock	2.9698	2.9858	2.9593	2.9672	1851480.0
2017-02-08 09:00:00	NVDA	Stock	2.9725	2.9725	2.9095	2.9275	105787640.0
2017-02-08 10:00:00	NVDA	Stock	2.9268	2.9558	2.9212	2.9484	86268480.0
2017-02-08 11:00:00	NVDA	Stock	2.9483	2.9695	2.9455	2.9672	39118560.0
2017-02-08 12:00:00	NVDA	Stock	2.9672	2.9748	2.9512	2.9574	38595960.0
2017-02-08 13:00:00	NVDA	Stock	2.957	2.9793	2.9565	2.9702	42731600.0
2017-02-08 14:00:00	NVDA	Stock	2.9702	2.9828	2.9683	2.9769	36106280.0
2017-02-08 15:00:00	NVDA	Stock	2.9765	2.9765	2.964	2.9658	60494560.0
2017-02-08 16:00:00	NVDA	Stock	2.9648	2.9705	2.9612	2.9612	1567440.0
2017-02-08 17:00:00	NVDA	Stock	2.9655	2.9663	2.963	2.9663	250880.0
2017-02-08 18:00:00	NVDA	Stock	2.9633	2.9633	2.9588	2.9612	202640.0
2017-02-08 19:00:00	NVDA	Stock	2.9612	2.9612	2.96	2.9612	173160.0
2017-02-08 07:00:00	AMZN	Stock	40.657	40.675	40.657	40.675	6660.0
2017-02-08 08:00:00	AMZN	Stock	40.65	40.65	40.601	40.625	78320.0
2017-02-08 09:00:00	AMZN	Stock	40.6575	40.8995	40.6	40.8415	7934200.0
2017-02-08 10:00:00	AMZN	Stock	40.843	40.995	40.7785	40.9525	11241080.0
2017-02-08 11:00:00	AMZN	Stock	40.944	40.9835	40.8645	40.947	4947860.0
2017-02-08 12:00:00	AMZN	Stock	40.95	41.0	40.869	40.917	4457500.0
2017-02-08 13:00:00	AMZN	Stock	40.916	40.9815	40.916	40.975	3004480.0

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

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