PREVIEW / stock_1hour / 2018-09-05

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-05.parquet
  size:    1.1 MB
  rows:    49,172
  symbols: 2,782

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-09-05 04:00:00	AAPL	Stock	57.0625	57.125	56.9625	57.05	32976.0
2018-09-05 05:00:00	AAPL	Stock	57.0475	57.05	56.9475	56.9625	32944.0
2018-09-05 06:00:00	AAPL	Stock	56.9625	57.0175	56.9	57.0125	25220.0
2018-09-05 07:00:00	AAPL	Stock	57.02	57.0825	57.0	57.0625	117564.0
2018-09-05 08:00:00	AAPL	Stock	57.025	57.225	56.98	57.1125	274952.0
2018-09-05 09:00:00	AAPL	Stock	57.1125	57.4175	56.5908	56.6052	18795548.0
2018-09-05 10:00:00	AAPL	Stock	56.61	56.75	56.275	56.6592	25291380.0
2018-09-05 11:00:00	AAPL	Stock	56.66	56.89	56.415	56.7975	13452716.0
2018-09-05 12:00:00	AAPL	Stock	56.8	57.2425	56.7975	57.0025	13843152.0
2018-09-05 13:00:00	AAPL	Stock	57.0025	57.2175	56.965	57.045	7552084.0
2018-09-05 14:00:00	AAPL	Stock	57.045	57.09	56.71	56.795	8770984.0
2018-09-05 15:00:00	AAPL	Stock	56.7925	56.8575	56.48	56.7175	16301472.0
2018-09-05 16:00:00	AAPL	Stock	56.7175	56.78	56.69	56.7325	9469648.0
2018-09-05 17:00:00	AAPL	Stock	56.7325	56.75	56.7225	56.75	44980.0
2018-09-05 18:00:00	AAPL	Stock	56.7325	56.735	56.7	56.7025	57316.0
2018-09-05 19:00:00	AAPL	Stock	56.7025	56.735	56.6625	56.67	66104.0
2018-09-05 04:00:00	MSFT	Stock	111.44	111.44	111.44	111.44	400.0
2018-09-05 05:00:00	MSFT	Stock	111.37	111.37	111.37	111.37	100.0
2018-09-05 06:00:00	MSFT	Stock	111.43	111.43	111.43	111.43	100.0
2018-09-05 07:00:00	MSFT	Stock	111.51	111.75	111.51	111.6	9570.0
2018-09-05 08:00:00	MSFT	Stock	111.5	111.76	111.41	111.64	11652.0
2018-09-05 09:00:00	MSFT	Stock	111.478	111.71	110.28	110.37	2406917.0
2018-09-05 10:00:00	MSFT	Stock	110.37	110.51	108.525	109.18	6707273.0
2018-09-05 11:00:00	MSFT	Stock	109.175	109.26	108.1	108.575	3745802.0
2018-09-05 12:00:00	MSFT	Stock	108.58	109.354	108.576	108.87	2945966.0
2018-09-05 13:00:00	MSFT	Stock	108.87	109.35	108.72	109.11	2120082.0
2018-09-05 14:00:00	MSFT	Stock	109.12	109.18	108.55	108.72	2042598.0
2018-09-05 15:00:00	MSFT	Stock	108.72	108.895	108.13	108.51	5585838.0
2018-09-05 16:00:00	MSFT	Stock	108.49	108.602	108.213	108.59	3590504.0
2018-09-05 17:00:00	MSFT	Stock	108.54	108.68	108.5	108.68	4383.0
2018-09-05 18:00:00	MSFT	Stock	108.55	108.66	108.55	108.6	1707.0
2018-09-05 19:00:00	MSFT	Stock	108.56	108.69	108.49	108.57	28458.0
2018-09-05 05:00:00	NVDA	Stock	7.0638	7.0638	7.0638	7.0638	7320.0
2018-09-05 06:00:00	NVDA	Stock	7.0582	7.0658	7.0582	7.0658	86360.0
2018-09-05 07:00:00	NVDA	Stock	7.0738	7.0738	7.0622	7.0662	142840.0
2018-09-05 08:00:00	NVDA	Stock	7.0625	7.0812	7.0625	7.075	683720.0
2018-09-05 09:00:00	NVDA	Stock	7.075	7.1105	6.9625	6.9663	45441280.0
2018-09-05 10:00:00	NVDA	Stock	6.9664	6.9905	6.884	6.9752	97300080.0
2018-09-05 11:00:00	NVDA	Stock	6.9758	6.9865	6.9264	6.9805	34988480.0
2018-09-05 12:00:00	NVDA	Stock	6.9803	7.0312	6.9608	6.965	36428680.0
2018-09-05 13:00:00	NVDA	Stock	6.962	6.9898	6.8788	6.974	45296600.0
2018-09-05 14:00:00	NVDA	Stock	6.9743	6.987	6.9478	6.9505	18393600.0
2018-09-05 15:00:00	NVDA	Stock	6.9515	6.9665	6.9363	6.961	44719480.0
2018-09-05 16:00:00	NVDA	Stock	6.9605	6.9605	6.9442	6.955	23442000.0
2018-09-05 17:00:00	NVDA	Stock	6.9595	6.96	6.9365	6.9365	126800.0
2018-09-05 18:00:00	NVDA	Stock	6.95	6.9562	6.9388	6.9392	62080.0
2018-09-05 19:00:00	NVDA	Stock	6.9392	6.9562	6.9392	6.943	67600.0
2018-09-05 04:00:00	AMZN	Stock	102.0	102.0	101.85	101.95	8360.0
2018-09-05 05:00:00	AMZN	Stock	101.95	101.95	101.732	101.7365	13000.0
2018-09-05 06:00:00	AMZN	Stock	101.75	101.869	101.75	101.869	6000.0

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

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