PREVIEW / stock_1hour / 2023-10-02

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-02.parquet
  size:    1.3 MB
  rows:    58,784
  symbols: 1,368

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-10-02 04:00:00	AAPL	Stock	172.7	172.91	172.4	172.51	17294.0
2023-10-02 05:00:00	AAPL	Stock	172.5	172.5	171.33	171.33	42593.0
2023-10-02 06:00:00	AAPL	Stock	171.42	171.61	171.03	171.23	19965.0
2023-10-02 07:00:00	AAPL	Stock	171.37	171.97	171.25	171.55	50387.0
2023-10-02 08:00:00	AAPL	Stock	171.38	172.99	171.06	171.3	132552.0
2023-10-02 09:00:00	AAPL	Stock	171.26	173.25	170.93	172.94	5992196.0
2023-10-02 10:00:00	AAPL	Stock	172.94	174.04	172.8	173.009	7533324.0
2023-10-02 11:00:00	AAPL	Stock	173.01	174.3	172.905	173.08	5350367.0
2023-10-02 12:00:00	AAPL	Stock	173.09	173.53	172.82	173.18	3403471.0
2023-10-02 13:00:00	AAPL	Stock	173.185	173.5799	172.73	173.13	3168186.0
2023-10-02 14:00:00	AAPL	Stock	173.13	173.71	172.61	172.89	3687059.0
2023-10-02 15:00:00	AAPL	Stock	172.88	173.78	172.533	173.75	7632905.0
2023-10-02 16:00:00	AAPL	Stock	173.75	173.96	171.21	173.73	5686819.0
2023-10-02 17:00:00	AAPL	Stock	173.75	173.78	173.64	173.65	24365.0
2023-10-02 18:00:00	AAPL	Stock	173.69	173.87	173.65	173.7	15908.0
2023-10-02 19:00:00	AAPL	Stock	173.75	173.94	173.63	173.82	24191.0
2023-10-02 04:00:00	MSFT	Stock	317.5	318.83	317.5	318.65	1020.0
2023-10-02 05:00:00	MSFT	Stock	318.3	318.3	316.03	316.1	3979.0
2023-10-02 06:00:00	MSFT	Stock	316.81	317.57	316.02	317.07	5753.0
2023-10-02 07:00:00	MSFT	Stock	317.2	317.38	316.35	316.4	16356.0
2023-10-02 08:00:00	MSFT	Stock	316.4	318.88	315.5	315.89	31100.0
2023-10-02 09:00:00	MSFT	Stock	315.89	318.715	315.18	316.95	1903781.0
2023-10-02 10:00:00	MSFT	Stock	317.0	319.0372	316.8	317.73	2071740.0
2023-10-02 11:00:00	MSFT	Stock	317.75	321.39	317.64	318.58	2107742.0
2023-10-02 12:00:00	MSFT	Stock	318.61	319.1	317.83	318.195	1008930.0
2023-10-02 13:00:00	MSFT	Stock	318.2	319.27	317.6	318.57	866281.0
2023-10-02 14:00:00	MSFT	Stock	318.575	320.2	318.31	318.99	1052779.0
2023-10-02 15:00:00	MSFT	Stock	318.95	321.888	318.53	321.81	2743302.0
2023-10-02 16:00:00	MSFT	Stock	321.8	322.48	315.75	321.8	2643819.0
2023-10-02 17:00:00	MSFT	Stock	321.8	321.88	321.4472	321.7306	8189.0
2023-10-02 18:00:00	MSFT	Stock	321.64	321.99	321.55	321.91	3870.0
2023-10-02 19:00:00	MSFT	Stock	321.89	321.98	321.07	321.98	11631.0
2023-10-02 04:00:00	NVDA	Stock	44.012	44.196	43.93	44.0	142540.0
2023-10-02 05:00:00	NVDA	Stock	43.99	44.25	43.943	44.049	253800.0
2023-10-02 06:00:00	NVDA	Stock	44.097	44.134	44.035	44.1	125840.0
2023-10-02 07:00:00	NVDA	Stock	44.069	44.08	43.913	43.989	1026330.0
2023-10-02 08:00:00	NVDA	Stock	44.045	44.246	43.862	43.895	2497580.0
2023-10-02 09:00:00	NVDA	Stock	43.9	44.682	43.76	44.5703	59597040.0
2023-10-02 10:00:00	NVDA	Stock	44.569	45.038	44.528	44.797	82864890.0
2023-10-02 11:00:00	NVDA	Stock	44.798	45.175	44.62	44.7085	45565600.0
2023-10-02 12:00:00	NVDA	Stock	44.703	44.847	44.548	44.6	34149100.0
2023-10-02 13:00:00	NVDA	Stock	44.5985	44.857	44.471	44.728	29060460.0
2023-10-02 14:00:00	NVDA	Stock	44.722	44.735	44.256	44.467	35579030.0
2023-10-02 15:00:00	NVDA	Stock	44.462	44.797	44.286	44.796	42719900.0
2023-10-02 16:00:00	NVDA	Stock	44.796	44.888	43.499	44.786	12150020.0
2023-10-02 17:00:00	NVDA	Stock	44.79	44.835	44.753	44.81	265760.0
2023-10-02 18:00:00	NVDA	Stock	44.822	44.855	44.813	44.849	161790.0
2023-10-02 19:00:00	NVDA	Stock	44.844	44.945	44.8	44.917	637700.0
2023-10-02 04:00:00	AMZN	Stock	128.26	128.57	128.25	128.25	23765.0
2023-10-02 05:00:00	AMZN	Stock	128.18	128.31	127.56	127.57	19200.0

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

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