PREVIEW / stock_1hour / 2003-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-06-20.parquet
  size:    484 KB
  rows:    22,959
  symbols: 1,586

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
2003-06-20 08:00:00	AAPL	Stock	0.3482	0.3482	0.3461	0.3482	58688.0
2003-06-20 09:00:00	AAPL	Stock	0.3482	0.3488	0.3438	0.3461	48400240.0
2003-06-20 10:00:00	AAPL	Stock	0.3459	0.3496	0.3438	0.3438	48586440.0
2003-06-20 11:00:00	AAPL	Stock	0.3438	0.3495	0.3436	0.3459	53661160.0
2003-06-20 12:00:00	AAPL	Stock	0.3461	0.3482	0.3458	0.3471	17555776.0
2003-06-20 13:00:00	AAPL	Stock	0.3473	0.3473	0.3375	0.3405	41605984.0
2003-06-20 14:00:00	AAPL	Stock	0.3405	0.3421	0.3396	0.3418	21836080.0
2003-06-20 15:00:00	AAPL	Stock	0.3416	0.3457	0.34	0.3429	45916976.0
2003-06-20 16:00:00	AAPL	Stock	0.3421	0.3436	0.3418	0.3429	16106440.0
2003-06-20 17:00:00	AAPL	Stock	0.3429	0.3429	0.3429	0.3429	106400.0
2003-06-20 18:00:00	AAPL	Stock	0.3429	0.3432	0.3429	0.3429	1663200.0
2003-06-20 08:00:00	MSFT	Stock	26.15	26.24	26.07	26.24	37136.0
2003-06-20 09:00:00	MSFT	Stock	26.24	26.38	26.01	26.08	15657649.0
2003-06-20 10:00:00	MSFT	Stock	26.079	26.35	26.03	26.27	13848165.0
2003-06-20 11:00:00	MSFT	Stock	26.28	26.36	26.209	26.23	6506979.0
2003-06-20 12:00:00	MSFT	Stock	26.23	26.29	26.2	26.2121	3683575.0
2003-06-20 13:00:00	MSFT	Stock	26.21	26.22	26.01	26.1	7797845.0
2003-06-20 14:00:00	MSFT	Stock	26.1	26.2	26.1	26.181	3880076.0
2003-06-20 15:00:00	MSFT	Stock	26.19	26.32	26.05	26.231	12137844.0
2003-06-20 16:00:00	MSFT	Stock	26.24	26.34	26.01	26.22	2681227.0
2003-06-20 17:00:00	MSFT	Stock	26.22	26.32	25.8	25.8	219800.0
2003-06-20 18:00:00	MSFT	Stock	26.31	26.325	26.16	26.22	1300850.0
2003-06-20 08:00:00	NVDA	Stock	0.1992	0.1992	0.1986	0.199	2562000.0
2003-06-20 09:00:00	NVDA	Stock	0.199	0.2017	0.1942	0.1954	178770480.0
2003-06-20 10:00:00	NVDA	Stock	0.1953	0.1992	0.1943	0.1976	176886120.0
2003-06-20 11:00:00	NVDA	Stock	0.1976	0.2012	0.1974	0.1987	83930880.0
2003-06-20 12:00:00	NVDA	Stock	0.1987	0.2007	0.1978	0.1993	51935160.0
2003-06-20 13:00:00	NVDA	Stock	0.1994	0.1997	0.1968	0.198	58516800.0
2003-06-20 14:00:00	NVDA	Stock	0.198	0.1998	0.1977	0.1997	54181200.0
2003-06-20 15:00:00	NVDA	Stock	0.1997	0.1997	0.1967	0.198	129300720.0
2003-06-20 16:00:00	NVDA	Stock	0.1968	0.198	0.196	0.1961	39792120.0
2003-06-20 17:00:00	NVDA	Stock	0.1977	0.1979	0.196	0.1969	2220000.0
2003-06-20 18:00:00	NVDA	Stock	0.1968	0.1985	0.1967	0.1983	10716000.0
2003-06-20 08:00:00	AMZN	Stock	1.776	1.7925	1.775	1.79	108000.0
2003-06-20 09:00:00	AMZN	Stock	1.775	1.7975	1.7515	1.769	20972820.0
2003-06-20 10:00:00	AMZN	Stock	1.767	1.7715	1.742	1.748	34176060.0
2003-06-20 11:00:00	AMZN	Stock	1.748	1.7625	1.748	1.756	17230220.0
2003-06-20 12:00:00	AMZN	Stock	1.757	1.772	1.756	1.7625	10448420.0
2003-06-20 13:00:00	AMZN	Stock	1.7625	1.7675	1.7555	1.7615	8222560.0
2003-06-20 14:00:00	AMZN	Stock	1.761	1.7655	1.7605	1.764	12128000.0
2003-06-20 15:00:00	AMZN	Stock	1.764	1.766	1.752	1.7555	19802580.0
2003-06-20 16:00:00	AMZN	Stock	1.753	1.765	1.75	1.7525	2810780.0
2003-06-20 17:00:00	AMZN	Stock	1.7515	1.7582	1.7515	1.753	56000.0
2003-06-20 18:00:00	AMZN	Stock	1.7585	1.7585	1.7585	1.7585	124000.0
2003-06-20 09:00:00	CL	Stock	30.0	30.0995	29.875	29.9	1203200.0
2003-06-20 10:00:00	CL	Stock	29.915	30.06	29.9	30.05	418200.0
2003-06-20 11:00:00	CL	Stock	30.05	30.09	29.93	29.95	161400.0
2003-06-20 12:00:00	CL	Stock	29.9695	30.025	29.925	29.95	165400.0
2003-06-20 13:00:00	CL	Stock	29.955	29.96	29.775	29.8	382400.0
2003-06-20 14:00:00	CL	Stock	29.8	29.875	29.8	29.845	250400.0

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

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