PREVIEW / stock_1hour / 2004-06-02

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-02.parquet
  size:    488 KB
  rows:    23,028
  symbols: 1,776

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-06-02 09:00:00	AAPL	Stock	0.5011	0.5018	0.4964	0.5	25686472.0
2004-06-02 10:00:00	AAPL	Stock	0.5002	0.5043	0.4984	0.503	28913696.0
2004-06-02 11:00:00	AAPL	Stock	0.503	0.5038	0.5013	0.503	17986416.0
2004-06-02 12:00:00	AAPL	Stock	0.503	0.5086	0.5027	0.5071	20878200.0
2004-06-02 13:00:00	AAPL	Stock	0.5071	0.5102	0.5064	0.5096	20216392.0
2004-06-02 14:00:00	AAPL	Stock	0.5098	0.5177	0.5086	0.5175	72610832.0
2004-06-02 15:00:00	AAPL	Stock	0.5175	0.5209	0.5143	0.5159	119011760.0
2004-06-02 16:00:00	AAPL	Stock	0.5159	0.5179	0.5143	0.5154	4529392.0
2004-06-02 17:00:00	AAPL	Stock	0.5129	0.5129	0.5129	0.5129	5600.0
2004-06-02 18:00:00	AAPL	Stock	0.5143	0.5143	0.5143	0.5143	5600.0
2004-06-02 08:00:00	MSFT	Stock	26.16	26.25	26.11	26.2	52780.0
2004-06-02 09:00:00	MSFT	Stock	26.18	26.22	26.1	26.14	4786471.0
2004-06-02 10:00:00	MSFT	Stock	26.15	26.2	26.01	26.1	9340924.0
2004-06-02 11:00:00	MSFT	Stock	26.09	26.13	26.04	26.08	7080229.0
2004-06-02 12:00:00	MSFT	Stock	26.07	26.14	26.0499	26.08	3031000.0
2004-06-02 13:00:00	MSFT	Stock	26.08	26.18	26.07	26.16	5922343.0
2004-06-02 14:00:00	MSFT	Stock	26.17	26.28	26.0999	26.2	10020291.0
2004-06-02 15:00:00	MSFT	Stock	26.21	26.22	26.09	26.14	11356148.0
2004-06-02 16:00:00	MSFT	Stock	26.14	26.18	26.076	26.13	1458518.0
2004-06-02 17:00:00	MSFT	Stock	26.17	26.17	26.13	26.13	7400.0
2004-06-02 18:00:00	MSFT	Stock	26.13	26.13	26.13	26.13	900.0
2004-06-02 08:00:00	NVDA	Stock	0.1962	0.2027	0.1962	0.2013	1600320.0
2004-06-02 09:00:00	NVDA	Stock	0.2017	0.2022	0.1952	0.1992	135651600.0
2004-06-02 10:00:00	NVDA	Stock	0.1993	0.1993	0.1944	0.1971	147620280.0
2004-06-02 11:00:00	NVDA	Stock	0.1971	0.1976	0.1958	0.1959	56588280.0
2004-06-02 12:00:00	NVDA	Stock	0.1958	0.1966	0.1939	0.1942	83795880.0
2004-06-02 13:00:00	NVDA	Stock	0.1942	0.1955	0.1937	0.1947	46360080.0
2004-06-02 14:00:00	NVDA	Stock	0.1948	0.1967	0.1942	0.1957	62259960.0
2004-06-02 15:00:00	NVDA	Stock	0.1958	0.1958	0.1936	0.1938	95305200.0
2004-06-02 16:00:00	NVDA	Stock	0.1938	0.1954	0.1933	0.1954	6205920.0
2004-06-02 08:00:00	AMZN	Stock	2.523	2.5235	2.5155	2.5235	249000.0
2004-06-02 09:00:00	AMZN	Stock	2.5235	2.5325	2.4915	2.5	39580440.0
2004-06-02 10:00:00	AMZN	Stock	2.5005	2.5115	2.4885	2.502	35528720.0
2004-06-02 11:00:00	AMZN	Stock	2.5015	2.517	2.496	2.509	26384860.0
2004-06-02 12:00:00	AMZN	Stock	2.5095	2.527	2.5035	2.5205	23483580.0
2004-06-02 13:00:00	AMZN	Stock	2.521	2.5425	2.521	2.5405	26583400.0
2004-06-02 14:00:00	AMZN	Stock	2.5405	2.5605	2.532	2.5445	36909660.0
2004-06-02 15:00:00	AMZN	Stock	2.545	2.546	2.5075	2.51	50879820.0
2004-06-02 16:00:00	AMZN	Stock	2.51	2.52	2.509	2.5175	3378000.0
2004-06-02 17:00:00	AMZN	Stock	2.512	2.5155	2.512	2.512	31620.0
2004-06-02 18:00:00	AMZN	Stock	2.515	2.5155	2.515	2.5155	18000.0
2004-06-02 09:00:00	CL	Stock	28.895	28.985	28.835	28.87	221600.0
2004-06-02 10:00:00	CL	Stock	28.845	28.87	28.67	28.67	209400.0
2004-06-02 11:00:00	CL	Stock	28.64	28.67	28.545	28.615	353200.0
2004-06-02 12:00:00	CL	Stock	28.62	28.675	28.59	28.595	210000.0
2004-06-02 13:00:00	CL	Stock	28.59	28.7	28.585	28.65	232000.0
2004-06-02 14:00:00	CL	Stock	28.65	28.775	28.65	28.705	434800.0
2004-06-02 15:00:00	CL	Stock	28.7	28.75	28.675	28.7	470400.0
2004-06-02 16:00:00	CL	Stock	28.71	28.71	28.71	28.71	32400.0

> showing 49 of 23,028 rows — these rows as CSV

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