PREVIEW / stock_1hour / 2004-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-05.parquet
  size:    515 KB
  rows:    24,228
  symbols: 1,718

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
2004-01-05 08:00:00	AAPL	Stock	0.3813	0.3848	0.3813	0.3839	194768.0
2004-01-05 09:00:00	AAPL	Stock	0.3839	0.388	0.38	0.3875	27706896.0
2004-01-05 10:00:00	AAPL	Stock	0.3875	0.3929	0.3861	0.3929	50371888.0
2004-01-05 11:00:00	AAPL	Stock	0.3927	0.3939	0.3914	0.3929	52231312.0
2004-01-05 12:00:00	AAPL	Stock	0.3929	0.3998	0.3929	0.3995	77194544.0
2004-01-05 13:00:00	AAPL	Stock	0.3995	0.3996	0.3961	0.3975	59723104.0
2004-01-05 14:00:00	AAPL	Stock	0.3975	0.3995	0.3945	0.3946	33421584.0
2004-01-05 15:00:00	AAPL	Stock	0.3946	0.3973	0.3932	0.3952	66509632.0
2004-01-05 16:00:00	AAPL	Stock	0.395	0.3998	0.3946	0.3955	5885600.0
2004-01-05 17:00:00	AAPL	Stock	0.3959	0.3998	0.3959	0.3998	1227408.0
2004-01-05 18:00:00	AAPL	Stock	0.4	0.4002	0.397	0.4002	123200.0
2004-01-05 08:00:00	MSFT	Stock	27.42	27.85	27.42	27.73	426774.0
2004-01-05 09:00:00	MSFT	Stock	27.75	27.95	27.46	27.92	9941741.0
2004-01-05 10:00:00	MSFT	Stock	27.92	28.001	27.85	27.97	11483483.0
2004-01-05 11:00:00	MSFT	Stock	27.97	27.98	27.88	27.93	7044059.0
2004-01-05 12:00:00	MSFT	Stock	27.92	28.1	27.92	28.01	10894869.0
2004-01-05 13:00:00	MSFT	Stock	28.01	28.15	28.0	28.08	5275648.0
2004-01-05 14:00:00	MSFT	Stock	28.08	28.1	28.04	28.07	5383683.0
2004-01-05 15:00:00	MSFT	Stock	28.08	28.15	28.05	28.13	9820348.0
2004-01-05 16:00:00	MSFT	Stock	28.12	28.2	27.9874	28.14	1942234.0
2004-01-05 17:00:00	MSFT	Stock	28.14	28.18	28.11	28.15	63497.0
2004-01-05 18:00:00	MSFT	Stock	28.15	28.18	28.15	28.18	1892.0
2004-01-05 08:00:00	NVDA	Stock	0.195	0.195	0.195	0.195	240000.0
2004-01-05 09:00:00	NVDA	Stock	0.1948	0.1964	0.1935	0.1956	66228480.0
2004-01-05 10:00:00	NVDA	Stock	0.1956	0.1969	0.1952	0.1965	135862320.0
2004-01-05 11:00:00	NVDA	Stock	0.1965	0.1967	0.1949	0.1962	70292640.0
2004-01-05 12:00:00	NVDA	Stock	0.1962	0.1966	0.1957	0.1966	29557800.0
2004-01-05 13:00:00	NVDA	Stock	0.1966	0.1996	0.1964	0.1996	91206480.0
2004-01-05 14:00:00	NVDA	Stock	0.1996	0.1999	0.1984	0.1987	46635360.0
2004-01-05 15:00:00	NVDA	Stock	0.1987	0.1998	0.1982	0.1982	90481440.0
2004-01-05 16:00:00	NVDA	Stock	0.1982	0.199	0.1981	0.1986	7544520.0
2004-01-05 17:00:00	NVDA	Stock	0.1986	0.1987	0.1986	0.1987	1960200.0
2004-01-05 18:00:00	NVDA	Stock	0.1987	0.1987	0.1986	0.1987	156000.0
2004-01-05 08:00:00	AMZN	Stock	2.5875	2.6	2.5875	2.595	46000.0
2004-01-05 09:00:00	AMZN	Stock	2.595	2.611	2.58	2.589	27363960.0
2004-01-05 10:00:00	AMZN	Stock	2.589	2.601	2.5765	2.583	47204460.0
2004-01-05 11:00:00	AMZN	Stock	2.5825	2.5905	2.5685	2.5895	28345020.0
2004-01-05 12:00:00	AMZN	Stock	2.5885	2.6	2.58	2.585	19179820.0
2004-01-05 13:00:00	AMZN	Stock	2.585	2.6175	2.5845	2.611	20456480.0
2004-01-05 14:00:00	AMZN	Stock	2.6111	2.6567	2.6078	2.647	31254920.0
2004-01-05 15:00:00	AMZN	Stock	2.647	2.68	2.643	2.661	43313040.0
2004-01-05 16:00:00	AMZN	Stock	2.6635	2.6675	2.59	2.6635	2072380.0
2004-01-05 17:00:00	AMZN	Stock	2.6635	2.665	2.6625	2.665	37940.0
2004-01-05 18:00:00	AMZN	Stock	2.661	2.661	2.661	2.661	10000.0
2004-01-05 09:00:00	CL	Stock	24.91	24.95	24.825	24.875	757000.0
2004-01-05 10:00:00	CL	Stock	24.875	24.92	24.85	24.9	1873200.0
2004-01-05 11:00:00	CL	Stock	24.9	24.9745	24.865	24.93	1171400.0
2004-01-05 12:00:00	CL	Stock	24.94	24.995	24.92	24.98	1274800.0
2004-01-05 13:00:00	CL	Stock	24.98	25.035	24.945	24.965	769600.0
2004-01-05 14:00:00	CL	Stock	24.965	25.015	24.925	24.98	1410400.0

> showing 50 of 24,228 rows — these rows as CSV

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