PREVIEW / stock_1hour / 2018-11-30

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-30.parquet
  size:    1.1 MB
  rows:    50,894
  symbols: 2,785

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
2018-11-30 04:00:00	AAPL	Stock	44.8025	44.8025	44.625	44.625	5716.0
2018-11-30 05:00:00	AAPL	Stock	44.685	44.7225	44.64	44.7	9876.0
2018-11-30 06:00:00	AAPL	Stock	44.695	44.695	44.4025	44.515	14600.0
2018-11-30 07:00:00	AAPL	Stock	44.61	44.66	44.475	44.6475	150352.0
2018-11-30 08:00:00	AAPL	Stock	44.5025	45.0225	44.47	45.0	514844.0
2018-11-30 09:00:00	AAPL	Stock	45.0025	45.0825	44.5325	44.5925	11996280.0
2018-11-30 10:00:00	AAPL	Stock	44.5962	44.7225	44.4775	44.5252	15174364.0
2018-11-30 11:00:00	AAPL	Stock	44.5232	44.6025	44.4	44.5525	12765020.0
2018-11-30 12:00:00	AAPL	Stock	44.555	44.5575	44.43	44.4325	7797304.0
2018-11-30 13:00:00	AAPL	Stock	44.4318	44.61	44.335	44.5275	10136468.0
2018-11-30 14:00:00	AAPL	Stock	44.5275	44.5378	44.2575	44.307	11007824.0
2018-11-30 15:00:00	AAPL	Stock	44.3062	44.8275	44.3062	44.65	29442956.0
2018-11-30 16:00:00	AAPL	Stock	44.65	44.7125	44.595	44.71	28907288.0
2018-11-30 17:00:00	AAPL	Stock	44.71	44.77	44.7	44.7275	175864.0
2018-11-30 18:00:00	AAPL	Stock	44.7275	44.7625	44.65	44.675	123216.0
2018-11-30 19:00:00	AAPL	Stock	44.69	44.72	44.665	44.7	77112.0
2018-11-30 07:00:00	MSFT	Stock	109.88	110.0	109.59	109.85	6842.0
2018-11-30 08:00:00	MSFT	Stock	109.608	110.49	109.6	110.42	31941.0
2018-11-30 09:00:00	MSFT	Stock	110.43	110.81	109.81	110.05	2563481.0
2018-11-30 10:00:00	MSFT	Stock	110.05	110.737	109.69	110.36	3581529.0
2018-11-30 11:00:00	MSFT	Stock	110.364	110.49	109.94	110.315	2404381.0
2018-11-30 12:00:00	MSFT	Stock	110.32	110.35	109.704	109.71	2105064.0
2018-11-30 13:00:00	MSFT	Stock	109.72	110.46	109.36	110.39	2746126.0
2018-11-30 14:00:00	MSFT	Stock	110.39	110.455	110.02	110.25	2174430.0
2018-11-30 15:00:00	MSFT	Stock	110.25	110.97	110.23	110.92	5848737.0
2018-11-30 16:00:00	MSFT	Stock	110.9	111.04	110.58	111.04	6953001.0
2018-11-30 17:00:00	MSFT	Stock	111.05	111.09	110.89	111.07	22629.0
2018-11-30 18:00:00	MSFT	Stock	110.94	111.0	110.9	110.95	4091.0
2018-11-30 19:00:00	MSFT	Stock	111.0	111.09	111.0	111.09	2079.0
2018-11-30 04:00:00	NVDA	Stock	3.9235	3.9235	3.9235	3.9235	5400.0
2018-11-30 06:00:00	NVDA	Stock	3.9142	3.9248	3.9142	3.92	14000.0
2018-11-30 07:00:00	NVDA	Stock	3.9195	3.9225	3.9025	3.9225	233120.0
2018-11-30 08:00:00	NVDA	Stock	3.9128	3.95	3.9065	3.9468	1462720.0
2018-11-30 09:00:00	NVDA	Stock	3.945	3.9792	3.893	3.9712	77519200.0
2018-11-30 10:00:00	NVDA	Stock	3.9722	4.0623	3.9585	4.0258	143540000.0
2018-11-30 11:00:00	NVDA	Stock	4.025	4.0655	4.0208	4.0514	80300560.0
2018-11-30 12:00:00	NVDA	Stock	4.0525	4.0708	4.023	4.0368	59803000.0
2018-11-30 13:00:00	NVDA	Stock	4.0374	4.0703	4.015	4.0544	54154480.0
2018-11-30 14:00:00	NVDA	Stock	4.0545	4.0758	4.043	4.0618	59824000.0
2018-11-30 15:00:00	NVDA	Stock	4.062	4.0965	4.062	4.0918	96891360.0
2018-11-30 16:00:00	NVDA	Stock	4.0913	4.0913	4.0728	4.0778	19237920.0
2018-11-30 17:00:00	NVDA	Stock	4.0772	4.0888	4.0772	4.087	1531640.0
2018-11-30 18:00:00	NVDA	Stock	4.0838	4.087	4.0812	4.0825	253720.0
2018-11-30 19:00:00	NVDA	Stock	4.0825	4.0868	4.0805	4.0868	466680.0
2018-11-30 07:00:00	AMZN	Stock	83.072	83.4	83.05	83.375	138880.0
2018-11-30 08:00:00	AMZN	Stock	83.05	84.35	83.0	84.2	722300.0
2018-11-30 09:00:00	AMZN	Stock	84.1415	84.166	83.325	83.9733	10889380.0
2018-11-30 10:00:00	AMZN	Stock	83.9527	84.7706	83.615	84.567	12688420.0
2018-11-30 11:00:00	AMZN	Stock	84.567	84.606	84.15	84.4935	10515460.0
2018-11-30 12:00:00	AMZN	Stock	84.4788	84.4943	83.9385	83.9455	6938720.0

> showing 50 of 50,894 rows — these rows as CSV

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