PREVIEW / stock_1hour / 2021-10-25

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-25.parquet
  size:    1.5 MB
  rows:    67,264
  symbols: 2,719

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-10-25 04:00:00	AAPL	Stock	148.5	148.85	148.45	148.61	17675.0
2021-10-25 05:00:00	AAPL	Stock	148.61	148.62	148.47	148.52	16062.0
2021-10-25 06:00:00	AAPL	Stock	148.53	148.63	148.32	148.36	26947.0
2021-10-25 07:00:00	AAPL	Stock	148.41	148.6	148.11	148.56	49207.0
2021-10-25 08:00:00	AAPL	Stock	148.35	148.64	148.15	148.42	347385.0
2021-10-25 09:00:00	AAPL	Stock	148.42	149.37	147.92	148.345	7862361.0
2021-10-25 10:00:00	AAPL	Stock	148.36	148.44	147.6211	148.0787	6194274.0
2021-10-25 11:00:00	AAPL	Stock	148.075	148.52	147.83	148.52	5247470.0
2021-10-25 12:00:00	AAPL	Stock	148.525	149.08	148.48	148.965	5111483.0
2021-10-25 13:00:00	AAPL	Stock	148.97	149.08	148.71	148.79	3006298.0
2021-10-25 14:00:00	AAPL	Stock	148.8	148.96	148.6328	148.69	3474323.0
2021-10-25 15:00:00	AAPL	Stock	148.7	148.78	148.42	148.65	6043908.0
2021-10-25 16:00:00	AAPL	Stock	148.64	148.9	147.77	148.58	6015820.0
2021-10-25 17:00:00	AAPL	Stock	148.55	148.67	148.45	148.46	44880.0
2021-10-25 18:00:00	AAPL	Stock	148.49	148.54	148.45	148.49	16706.0
2021-10-25 19:00:00	AAPL	Stock	148.47	148.6	148.4	148.6	44278.0
2021-10-25 04:00:00	MSFT	Stock	310.06	310.45	310.06	310.07	2489.0
2021-10-25 05:00:00	MSFT	Stock	310.0	310.02	309.64	309.65	2086.0
2021-10-25 06:00:00	MSFT	Stock	309.66	309.74	309.01	309.22	5288.0
2021-10-25 07:00:00	MSFT	Stock	309.68	309.68	308.95	309.4	10923.0
2021-10-25 08:00:00	MSFT	Stock	309.3501	309.4	308.95	309.0	15025.0
2021-10-25 09:00:00	MSFT	Stock	309.0	309.54	306.46	307.415	2157385.0
2021-10-25 10:00:00	MSFT	Stock	307.43	308.25	307.17	307.98	1616645.0
2021-10-25 11:00:00	MSFT	Stock	307.95	308.609	307.62	308.065	1145549.0
2021-10-25 12:00:00	MSFT	Stock	308.08	309.0536	308.07	309.02	1036112.0
2021-10-25 13:00:00	MSFT	Stock	309.03	309.1163	308.52	308.535	811622.0
2021-10-25 14:00:00	MSFT	Stock	308.54	308.81	308.365	308.73	910130.0
2021-10-25 15:00:00	MSFT	Stock	308.7499	308.76	307.44	308.3	2063480.0
2021-10-25 16:00:00	MSFT	Stock	308.27	309.22	307.75	309.17	3442448.0
2021-10-25 17:00:00	MSFT	Stock	309.2	309.4	309.1	309.28	14195.0
2021-10-25 18:00:00	MSFT	Stock	309.42	309.77	309.2	309.5	9120.0
2021-10-25 19:00:00	MSFT	Stock	309.31	309.5499	309.06	309.52	8014.0
2021-10-25 04:00:00	NVDA	Stock	22.864	22.888	22.798	22.83	38400.0
2021-10-25 05:00:00	NVDA	Stock	22.835	22.961	22.835	22.851	66090.0
2021-10-25 06:00:00	NVDA	Stock	22.833	23.025	22.833	22.952	103940.0
2021-10-25 07:00:00	NVDA	Stock	22.926	22.975	22.883	22.97	357200.0
2021-10-25 08:00:00	NVDA	Stock	22.9	23.07	22.6692	23.03	1028490.0
2021-10-25 09:00:00	NVDA	Stock	23.02	23.1588	22.827	22.8805	32904640.0
2021-10-25 10:00:00	NVDA	Stock	22.883	22.9378	22.77	22.902	29295210.0
2021-10-25 11:00:00	NVDA	Stock	22.902	23.075	22.879	23.043	18739080.0
2021-10-25 12:00:00	NVDA	Stock	23.045	23.298	23.035	23.278	25949040.0
2021-10-25 13:00:00	NVDA	Stock	23.2775	23.304	23.201	23.2714	13131580.0
2021-10-25 14:00:00	NVDA	Stock	23.275	23.342	23.255	23.325	12020150.0
2021-10-25 15:00:00	NVDA	Stock	23.327	23.355	23.114	23.166	22540660.0
2021-10-25 16:00:00	NVDA	Stock	23.166	23.265	23.166	23.258	21431970.0
2021-10-25 17:00:00	NVDA	Stock	23.26	23.465	23.226	23.45	487130.0
2021-10-25 18:00:00	NVDA	Stock	23.458	23.7	23.405	23.625	695700.0
2021-10-25 19:00:00	NVDA	Stock	23.6	23.646	23.56	23.575	239820.0
2021-10-25 04:00:00	AMZN	Stock	167.25	167.25	167.25	167.25	2000.0
2021-10-25 05:00:00	AMZN	Stock	167.2505	167.2505	167.2505	167.2505	2000.0

> showing 50 of 67,264 rows — these rows as CSV

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