PREVIEW / stock_1hour / 2018-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-23.parquet
  size:    1.1 MB
  rows:    50,306
  symbols: 2,786

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-10-23 04:00:00	AAPL	Stock	54.9675	54.9675	54.3275	54.4	51748.0
2018-10-23 05:00:00	AAPL	Stock	54.3325	54.3625	54.22	54.3625	23020.0
2018-10-23 06:00:00	AAPL	Stock	54.325	54.4125	54.2125	54.4125	37928.0
2018-10-23 07:00:00	AAPL	Stock	54.4375	54.5225	54.085	54.2875	457496.0
2018-10-23 08:00:00	AAPL	Stock	54.4375	54.55	53.92	54.0575	1366020.0
2018-10-23 09:00:00	AAPL	Stock	54.0725	54.5175	53.79	54.1625	20727484.0
2018-10-23 10:00:00	AAPL	Stock	54.1625	54.3175	53.675	54.0725	24597096.0
2018-10-23 11:00:00	AAPL	Stock	54.0725	54.425	53.935	54.2188	13515540.0
2018-10-23 12:00:00	AAPL	Stock	54.2188	54.8575	54.215	54.6025	12723880.0
2018-10-23 13:00:00	AAPL	Stock	54.5975	54.97	54.5725	54.695	10081360.0
2018-10-23 14:00:00	AAPL	Stock	54.6925	55.5175	54.6925	55.46	13654152.0
2018-10-23 15:00:00	AAPL	Stock	55.4425	55.8125	55.44	55.6912	24328100.0
2018-10-23 16:00:00	AAPL	Stock	55.6825	55.805	55.6275	55.7875	7216216.0
2018-10-23 17:00:00	AAPL	Stock	55.7875	55.7925	55.65	55.65	135148.0
2018-10-23 18:00:00	AAPL	Stock	55.7	55.71	55.5875	55.5875	92964.0
2018-10-23 19:00:00	AAPL	Stock	55.575	55.6575	55.565	55.575	170524.0
2018-10-23 04:00:00	MSFT	Stock	108.8	108.8	107.63	107.63	8447.0
2018-10-23 05:00:00	MSFT	Stock	107.66	107.91	107.13	107.91	5071.0
2018-10-23 06:00:00	MSFT	Stock	107.7	108.0	107.66	108.0	1740.0
2018-10-23 07:00:00	MSFT	Stock	108.19	108.79	107.53	108.15	57909.0
2018-10-23 08:00:00	MSFT	Stock	107.94	108.62	107.53	108.0	85744.0
2018-10-23 09:00:00	MSFT	Stock	108.0	108.0	106.39	106.44	5360417.0
2018-10-23 10:00:00	MSFT	Stock	106.435	106.575	105.11	105.855	7463756.0
2018-10-23 11:00:00	MSFT	Stock	105.855	106.63	105.46	105.705	4775430.0
2018-10-23 12:00:00	MSFT	Stock	105.72	107.46	105.64	106.81	4081671.0
2018-10-23 13:00:00	MSFT	Stock	106.8	107.78	106.75	107.109	3255371.0
2018-10-23 14:00:00	MSFT	Stock	107.12	108.85	107.09	108.6	4193226.0
2018-10-23 15:00:00	MSFT	Stock	108.6	108.97	107.89	108.11	6420192.0
2018-10-23 16:00:00	MSFT	Stock	108.12	108.5	108.1	108.5	2665818.0
2018-10-23 17:00:00	MSFT	Stock	108.4	108.54	108.32	108.32	18285.0
2018-10-23 18:00:00	MSFT	Stock	108.35	108.45	108.13	108.17	29794.0
2018-10-23 19:00:00	MSFT	Stock	108.1	108.57	108.1	108.5	19231.0
2018-10-23 04:00:00	NVDA	Stock	5.722	5.722	5.625	5.625	132680.0
2018-10-23 05:00:00	NVDA	Stock	5.5928	5.62	5.5928	5.6125	114840.0
2018-10-23 06:00:00	NVDA	Stock	5.6225	5.6305	5.575	5.611	202840.0
2018-10-23 07:00:00	NVDA	Stock	5.616	5.642	5.553	5.5725	1327200.0
2018-10-23 08:00:00	NVDA	Stock	5.625	5.625	5.5502	5.5975	2667240.0
2018-10-23 09:00:00	NVDA	Stock	5.5928	5.5928	5.4405	5.5572	123592640.0
2018-10-23 10:00:00	NVDA	Stock	5.5523	5.56	5.4178	5.4349	118093680.0
2018-10-23 11:00:00	NVDA	Stock	5.4343	5.5303	5.4268	5.4668	62599240.0
2018-10-23 12:00:00	NVDA	Stock	5.4682	5.5978	5.464	5.5342	58535000.0
2018-10-23 13:00:00	NVDA	Stock	5.5333	5.57	5.5185	5.5415	35833520.0
2018-10-23 14:00:00	NVDA	Stock	5.5431	5.6048	5.521	5.557	49230240.0
2018-10-23 15:00:00	NVDA	Stock	5.5555	5.583	5.5125	5.5263	84973240.0
2018-10-23 16:00:00	NVDA	Stock	5.5265	5.5265	5.4525	5.4743	6556120.0
2018-10-23 17:00:00	NVDA	Stock	5.4775	5.4873	5.4625	5.475	1072920.0
2018-10-23 18:00:00	NVDA	Stock	5.471	5.481	5.4663	5.4732	305120.0
2018-10-23 19:00:00	NVDA	Stock	5.4688	5.5063	5.4678	5.5	1435360.0
2018-10-23 04:00:00	AMZN	Stock	88.5845	88.5845	87.5705	87.725	25040.0
2018-10-23 05:00:00	AMZN	Stock	87.65	87.8455	87.58	87.8455	33900.0

> showing 50 of 50,306 rows — these rows as CSV

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