PREVIEW / stock_1hour / 2004-01-02

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-02.parquet
  size:    490 KB
  rows:    22,420
  symbols: 1,707

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-02 08:00:00	AAPL	Stock	0.3821	0.3821	0.3821	0.3821	56000.0
2004-01-02 09:00:00	AAPL	Stock	0.3816	0.3884	0.3816	0.3825	33139456.0
2004-01-02 10:00:00	AAPL	Stock	0.3823	0.3846	0.382	0.3836	25768848.0
2004-01-02 11:00:00	AAPL	Stock	0.3832	0.3836	0.382	0.3825	11342016.0
2004-01-02 12:00:00	AAPL	Stock	0.3825	0.3836	0.3819	0.3823	10577336.0
2004-01-02 13:00:00	AAPL	Stock	0.3825	0.3839	0.382	0.3823	6203736.0
2004-01-02 14:00:00	AAPL	Stock	0.3825	0.3827	0.3796	0.3804	17574648.0
2004-01-02 15:00:00	AAPL	Stock	0.3802	0.3814	0.3782	0.3782	24730832.0
2004-01-02 16:00:00	AAPL	Stock	0.3796	0.3802	0.3782	0.3799	2036552.0
2004-01-02 17:00:00	AAPL	Stock	0.3791	0.3791	0.3791	0.3791	28000.0
2004-01-02 18:00:00	AAPL	Stock	0.3793	0.3793	0.3793	0.3793	28000.0
2004-01-02 08:00:00	MSFT	Stock	27.5	27.59	27.5	27.58	57200.0
2004-01-02 09:00:00	MSFT	Stock	27.58	27.61	27.52	27.59	5443914.0
2004-01-02 10:00:00	MSFT	Stock	27.59	27.75	27.55	27.75	8608866.0
2004-01-02 11:00:00	MSFT	Stock	27.75	27.77	27.68	27.731	5661015.0
2004-01-02 12:00:00	MSFT	Stock	27.74	27.75	27.62	27.71	4734367.0
2004-01-02 13:00:00	MSFT	Stock	27.71	27.72	27.66	27.67	2910641.0
2004-01-02 14:00:00	MSFT	Stock	27.68	27.69	27.42	27.45	6808697.0
2004-01-02 15:00:00	MSFT	Stock	27.45	27.5	27.33	27.42	6869259.0
2004-01-02 16:00:00	MSFT	Stock	27.41	27.565	27.38	27.4531	814914.0
2004-01-02 17:00:00	MSFT	Stock	27.51	27.51	27.42	27.49	260205.0
2004-01-02 18:00:00	MSFT	Stock	27.48	27.48	27.48	27.48	400.0
2004-01-02 08:00:00	NVDA	Stock	0.1937	0.1937	0.1937	0.1937	60000.0
2004-01-02 09:00:00	NVDA	Stock	0.1948	0.1983	0.1948	0.1968	63813000.0
2004-01-02 10:00:00	NVDA	Stock	0.1968	0.1991	0.1964	0.1979	82489200.0
2004-01-02 11:00:00	NVDA	Stock	0.1979	0.1987	0.1952	0.1953	71329920.0
2004-01-02 12:00:00	NVDA	Stock	0.1953	0.1958	0.1941	0.1956	57211320.0
2004-01-02 13:00:00	NVDA	Stock	0.1956	0.1958	0.1947	0.1956	18338040.0
2004-01-02 14:00:00	NVDA	Stock	0.1956	0.1959	0.193	0.1932	39634800.0
2004-01-02 15:00:00	NVDA	Stock	0.1932	0.1948	0.1924	0.193	69485760.0
2004-01-02 16:00:00	NVDA	Stock	0.1923	0.1937	0.1923	0.1924	3646920.0
2004-01-02 17:00:00	NVDA	Stock	0.1924	0.1934	0.1924	0.1934	252000.0
2004-01-02 08:00:00	AMZN	Stock	2.632	2.65	2.631	2.65	210000.0
2004-01-02 09:00:00	AMZN	Stock	2.65	2.6565	2.6285	2.6445	12929180.0
2004-01-02 10:00:00	AMZN	Stock	2.6445	2.6501	2.6252	2.6355	18893560.0
2004-01-02 11:00:00	AMZN	Stock	2.636	2.638	2.5885	2.6	25755180.0
2004-01-02 12:00:00	AMZN	Stock	2.601	2.607	2.5715	2.5885	24506460.0
2004-01-02 13:00:00	AMZN	Stock	2.5895	2.608	2.585	2.6069	9897340.0
2004-01-02 14:00:00	AMZN	Stock	2.6069	2.608	2.5775	2.583	13548920.0
2004-01-02 15:00:00	AMZN	Stock	2.583	2.599	2.579	2.5905	21858220.0
2004-01-02 16:00:00	AMZN	Stock	2.5865	2.5955	2.5865	2.5889	1109860.0
2004-01-02 17:00:00	AMZN	Stock	2.5875	2.5945	2.587	2.5875	180000.0
2004-01-02 18:00:00	AMZN	Stock	2.587	2.587	2.587	2.587	12000.0
2004-01-02 09:00:00	CL	Stock	24.975	25.05	24.93	25.03	394400.0
2004-01-02 10:00:00	CL	Stock	25.005	25.05	24.99	25.04	880000.0
2004-01-02 11:00:00	CL	Stock	25.03	25.045	24.975	24.985	691000.0
2004-01-02 12:00:00	CL	Stock	24.985	25.02	24.975	24.985	243800.0
2004-01-02 13:00:00	CL	Stock	24.975	24.985	24.835	24.865	452400.0
2004-01-02 14:00:00	CL	Stock	24.865	24.915	24.735	24.75	413600.0
2004-01-02 15:00:00	CL	Stock	24.745	24.805	24.71	24.805	590200.0

> showing 50 of 22,420 rows — these rows as CSV

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