PREVIEW / stock_1hour / 2023-02-17

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-17.parquet
  size:    1.4 MB
  rows:    60,265
  symbols: 1,820

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-17 04:00:00	AAPL	Stock	152.8	152.8	151.85	152.12	46586.0
2023-02-17 05:00:00	AAPL	Stock	152.19	152.3	152.01	152.02	11828.0
2023-02-17 06:00:00	AAPL	Stock	152.01	152.1	151.86	152.07	27006.0
2023-02-17 07:00:00	AAPL	Stock	152.12	152.5	152.1	152.38	37318.0
2023-02-17 08:00:00	AAPL	Stock	152.22	152.99	152.0	152.5	185783.0
2023-02-17 09:00:00	AAPL	Stock	152.5	153.39	151.5	151.69	8204528.0
2023-02-17 10:00:00	AAPL	Stock	151.68	152.68	151.63	152.01	7769079.0
2023-02-17 11:00:00	AAPL	Stock	151.99	152.2699	151.37	151.575	4767866.0
2023-02-17 12:00:00	AAPL	Stock	151.57	152.17	150.9104	151.08	4507982.0
2023-02-17 13:00:00	AAPL	Stock	151.09	151.4899	150.85	151.44	3647036.0
2023-02-17 14:00:00	AAPL	Stock	151.435	152.3599	151.34	152.3501	4929308.0
2023-02-17 15:00:00	AAPL	Stock	152.3589	152.63	151.93	152.54	8184561.0
2023-02-17 16:00:00	AAPL	Stock	152.54	152.55	152.4	152.52	6571978.0
2023-02-17 17:00:00	AAPL	Stock	152.52	152.54	152.41	152.5	104660.0
2023-02-17 18:00:00	AAPL	Stock	152.5	152.69	152.48	152.62	21764.0
2023-02-17 19:00:00	AAPL	Stock	152.62	152.64	152.55	152.64	16295.0
2023-02-17 04:00:00	MSFT	Stock	260.0	260.68	259.52	260.0	17463.0
2023-02-17 05:00:00	MSFT	Stock	259.9	259.99	259.62	259.62	3651.0
2023-02-17 06:00:00	MSFT	Stock	259.66	259.79	259.0	259.79	10268.0
2023-02-17 07:00:00	MSFT	Stock	259.83	260.84	259.83	260.68	13248.0
2023-02-17 08:00:00	MSFT	Stock	260.0907	260.84	259.81	260.5501	60251.0
2023-02-17 09:00:00	MSFT	Stock	260.46	261.94	256.44	257.265	4448180.0
2023-02-17 10:00:00	MSFT	Stock	257.23	258.97	256.89	256.94	3401463.0
2023-02-17 11:00:00	MSFT	Stock	256.93	257.49	256.52	257.18	2042509.0
2023-02-17 12:00:00	MSFT	Stock	257.18	257.74	256.0	256.295	1968513.0
2023-02-17 13:00:00	MSFT	Stock	256.3	257.215	256.23	256.6222	1467792.0
2023-02-17 14:00:00	MSFT	Stock	256.63	257.87	256.543	257.69	1984983.0
2023-02-17 15:00:00	MSFT	Stock	257.73	258.3	257.11	258.09	3370504.0
2023-02-17 16:00:00	MSFT	Stock	258.08	258.32	257.94	258.24	3031106.0
2023-02-17 17:00:00	MSFT	Stock	258.22	258.25	258.06	258.24	8804.0
2023-02-17 18:00:00	MSFT	Stock	258.24	258.49	258.16	258.16	8867.0
2023-02-17 19:00:00	MSFT	Stock	258.38	258.45	258.16	258.28	5892.0
2023-02-17 04:00:00	NVDA	Stock	21.591	21.738	21.488	21.671	351500.0
2023-02-17 05:00:00	NVDA	Stock	21.662	21.662	21.601	21.601	28220.0
2023-02-17 06:00:00	NVDA	Stock	21.6	21.638	21.582	21.638	161810.0
2023-02-17 07:00:00	NVDA	Stock	21.644	21.69	21.557	21.678	469740.0
2023-02-17 08:00:00	NVDA	Stock	21.679	21.76	21.541	21.7166	1084160.0
2023-02-17 09:00:00	NVDA	Stock	21.725	21.835	21.364	21.521	72113760.0
2023-02-17 10:00:00	NVDA	Stock	21.5195	21.6328	21.164	21.164	72663630.0
2023-02-17 11:00:00	NVDA	Stock	21.162	21.291	21.071	21.172	45669700.0
2023-02-17 12:00:00	NVDA	Stock	21.172	21.315	20.975	21.081	45691630.0
2023-02-17 13:00:00	NVDA	Stock	21.079	21.205	21.044	21.189	31843550.0
2023-02-17 14:00:00	NVDA	Stock	21.191	21.507	21.188	21.493	42591180.0
2023-02-17 15:00:00	NVDA	Stock	21.495	21.525	21.334	21.388	49941400.0
2023-02-17 16:00:00	NVDA	Stock	21.388	21.393	21.35	21.378	15661660.0
2023-02-17 17:00:00	NVDA	Stock	21.373	21.402	21.32	21.39	500570.0
2023-02-17 18:00:00	NVDA	Stock	21.39	21.55	21.39	21.525	548330.0
2023-02-17 19:00:00	NVDA	Stock	21.545	21.556	21.486	21.51	283430.0
2023-02-17 04:00:00	AMZN	Stock	97.44	97.94	97.0	97.22	39025.0
2023-02-17 05:00:00	AMZN	Stock	97.34	97.38	97.15	97.23	30005.0

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

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