PREVIEW / stock_1hour / 2022-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-08.parquet
  size:    1.4 MB
  rows:    64,378
  symbols: 2,303

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
2022-08-08 04:00:00	AAPL	Stock	166.24	166.24	165.59	165.89	30813.0
2022-08-08 05:00:00	AAPL	Stock	165.96	166.1	165.74	165.81	7614.0
2022-08-08 06:00:00	AAPL	Stock	165.81	166.45	165.81	166.44	25766.0
2022-08-08 07:00:00	AAPL	Stock	166.36	166.58	166.1	166.37	201915.0
2022-08-08 08:00:00	AAPL	Stock	166.2602	166.68	164.937	166.68	460684.0
2022-08-08 09:00:00	AAPL	Stock	166.67	167.78	165.8	167.48	8378337.0
2022-08-08 10:00:00	AAPL	Stock	167.46	167.81	166.45	166.59	6619065.0
2022-08-08 11:00:00	AAPL	Stock	166.595	167.07	165.12	165.68	6078327.0
2022-08-08 12:00:00	AAPL	Stock	165.68	165.7501	164.55	165.05	5457982.0
2022-08-08 13:00:00	AAPL	Stock	165.04	165.55	164.69	165.2825	3733771.0
2022-08-08 14:00:00	AAPL	Stock	165.29	165.3059	164.2	164.585	4019369.0
2022-08-08 15:00:00	AAPL	Stock	164.5875	165.17	164.505	164.88	5702764.0
2022-08-08 16:00:00	AAPL	Stock	164.87	165.0	164.8115	164.99	3216373.0
2022-08-08 17:00:00	AAPL	Stock	165.0	165.16	164.94	165.04	25867.0
2022-08-08 18:00:00	AAPL	Stock	165.05	165.05	164.94	165.0	18520.0
2022-08-08 19:00:00	AAPL	Stock	164.95	165.44	164.92	165.27	55466.0
2022-08-08 04:00:00	MSFT	Stock	283.02	284.01	282.9	283.58	4018.0
2022-08-08 05:00:00	MSFT	Stock	283.2	283.35	283.12	283.12	850.0
2022-08-08 06:00:00	MSFT	Stock	283.34	284.3	283.34	284.27	1339.0
2022-08-08 07:00:00	MSFT	Stock	284.1	284.47	284.0	284.4	6933.0
2022-08-08 08:00:00	MSFT	Stock	284.07	285.0	281.81	284.94	17046.0
2022-08-08 09:00:00	MSFT	Stock	284.9	285.89	282.46	285.24	2308537.0
2022-08-08 10:00:00	MSFT	Stock	285.27	285.92	283.13	283.49	1957230.0
2022-08-08 11:00:00	MSFT	Stock	283.55	284.17	281.1	282.55	1650060.0
2022-08-08 12:00:00	MSFT	Stock	282.54	282.58	280.28	281.28	1251855.0
2022-08-08 13:00:00	MSFT	Stock	281.22	281.53	280.01	280.74	769668.0
2022-08-08 14:00:00	MSFT	Stock	280.73	280.7425	279.32	279.958	1083947.0
2022-08-08 15:00:00	MSFT	Stock	279.97	280.76	279.5	280.35	1748280.0
2022-08-08 16:00:00	MSFT	Stock	280.32	281.29	280.32	281.29	1875651.0
2022-08-08 17:00:00	MSFT	Stock	280.75	281.1809	280.6315	280.85	7386.0
2022-08-08 18:00:00	MSFT	Stock	280.7	280.78	280.5	280.5	2942.0
2022-08-08 19:00:00	MSFT	Stock	280.62	281.69	280.62	281.44	8257.0
2022-08-08 04:00:00	NVDA	Stock	19.105	19.114	19.0	19.029	173440.0
2022-08-08 05:00:00	NVDA	Stock	19.04	19.049	19.023	19.033	10250.0
2022-08-08 06:00:00	NVDA	Stock	19.035	19.14	19.035	19.1	135550.0
2022-08-08 07:00:00	NVDA	Stock	19.09	19.112	19.041	19.089	165500.0
2022-08-08 08:00:00	NVDA	Stock	19.08	19.136	18.902	19.065	985300.0
2022-08-08 09:00:00	NVDA	Stock	19.053	19.06	17.359	18.048	157741560.0
2022-08-08 10:00:00	NVDA	Stock	18.049	18.213	17.626	17.647	139870290.0
2022-08-08 11:00:00	NVDA	Stock	17.65	17.778	17.242	17.439	116190670.0
2022-08-08 12:00:00	NVDA	Stock	17.437	17.557	17.284	17.465	90530070.0
2022-08-08 13:00:00	NVDA	Stock	17.463	17.595	17.4425	17.515	61006430.0
2022-08-08 14:00:00	NVDA	Stock	17.514	17.517	17.349	17.416	54340640.0
2022-08-08 15:00:00	NVDA	Stock	17.416	17.849	17.3995	17.798	139038780.0
2022-08-08 16:00:00	NVDA	Stock	17.7985	17.835	17.748	17.789	23676590.0
2022-08-08 17:00:00	NVDA	Stock	17.7801	17.7845	17.695	17.712	708580.0
2022-08-08 18:00:00	NVDA	Stock	17.701	17.713	17.618	17.627	520140.0
2022-08-08 19:00:00	NVDA	Stock	17.628	17.694	17.57	17.65	867030.0
2022-08-08 04:00:00	AMZN	Stock	141.58	141.74	140.71	141.6	21253.0
2022-08-08 05:00:00	AMZN	Stock	141.55	141.65	141.4	141.5	5804.0

> showing 50 of 64,378 rows — these rows as CSV

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