PREVIEW / stock_1hour / 2017-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-17.parquet
  size:    1.1 MB
  rows:    48,726
  symbols: 3,049

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-05-17 04:00:00	AAPL	Stock	38.6875	38.7375	38.675	38.6875	37636.0
2017-05-17 05:00:00	AAPL	Stock	38.675	38.675	38.6275	38.675	19244.0
2017-05-17 06:00:00	AAPL	Stock	38.675	38.71	38.65	38.71	42064.0
2017-05-17 07:00:00	AAPL	Stock	38.7125	38.735	38.6625	38.695	55968.0
2017-05-17 08:00:00	AAPL	Stock	38.6775	38.735	38.4525	38.4625	659196.0
2017-05-17 09:00:00	AAPL	Stock	38.4625	38.8675	38.3	38.3	20316408.0
2017-05-17 10:00:00	AAPL	Stock	38.3025	38.3678	37.5	37.7312	39683992.0
2017-05-17 11:00:00	AAPL	Stock	37.7325	38.115	37.695	38.0775	24591024.0
2017-05-17 12:00:00	AAPL	Stock	38.0775	38.1025	37.8825	37.9825	12351780.0
2017-05-17 13:00:00	AAPL	Stock	37.98	38.035	37.755	37.7575	13491720.0
2017-05-17 14:00:00	AAPL	Stock	37.7575	37.8375	37.475	37.6075	26210076.0
2017-05-17 15:00:00	AAPL	Stock	37.6075	37.745	37.4275	37.55	33901964.0
2017-05-17 16:00:00	AAPL	Stock	37.5475	37.68	37.5425	37.6	11771752.0
2017-05-17 17:00:00	AAPL	Stock	37.6	37.6175	37.57	37.5975	54628.0
2017-05-17 18:00:00	AAPL	Stock	37.575	37.64	37.575	37.6375	135892.0
2017-05-17 19:00:00	AAPL	Stock	37.64	37.7325	37.6325	37.7325	141576.0
2017-05-17 05:00:00	MSFT	Stock	69.12	69.12	69.12	69.12	200.0
2017-05-17 06:00:00	MSFT	Stock	69.05	69.05	69.05	69.05	500.0
2017-05-17 07:00:00	MSFT	Stock	69.08	69.15	69.08	69.11	1200.0
2017-05-17 08:00:00	MSFT	Stock	69.01	69.11	68.86	68.99	37508.0
2017-05-17 09:00:00	MSFT	Stock	68.87	69.1	68.63	68.86	3068126.0
2017-05-17 10:00:00	MSFT	Stock	68.87	68.89	68.24	68.285	3741486.0
2017-05-17 11:00:00	MSFT	Stock	68.28	68.52	68.12	68.485	2764772.0
2017-05-17 12:00:00	MSFT	Stock	68.487	68.487	68.26	68.34	2205289.0
2017-05-17 13:00:00	MSFT	Stock	68.346	68.36	67.92	67.96	1892146.0
2017-05-17 14:00:00	MSFT	Stock	67.96	68.04	67.655	67.825	3389169.0
2017-05-17 15:00:00	MSFT	Stock	67.83	67.905	67.43	67.45	6573329.0
2017-05-17 16:00:00	MSFT	Stock	67.46	67.6	67.45	67.5	3457574.0
2017-05-17 17:00:00	MSFT	Stock	67.56	67.56	67.45	67.45	799.0
2017-05-17 18:00:00	MSFT	Stock	67.45	67.56	67.35	67.48	8693.0
2017-05-17 19:00:00	MSFT	Stock	67.48	67.67	67.46	67.65	12704.0
2017-05-17 04:00:00	NVDA	Stock	3.38	3.38	3.3775	3.3775	96000.0
2017-05-17 05:00:00	NVDA	Stock	3.3738	3.3972	3.3675	3.3782	252960.0
2017-05-17 06:00:00	NVDA	Stock	3.365	3.3875	3.365	3.3875	180640.0
2017-05-17 07:00:00	NVDA	Stock	3.3838	3.3895	3.375	3.375	477320.0
2017-05-17 08:00:00	NVDA	Stock	3.3755	3.4168	3.364	3.3688	5055440.0
2017-05-17 09:00:00	NVDA	Stock	3.3688	3.3715	3.319	3.3192	149899080.0
2017-05-17 10:00:00	NVDA	Stock	3.3198	3.3345	3.2628	3.2715	217656000.0
2017-05-17 11:00:00	NVDA	Stock	3.2725	3.3015	3.2505	3.2965	168108080.0
2017-05-17 12:00:00	NVDA	Stock	3.2968	3.322	3.2828	3.3215	100828920.0
2017-05-17 13:00:00	NVDA	Stock	3.3215	3.3222	3.2642	3.275	137864560.0
2017-05-17 14:00:00	NVDA	Stock	3.2748	3.2795	3.202	3.21	172833080.0
2017-05-17 15:00:00	NVDA	Stock	3.21	3.2375	3.1888	3.1945	178995920.0
2017-05-17 16:00:00	NVDA	Stock	3.193	3.199	3.1855	3.1985	30792800.0
2017-05-17 17:00:00	NVDA	Stock	3.1975	3.2058	3.193	3.195	1154920.0
2017-05-17 18:00:00	NVDA	Stock	3.1965	3.2088	3.1952	3.207	621320.0
2017-05-17 19:00:00	NVDA	Stock	3.205	3.2292	3.2025	3.2242	1559600.0
2017-05-17 04:00:00	AMZN	Stock	48.0795	48.1	48.0795	48.1	22400.0
2017-05-17 06:00:00	AMZN	Stock	48.105	48.125	48.099	48.125	25420.0
2017-05-17 07:00:00	AMZN	Stock	48.144	48.144	48.1	48.115	18880.0

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

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