PREVIEW / stock_1hour / 2018-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-16.parquet
  size:    1.1 MB
  rows:    48,887
  symbols: 2,801

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-07-16 05:00:00	AAPL	Stock	48.0	48.0	48.0	48.0	2800.0
2018-07-16 07:00:00	AAPL	Stock	47.92	47.9675	47.85	47.91	113372.0
2018-07-16 08:00:00	AAPL	Stock	47.9425	47.9725	47.8625	47.8625	128476.0
2018-07-16 09:00:00	AAPL	Stock	47.875	48.1625	47.8325	48.0925	9347816.0
2018-07-16 10:00:00	AAPL	Stock	48.0925	48.1095	47.7825	47.7925	8658112.0
2018-07-16 11:00:00	AAPL	Stock	47.7925	47.855	47.743	47.8275	4576948.0
2018-07-16 12:00:00	AAPL	Stock	47.8275	47.8425	47.7175	47.7202	4652492.0
2018-07-16 13:00:00	AAPL	Stock	47.7225	47.7465	47.6475	47.695	4328188.0
2018-07-16 14:00:00	AAPL	Stock	47.695	47.7075	47.6038	47.6638	4355780.0
2018-07-16 15:00:00	AAPL	Stock	47.665	47.745	47.6325	47.73	8507660.0
2018-07-16 16:00:00	AAPL	Stock	47.7275	47.7275	47.4075	47.475	8511700.0
2018-07-16 17:00:00	AAPL	Stock	47.4875	47.52	47.415	47.5	53380.0
2018-07-16 18:00:00	AAPL	Stock	47.495	47.5175	47.4775	47.5175	29372.0
2018-07-16 19:00:00	AAPL	Stock	47.5075	47.525	47.475	47.4925	38712.0
2018-07-16 04:00:00	MSFT	Stock	105.98	105.98	105.97	105.97	200.0
2018-07-16 05:00:00	MSFT	Stock	105.93	105.96	105.87	105.87	700.0
2018-07-16 06:00:00	MSFT	Stock	105.87	105.87	105.7	105.77	2932.0
2018-07-16 07:00:00	MSFT	Stock	105.69	105.79	105.53	105.7	8264.0
2018-07-16 08:00:00	MSFT	Stock	105.8	105.93	105.5	105.64	37404.0
2018-07-16 09:00:00	MSFT	Stock	105.67	105.82	105.24	105.42	2977894.0
2018-07-16 10:00:00	MSFT	Stock	105.425	105.585	105.08	105.09	2927499.0
2018-07-16 11:00:00	MSFT	Stock	105.09	105.4	105.08	105.245	1797274.0
2018-07-16 12:00:00	MSFT	Stock	105.245	105.29	104.96	105.11	1744890.0
2018-07-16 13:00:00	MSFT	Stock	105.115	105.135	104.77	104.805	1444992.0
2018-07-16 14:00:00	MSFT	Stock	104.8	104.845	104.515	104.615	1680511.0
2018-07-16 15:00:00	MSFT	Stock	104.62	104.97	104.52	104.92	3354074.0
2018-07-16 16:00:00	MSFT	Stock	104.91	105.035	104.248	104.5	2706803.0
2018-07-16 17:00:00	MSFT	Stock	104.5	104.7	104.21	104.44	8133.0
2018-07-16 18:00:00	MSFT	Stock	104.46	104.5	104.35	104.35	9679.0
2018-07-16 19:00:00	MSFT	Stock	104.3	104.57	104.25	104.41	8384.0
2018-07-16 07:00:00	NVDA	Stock	6.233	6.2438	6.233	6.2375	56760.0
2018-07-16 08:00:00	NVDA	Stock	6.2375	6.2468	6.2275	6.2362	372120.0
2018-07-16 09:00:00	NVDA	Stock	6.24	6.2585	6.205	6.241	35708920.0
2018-07-16 10:00:00	NVDA	Stock	6.2424	6.2515	6.197	6.2015	34001480.0
2018-07-16 11:00:00	NVDA	Stock	6.2013	6.2285	6.1925	6.2252	20877200.0
2018-07-16 12:00:00	NVDA	Stock	6.2255	6.2315	6.2112	6.2278	9961240.0
2018-07-16 13:00:00	NVDA	Stock	6.2273	6.233	6.2138	6.2195	9602000.0
2018-07-16 14:00:00	NVDA	Stock	6.2198	6.2308	6.1981	6.1995	19009760.0
2018-07-16 15:00:00	NVDA	Stock	6.2003	6.2128	6.194	6.205	27861080.0
2018-07-16 16:00:00	NVDA	Stock	6.205	6.207	6.1255	6.13	13972160.0
2018-07-16 17:00:00	NVDA	Stock	6.125	6.13	6.106	6.13	737720.0
2018-07-16 18:00:00	NVDA	Stock	6.13	6.1495	6.1218	6.145	264440.0
2018-07-16 19:00:00	NVDA	Stock	6.145	6.1575	6.145	6.1558	273200.0
2018-07-16 04:00:00	AMZN	Stock	91.0	91.139	91.0	91.139	6000.0
2018-07-16 05:00:00	AMZN	Stock	91.1	91.3	91.1	91.1	59080.0
2018-07-16 06:00:00	AMZN	Stock	91.103	91.1895	91.0	91.0	18440.0
2018-07-16 07:00:00	AMZN	Stock	91.0495	91.0495	90.825	90.9225	272320.0
2018-07-16 08:00:00	AMZN	Stock	91.0205	91.1475	90.86	91.1	548700.0
2018-07-16 09:00:00	AMZN	Stock	91.1025	91.39	90.6515	91.374	16460960.0
2018-07-16 10:00:00	AMZN	Stock	91.3701	91.5855	91.1425	91.2685	15818100.0

> showing 50 of 48,887 rows — these rows as CSV

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