PREVIEW / stock_1hour / 2024-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-01-18.parquet
  size:    1.3 MB
  rows:    58,282
  symbols: 1,168

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
2024-01-18 04:00:00	AAPL	Stock	182.55	182.83	182.2	182.2	13641.0
2024-01-18 05:00:00	AAPL	Stock	182.3	182.55	182.11	182.55	6073.0
2024-01-18 06:00:00	AAPL	Stock	182.55	186.15	182.55	185.92	214483.0
2024-01-18 07:00:00	AAPL	Stock	185.81	187.25	185.52	186.9	291027.0
2024-01-18 08:00:00	AAPL	Stock	185.79	187.25	182.04	185.86	480248.0
2024-01-18 09:00:00	AAPL	Stock	185.909	187.65	185.83	187.37	10725088.0
2024-01-18 10:00:00	AAPL	Stock	187.36	188.16	186.595	188.0881	9471373.0
2024-01-18 11:00:00	AAPL	Stock	188.09	188.96	187.56	188.4716	7858642.0
2024-01-18 12:00:00	AAPL	Stock	188.485	188.53	187.5	187.85	5472838.0
2024-01-18 13:00:00	AAPL	Stock	187.85	188.2601	186.7501	188.1601	5683615.0
2024-01-18 14:00:00	AAPL	Stock	188.17	189.14	188.16	188.975	6041779.0
2024-01-18 15:00:00	AAPL	Stock	188.98	189.13	188.51	188.73	8532464.0
2024-01-18 16:00:00	AAPL	Stock	188.63	188.97	188.46	188.5	10190639.0
2024-01-18 17:00:00	AAPL	Stock	188.48	188.63	187.75	188.2	179110.0
2024-01-18 18:00:00	AAPL	Stock	188.22	188.6	188.15	188.6	55723.0
2024-01-18 19:00:00	AAPL	Stock	188.6	188.69	188.4	188.69	27826.0
2024-01-18 04:00:00	MSFT	Stock	392.63	393.82	392.63	393.32	11063.0
2024-01-18 05:00:00	MSFT	Stock	393.23	394.32	393.0	394.32	4210.0
2024-01-18 06:00:00	MSFT	Stock	393.99	393.99	392.42	393.45	21851.0
2024-01-18 07:00:00	MSFT	Stock	393.51	393.85	391.01	391.59	37872.0
2024-01-18 08:00:00	MSFT	Stock	393.0	393.8	389.85	391.2499	99252.0
2024-01-18 09:00:00	MSFT	Stock	391.25	393.19	390.5	392.18	2611099.0
2024-01-18 10:00:00	MSFT	Stock	392.19	392.98	390.97	392.4784	2029307.0
2024-01-18 11:00:00	MSFT	Stock	392.48	393.13	391.96	392.8	1551421.0
2024-01-18 12:00:00	MSFT	Stock	392.85	392.9	390.96	391.17	1143809.0
2024-01-18 13:00:00	MSFT	Stock	391.16	391.82	390.12	391.52	825799.0
2024-01-18 14:00:00	MSFT	Stock	391.54	393.04	391.49	392.81	1112756.0
2024-01-18 15:00:00	MSFT	Stock	392.81	393.99	392.4201	393.84	2162106.0
2024-01-18 16:00:00	MSFT	Stock	393.81	394.25	393.27	393.82	3735025.0
2024-01-18 17:00:00	MSFT	Stock	393.95	393.95	393.51	393.88	24296.0
2024-01-18 18:00:00	MSFT	Stock	393.9854	394.89	393.51	394.35	10275.0
2024-01-18 19:00:00	MSFT	Stock	394.79	394.85	394.3501	394.55	14141.0
2024-01-18 04:00:00	NVDA	Stock	56.612	56.994	56.462	56.86	471510.0
2024-01-18 05:00:00	NVDA	Stock	56.85	56.979	56.8	56.979	139060.0
2024-01-18 06:00:00	NVDA	Stock	56.95	57.144	56.95	57.095	336840.0
2024-01-18 07:00:00	NVDA	Stock	57.097	57.374	56.888	57.282	2306430.0
2024-01-18 08:00:00	NVDA	Stock	56.996	57.485	55.767	57.325	5706600.0
2024-01-18 09:00:00	NVDA	Stock	57.328	57.52	56.888	57.128	63865170.0
2024-01-18 10:00:00	NVDA	Stock	57.128	57.594	56.9215	57.433	63221610.0
2024-01-18 11:00:00	NVDA	Stock	57.43	57.6	57.223	57.5075	39964000.0
2024-01-18 12:00:00	NVDA	Stock	57.511	57.5171	56.825	56.955	45144740.0
2024-01-18 13:00:00	NVDA	Stock	56.947	56.976	56.107	56.758	53181090.0
2024-01-18 14:00:00	NVDA	Stock	56.756	57.055	56.748	56.9	38049680.0
2024-01-18 15:00:00	NVDA	Stock	56.9	57.185	56.75	57.112	44085890.0
2024-01-18 16:00:00	NVDA	Stock	57.107	57.355	57.05	57.35	17960630.0
2024-01-18 17:00:00	NVDA	Stock	57.33	57.43	57.312	57.324	1134460.0
2024-01-18 18:00:00	NVDA	Stock	57.325	57.41	57.312	57.39	718600.0
2024-01-18 19:00:00	NVDA	Stock	57.398	57.46	57.38	57.445	778900.0
2024-01-18 04:00:00	AMZN	Stock	151.78	152.22	151.78	152.01	11200.0
2024-01-18 05:00:00	AMZN	Stock	152.18	152.5	152.1	152.45	14769.0

> showing 50 of 58,282 rows — these rows as CSV

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