PREVIEW / stock_1hour / 2016-02-16

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-16.parquet
  size:    1.0 MB
  rows:    48,965
  symbols: 3,359

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-02-16 04:00:00	AAPL	Stock	23.46	24.0525	23.46	23.885	31828.0
2016-02-16 05:00:00	AAPL	Stock	23.8775	23.8775	23.8375	23.8375	6200.0
2016-02-16 06:00:00	AAPL	Stock	23.8375	23.85	23.7875	23.85	25824.0
2016-02-16 07:00:00	AAPL	Stock	23.8575	23.9025	23.8325	23.87	122360.0
2016-02-16 08:00:00	AAPL	Stock	23.8625	23.9025	23.45	23.7875	483752.0
2016-02-16 09:00:00	AAPL	Stock	23.785	23.8675	23.6525	23.795	23942408.0
2016-02-16 10:00:00	AAPL	Stock	23.7925	23.8625	23.71	23.8175	24160064.0
2016-02-16 11:00:00	AAPL	Stock	23.8175	23.9375	23.745	23.9362	19242284.0
2016-02-16 12:00:00	AAPL	Stock	23.9375	24.0355	23.9297	24.01	21172752.0
2016-02-16 13:00:00	AAPL	Stock	24.0095	24.1	23.9862	24.0725	17988860.0
2016-02-16 14:00:00	AAPL	Stock	24.0712	24.2125	24.0675	24.1225	22828048.0
2016-02-16 15:00:00	AAPL	Stock	24.1225	24.195	24.0275	24.155	36219756.0
2016-02-16 16:00:00	AAPL	Stock	24.155	24.16	23.9575	24.035	11539556.0
2016-02-16 17:00:00	AAPL	Stock	24.0525	24.16	23.975	24.0125	644092.0
2016-02-16 18:00:00	AAPL	Stock	24.02	24.02	23.975	24.0125	79652.0
2016-02-16 19:00:00	AAPL	Stock	24.015	24.1	24.015	24.0875	86340.0
2016-02-16 04:00:00	MSFT	Stock	50.75	50.92	50.75	50.92	1500.0
2016-02-16 05:00:00	MSFT	Stock	51.08	51.08	51.0	51.0	200.0
2016-02-16 06:00:00	MSFT	Stock	50.7	50.94	50.56	50.94	2405.0
2016-02-16 07:00:00	MSFT	Stock	51.0	51.0	50.82	50.82	3850.0
2016-02-16 08:00:00	MSFT	Stock	51.02	51.02	50.7	50.74	21607.0
2016-02-16 09:00:00	MSFT	Stock	50.76	51.0	50.57	50.725	3139901.0
2016-02-16 10:00:00	MSFT	Stock	50.725	50.8	50.38	50.41	2947616.0
2016-02-16 11:00:00	MSFT	Stock	50.41	50.717	50.13	50.69	3848224.0
2016-02-16 12:00:00	MSFT	Stock	50.7	50.9	50.63	50.835	2136968.0
2016-02-16 13:00:00	MSFT	Stock	50.84	50.91	50.75	50.81	2199998.0
2016-02-16 14:00:00	MSFT	Stock	50.805	50.885	50.66	50.725	2549213.0
2016-02-16 15:00:00	MSFT	Stock	50.73	51.09	50.61	51.09	9475952.0
2016-02-16 16:00:00	MSFT	Stock	51.08	51.09	50.9	50.91	6675282.0
2016-02-16 17:00:00	MSFT	Stock	50.91	51.03	50.91	51.03	3100.0
2016-02-16 18:00:00	MSFT	Stock	51.08	51.09	51.08	51.09	1127.0
2016-02-16 19:00:00	MSFT	Stock	51.05	51.29	51.05	51.29	4375.0
2016-02-16 07:00:00	NVDA	Stock	0.66	0.66	0.66	0.66	44000.0
2016-02-16 08:00:00	NVDA	Stock	0.6513	0.66	0.6513	0.655	146000.0
2016-02-16 09:00:00	NVDA	Stock	0.6548	0.6738	0.6505	0.6602	70881440.0
2016-02-16 10:00:00	NVDA	Stock	0.6602	0.6655	0.6572	0.6615	78502480.0
2016-02-16 11:00:00	NVDA	Stock	0.6612	0.6656	0.656	0.6642	36582640.0
2016-02-16 12:00:00	NVDA	Stock	0.6642	0.6655	0.66	0.6635	21746040.0
2016-02-16 13:00:00	NVDA	Stock	0.6636	0.6694	0.6615	0.6692	28816240.0
2016-02-16 14:00:00	NVDA	Stock	0.6692	0.6732	0.667	0.6695	39481800.0
2016-02-16 15:00:00	NVDA	Stock	0.6695	0.6758	0.6688	0.6748	119473840.0
2016-02-16 16:00:00	NVDA	Stock	0.6745	0.675	0.6722	0.6722	12586400.0
2016-02-16 17:00:00	NVDA	Stock	0.6742	0.6748	0.6698	0.6698	272960.0
2016-02-16 18:00:00	NVDA	Stock	0.6698	0.6748	0.6698	0.6748	94000.0
2016-02-16 19:00:00	NVDA	Stock	0.6748	0.6748	0.6748	0.6748	144800.0
2016-02-16 04:00:00	AMZN	Stock	26.025	26.025	26.0055	26.0055	4000.0
2016-02-16 06:00:00	AMZN	Stock	25.855	25.8605	25.837	25.8605	17200.0
2016-02-16 07:00:00	AMZN	Stock	25.855	25.95	25.855	25.901	162700.0
2016-02-16 08:00:00	AMZN	Stock	25.9	25.95	25.73	25.775	646080.0
2016-02-16 09:00:00	AMZN	Stock	25.797	26.2225	25.785	26.037	23915900.0

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

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