PREVIEW / stock_1hour / 2023-03-24

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-24.parquet
  size:    1.3 MB
  rows:    59,831
  symbols: 1,728

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-03-24 04:00:00	AAPL	Stock	159.43	159.7	158.87	159.04	29633.0
2023-03-24 05:00:00	AAPL	Stock	159.05	159.4	158.1	158.33	18967.0
2023-03-24 06:00:00	AAPL	Stock	158.25	158.63	158.01	158.05	22571.0
2023-03-24 07:00:00	AAPL	Stock	158.2	158.5	158.0	158.02	45397.0
2023-03-24 08:00:00	AAPL	Stock	158.18	159.3	157.82	158.82	305028.0
2023-03-24 09:00:00	AAPL	Stock	158.83	159.39	157.85	159.19	5909923.0
2023-03-24 10:00:00	AAPL	Stock	159.2	159.56	158.25	159.17	7645672.0
2023-03-24 11:00:00	AAPL	Stock	159.18	159.4	158.05	159.09	6519375.0
2023-03-24 12:00:00	AAPL	Stock	159.1	159.47	158.18	158.7499	4757276.0
2023-03-24 13:00:00	AAPL	Stock	158.74	159.67	158.565	159.15	4783536.0
2023-03-24 14:00:00	AAPL	Stock	159.15	159.95	159.102	159.6731	4627987.0
2023-03-24 15:00:00	AAPL	Stock	159.68	160.34	159.36	160.25	7723789.0
2023-03-24 16:00:00	AAPL	Stock	160.27	160.39	160.1	160.31	7295007.0
2023-03-24 17:00:00	AAPL	Stock	160.35	160.36	159.82	160.08	168952.0
2023-03-24 18:00:00	AAPL	Stock	160.07	160.14	160.03	160.08	19675.0
2023-03-24 19:00:00	AAPL	Stock	160.07	160.2	159.92	160.2	29748.0
2023-03-24 04:00:00	MSFT	Stock	278.89	278.89	277.0	277.66	16678.0
2023-03-24 05:00:00	MSFT	Stock	277.34	278.04	276.73	277.1	5928.0
2023-03-24 06:00:00	MSFT	Stock	276.8	276.93	275.82	275.88	26787.0
2023-03-24 07:00:00	MSFT	Stock	276.2	276.4	275.05	275.41	30613.0
2023-03-24 08:00:00	MSFT	Stock	276.3	278.83	274.8	276.9143	51680.0
2023-03-24 09:00:00	MSFT	Stock	276.7	277.93	275.28	277.7	2555720.0
2023-03-24 10:00:00	MSFT	Stock	277.77	278.935	276.61	278.88	3358952.0
2023-03-24 11:00:00	MSFT	Stock	278.91	279.71	276.7158	279.25	3066283.0
2023-03-24 12:00:00	MSFT	Stock	279.26	279.77	277.2273	278.2	2234256.0
2023-03-24 13:00:00	MSFT	Stock	278.2	279.2	277.58	278.0578	1870353.0
2023-03-24 14:00:00	MSFT	Stock	278.055	279.2	277.84	278.9264	1453418.0
2023-03-24 15:00:00	MSFT	Stock	278.94	280.63	278.69	280.57	3719492.0
2023-03-24 16:00:00	MSFT	Stock	280.58	280.93	280.0	280.75	3651410.0
2023-03-24 17:00:00	MSFT	Stock	280.7741	280.8597	280.46	280.7	24120.0
2023-03-24 18:00:00	MSFT	Stock	280.73	281.0	280.6	280.75	9138.0
2023-03-24 19:00:00	MSFT	Stock	280.94	280.94	280.65	280.8	9553.0
2023-03-24 04:00:00	NVDA	Stock	27.32	27.37	27.15	27.165	201640.0
2023-03-24 05:00:00	NVDA	Stock	27.226	27.27	26.98	26.99	182540.0
2023-03-24 06:00:00	NVDA	Stock	26.976	27.079	26.9	27.055	283580.0
2023-03-24 07:00:00	NVDA	Stock	27.047	27.079	26.9	26.955	710870.0
2023-03-24 08:00:00	NVDA	Stock	27.0177	27.315	26.845	27.045	2014450.0
2023-03-24 09:00:00	NVDA	Stock	27.002	27.167	26.636	26.818	55464550.0
2023-03-24 10:00:00	NVDA	Stock	26.823	26.884	26.492	26.5254	66261000.0
2023-03-24 11:00:00	NVDA	Stock	26.52	26.725	26.355	26.684	60034880.0
2023-03-24 12:00:00	NVDA	Stock	26.688	26.756	26.415	26.5319	38946790.0
2023-03-24 13:00:00	NVDA	Stock	26.535	26.593	26.453	26.497	26832600.0
2023-03-24 14:00:00	NVDA	Stock	26.5005	26.6793	26.46	26.6315	32778650.0
2023-03-24 15:00:00	NVDA	Stock	26.634	26.8	26.549	26.78	50631820.0
2023-03-24 16:00:00	NVDA	Stock	26.779	26.78	26.724	26.755	17560450.0
2023-03-24 17:00:00	NVDA	Stock	26.755	26.76	26.7408	26.745	105280.0
2023-03-24 18:00:00	NVDA	Stock	26.75	26.767	26.745	26.764	130790.0
2023-03-24 19:00:00	NVDA	Stock	26.754	26.771	26.745	26.77	203220.0
2023-03-24 04:00:00	AMZN	Stock	99.0	99.47	98.73	99.1	22201.0
2023-03-24 05:00:00	AMZN	Stock	99.0	99.3	98.53	98.56	31200.0

> showing 50 of 59,831 rows — these rows as CSV

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