PREVIEW / stock_1hour / 2022-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-23.parquet
  size:    1.4 MB
  rows:    64,100
  symbols: 2,229

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-09-23 04:00:00	AAPL	Stock	152.33	152.55	151.62	151.62	27602.0
2022-09-23 05:00:00	AAPL	Stock	151.63	151.7	150.5	150.96	41949.0
2022-09-23 06:00:00	AAPL	Stock	151.02	151.19	150.16	150.3	56722.0
2022-09-23 07:00:00	AAPL	Stock	150.27	150.59	150.0	150.45	197787.0
2022-09-23 08:00:00	AAPL	Stock	150.4891	152.18	149.85	150.16	575011.0
2022-09-23 09:00:00	AAPL	Stock	150.12	151.47	149.8612	150.02	14090316.0
2022-09-23 10:00:00	AAPL	Stock	150.025	150.54	149.312	149.96	13381324.0
2022-09-23 11:00:00	AAPL	Stock	149.97	150.65	149.76	150.26	9295068.0
2022-09-23 12:00:00	AAPL	Stock	150.25	150.37	149.41	150.1699	7762491.0
2022-09-23 13:00:00	AAPL	Stock	150.1609	150.3187	149.46	149.7099	6126765.0
2022-09-23 14:00:00	AAPL	Stock	149.7	150.0	148.56	148.7	8690298.0
2022-09-23 15:00:00	AAPL	Stock	148.68	150.66	148.67	150.53	15578094.0
2022-09-23 16:00:00	AAPL	Stock	150.53	150.78	150.34	150.61	6264440.0
2022-09-23 17:00:00	AAPL	Stock	150.6	150.8	150.43	150.6	94325.0
2022-09-23 18:00:00	AAPL	Stock	150.61	150.81	150.6	150.75	19030.0
2022-09-23 19:00:00	AAPL	Stock	150.75	150.85	150.52	150.57	58150.0
2022-09-23 04:00:00	MSFT	Stock	240.4	240.4	239.01	239.01	4864.0
2022-09-23 05:00:00	MSFT	Stock	238.87	238.99	237.6	238.25	10712.0
2022-09-23 06:00:00	MSFT	Stock	238.3	238.3	237.5	237.6	6291.0
2022-09-23 07:00:00	MSFT	Stock	238.0	238.26	237.36	238.0	31741.0
2022-09-23 08:00:00	MSFT	Stock	237.5115	240.0	237.32	238.1015	72215.0
2022-09-23 09:00:00	MSFT	Stock	238.25	240.43	238.24	238.79	3368700.0
2022-09-23 10:00:00	MSFT	Stock	238.83	241.13	238.35	240.13	3698780.0
2022-09-23 11:00:00	MSFT	Stock	240.13	240.8	238.05	238.22	2737645.0
2022-09-23 12:00:00	MSFT	Stock	238.21	238.47	237.5	238.3	2021984.0
2022-09-23 13:00:00	MSFT	Stock	238.3104	238.76	237.31	237.73	1605636.0
2022-09-23 14:00:00	MSFT	Stock	237.74	237.97	235.2	235.3954	2345300.0
2022-09-23 15:00:00	MSFT	Stock	235.3899	238.44	235.34	237.96	4604720.0
2022-09-23 16:00:00	MSFT	Stock	237.97	238.25	237.92	238.25	3295650.0
2022-09-23 17:00:00	MSFT	Stock	238.0789	238.24	238.0789	238.1	1576.0
2022-09-23 18:00:00	MSFT	Stock	238.03	238.1	237.95	238.05	3037.0
2022-09-23 19:00:00	MSFT	Stock	238.05	238.15	237.7	238.07	27895.0
2022-09-23 04:00:00	NVDA	Stock	12.546	12.546	12.401	12.417	190870.0
2022-09-23 05:00:00	NVDA	Stock	12.406	12.419	12.301	12.347	261610.0
2022-09-23 06:00:00	NVDA	Stock	12.33	12.348	12.282	12.282	111190.0
2022-09-23 07:00:00	NVDA	Stock	12.312	12.333	12.2	12.25	745570.0
2022-09-23 08:00:00	NVDA	Stock	12.25	12.4301	12.201	12.262	2662390.0
2022-09-23 09:00:00	NVDA	Stock	12.268	12.611	12.25	12.338	78535480.0
2022-09-23 10:00:00	NVDA	Stock	12.337	12.536	12.275	12.449	101380390.0
2022-09-23 11:00:00	NVDA	Stock	12.449	12.5395	12.3	12.402	73400820.0
2022-09-23 12:00:00	NVDA	Stock	12.401	12.414	12.275	12.391	50564870.0
2022-09-23 13:00:00	NVDA	Stock	12.391	12.42	12.318	12.357	46479070.0
2022-09-23 14:00:00	NVDA	Stock	12.356	12.388	12.257	12.283	59510350.0
2022-09-23 15:00:00	NVDA	Stock	12.281	12.5778	12.277	12.521	111100860.0
2022-09-23 16:00:00	NVDA	Stock	12.516	12.54	12.505	12.508	23202560.0
2022-09-23 17:00:00	NVDA	Stock	12.515	12.534	12.492	12.495	310600.0
2022-09-23 18:00:00	NVDA	Stock	12.493	12.542	12.475	12.52	725080.0
2022-09-23 19:00:00	NVDA	Stock	12.525	12.574	12.508	12.508	552710.0
2022-09-23 04:00:00	AMZN	Stock	116.99	116.99	116.16	116.16	32563.0
2022-09-23 05:00:00	AMZN	Stock	116.12	116.16	115.51	115.7	48926.0

> showing 50 of 64,100 rows — these rows as CSV

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