PREVIEW / stock_1hour / 2018-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-17.parquet
  size:    1.1 MB
  rows:    49,405
  symbols: 2,758

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-17 04:00:00	AAPL	Stock	55.7875	55.9825	55.7875	55.86	36384.0
2018-10-17 05:00:00	AAPL	Stock	55.925	55.925	55.8375	55.8425	6048.0
2018-10-17 06:00:00	AAPL	Stock	55.7875	55.8	55.6875	55.715	62820.0
2018-10-17 07:00:00	AAPL	Stock	55.75	55.795	55.4625	55.4975	149336.0
2018-10-17 08:00:00	AAPL	Stock	55.525	55.8125	55.3625	55.55	356956.0
2018-10-17 09:00:00	AAPL	Stock	55.5325	55.65	55.08	55.1425	12120292.0
2018-10-17 10:00:00	AAPL	Stock	55.145	55.3025	54.835	55.0175	14118900.0
2018-10-17 11:00:00	AAPL	Stock	55.018	55.4	54.9	55.2575	8840828.0
2018-10-17 12:00:00	AAPL	Stock	55.265	55.4638	55.125	55.4168	6691692.0
2018-10-17 13:00:00	AAPL	Stock	55.4162	55.66	55.305	55.34	6327972.0
2018-10-17 14:00:00	AAPL	Stock	55.3325	55.465	54.98	55.3562	7082244.0
2018-10-17 15:00:00	AAPL	Stock	55.36	55.425	55.04	55.3	9665952.0
2018-10-17 16:00:00	AAPL	Stock	55.2975	55.3975	55.265	55.325	8817192.0
2018-10-17 17:00:00	AAPL	Stock	55.2975	55.3475	55.2975	55.3325	32940.0
2018-10-17 18:00:00	AAPL	Stock	55.3025	55.3025	55.1875	55.1875	27444.0
2018-10-17 19:00:00	AAPL	Stock	55.1875	55.1875	55.0	55.125	63736.0
2018-10-17 04:00:00	MSFT	Stock	111.81	111.82	111.47	111.47	1827.0
2018-10-17 05:00:00	MSFT	Stock	111.47	111.47	111.47	111.47	550.0
2018-10-17 06:00:00	MSFT	Stock	111.46	111.47	111.3	111.3	2249.0
2018-10-17 07:00:00	MSFT	Stock	111.5	111.5	110.85	110.9	23117.0
2018-10-17 08:00:00	MSFT	Stock	111.38	111.69	110.57	111.38	42009.0
2018-10-17 09:00:00	MSFT	Stock	111.375	111.81	109.92	110.335	3222150.0
2018-10-17 10:00:00	MSFT	Stock	110.34	110.38	109.548	109.84	3362308.0
2018-10-17 11:00:00	MSFT	Stock	109.84	110.78	109.68	110.74	2487565.0
2018-10-17 12:00:00	MSFT	Stock	110.75	111.05	110.14	110.438	2465702.0
2018-10-17 13:00:00	MSFT	Stock	110.455	111.13	110.455	110.8	2142020.0
2018-10-17 14:00:00	MSFT	Stock	110.78	110.97	110.04	110.825	2165194.0
2018-10-17 15:00:00	MSFT	Stock	110.83	110.92	110.3	110.72	4126456.0
2018-10-17 16:00:00	MSFT	Stock	110.71	111.0	110.68	110.75	3123713.0
2018-10-17 17:00:00	MSFT	Stock	110.82	110.933	110.82	110.93	1166.0
2018-10-17 18:00:00	MSFT	Stock	110.85	110.9	110.7	110.7	2772.0
2018-10-17 19:00:00	MSFT	Stock	110.57	110.68	110.52	110.68	1468.0
2018-10-17 04:00:00	NVDA	Stock	6.2625	6.2625	6.2522	6.2522	304680.0
2018-10-17 05:00:00	NVDA	Stock	6.2522	6.2522	6.2522	6.2522	16880.0
2018-10-17 06:00:00	NVDA	Stock	6.2262	6.2298	6.2222	6.2298	186000.0
2018-10-17 07:00:00	NVDA	Stock	6.2275	6.2418	6.1775	6.1775	1024480.0
2018-10-17 08:00:00	NVDA	Stock	6.2008	6.2375	6.1518	6.1812	1693960.0
2018-10-17 09:00:00	NVDA	Stock	6.1862	6.247	6.1125	6.1332	61249440.0
2018-10-17 10:00:00	NVDA	Stock	6.1337	6.1568	6.027	6.0662	65222280.0
2018-10-17 11:00:00	NVDA	Stock	6.065	6.1228	6.0562	6.082	30982640.0
2018-10-17 12:00:00	NVDA	Stock	6.0833	6.1108	6.0616	6.0852	19001640.0
2018-10-17 13:00:00	NVDA	Stock	6.0878	6.1265	6.07	6.078	31445280.0
2018-10-17 14:00:00	NVDA	Stock	6.0777	6.0965	6.0315	6.077	25852480.0
2018-10-17 15:00:00	NVDA	Stock	6.076	6.0943	6.0468	6.0765	42659480.0
2018-10-17 16:00:00	NVDA	Stock	6.0765	6.0875	6.0682	6.0763	7567240.0
2018-10-17 17:00:00	NVDA	Stock	6.0795	6.0813	6.075	6.08	44360.0
2018-10-17 18:00:00	NVDA	Stock	6.08	6.0948	6.0765	6.0948	355280.0
2018-10-17 19:00:00	NVDA	Stock	6.095	6.095	6.07	6.07	126520.0
2018-10-17 04:00:00	AMZN	Stock	92.875	92.875	92.6685	92.751	76560.0
2018-10-17 05:00:00	AMZN	Stock	92.65	92.75	92.501	92.565	99000.0

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

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