PREVIEW / stock_1hour / 2005-03-31

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-31.parquet
  size:    565 KB
  rows:    26,608
  symbols: 1,957

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
2005-03-31 08:00:00	AAPL	Stock	1.5286	1.5346	1.5179	1.5239	2498776.0
2005-03-31 09:00:00	AAPL	Stock	1.5236	1.5236	1.4964	1.5086	140470820.0
2005-03-31 10:00:00	AAPL	Stock	1.5086	1.5104	1.5	1.5043	79032576.0
2005-03-31 11:00:00	AAPL	Stock	1.5039	1.5093	1.4971	1.5011	63004900.0
2005-03-31 12:00:00	AAPL	Stock	1.5011	1.5014	1.4854	1.4879	86446724.0
2005-03-31 13:00:00	AAPL	Stock	1.4875	1.4971	1.4857	1.4939	55815032.0
2005-03-31 14:00:00	AAPL	Stock	1.4936	1.5079	1.4911	1.5029	84074928.0
2005-03-31 15:00:00	AAPL	Stock	1.5029	1.5054	1.4882	1.4886	78817620.0
2005-03-31 16:00:00	AAPL	Stock	1.4882	1.5001	1.4882	1.4893	4591608.0
2005-03-31 17:00:00	AAPL	Stock	1.4889	1.4911	1.4882	1.4893	408212.0
2005-03-31 18:00:00	AAPL	Stock	1.4889	1.4925	1.4886	1.4886	149072.0
2005-03-31 08:00:00	MSFT	Stock	24.26	24.27	24.23	24.26	131199.0
2005-03-31 09:00:00	MSFT	Stock	24.25	24.3	24.13	24.3	8512527.0
2005-03-31 10:00:00	MSFT	Stock	24.3	24.31	24.139	24.16	9498007.0
2005-03-31 11:00:00	MSFT	Stock	24.16	24.29	24.15	24.22	6165877.0
2005-03-31 12:00:00	MSFT	Stock	24.22	24.22	24.12	24.17	6737346.0
2005-03-31 13:00:00	MSFT	Stock	24.16	24.25	24.15	24.21	5070336.0
2005-03-31 14:00:00	MSFT	Stock	24.21	24.31	24.19	24.28	10050921.0
2005-03-31 15:00:00	MSFT	Stock	24.28	24.3	24.14	24.15	11014611.0
2005-03-31 16:00:00	MSFT	Stock	24.15	24.17	24.12	24.12	899197.0
2005-03-31 17:00:00	MSFT	Stock	24.14	24.17	24.12	24.13	31090.0
2005-03-31 18:00:00	MSFT	Stock	24.13	24.16	24.13	24.16	8400.0
2005-03-31 09:00:00	NVDA	Stock	0.202	0.2027	0.2001	0.2012	59180880.0
2005-03-31 10:00:00	NVDA	Stock	0.2012	0.2012	0.1989	0.1995	71376240.0
2005-03-31 11:00:00	NVDA	Stock	0.1995	0.2002	0.1992	0.1999	38504160.0
2005-03-31 12:00:00	NVDA	Stock	0.2	0.2	0.1971	0.1992	48987840.0
2005-03-31 13:00:00	NVDA	Stock	0.1992	0.1997	0.1987	0.1991	33662400.0
2005-03-31 14:00:00	NVDA	Stock	0.1991	0.1997	0.1982	0.1987	70644840.0
2005-03-31 15:00:00	NVDA	Stock	0.1987	0.1992	0.1971	0.198	142100400.0
2005-03-31 16:00:00	NVDA	Stock	0.1977	0.1982	0.1977	0.198	4573680.0
2005-03-31 17:00:00	NVDA	Stock	0.198	0.1982	0.1972	0.1972	316800.0
2005-03-31 08:00:00	AMZN	Stock	1.7175	1.7175	1.715	1.715	16000.0
2005-03-31 09:00:00	AMZN	Stock	1.715	1.725	1.7085	1.716	8798660.0
2005-03-31 10:00:00	AMZN	Stock	1.7155	1.716	1.7035	1.705	12472780.0
2005-03-31 11:00:00	AMZN	Stock	1.705	1.709	1.7025	1.7055	7482600.0
2005-03-31 12:00:00	AMZN	Stock	1.7055	1.7085	1.7	1.7084	7403120.0
2005-03-31 13:00:00	AMZN	Stock	1.7075	1.724	1.7075	1.7216	7110880.0
2005-03-31 14:00:00	AMZN	Stock	1.722	1.7275	1.7185	1.721	7683300.0
2005-03-31 15:00:00	AMZN	Stock	1.7205	1.725	1.713	1.713	13440060.0
2005-03-31 16:00:00	AMZN	Stock	1.7145	1.7175	1.7125	1.7125	694260.0
2005-03-31 17:00:00	AMZN	Stock	1.7135	1.7135	1.7118	1.7125	350000.0
2005-03-31 09:00:00	CL	Stock	26.225	26.25	26.025	26.15	297000.0
2005-03-31 10:00:00	CL	Stock	26.15	26.15	26.01	26.06	322800.0
2005-03-31 11:00:00	CL	Stock	26.05	26.145	26.045	26.11	263600.0
2005-03-31 12:00:00	CL	Stock	26.11	26.135	26.045	26.085	233400.0
2005-03-31 13:00:00	CL	Stock	26.085	26.1	26.01	26.05	182400.0
2005-03-31 14:00:00	CL	Stock	26.045	26.125	26.01	26.08	247000.0
2005-03-31 15:00:00	CL	Stock	26.085	26.14	26.035	26.075	529600.0
2005-03-31 16:00:00	CL	Stock	26.085	26.09	26.085	26.09	5400.0
2005-03-31 17:00:00	CL	Stock	26.085	26.085	26.085	26.085	200.0

> showing 50 of 26,608 rows — these rows as CSV

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