PREVIEW / stock_1hour / 2023-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-25.parquet
  size:    1.4 MB
  rows:    60,200
  symbols: 1,538

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-07-25 04:00:00	AAPL	Stock	193.58	193.66	193.4	193.55	12799.0
2023-07-25 05:00:00	AAPL	Stock	193.46	193.57	193.45	193.56	5915.0
2023-07-25 06:00:00	AAPL	Stock	193.54	193.54	193.3	193.33	12460.0
2023-07-25 07:00:00	AAPL	Stock	193.4	193.54	193.4	193.54	14254.0
2023-07-25 08:00:00	AAPL	Stock	193.48	193.77	193.4	193.58	104991.0
2023-07-25 09:00:00	AAPL	Stock	193.59	194.02	192.915	193.95	4225467.0
2023-07-25 10:00:00	AAPL	Stock	193.955	194.2	193.23	193.28	3830078.0
2023-07-25 11:00:00	AAPL	Stock	193.2722	194.13	193.25	193.765	2954461.0
2023-07-25 12:00:00	AAPL	Stock	193.765	193.9655	193.61	193.92	2082038.0
2023-07-25 13:00:00	AAPL	Stock	193.9188	194.24	193.84	193.975	2245469.0
2023-07-25 14:00:00	AAPL	Stock	193.97	194.44	193.87	193.94	2451089.0
2023-07-25 15:00:00	AAPL	Stock	193.945	194.42	193.6	193.62	5682349.0
2023-07-25 16:00:00	AAPL	Stock	193.63	193.98	193.31	193.51	5670591.0
2023-07-25 17:00:00	AAPL	Stock	193.52	193.94	193.45	193.78	83626.0
2023-07-25 18:00:00	AAPL	Stock	193.81	193.81	193.21	193.4	80478.0
2023-07-25 19:00:00	AAPL	Stock	193.42	193.57	193.34	193.53	28890.0
2023-07-25 04:00:00	MSFT	Stock	347.0	347.59	346.9	347.25	18617.0
2023-07-25 05:00:00	MSFT	Stock	347.25	348.0	347.22	347.92	23077.0
2023-07-25 06:00:00	MSFT	Stock	348.0	348.5	347.5	347.85	24144.0
2023-07-25 07:00:00	MSFT	Stock	347.79	348.2	347.73	348.15	35283.0
2023-07-25 08:00:00	MSFT	Stock	346.85	349.9	346.75	348.2805	141803.0
2023-07-25 09:00:00	MSFT	Stock	348.28	348.49	345.07	347.9	2977340.0
2023-07-25 10:00:00	MSFT	Stock	347.88	347.99	345.85	346.14	2775721.0
2023-07-25 11:00:00	MSFT	Stock	346.19	349.25	346.1162	348.57	2349652.0
2023-07-25 12:00:00	MSFT	Stock	348.6	350.41	348.2001	350.1757	2644072.0
2023-07-25 13:00:00	MSFT	Stock	350.15	351.13	349.92	350.35	2120977.0
2023-07-25 14:00:00	MSFT	Stock	350.36	351.62	350.25	350.354	2304847.0
2023-07-25 15:00:00	MSFT	Stock	350.33	351.89	349.62	350.95	5566429.0
2023-07-25 16:00:00	MSFT	Stock	350.98	351.48	338.56	348.7	5276059.0
2023-07-25 17:00:00	MSFT	Stock	348.5	354.9	345.15	348.85	1658653.0
2023-07-25 18:00:00	MSFT	Stock	348.51	353.79	335.0	339.02	2764881.0
2023-07-25 19:00:00	MSFT	Stock	339.02	339.47	337.06	337.8	342048.0
2023-07-25 04:00:00	NVDA	Stock	44.824	45.17	44.8	45.12	209680.0
2023-07-25 05:00:00	NVDA	Stock	45.13	45.19	45.121	45.145	86640.0
2023-07-25 06:00:00	NVDA	Stock	45.125	45.125	44.997	45.049	51870.0
2023-07-25 07:00:00	NVDA	Stock	45.004	45.067	44.952	45.025	244630.0
2023-07-25 08:00:00	NVDA	Stock	44.84	45.115	44.75	45.035	1126840.0
2023-07-25 09:00:00	NVDA	Stock	45.03	45.998	44.923	45.989	54997310.0
2023-07-25 10:00:00	NVDA	Stock	45.9971	46.104	45.522	45.668	54732410.0
2023-07-25 11:00:00	NVDA	Stock	45.669	46.044	45.652	45.9356	30899550.0
2023-07-25 12:00:00	NVDA	Stock	45.94	45.998	45.771	45.9095	21106650.0
2023-07-25 13:00:00	NVDA	Stock	45.9077	45.962	45.638	45.704	18628630.0
2023-07-25 14:00:00	NVDA	Stock	45.704	46.1825	45.675	45.845	28608310.0
2023-07-25 15:00:00	NVDA	Stock	45.841	46.025	45.5834	45.662	35455520.0
2023-07-25 16:00:00	NVDA	Stock	45.679	45.793	45.4	45.729	16564090.0
2023-07-25 17:00:00	NVDA	Stock	45.729	46.13	45.551	46.13	1485860.0
2023-07-25 18:00:00	NVDA	Stock	46.148	46.6	45.861	46.047	3988730.0
2023-07-25 19:00:00	NVDA	Stock	46.05	46.065	45.956	46.055	676300.0
2023-07-25 04:00:00	AMZN	Stock	129.12	129.59	129.11	129.59	39540.0
2023-07-25 05:00:00	AMZN	Stock	129.55	129.63	129.53	129.57	5103.0

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

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