PREVIEW / stock_1hour / 2019-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-20.parquet
  size:    1.1 MB
  rows:    51,204
  symbols: 2,500

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
2019-11-20 04:00:00	AAPL	Stock	66.2475	66.2475	66.075	66.22	20012.0
2019-11-20 05:00:00	AAPL	Stock	66.215	66.215	66.09	66.09	24700.0
2019-11-20 06:00:00	AAPL	Stock	66.15	66.255	66.05	66.255	58892.0
2019-11-20 07:00:00	AAPL	Stock	66.275	66.3375	66.2075	66.2225	174492.0
2019-11-20 08:00:00	AAPL	Stock	66.255	66.3375	66.2	66.225	298476.0
2019-11-20 09:00:00	AAPL	Stock	66.2175	66.5208	66.2	66.3025	8587364.0
2019-11-20 10:00:00	AAPL	Stock	66.3062	66.3825	66.0575	66.2588	9292512.0
2019-11-20 11:00:00	AAPL	Stock	66.2625	66.305	65.8525	65.89	7836412.0
2019-11-20 12:00:00	AAPL	Stock	65.892	66.075	65.166	65.4275	10578828.0
2019-11-20 13:00:00	AAPL	Stock	65.4325	65.5825	65.1	65.5125	15433124.0
2019-11-20 14:00:00	AAPL	Stock	65.5128	65.705	65.3025	65.5625	9152320.0
2019-11-20 15:00:00	AAPL	Stock	65.5625	65.8075	65.45	65.805	12406160.0
2019-11-20 16:00:00	AAPL	Stock	65.7975	65.7975	65.705	65.77	11019216.0
2019-11-20 17:00:00	AAPL	Stock	65.7875	66.2175	65.7875	65.9425	443040.0
2019-11-20 18:00:00	AAPL	Stock	65.94	66.0625	65.805	65.9875	72680.0
2019-11-20 19:00:00	AAPL	Stock	66.0	66.075	65.8125	65.8375	124188.0
2019-11-20 04:00:00	MSFT	Stock	149.55	149.55	149.12	149.45	10391.0
2019-11-20 05:00:00	MSFT	Stock	149.49	149.51	149.35	149.35	4150.0
2019-11-20 06:00:00	MSFT	Stock	149.31	149.48	149.21	149.45	9653.0
2019-11-20 07:00:00	MSFT	Stock	149.6	149.8	149.46	149.6	13128.0
2019-11-20 08:00:00	MSFT	Stock	149.463	149.79	149.463	149.62	27605.0
2019-11-20 09:00:00	MSFT	Stock	149.57	150.95	149.55	150.605	3075391.0
2019-11-20 10:00:00	MSFT	Stock	150.61	150.698	150.07	150.328	2472562.0
2019-11-20 11:00:00	MSFT	Stock	150.33	150.465	149.96	150.06	1587138.0
2019-11-20 12:00:00	MSFT	Stock	150.079	150.22	148.96	149.31	2138079.0
2019-11-20 13:00:00	MSFT	Stock	149.32	149.35	148.46	149.129	3325573.0
2019-11-20 14:00:00	MSFT	Stock	149.12	149.6	148.81	149.38	1534655.0
2019-11-20 15:00:00	MSFT	Stock	149.373	149.62	149.08	149.62	2403068.0
2019-11-20 16:00:00	MSFT	Stock	149.62	150.205	148.845	149.39	3620865.0
2019-11-20 17:00:00	MSFT	Stock	149.4	149.43	149.06	149.283	20717.0
2019-11-20 18:00:00	MSFT	Stock	149.16	149.29	149.0	149.25	3952.0
2019-11-20 19:00:00	MSFT	Stock	149.18	149.29	148.7	148.7	19808.0
2019-11-20 04:00:00	NVDA	Stock	5.1735	5.1735	5.1588	5.1588	27520.0
2019-11-20 06:00:00	NVDA	Stock	5.1588	5.1655	5.1588	5.1655	50520.0
2019-11-20 07:00:00	NVDA	Stock	5.1625	5.1748	5.154	5.1698	146120.0
2019-11-20 08:00:00	NVDA	Stock	5.1625	5.1718	5.1515	5.1628	856280.0
2019-11-20 09:00:00	NVDA	Stock	5.1654	5.2068	5.1611	5.198	29087360.0
2019-11-20 10:00:00	NVDA	Stock	5.198	5.326	5.1908	5.3225	82847080.0
2019-11-20 11:00:00	NVDA	Stock	5.3225	5.3338	5.2888	5.3042	48716480.0
2019-11-20 12:00:00	NVDA	Stock	5.3038	5.3638	5.244	5.273	77156280.0
2019-11-20 13:00:00	NVDA	Stock	5.2712	5.2798	5.1955	5.2748	84101440.0
2019-11-20 14:00:00	NVDA	Stock	5.275	5.289	5.2502	5.2766	38886280.0
2019-11-20 15:00:00	NVDA	Stock	5.2766	5.283	5.2548	5.2794	44742440.0
2019-11-20 16:00:00	NVDA	Stock	5.2795	5.3378	5.2678	5.2728	20943040.0
2019-11-20 17:00:00	NVDA	Stock	5.2748	5.2748	5.25	5.2553	254360.0
2019-11-20 18:00:00	NVDA	Stock	5.262	5.27	5.262	5.2653	227360.0
2019-11-20 19:00:00	NVDA	Stock	5.2675	5.2675	5.2575	5.2625	214320.0
2019-11-20 04:00:00	AMZN	Stock	87.2	87.2	87.2	87.2	3420.0
2019-11-20 07:00:00	AMZN	Stock	87.3495	87.419	87.326	87.337	21360.0
2019-11-20 08:00:00	AMZN	Stock	87.3	87.4225	87.251	87.295	55720.0

> showing 50 of 51,204 rows — these rows as CSV

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