PREVIEW / stock_1hour / 2020-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-06.parquet
  size:    1.3 MB
  rows:    58,507
  symbols: 2,445

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
2020-07-06 04:00:00	AAPL	Stock	92.255	92.75	92.255	92.4875	52508.0
2020-07-06 05:00:00	AAPL	Stock	92.475	92.58	92.375	92.5625	18984.0
2020-07-06 06:00:00	AAPL	Stock	92.55	92.625	92.5	92.6	24704.0
2020-07-06 07:00:00	AAPL	Stock	92.55	92.55	92.28	92.4425	303216.0
2020-07-06 08:00:00	AAPL	Stock	92.2812	92.495	92.2775	92.3565	364496.0
2020-07-06 09:00:00	AAPL	Stock	92.3625	93.375	92.325	93.2975	18428912.0
2020-07-06 10:00:00	AAPL	Stock	93.305	93.75	92.9775	93.745	16667920.0
2020-07-06 11:00:00	AAPL	Stock	93.745	93.945	93.555	93.5988	12653244.0
2020-07-06 12:00:00	AAPL	Stock	93.595	93.7	93.325	93.5312	8258232.0
2020-07-06 13:00:00	AAPL	Stock	93.5375	93.5525	93.3075	93.3655	6383048.0
2020-07-06 14:00:00	AAPL	Stock	93.3675	93.38	92.99	93.2645	8006480.0
2020-07-06 15:00:00	AAPL	Stock	93.2575	93.6025	93.0025	93.4525	13048340.0
2020-07-06 16:00:00	AAPL	Stock	93.4625	93.5575	93.375	93.4975	10207908.0
2020-07-06 17:00:00	AAPL	Stock	93.4625	93.525	93.4375	93.475	282756.0
2020-07-06 18:00:00	AAPL	Stock	93.4175	93.5625	93.4075	93.5625	52396.0
2020-07-06 19:00:00	AAPL	Stock	93.575	93.8725	93.575	93.8625	168912.0
2020-07-06 04:00:00	MSFT	Stock	208.2	209.36	208.2	209.03	5611.0
2020-07-06 05:00:00	MSFT	Stock	209.03	209.1	208.98	209.1	2219.0
2020-07-06 06:00:00	MSFT	Stock	209.1	209.5	208.99	209.36	11115.0
2020-07-06 07:00:00	MSFT	Stock	209.1	209.51	208.8	209.08	73089.0
2020-07-06 08:00:00	MSFT	Stock	209.094	209.5	208.8	209.244	68228.0
2020-07-06 09:00:00	MSFT	Stock	209.24	209.35	208.09	209.025	3726550.0
2020-07-06 10:00:00	MSFT	Stock	209.03	210.06	208.75	209.955	4185791.0
2020-07-06 11:00:00	MSFT	Stock	209.95	211.13	209.83	210.585	2787306.0
2020-07-06 12:00:00	MSFT	Stock	210.584	211.07	209.62	210.927	2782128.0
2020-07-06 13:00:00	MSFT	Stock	210.929	211.13	210.04	210.78	2259636.0
2020-07-06 14:00:00	MSFT	Stock	210.77	210.81	209.73	210.53	2299155.0
2020-07-06 15:00:00	MSFT	Stock	210.53	211.09	209.66	210.69	4065700.0
2020-07-06 16:00:00	MSFT	Stock	210.7	210.88	210.3	210.68	3878985.0
2020-07-06 17:00:00	MSFT	Stock	210.7	211.09	210.61	210.85	129065.0
2020-07-06 18:00:00	MSFT	Stock	210.76	210.89	210.36	210.89	11657.0
2020-07-06 19:00:00	MSFT	Stock	210.85	211.88	210.82	211.88	34522.0
2020-07-06 04:00:00	NVDA	Stock	9.725	9.8088	9.725	9.7765	70440.0
2020-07-06 05:00:00	NVDA	Stock	9.7765	9.7988	9.7765	9.7985	33240.0
2020-07-06 06:00:00	NVDA	Stock	9.805	9.825	9.8043	9.813	28600.0
2020-07-06 07:00:00	NVDA	Stock	9.825	9.825	9.7488	9.7912	839440.0
2020-07-06 08:00:00	NVDA	Stock	9.7995	9.818	9.7055	9.7662	1338560.0
2020-07-06 09:00:00	NVDA	Stock	9.775	9.8275	9.7125	9.8197	44988520.0
2020-07-06 10:00:00	NVDA	Stock	9.8203	9.872	9.782	9.8702	42843080.0
2020-07-06 11:00:00	NVDA	Stock	9.8713	9.9088	9.86	9.8748	27491320.0
2020-07-06 12:00:00	NVDA	Stock	9.8729	9.88	9.815	9.8565	22598840.0
2020-07-06 13:00:00	NVDA	Stock	9.8585	9.8585	9.79	9.7902	21098560.0
2020-07-06 14:00:00	NVDA	Stock	9.7905	9.7975	9.7311	9.779	21460000.0
2020-07-06 15:00:00	NVDA	Stock	9.7788	9.845	9.7428	9.841	32973520.0
2020-07-06 16:00:00	NVDA	Stock	9.8392	9.84	9.825	9.8312	19691800.0
2020-07-06 17:00:00	NVDA	Stock	9.8375	9.8392	9.8263	9.8278	419880.0
2020-07-06 18:00:00	NVDA	Stock	9.8288	9.835	9.825	9.825	118880.0
2020-07-06 19:00:00	NVDA	Stock	9.831	9.8743	9.8308	9.85	800560.0
2020-07-06 04:00:00	AMZN	Stock	146.7525	146.9	146.75	146.7985	17540.0
2020-07-06 05:00:00	AMZN	Stock	146.75	146.9	146.75	146.848	13320.0

> showing 50 of 58,507 rows — these rows as CSV

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