PREVIEW / stock_1hour / 2023-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-08.parquet
  size:    1.4 MB
  rows:    60,745
  symbols: 1,478

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-08-08 04:00:00	AAPL	Stock	178.78	178.78	178.25	178.7	23597.0
2023-08-08 05:00:00	AAPL	Stock	178.73	179.19	178.48	179.19	35045.0
2023-08-08 06:00:00	AAPL	Stock	179.18	179.5	179.1	179.2	24534.0
2023-08-08 07:00:00	AAPL	Stock	179.25	179.26	178.29	178.64	70099.0
2023-08-08 08:00:00	AAPL	Stock	179.17	179.47	178.16	179.02	397318.0
2023-08-08 09:00:00	AAPL	Stock	179.02	179.84	177.58	178.05	9340904.0
2023-08-08 10:00:00	AAPL	Stock	178.045	179.22	177.76	178.13	9910998.0
2023-08-08 11:00:00	AAPL	Stock	178.13	178.3482	177.825	177.865	5575353.0
2023-08-08 12:00:00	AAPL	Stock	177.8678	178.99	177.84	178.91	3976812.0
2023-08-08 13:00:00	AAPL	Stock	178.919	179.48	178.7	179.045	5138272.0
2023-08-08 14:00:00	AAPL	Stock	179.05	179.55	178.91	179.485	3842311.0
2023-08-08 15:00:00	AAPL	Stock	179.49	180.27	179.34	179.8	10234028.0
2023-08-08 16:00:00	AAPL	Stock	179.8	179.94	179.6	179.76	5818287.0
2023-08-08 17:00:00	AAPL	Stock	179.75	179.77	179.62	179.73	28690.0
2023-08-08 18:00:00	AAPL	Stock	179.75	179.9	179.74	179.85	30366.0
2023-08-08 19:00:00	AAPL	Stock	179.84	179.91	179.56	179.79	38904.0
2023-08-08 04:00:00	MSFT	Stock	330.0	330.0	329.29	329.29	3564.0
2023-08-08 05:00:00	MSFT	Stock	329.27	329.27	328.96	328.96	543.0
2023-08-08 06:00:00	MSFT	Stock	328.97	329.92	328.83	329.3	5070.0
2023-08-08 07:00:00	MSFT	Stock	329.0	329.09	326.5	327.5	31108.0
2023-08-08 08:00:00	MSFT	Stock	328.75	329.69	326.43	327.6	25938.0
2023-08-08 09:00:00	MSFT	Stock	327.5	328.75	325.54	325.78	1824993.0
2023-08-08 10:00:00	MSFT	Stock	325.74	326.2885	323.08	323.32	2961786.0
2023-08-08 11:00:00	MSFT	Stock	323.335	324.64	323.0	323.31	1999348.0
2023-08-08 12:00:00	MSFT	Stock	323.3	324.61	323.19	324.13	1367781.0
2023-08-08 13:00:00	MSFT	Stock	324.17	324.9	323.89	324.41	1143523.0
2023-08-08 14:00:00	MSFT	Stock	324.43	325.27	323.99	325.0	1193589.0
2023-08-08 15:00:00	MSFT	Stock	324.95	326.4	324.51	326.04	2161964.0
2023-08-08 16:00:00	MSFT	Stock	326.095	326.2975	325.4	325.99	2714285.0
2023-08-08 17:00:00	MSFT	Stock	325.92	326.05	325.79	325.9	91295.0
2023-08-08 18:00:00	MSFT	Stock	326.0	326.1852	325.87	325.87	4070.0
2023-08-08 19:00:00	MSFT	Stock	326.05	326.05	325.61	325.66	13474.0
2023-08-08 04:00:00	NVDA	Stock	45.287	45.287	44.948	45.0	176050.0
2023-08-08 05:00:00	NVDA	Stock	44.925	44.935	44.82	44.898	168880.0
2023-08-08 06:00:00	NVDA	Stock	44.94	44.94	44.88	44.937	20530.0
2023-08-08 07:00:00	NVDA	Stock	44.948	44.959	44.825	44.918	339920.0
2023-08-08 08:00:00	NVDA	Stock	44.953	45.2	44.825	45.06	1644170.0
2023-08-08 09:00:00	NVDA	Stock	45.05	45.242	44.565	44.687	35761110.0
2023-08-08 10:00:00	NVDA	Stock	44.676	44.9	44.57	44.6467	41359570.0
2023-08-08 11:00:00	NVDA	Stock	44.633	45.1372	44.056	44.336	66651080.0
2023-08-08 12:00:00	NVDA	Stock	44.3402	44.595	44.256	44.358	34974290.0
2023-08-08 13:00:00	NVDA	Stock	44.368	44.6509	44.292	44.611	25948690.0
2023-08-08 14:00:00	NVDA	Stock	44.6155	44.764	44.472	44.6745	25171190.0
2023-08-08 15:00:00	NVDA	Stock	44.67	44.737	44.4512	44.659	26923310.0
2023-08-08 16:00:00	NVDA	Stock	44.658	44.725	44.22	44.4	11558120.0
2023-08-08 17:00:00	NVDA	Stock	44.43	44.65	44.4	44.597	525400.0
2023-08-08 18:00:00	NVDA	Stock	44.6	44.664	44.57	44.575	537750.0
2023-08-08 19:00:00	NVDA	Stock	44.575	44.655	44.571	44.65	344710.0
2023-08-08 04:00:00	AMZN	Stock	141.37	141.65	141.24	141.39	16760.0
2023-08-08 05:00:00	AMZN	Stock	141.37	141.37	141.05	141.2	9087.0

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

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