PREVIEW / stock_1hour / 2023-02-27

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-27.parquet
  size:    1.4 MB
  rows:    60,595
  symbols: 1,840

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
2023-02-27 04:00:00	AAPL	Stock	146.95	147.17	146.8	146.85	24826.0
2023-02-27 05:00:00	AAPL	Stock	146.87	147.09	146.87	146.93	4177.0
2023-02-27 06:00:00	AAPL	Stock	146.97	147.09	146.95	147.02	4165.0
2023-02-27 07:00:00	AAPL	Stock	147.0	147.33	146.97	147.07	45843.0
2023-02-27 08:00:00	AAPL	Stock	147.05	148.25	146.344	148.02	197527.0
2023-02-27 09:00:00	AAPL	Stock	148.0553	148.56	147.57	148.53	4987031.0
2023-02-27 10:00:00	AAPL	Stock	148.525	149.17	147.78	148.17	6774779.0
2023-02-27 11:00:00	AAPL	Stock	148.165	148.25	147.45	147.93	3989310.0
2023-02-27 12:00:00	AAPL	Stock	147.95	148.45	147.68	148.3401	3322031.0
2023-02-27 13:00:00	AAPL	Stock	148.36	148.65	148.0501	148.48	3149292.0
2023-02-27 14:00:00	AAPL	Stock	148.48	148.7901	148.06	148.0601	3726126.0
2023-02-27 15:00:00	AAPL	Stock	148.06	148.215	147.7	147.9189	6165320.0
2023-02-27 16:00:00	AAPL	Stock	147.92	148.1	147.89	147.95	6614686.0
2023-02-27 17:00:00	AAPL	Stock	147.95	148.0	147.94	147.9899	6678.0
2023-02-27 18:00:00	AAPL	Stock	147.99	148.12	147.99	148.02	10822.0
2023-02-27 19:00:00	AAPL	Stock	148.0299	148.15	147.99	148.03	33796.0
2023-02-27 04:00:00	MSFT	Stock	250.58	250.93	250.35	250.43	3211.0
2023-02-27 05:00:00	MSFT	Stock	250.33	250.83	250.33	250.44	3182.0
2023-02-27 06:00:00	MSFT	Stock	250.61	250.69	250.51	250.62	1777.0
2023-02-27 07:00:00	MSFT	Stock	250.55	250.68	250.1	250.2	8767.0
2023-02-27 08:00:00	MSFT	Stock	250.51	252.68	249.843	251.95	58959.0
2023-02-27 09:00:00	MSFT	Stock	251.96	252.82	250.76	251.83	1809402.0
2023-02-27 10:00:00	MSFT	Stock	251.84	252.79	250.18	250.72	2479326.0
2023-02-27 11:00:00	MSFT	Stock	250.73	250.78	249.52	250.3599	1720711.0
2023-02-27 12:00:00	MSFT	Stock	250.37	250.75	249.685	250.74	985444.0
2023-02-27 13:00:00	MSFT	Stock	250.74	251.159	249.9	250.62	969889.0
2023-02-27 14:00:00	MSFT	Stock	250.61	251.02	249.63	249.845	1024699.0
2023-02-27 15:00:00	MSFT	Stock	249.82	250.3	249.39	250.2	2687549.0
2023-02-27 16:00:00	MSFT	Stock	250.21	250.35	250.15	250.15	3071803.0
2023-02-27 17:00:00	MSFT	Stock	250.1499	250.25	250.1499	250.16	3147.0
2023-02-27 18:00:00	MSFT	Stock	250.25	250.5	250.17	250.21	5180.0
2023-02-27 19:00:00	MSFT	Stock	250.17	250.5	250.17	250.32	5601.0
2023-02-27 04:00:00	NVDA	Stock	23.396	23.549	23.225	23.479	254940.0
2023-02-27 05:00:00	NVDA	Stock	23.452	23.513	23.45	23.485	47700.0
2023-02-27 06:00:00	NVDA	Stock	23.472	23.55	23.472	23.512	154860.0
2023-02-27 07:00:00	NVDA	Stock	23.51	23.611	23.466	23.56	685030.0
2023-02-27 08:00:00	NVDA	Stock	23.585	23.725	23.2278	23.68	2367990.0
2023-02-27 09:00:00	NVDA	Stock	23.68	23.8799	23.6	23.786	71305060.0
2023-02-27 10:00:00	NVDA	Stock	23.786	23.838	23.454	23.5491	77242350.0
2023-02-27 11:00:00	NVDA	Stock	23.546	23.707	23.544	23.639	45780510.0
2023-02-27 12:00:00	NVDA	Stock	23.64	23.666	23.488	23.653	29538530.0
2023-02-27 13:00:00	NVDA	Stock	23.654	23.819	23.627	23.788	40617720.0
2023-02-27 14:00:00	NVDA	Stock	23.791	23.811	23.568	23.625	30962800.0
2023-02-27 15:00:00	NVDA	Stock	23.625	23.643	23.472	23.499	41713220.0
2023-02-27 16:00:00	NVDA	Stock	23.499	23.518	23.489	23.507	13272540.0
2023-02-27 17:00:00	NVDA	Stock	23.507	23.523	23.5	23.501	176590.0
2023-02-27 18:00:00	NVDA	Stock	23.495	23.528	23.495	23.52	159100.0
2023-02-27 19:00:00	NVDA	Stock	23.515	23.548	23.51	23.543	211610.0
2023-02-27 04:00:00	AMZN	Stock	93.81	94.1	93.65	93.9	13919.0
2023-02-27 05:00:00	AMZN	Stock	93.76	94.0	93.76	93.89	5554.0

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

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