PREVIEW / stock_1hour / 2008-12-23

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-23.parquet
  size:    812 KB
  rows:    40,194
  symbols: 3,372

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
2008-12-23 06:00:00	AAPL	Stock	3.0754	3.0754	3.0754	3.0754	36820.0
2008-12-23 08:00:00	AAPL	Stock	3.0768	3.0832	3.0643	3.0814	915096.0
2008-12-23 09:00:00	AAPL	Stock	3.0836	3.1182	3.0714	3.1174	82458488.0
2008-12-23 10:00:00	AAPL	Stock	3.1164	3.1382	3.0896	3.1236	124034428.0
2008-12-23 11:00:00	AAPL	Stock	3.1232	3.1311	3.0861	3.0889	92409800.0
2008-12-23 12:00:00	AAPL	Stock	3.0889	3.0925	3.0693	3.085	69081320.0
2008-12-23 13:00:00	AAPL	Stock	3.0854	3.0982	3.0761	3.0979	53184348.0
2008-12-23 14:00:00	AAPL	Stock	3.0971	3.0986	3.0679	3.0768	79831752.0
2008-12-23 15:00:00	AAPL	Stock	3.0768	3.1025	3.0729	3.0861	117996928.0
2008-12-23 16:00:00	AAPL	Stock	3.0861	3.096	3.0743	3.0771	9288972.0
2008-12-23 17:00:00	AAPL	Stock	3.0771	3.0818	3.0736	3.0768	394940.0
2008-12-23 18:00:00	AAPL	Stock	3.0804	3.085	3.0786	3.085	6526884.0
2008-12-23 19:00:00	AAPL	Stock	3.0811	3.0846	3.0793	3.0846	107520.0
2008-12-23 08:00:00	MSFT	Stock	19.29	19.3	19.21	19.3	7613.0
2008-12-23 09:00:00	MSFT	Stock	19.3	19.48	19.19	19.46	4340538.0
2008-12-23 10:00:00	MSFT	Stock	19.45	19.57	19.3	19.34	7669260.0
2008-12-23 11:00:00	MSFT	Stock	19.35	19.4	19.17	19.19	5486680.0
2008-12-23 12:00:00	MSFT	Stock	19.188	19.298	19.06	19.17	4987664.0
2008-12-23 13:00:00	MSFT	Stock	19.16	19.21	19.08	19.19	3857305.0
2008-12-23 14:00:00	MSFT	Stock	19.18	19.19	19.01	19.13	7908204.0
2008-12-23 15:00:00	MSFT	Stock	19.13	19.33	19.1	19.29	10794576.0
2008-12-23 16:00:00	MSFT	Stock	19.28	19.33	19.166	19.3	2036138.0
2008-12-23 17:00:00	MSFT	Stock	19.3	19.3	19.24	19.29	8401.0
2008-12-23 18:00:00	MSFT	Stock	19.29	19.29	19.28	19.28	18481.0
2008-12-23 19:00:00	MSFT	Stock	19.3	19.31	19.3	19.3	4650.0
2008-12-23 08:00:00	NVDA	Stock	0.2	0.2	0.2	0.2	4000.0
2008-12-23 09:00:00	NVDA	Stock	0.2025	0.2033	0.198	0.2027	41559880.0
2008-12-23 10:00:00	NVDA	Stock	0.2027	0.2058	0.2013	0.2043	56342440.0
2008-12-23 11:00:00	NVDA	Stock	0.2043	0.206	0.2033	0.2038	40953840.0
2008-12-23 12:00:00	NVDA	Stock	0.2039	0.2047	0.197	0.2005	63201240.0
2008-12-23 13:00:00	NVDA	Stock	0.2002	0.2005	0.1958	0.199	53730680.0
2008-12-23 14:00:00	NVDA	Stock	0.199	0.1992	0.1948	0.1963	55355680.0
2008-12-23 15:00:00	NVDA	Stock	0.1962	0.1988	0.1955	0.1978	57350000.0
2008-12-23 16:00:00	NVDA	Stock	0.1978	0.1978	0.1948	0.1965	271520.0
2008-12-23 17:00:00	NVDA	Stock	0.1962	0.1962	0.195	0.1958	122920.0
2008-12-23 18:00:00	NVDA	Stock	0.1952	0.1952	0.1952	0.1952	86400.0
2008-12-23 19:00:00	NVDA	Stock	0.1952	0.196	0.1952	0.196	59680.0
2008-12-23 08:00:00	AMZN	Stock	2.5135	2.5135	2.5135	2.5135	6000.0
2008-12-23 09:00:00	AMZN	Stock	2.5145	2.5595	2.5055	2.5535	18511380.0
2008-12-23 10:00:00	AMZN	Stock	2.554	2.5725	2.5385	2.5533	18498820.0
2008-12-23 11:00:00	AMZN	Stock	2.5535	2.5775	2.546	2.548	14209660.0
2008-12-23 12:00:00	AMZN	Stock	2.5485	2.5635	2.5465	2.5585	10794540.0
2008-12-23 13:00:00	AMZN	Stock	2.5585	2.5805	2.557	2.5802	12372860.0
2008-12-23 14:00:00	AMZN	Stock	2.5802	2.5802	2.5275	2.533	15029440.0
2008-12-23 15:00:00	AMZN	Stock	2.534	2.5645	2.5225	2.5555	23659300.0
2008-12-23 16:00:00	AMZN	Stock	2.554	2.575	2.552	2.573	178600.0
2008-12-23 17:00:00	AMZN	Stock	2.57	2.588	2.57	2.575	69620.0
2008-12-23 18:00:00	AMZN	Stock	2.568	2.57	2.568	2.57	17520.0
2008-12-23 19:00:00	AMZN	Stock	2.5715	2.5715	2.5625	2.5625	20000.0
2008-12-23 08:00:00	TLT	Stock	120.75	120.75	119.97	119.97	6200.0

> showing 50 of 40,194 rows — these rows as CSV

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