PREVIEW / stock_1hour / 2022-11-15

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-15.parquet
  size:    1.4 MB
  rows:    62,933
  symbols: 2,085

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-15 04:00:00	AAPL	Stock	149.51	150.0	149.49	150.0	42637.0
2022-11-15 05:00:00	AAPL	Stock	149.99	150.27	149.99	150.14	16843.0
2022-11-15 06:00:00	AAPL	Stock	150.19	150.34	149.88	149.94	53261.0
2022-11-15 07:00:00	AAPL	Stock	149.92	150.25	149.71	150.25	101305.0
2022-11-15 08:00:00	AAPL	Stock	149.9264	152.73	147.91	152.37	736170.0
2022-11-15 09:00:00	AAPL	Stock	152.34	153.22	151.68	152.64	11233962.0
2022-11-15 10:00:00	AAPL	Stock	152.635	153.59	152.12	152.481	11412359.0
2022-11-15 11:00:00	AAPL	Stock	152.48	153.03	151.79	152.7249	7485179.0
2022-11-15 12:00:00	AAPL	Stock	152.73	152.7689	151.21	151.42	7883834.0
2022-11-15 13:00:00	AAPL	Stock	151.4242	151.7	148.695	149.4844	11026871.0
2022-11-15 14:00:00	AAPL	Stock	149.485	150.75	148.5613	150.4758	9803975.0
2022-11-15 15:00:00	AAPL	Stock	150.48	150.89	149.63	150.07	10695693.0
2022-11-15 16:00:00	AAPL	Stock	150.07	150.45	149.84	150.07	9349924.0
2022-11-15 17:00:00	AAPL	Stock	150.07	150.09	149.75	149.9	93226.0
2022-11-15 18:00:00	AAPL	Stock	149.9	150.07	149.59	150.03	33119.0
2022-11-15 19:00:00	AAPL	Stock	150.04	150.28	149.69	149.7	28735.0
2022-11-15 04:00:00	MSFT	Stock	243.9	244.01	242.79	243.5	46102.0
2022-11-15 05:00:00	MSFT	Stock	243.76	244.29	243.65	243.87	3280.0
2022-11-15 06:00:00	MSFT	Stock	244.14	244.15	243.8	243.97	25254.0
2022-11-15 07:00:00	MSFT	Stock	243.97	244.87	243.62	244.81	25646.0
2022-11-15 08:00:00	MSFT	Stock	243.8	249.83	240.947	248.4	177614.0
2022-11-15 09:00:00	MSFT	Stock	248.69	248.69	244.02	245.33	3364647.0
2022-11-15 10:00:00	MSFT	Stock	245.34	246.1	243.6	244.525	3121743.0
2022-11-15 11:00:00	MSFT	Stock	244.49	245.6	243.67	245.28	1831803.0
2022-11-15 12:00:00	MSFT	Stock	245.3	245.31	244.13	244.69	1412010.0
2022-11-15 13:00:00	MSFT	Stock	244.73	245.005	240.3	241.39	2597726.0
2022-11-15 14:00:00	MSFT	Stock	241.41	242.9999	240.03	242.6371	2315861.0
2022-11-15 15:00:00	MSFT	Stock	242.65	243.34	241.05	242.03	3564813.0
2022-11-15 16:00:00	MSFT	Stock	242.06	242.5	241.5046	241.71	5498571.0
2022-11-15 17:00:00	MSFT	Stock	241.8797	241.88	241.5	241.6167	4596.0
2022-11-15 18:00:00	MSFT	Stock	241.61	241.7	241.25	241.7	4443.0
2022-11-15 19:00:00	MSFT	Stock	241.65	241.65	240.59	240.73	9493.0
2022-11-15 04:00:00	NVDA	Stock	16.472	16.595	16.472	16.55	115050.0
2022-11-15 05:00:00	NVDA	Stock	16.56	16.587	16.56	16.57	34960.0
2022-11-15 06:00:00	NVDA	Stock	16.585	16.588	16.557	16.575	88540.0
2022-11-15 07:00:00	NVDA	Stock	16.581	16.66	16.551	16.633	775330.0
2022-11-15 08:00:00	NVDA	Stock	16.551	17.038	16.355	17.023	5680190.0
2022-11-15 09:00:00	NVDA	Stock	17.0074	17.025	16.67	16.895	73121000.0
2022-11-15 10:00:00	NVDA	Stock	16.897	16.998	16.606	16.647	80886030.0
2022-11-15 11:00:00	NVDA	Stock	16.645	16.824	16.6	16.791	48403870.0
2022-11-15 12:00:00	NVDA	Stock	16.7935	16.913	16.716	16.887	46178670.0
2022-11-15 13:00:00	NVDA	Stock	16.887	16.907	16.382	16.558	60443670.0
2022-11-15 14:00:00	NVDA	Stock	16.56	16.8095	16.42	16.693	53081110.0
2022-11-15 15:00:00	NVDA	Stock	16.691	16.744	16.619	16.676	53408360.0
2022-11-15 16:00:00	NVDA	Stock	16.666	16.713	16.6099	16.624	37972310.0
2022-11-15 17:00:00	NVDA	Stock	16.63	16.63	16.535	16.541	654100.0
2022-11-15 18:00:00	NVDA	Stock	16.541	16.575	16.49	16.57	464160.0
2022-11-15 19:00:00	NVDA	Stock	16.585	16.585	16.52	16.53	558960.0
2022-11-15 04:00:00	AMZN	Stock	99.86	99.9	99.03	99.29	71121.0
2022-11-15 05:00:00	AMZN	Stock	99.21	99.64	99.19	99.58	33781.0

> showing 50 of 62,933 rows — these rows as CSV

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