PREVIEW / stock_1hour / 2020-08-26

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-26.parquet
  size:    1.2 MB
  rows:    56,791
  symbols: 2,455

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-08-26 04:00:00	AAPL	Stock	125.005	125.2875	124.75	125.2625	28136.0
2020-08-26 05:00:00	AAPL	Stock	125.305	125.5175	125.275	125.325	20884.0
2020-08-26 06:00:00	AAPL	Stock	125.375	126.23	125.315	126.1275	133804.0
2020-08-26 07:00:00	AAPL	Stock	126.2225	126.2225	125.6675	125.875	423660.0
2020-08-26 08:00:00	AAPL	Stock	125.83	126.0975	125.135	125.8715	745492.0
2020-08-26 09:00:00	AAPL	Stock	125.875	126.9925	125.5175	125.98	22055756.0
2020-08-26 10:00:00	AAPL	Stock	125.985	126.0632	125.0825	125.5625	20813076.0
2020-08-26 11:00:00	AAPL	Stock	125.5675	126.2708	125.33	126.2075	13910232.0
2020-08-26 12:00:00	AAPL	Stock	126.205	126.825	125.785	126.1742	18735656.0
2020-08-26 13:00:00	AAPL	Stock	126.1762	126.415	125.8425	126.305	9264440.0
2020-08-26 14:00:00	AAPL	Stock	126.31	126.4675	125.4	125.631	12033364.0
2020-08-26 15:00:00	AAPL	Stock	125.6275	126.58	125.46	126.5475	16767972.0
2020-08-26 16:00:00	AAPL	Stock	126.5225	126.805	126.0925	126.6875	7041316.0
2020-08-26 17:00:00	AAPL	Stock	126.6875	126.75	126.565	126.6625	178220.0
2020-08-26 18:00:00	AAPL	Stock	126.575	126.66	126.475	126.475	121188.0
2020-08-26 19:00:00	AAPL	Stock	126.475	126.5225	126.2	126.325	309688.0
2020-08-26 04:00:00	MSFT	Stock	217.47	217.47	217.0	217.15	4036.0
2020-08-26 05:00:00	MSFT	Stock	217.15	217.31	217.13	217.15	4882.0
2020-08-26 06:00:00	MSFT	Stock	217.15	217.42	217.15	217.21	3610.0
2020-08-26 07:00:00	MSFT	Stock	217.47	218.43	217.4	217.66	45217.0
2020-08-26 08:00:00	MSFT	Stock	217.5	218.405	217.0	217.71	103135.0
2020-08-26 09:00:00	MSFT	Stock	217.72	218.985	217.36	218.405	3674674.0
2020-08-26 10:00:00	MSFT	Stock	218.435	220.53	217.88	219.864	4472126.0
2020-08-26 11:00:00	MSFT	Stock	219.865	221.69	219.865	221.36	3418256.0
2020-08-26 12:00:00	MSFT	Stock	221.4	222.09	219.55	220.07	3640828.0
2020-08-26 13:00:00	MSFT	Stock	220.09	220.62	219.54	220.46	3607689.0
2020-08-26 14:00:00	MSFT	Stock	220.461	220.935	218.82	219.13	2346492.0
2020-08-26 15:00:00	MSFT	Stock	219.125	221.29	219.0	221.15	4144615.0
2020-08-26 16:00:00	MSFT	Stock	221.15	221.47	220.23	221.14	5018355.0
2020-08-26 17:00:00	MSFT	Stock	221.25	221.25	220.75	221.07	12467.0
2020-08-26 18:00:00	MSFT	Stock	220.99	220.99	220.4	220.4	11376.0
2020-08-26 19:00:00	MSFT	Stock	220.59	221.05	220.06	220.9	25783.0
2020-08-26 04:00:00	NVDA	Stock	12.7915	12.8008	12.75	12.7625	102480.0
2020-08-26 05:00:00	NVDA	Stock	12.82	12.82	12.8	12.8	30920.0
2020-08-26 06:00:00	NVDA	Stock	12.7805	12.8	12.7775	12.8	58800.0
2020-08-26 07:00:00	NVDA	Stock	12.7918	12.8238	12.7812	12.81	567680.0
2020-08-26 08:00:00	NVDA	Stock	12.79	12.825	12.7725	12.795	1317880.0
2020-08-26 09:00:00	NVDA	Stock	12.7902	12.8403	12.7028	12.718	45417200.0
2020-08-26 10:00:00	NVDA	Stock	12.718	12.7918	12.693	12.7653	40699800.0
2020-08-26 11:00:00	NVDA	Stock	12.7632	12.787	12.7093	12.7678	28024360.0
2020-08-26 12:00:00	NVDA	Stock	12.771	12.8685	12.7658	12.7823	39559840.0
2020-08-26 13:00:00	NVDA	Stock	12.7832	12.845	12.7525	12.8077	22707880.0
2020-08-26 14:00:00	NVDA	Stock	12.809	12.8197	12.6778	12.6915	32921240.0
2020-08-26 15:00:00	NVDA	Stock	12.694	12.7855	12.6815	12.773	43066760.0
2020-08-26 16:00:00	NVDA	Stock	12.773	12.78	12.755	12.78	3167880.0
2020-08-26 17:00:00	NVDA	Stock	12.787	12.7875	12.775	12.7752	155840.0
2020-08-26 18:00:00	NVDA	Stock	12.777	12.777	12.7552	12.76	198440.0
2020-08-26 19:00:00	NVDA	Stock	12.7625	12.7625	12.7388	12.7388	197120.0
2020-08-26 04:00:00	AMZN	Stock	167.533	167.533	167.4	167.405	22120.0
2020-08-26 05:00:00	AMZN	Stock	167.3245	167.3245	167.3245	167.3245	2000.0

> showing 50 of 56,791 rows — these rows as CSV

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