PREVIEW / stock_1hour / 2022-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-16.parquet
  size:    1.4 MB
  rows:    61,225
  symbols: 2,069

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-16 04:00:00	AAPL	Stock	150.25	150.28	149.75	150.09	83473.0
2022-11-16 05:00:00	AAPL	Stock	150.12	150.57	150.04	150.1	16410.0
2022-11-16 06:00:00	AAPL	Stock	150.1	150.1	149.5	149.81	67752.0
2022-11-16 07:00:00	AAPL	Stock	149.81	150.25	149.57	150.09	81886.0
2022-11-16 08:00:00	AAPL	Stock	150.5	151.23	148.0	149.07	488108.0
2022-11-16 09:00:00	AAPL	Stock	149.03	149.87	147.9474	148.27	7706289.0
2022-11-16 10:00:00	AAPL	Stock	148.26	148.9	147.29	147.735	9684399.0
2022-11-16 11:00:00	AAPL	Stock	147.735	148.76	147.67	148.43	6487633.0
2022-11-16 12:00:00	AAPL	Stock	148.43	149.5	148.18	148.75	6344871.0
2022-11-16 13:00:00	AAPL	Stock	148.735	149.33	148.53	148.61	3920869.0
2022-11-16 14:00:00	AAPL	Stock	148.605	149.0766	148.28	149.0455	4221769.0
2022-11-16 15:00:00	AAPL	Stock	149.037	149.25	148.355	148.78	8132149.0
2022-11-16 16:00:00	AAPL	Stock	148.78	149.38	148.6	148.76	8534922.0
2022-11-16 17:00:00	AAPL	Stock	148.8	148.88	148.7324	148.88	44225.0
2022-11-16 18:00:00	AAPL	Stock	148.85	149.18	148.85	149.17	14742.0
2022-11-16 19:00:00	AAPL	Stock	149.18	149.19	148.85	148.9	23455.0
2022-11-16 04:00:00	MSFT	Stock	241.78	242.0	241.5	242.0	10024.0
2022-11-16 05:00:00	MSFT	Stock	241.98	242.4	241.89	241.89	2142.0
2022-11-16 06:00:00	MSFT	Stock	241.1	242.09	241.1	241.82	4855.0
2022-11-16 07:00:00	MSFT	Stock	241.77	241.95	241.17	241.95	8400.0
2022-11-16 08:00:00	MSFT	Stock	241.5	242.26	240.1	240.92	36594.0
2022-11-16 09:00:00	MSFT	Stock	240.93	243.65	240.92	242.76	2336471.0
2022-11-16 10:00:00	MSFT	Stock	242.79	243.0	240.42	240.74	2379575.0
2022-11-16 11:00:00	MSFT	Stock	240.76	242.59	240.67	242.27	1665762.0
2022-11-16 12:00:00	MSFT	Stock	242.23	243.8	241.8665	243.0	1378741.0
2022-11-16 13:00:00	MSFT	Stock	242.95	243.5	241.78	241.99	1339991.0
2022-11-16 14:00:00	MSFT	Stock	241.98	242.9	241.76	242.84	1214497.0
2022-11-16 15:00:00	MSFT	Stock	242.82	243.03	241.62	241.65	3271714.0
2022-11-16 16:00:00	MSFT	Stock	241.83	242.4485	241.2	241.32	5730472.0
2022-11-16 17:00:00	MSFT	Stock	241.49	241.72	241.49	241.5389	5662.0
2022-11-16 18:00:00	MSFT	Stock	241.71	241.95	241.51	241.92	8807.0
2022-11-16 19:00:00	MSFT	Stock	241.85	241.95	241.65	241.95	8289.0
2022-11-16 04:00:00	NVDA	Stock	16.612	16.666	16.541	16.579	126650.0
2022-11-16 05:00:00	NVDA	Stock	16.579	16.618	16.561	16.561	95550.0
2022-11-16 06:00:00	NVDA	Stock	16.536	16.536	16.461	16.466	111920.0
2022-11-16 07:00:00	NVDA	Stock	16.493	16.52	16.431	16.513	313070.0
2022-11-16 08:00:00	NVDA	Stock	16.645	16.645	16.262	16.282	2894910.0
2022-11-16 09:00:00	NVDA	Stock	16.28	16.364	16.0	16.131	72405300.0
2022-11-16 10:00:00	NVDA	Stock	16.126	16.2015	15.903	15.926	71585580.0
2022-11-16 11:00:00	NVDA	Stock	15.927	16.272	15.9164	16.131	63576710.0
2022-11-16 12:00:00	NVDA	Stock	16.132	16.275	16.0555	16.1786	54559020.0
2022-11-16 13:00:00	NVDA	Stock	16.18	16.23	16.073	16.094	38486870.0
2022-11-16 14:00:00	NVDA	Stock	16.092	16.196	16.058	16.093	41055010.0
2022-11-16 15:00:00	NVDA	Stock	16.094	16.105	15.873	15.94	94955900.0
2022-11-16 16:00:00	NVDA	Stock	15.944	16.558	15.3	16.204	77675300.0
2022-11-16 17:00:00	NVDA	Stock	16.204	16.245	15.91	16.035	17438470.0
2022-11-16 18:00:00	NVDA	Stock	16.035	16.18	16.034	16.177	3847640.0
2022-11-16 19:00:00	NVDA	Stock	16.17	16.26	16.131	16.26	3949490.0
2022-11-16 04:00:00	AMZN	Stock	99.02	99.5	99.02	99.49	26592.0
2022-11-16 05:00:00	AMZN	Stock	99.37	99.65	99.22	99.25	13913.0

> showing 50 of 61,225 rows — these rows as CSV

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