PREVIEW / stock_1hour / 2022-11-18

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-18.parquet
  size:    1.3 MB
  rows:    60,381
  symbols: 2,090

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
2022-11-18 04:00:00	AAPL	Stock	150.17	151.22	150.17	150.8	38338.0
2022-11-18 05:00:00	AAPL	Stock	150.81	151.68	150.73	151.6	31187.0
2022-11-18 06:00:00	AAPL	Stock	151.5	151.58	151.28	151.3	31770.0
2022-11-18 07:00:00	AAPL	Stock	151.31	152.07	151.29	151.55	97107.0
2022-11-18 08:00:00	AAPL	Stock	151.57	152.0885	151.3	151.9	174990.0
2022-11-18 09:00:00	AAPL	Stock	151.92	152.7	150.775	151.48	8716587.0
2022-11-18 10:00:00	AAPL	Stock	151.48	151.5199	149.97	150.9905	9984900.0
2022-11-18 11:00:00	AAPL	Stock	150.99	151.98	150.57	151.42	8440711.0
2022-11-18 12:00:00	AAPL	Stock	151.41	151.59	150.35	150.65	5579353.0
2022-11-18 13:00:00	AAPL	Stock	150.6509	151.2799	150.54	150.99	5065850.0
2022-11-18 14:00:00	AAPL	Stock	150.995	151.3079	150.86	151.21	5162198.0
2022-11-18 15:00:00	AAPL	Stock	151.22	151.91	150.78	151.31	12037802.0
2022-11-18 16:00:00	AAPL	Stock	151.32	151.37	150.97	151.11	10543917.0
2022-11-18 17:00:00	AAPL	Stock	151.09	151.29	151.0	151.0034	261333.0
2022-11-18 18:00:00	AAPL	Stock	151.03	151.09	150.9	150.95	12365.0
2022-11-18 19:00:00	AAPL	Stock	150.91	150.98	150.85	150.88	15337.0
2022-11-18 04:00:00	MSFT	Stock	241.68	242.15	241.68	241.93	3247.0
2022-11-18 05:00:00	MSFT	Stock	241.65	243.5	241.65	243.4	2020.0
2022-11-18 06:00:00	MSFT	Stock	243.49	243.5	243.24	243.49	635.0
2022-11-18 07:00:00	MSFT	Stock	243.3	243.6	242.88	243.42	12623.0
2022-11-18 08:00:00	MSFT	Stock	243.014	243.72	241.076	243.69	18810.0
2022-11-18 09:00:00	MSFT	Stock	243.75	244.7	240.07	241.69	3353586.0
2022-11-18 10:00:00	MSFT	Stock	241.72	241.86	239.03	239.8	1920577.0
2022-11-18 11:00:00	MSFT	Stock	239.82	240.49	239.06	239.9825	1434321.0
2022-11-18 12:00:00	MSFT	Stock	239.99	240.22	239.15	239.545	1387078.0
2022-11-18 13:00:00	MSFT	Stock	239.5794	240.28	239.13	239.44	1187335.0
2022-11-18 14:00:00	MSFT	Stock	239.43	239.77	239.08	239.45	1258349.0
2022-11-18 15:00:00	MSFT	Stock	239.45	242.07	239.43	241.31	3736095.0
2022-11-18 16:00:00	MSFT	Stock	241.22	241.8591	240.82	241.2356	5893556.0
2022-11-18 17:00:00	MSFT	Stock	241.2222	241.35	240.9	241.3303	18764.0
2022-11-18 18:00:00	MSFT	Stock	241.3	241.44	241.0	241.2	8571.0
2022-11-18 19:00:00	MSFT	Stock	241.03	241.07	241.03	241.07	300.0
2022-11-18 04:00:00	NVDA	Stock	15.7	15.89	15.7	15.8	190060.0
2022-11-18 05:00:00	NVDA	Stock	15.804	15.97	15.803	15.951	255100.0
2022-11-18 06:00:00	NVDA	Stock	15.944	15.959	15.91	15.948	51380.0
2022-11-18 07:00:00	NVDA	Stock	15.928	16.0	15.868	15.925	692380.0
2022-11-18 08:00:00	NVDA	Stock	15.9327	16.0	15.782	15.94	1292060.0
2022-11-18 09:00:00	NVDA	Stock	15.944	16.002	15.612	15.633	64110090.0
2022-11-18 10:00:00	NVDA	Stock	15.6315	15.641	15.304	15.337	79143150.0
2022-11-18 11:00:00	NVDA	Stock	15.337	15.467	15.304	15.364	44625850.0
2022-11-18 12:00:00	NVDA	Stock	15.3637	15.379	15.12	15.158	55717370.0
2022-11-18 13:00:00	NVDA	Stock	15.156	15.32	15.15	15.223	46608440.0
2022-11-18 14:00:00	NVDA	Stock	15.222	15.314	15.202	15.294	32146430.0
2022-11-18 15:00:00	NVDA	Stock	15.2996	15.468	15.293	15.409	64279510.0
2022-11-18 16:00:00	NVDA	Stock	15.409	15.427	15.38	15.3912	25939530.0
2022-11-18 17:00:00	NVDA	Stock	15.393	15.409	15.36	15.361	908040.0
2022-11-18 18:00:00	NVDA	Stock	15.366	15.378	15.366	15.37	88540.0
2022-11-18 19:00:00	NVDA	Stock	15.372	15.381	15.357	15.36	235680.0
2022-11-18 04:00:00	AMZN	Stock	95.11	95.8	95.11	95.63	11697.0
2022-11-18 05:00:00	AMZN	Stock	95.53	96.2	95.51	96.19	8609.0

> showing 50 of 60,381 rows — these rows as CSV

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