PREVIEW / stock_1hour / 2019-10-07

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-07.parquet
  size:    1.1 MB
  rows:    49,201
  symbols: 2,532

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-10-07 04:00:00	AAPL	Stock	56.62	56.62	56.4375	56.455	33072.0
2019-10-07 05:00:00	AAPL	Stock	56.4725	56.5	56.425	56.5	14604.0
2019-10-07 06:00:00	AAPL	Stock	56.525	56.75	56.4625	56.75	58808.0
2019-10-07 07:00:00	AAPL	Stock	56.75	56.785	56.6275	56.66	129704.0
2019-10-07 08:00:00	AAPL	Stock	56.7625	56.78	56.59	56.5925	216544.0
2019-10-07 09:00:00	AAPL	Stock	56.62	56.98	56.46	56.7625	14132852.0
2019-10-07 10:00:00	AAPL	Stock	56.77	57.204	56.7325	57.19	16995032.0
2019-10-07 11:00:00	AAPL	Stock	57.19	57.355	57.1425	57.3525	13398964.0
2019-10-07 12:00:00	AAPL	Stock	57.354	57.3675	57.2	57.3488	9016160.0
2019-10-07 13:00:00	AAPL	Stock	57.3475	57.4825	57.1555	57.4702	13582428.0
2019-10-07 14:00:00	AAPL	Stock	57.4725	57.479	56.6475	56.8565	17050756.0
2019-10-07 15:00:00	AAPL	Stock	56.86	56.9975	56.6525	56.765	13199728.0
2019-10-07 16:00:00	AAPL	Stock	56.765	56.82	56.745	56.8	6703660.0
2019-10-07 17:00:00	AAPL	Stock	56.805	56.8125	56.775	56.7875	35544.0
2019-10-07 18:00:00	AAPL	Stock	56.7875	56.815	56.6875	56.7875	41636.0
2019-10-07 19:00:00	AAPL	Stock	56.815	56.875	56.8125	56.86	42328.0
2019-10-07 04:00:00	MSFT	Stock	137.88	137.88	137.59	137.59	1684.0
2019-10-07 05:00:00	MSFT	Stock	137.5	137.5	137.5	137.5	407.0
2019-10-07 06:00:00	MSFT	Stock	137.86	138.01	137.86	138.01	500.0
2019-10-07 07:00:00	MSFT	Stock	138.08	138.08	137.89	137.95	6700.0
2019-10-07 08:00:00	MSFT	Stock	137.99	138.07	137.8	137.85	16110.0
2019-10-07 09:00:00	MSFT	Stock	137.97	137.97	137.03	137.2	1455325.0
2019-10-07 10:00:00	MSFT	Stock	137.21	137.61	137.05	137.525	1473730.0
2019-10-07 11:00:00	MSFT	Stock	137.53	138.03	137.51	138.017	1425127.0
2019-10-07 12:00:00	MSFT	Stock	138.01	138.024	137.47	137.56	1035118.0
2019-10-07 13:00:00	MSFT	Stock	137.56	138.18	137.31	137.94	1515971.0
2019-10-07 14:00:00	MSFT	Stock	137.94	137.985	137.18	137.398	1165091.0
2019-10-07 15:00:00	MSFT	Stock	137.4	137.68	137.02	137.1	2357751.0
2019-10-07 16:00:00	MSFT	Stock	137.12	138.35	137.06	138.0	2661446.0
2019-10-07 17:00:00	MSFT	Stock	137.95	138.0	137.8	137.9	23589.0
2019-10-07 18:00:00	MSFT	Stock	137.68	137.94	137.53	137.86	22675.0
2019-10-07 19:00:00	MSFT	Stock	137.9	137.97	137.9	137.97	5053.0
2019-10-07 04:00:00	NVDA	Stock	4.525	4.5275	4.525	4.5275	128000.0
2019-10-07 05:00:00	NVDA	Stock	4.5275	4.5312	4.5273	4.5312	97880.0
2019-10-07 06:00:00	NVDA	Stock	4.5362	4.5925	4.5362	4.5925	256560.0
2019-10-07 07:00:00	NVDA	Stock	4.5752	4.6188	4.5662	4.6088	1268240.0
2019-10-07 08:00:00	NVDA	Stock	4.585	4.6325	4.538	4.613	2619960.0
2019-10-07 09:00:00	NVDA	Stock	4.6075	4.7085	4.6075	4.6938	94757120.0
2019-10-07 10:00:00	NVDA	Stock	4.6961	4.7083	4.673	4.6925	69219360.0
2019-10-07 11:00:00	NVDA	Stock	4.6935	4.7013	4.653	4.6675	54329320.0
2019-10-07 12:00:00	NVDA	Stock	4.6672	4.673	4.642	4.6468	28105320.0
2019-10-07 13:00:00	NVDA	Stock	4.6465	4.665	4.6098	4.661	53200800.0
2019-10-07 14:00:00	NVDA	Stock	4.6622	4.6628	4.6134	4.6348	32116600.0
2019-10-07 15:00:00	NVDA	Stock	4.6358	4.6382	4.6057	4.6083	70324520.0
2019-10-07 16:00:00	NVDA	Stock	4.6083	4.6263	4.5902	4.601	4360320.0
2019-10-07 17:00:00	NVDA	Stock	4.5963	4.605	4.5875	4.5875	595280.0
2019-10-07 18:00:00	NVDA	Stock	4.5883	4.6	4.5875	4.6	197360.0
2019-10-07 19:00:00	NVDA	Stock	4.5952	4.6057	4.5952	4.6057	278600.0
2019-10-07 04:00:00	AMZN	Stock	86.621	86.621	86.621	86.621	7120.0
2019-10-07 05:00:00	AMZN	Stock	86.6	86.6	86.6	86.6	3280.0

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

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