PREVIEW / stock_1hour / 2001-03-06

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-03-06.parquet
  size:    346 KB
  rows:    16,402
  symbols: 1,270

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
2001-03-06 08:00:00	AAPL	Stock	0.3633	0.3795	0.3633	0.3705	2480800.0
2001-03-06 09:00:00	AAPL	Stock	0.3717	0.3895	0.3683	0.3895	107777600.0
2001-03-06 10:00:00	AAPL	Stock	0.3895	0.394	0.3873	0.3895	145325600.0
2001-03-06 11:00:00	AAPL	Stock	0.3884	0.3895	0.3783	0.3806	147089600.0
2001-03-06 12:00:00	AAPL	Stock	0.3817	0.3839	0.3795	0.3817	65262400.0
2001-03-06 13:00:00	AAPL	Stock	0.3817	0.3884	0.3817	0.3873	72738400.0
2001-03-06 14:00:00	AAPL	Stock	0.3884	0.3917	0.3839	0.3873	100464000.0
2001-03-06 15:00:00	AAPL	Stock	0.3884	0.3895	0.3828	0.3828	59808000.0
2001-03-06 16:00:00	AAPL	Stock	0.3828	0.3839	0.3806	0.3839	12969600.0
2001-03-06 17:00:00	AAPL	Stock	0.3817	0.3817	0.3817	0.3817	56000.0
2001-03-06 18:00:00	AAPL	Stock	0.3817	0.3817	0.3817	0.3817	28000.0
2001-03-06 08:00:00	MSFT	Stock	29.0	29.375	29.0	29.3125	144400.0
2001-03-06 09:00:00	MSFT	Stock	29.3125	29.4375	29.0	29.25	9682200.0
2001-03-06 10:00:00	MSFT	Stock	29.25	29.9375	29.1875	29.75	17409000.0
2001-03-06 11:00:00	MSFT	Stock	29.75	29.8438	29.6562	29.75	6885600.0
2001-03-06 12:00:00	MSFT	Stock	29.7188	29.7812	29.5625	29.6875	4323600.0
2001-03-06 13:00:00	MSFT	Stock	29.6875	30.0	29.625	29.875	6124800.0
2001-03-06 14:00:00	MSFT	Stock	29.9375	29.9375	29.625	29.8594	7267000.0
2001-03-06 15:00:00	MSFT	Stock	29.8438	29.9375	29.625	29.7188	10498000.0
2001-03-06 16:00:00	MSFT	Stock	29.75	29.8438	29.7188	29.7188	1940800.0
2001-03-06 17:00:00	MSFT	Stock	29.7188	29.875	29.6562	29.6875	20000.0
2001-03-06 18:00:00	MSFT	Stock	29.6562	29.7188	29.6562	29.7188	2800.0
2001-03-06 08:00:00	NVDA	Stock	0.1824	0.1896	0.1824	0.1896	720000.0
2001-03-06 09:00:00	NVDA	Stock	0.1896	0.1997	0.1888	0.1948	86448000.0
2001-03-06 10:00:00	NVDA	Stock	0.1948	0.2034	0.1945	0.2018	122808000.0
2001-03-06 11:00:00	NVDA	Stock	0.2016	0.2039	0.201	0.2034	83040000.0
2001-03-06 12:00:00	NVDA	Stock	0.2029	0.2036	0.1953	0.1984	76176000.0
2001-03-06 13:00:00	NVDA	Stock	0.1979	0.2055	0.1977	0.2047	60552000.0
2001-03-06 14:00:00	NVDA	Stock	0.2049	0.2063	0.2021	0.2049	164400000.0
2001-03-06 15:00:00	NVDA	Stock	0.2049	0.2076	0.199	0.201	165048000.0
2001-03-06 16:00:00	NVDA	Stock	0.201	0.2052	0.201	0.2042	35400000.0
2001-03-06 17:00:00	NVDA	Stock	0.2021	0.2063	0.2021	0.2021	696000.0
2001-03-06 08:00:00	AMZN	Stock	0.6469	0.6625	0.6328	0.65	1190000.0
2001-03-06 09:00:00	AMZN	Stock	0.6516	0.6969	0.6438	0.6844	73522000.0
2001-03-06 10:00:00	AMZN	Stock	0.6844	0.7	0.675	0.675	70412000.0
2001-03-06 11:00:00	AMZN	Stock	0.675	0.6844	0.6625	0.675	31416000.0
2001-03-06 12:00:00	AMZN	Stock	0.675	0.6875	0.6719	0.6719	19214000.0
2001-03-06 13:00:00	AMZN	Stock	0.6734	0.6781	0.6688	0.675	19440000.0
2001-03-06 14:00:00	AMZN	Stock	0.675	0.6781	0.6719	0.6719	13612000.0
2001-03-06 15:00:00	AMZN	Stock	0.675	0.6781	0.5625	0.6047	162422000.0
2001-03-06 16:00:00	AMZN	Stock	0.6031	0.6688	0.5875	0.5875	42704000.0
2001-03-06 17:00:00	AMZN	Stock	0.5938	0.5938	0.5875	0.5875	1132000.0
2001-03-06 18:00:00	AMZN	Stock	0.5906	0.5938	0.5875	0.5938	250000.0
2001-03-06 09:00:00	CL	Stock	29.25	29.25	28.925	29.0	334800.0
2001-03-06 10:00:00	CL	Stock	28.975	29.135	28.925	28.96	271200.0
2001-03-06 11:00:00	CL	Stock	28.96	29.1	28.96	29.06	232200.0
2001-03-06 12:00:00	CL	Stock	29.06	29.06	28.95	28.975	218400.0
2001-03-06 13:00:00	CL	Stock	28.975	29.095	28.925	28.94	382800.0
2001-03-06 14:00:00	CL	Stock	28.925	28.95	28.825	28.925	240200.0
2001-03-06 15:00:00	CL	Stock	28.9	28.975	28.8	28.93	337400.0

> showing 50 of 16,402 rows — these rows as CSV

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