PREVIEW / stock_1hour / 2021-08-30

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-30.parquet
  size:    1.4 MB
  rows:    65,243
  symbols: 2,754

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
2021-08-30 04:00:00	AAPL	Stock	148.59	148.78	148.5	148.64	21815.0
2021-08-30 05:00:00	AAPL	Stock	148.7	148.82	148.7	148.75	5391.0
2021-08-30 06:00:00	AAPL	Stock	148.74	149.05	148.74	148.83	13690.0
2021-08-30 07:00:00	AAPL	Stock	148.79	148.84	148.7	148.78	34946.0
2021-08-30 08:00:00	AAPL	Stock	148.81	148.93	148.229	148.85	151449.0
2021-08-30 09:00:00	AAPL	Stock	148.86	150.95	148.61	150.775	12209340.0
2021-08-30 10:00:00	AAPL	Stock	150.78	152.13	150.78	151.91	17222762.0
2021-08-30 11:00:00	AAPL	Stock	151.919	152.5	151.8	152.4999	9766191.0
2021-08-30 12:00:00	AAPL	Stock	152.49	153.11	152.13	152.9751	9723959.0
2021-08-30 13:00:00	AAPL	Stock	152.975	153.42	152.86	153.405	8056992.0
2021-08-30 14:00:00	AAPL	Stock	153.4005	153.49	152.8107	153.0502	7733812.0
2021-08-30 15:00:00	AAPL	Stock	153.0501	153.41	152.98	153.1	10476154.0
2021-08-30 16:00:00	AAPL	Stock	153.08	153.17	152.96	152.96	4801157.0
2021-08-30 17:00:00	AAPL	Stock	152.99	153.09	152.85	153.08	69404.0
2021-08-30 18:00:00	AAPL	Stock	153.09	153.14	152.91	152.97	47103.0
2021-08-30 19:00:00	AAPL	Stock	152.98	153.0	152.82	152.91	84760.0
2021-08-30 04:00:00	MSFT	Stock	301.19	301.22	300.85	300.95	15207.0
2021-08-30 05:00:00	MSFT	Stock	300.94	301.2	300.94	301.11	1781.0
2021-08-30 06:00:00	MSFT	Stock	301.3	301.4	301.0	301.0	13100.0
2021-08-30 07:00:00	MSFT	Stock	300.92	301.14	300.82	300.83	9579.0
2021-08-30 08:00:00	MSFT	Stock	300.84	301.06	300.6	300.75	20672.0
2021-08-30 09:00:00	MSFT	Stock	300.76	303.93	300.5	303.12	2069982.0
2021-08-30 10:00:00	MSFT	Stock	303.12	304.15	302.3067	304.135	2117774.0
2021-08-30 11:00:00	MSFT	Stock	304.13	304.22	302.99	303.37	1198299.0
2021-08-30 12:00:00	MSFT	Stock	303.38	303.42	302.68	302.9684	901501.0
2021-08-30 13:00:00	MSFT	Stock	302.9616	303.675	302.78	303.44	904058.0
2021-08-30 14:00:00	MSFT	Stock	303.46	303.58	303.06	303.27	865786.0
2021-08-30 15:00:00	MSFT	Stock	303.26	303.89	303.05	303.56	1754612.0
2021-08-30 16:00:00	MSFT	Stock	303.59	303.88	303.43	303.88	2072850.0
2021-08-30 17:00:00	MSFT	Stock	303.55	303.6	303.14	303.15	32963.0
2021-08-30 18:00:00	MSFT	Stock	303.3	303.49	303.22	303.47	7866.0
2021-08-30 19:00:00	MSFT	Stock	303.47	303.6	303.31	303.6	4902.0
2021-08-30 04:00:00	NVDA	Stock	22.659	22.88	22.651	22.798	100980.0
2021-08-30 05:00:00	NVDA	Stock	22.795	22.795	22.736	22.75	94340.0
2021-08-30 06:00:00	NVDA	Stock	22.771	22.781	22.75	22.75	123680.0
2021-08-30 07:00:00	NVDA	Stock	22.764	22.801	22.7	22.77	492650.0
2021-08-30 08:00:00	NVDA	Stock	22.772	22.819	22.5795	22.814	713250.0
2021-08-30 09:00:00	NVDA	Stock	22.825	23.043	22.752	22.921	42353550.0
2021-08-30 10:00:00	NVDA	Stock	22.9163	22.965	22.771	22.813	28695060.0
2021-08-30 11:00:00	NVDA	Stock	22.812	22.83	22.551	22.703	37398580.0
2021-08-30 12:00:00	NVDA	Stock	22.71	22.73	22.59	22.627	20279890.0
2021-08-30 13:00:00	NVDA	Stock	22.628	22.743	22.615	22.7365	15127240.0
2021-08-30 14:00:00	NVDA	Stock	22.739	22.774	22.706	22.755	15730810.0
2021-08-30 15:00:00	NVDA	Stock	22.755	22.782	22.66	22.685	27264510.0
2021-08-30 16:00:00	NVDA	Stock	22.688	22.699	22.66	22.693	11343200.0
2021-08-30 17:00:00	NVDA	Stock	22.691	22.698	22.661	22.661	124580.0
2021-08-30 18:00:00	NVDA	Stock	22.662	22.678	22.66	22.663	113590.0
2021-08-30 19:00:00	NVDA	Stock	22.662	22.662	22.612	22.614	146130.0
2021-08-30 07:00:00	AMZN	Stock	167.8	168.075	167.8	168.075	28380.0
2021-08-30 08:00:00	AMZN	Stock	167.8	168.14	167.7966	168.0935	26820.0

> showing 50 of 65,243 rows — these rows as CSV

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