PREVIEW / stock_1hour / 2018-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-14.parquet
  size:    1.1 MB
  rows:    49,111
  symbols: 2,816

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-08-14 04:00:00	AAPL	Stock	52.5025	52.5875	52.5	52.5	6776.0
2018-08-14 05:00:00	AAPL	Stock	52.5375	52.5375	52.5	52.5	876.0
2018-08-14 06:00:00	AAPL	Stock	52.55	52.6075	52.5	52.575	46268.0
2018-08-14 07:00:00	AAPL	Stock	52.555	52.56	52.465	52.5025	90468.0
2018-08-14 08:00:00	AAPL	Stock	52.55	52.5625	52.4425	52.485	240776.0
2018-08-14 09:00:00	AAPL	Stock	52.4725	52.64	52.2125	52.3025	13327740.0
2018-08-14 10:00:00	AAPL	Stock	52.3075	52.4625	52.065	52.41	13740964.0
2018-08-14 11:00:00	AAPL	Stock	52.41	52.4125	52.2512	52.32	9317892.0
2018-08-14 12:00:00	AAPL	Stock	52.3225	52.4425	52.275	52.31	5690196.0
2018-08-14 13:00:00	AAPL	Stock	52.3088	52.3975	52.295	52.3875	3796400.0
2018-08-14 14:00:00	AAPL	Stock	52.3925	52.455	52.34	52.4125	5186184.0
2018-08-14 15:00:00	AAPL	Stock	52.41	52.45	52.3825	52.44	8096908.0
2018-08-14 16:00:00	AAPL	Stock	52.415	52.4625	52.415	52.46	5537992.0
2018-08-14 17:00:00	AAPL	Stock	52.46	52.4925	52.4425	52.4875	71516.0
2018-08-14 18:00:00	AAPL	Stock	52.4875	52.49	52.4	52.435	106428.0
2018-08-14 19:00:00	AAPL	Stock	52.435	52.4625	52.425	52.4625	113336.0
2018-08-14 04:00:00	MSFT	Stock	109.0	109.0	109.0	109.0	2050.0
2018-08-14 05:00:00	MSFT	Stock	108.98	108.99	108.97	108.97	759.0
2018-08-14 06:00:00	MSFT	Stock	109.0	109.0	108.54	108.54	3296.0
2018-08-14 07:00:00	MSFT	Stock	108.78	108.78	108.65	108.75	1015.0
2018-08-14 08:00:00	MSFT	Stock	108.8	108.8	108.55	108.72	8079.0
2018-08-14 09:00:00	MSFT	Stock	108.63	108.78	108.17	108.29	1957873.0
2018-08-14 10:00:00	MSFT	Stock	108.29	109.175	108.04	109.16	2251847.0
2018-08-14 11:00:00	MSFT	Stock	109.165	109.52	109.11	109.265	2087420.0
2018-08-14 12:00:00	MSFT	Stock	109.27	109.47	109.21	109.305	1166321.0
2018-08-14 13:00:00	MSFT	Stock	109.305	109.5	109.28	109.49	1249508.0
2018-08-14 14:00:00	MSFT	Stock	109.5	109.66	109.32	109.635	1338764.0
2018-08-14 15:00:00	MSFT	Stock	109.635	109.75	109.51	109.57	3247640.0
2018-08-14 16:00:00	MSFT	Stock	109.56	109.73	109.54	109.63	1944230.0
2018-08-14 17:00:00	MSFT	Stock	109.683	109.78	109.63	109.65	11747.0
2018-08-14 18:00:00	MSFT	Stock	109.64	109.74	109.64	109.74	1957.0
2018-08-14 19:00:00	MSFT	Stock	109.7	109.74	109.68	109.74	4755.0
2018-08-14 04:00:00	NVDA	Stock	6.5	6.5038	6.4825	6.5	37720.0
2018-08-14 06:00:00	NVDA	Stock	6.5	6.513	6.5	6.513	26400.0
2018-08-14 07:00:00	NVDA	Stock	6.5	6.519	6.4788	6.4945	518960.0
2018-08-14 08:00:00	NVDA	Stock	6.5	6.5222	6.4788	6.5075	1903640.0
2018-08-14 09:00:00	NVDA	Stock	6.5075	6.5407	6.469	6.4916	97915040.0
2018-08-14 10:00:00	NVDA	Stock	6.4929	6.5125	6.4255	6.5005	85709080.0
2018-08-14 11:00:00	NVDA	Stock	6.5002	6.5315	6.485	6.518	46166480.0
2018-08-14 12:00:00	NVDA	Stock	6.5174	6.5385	6.4963	6.4979	41450080.0
2018-08-14 13:00:00	NVDA	Stock	6.4992	6.5144	6.4875	6.508	26874120.0
2018-08-14 14:00:00	NVDA	Stock	6.508	6.5255	6.4978	6.5215	31624760.0
2018-08-14 15:00:00	NVDA	Stock	6.5212	6.55	6.5212	6.5365	67104520.0
2018-08-14 16:00:00	NVDA	Stock	6.5358	6.5463	6.5335	6.5412	3748920.0
2018-08-14 17:00:00	NVDA	Stock	6.55	6.6075	6.5405	6.5982	4507000.0
2018-08-14 18:00:00	NVDA	Stock	6.5963	6.6	6.5788	6.59	2416680.0
2018-08-14 19:00:00	NVDA	Stock	6.5938	6.5975	6.5825	6.5845	1630600.0
2018-08-14 04:00:00	AMZN	Stock	95.555	95.787	95.555	95.75	34680.0
2018-08-14 05:00:00	AMZN	Stock	95.75	95.785	95.75	95.785	8320.0
2018-08-14 06:00:00	AMZN	Stock	95.8435	96.1445	95.8435	96.1445	63400.0

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

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