PREVIEW / stock_1hour / 2005-04-05

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-05.parquet
  size:    529 KB
  rows:    25,157
  symbols: 1,954

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-04-05 08:00:00	AAPL	Stock	1.4661	1.4821	1.4661	1.4732	1062964.0
2005-04-05 09:00:00	AAPL	Stock	1.4736	1.5079	1.4675	1.5054	114152164.0
2005-04-05 10:00:00	AAPL	Stock	1.505	1.5054	1.4929	1.5043	113014748.0
2005-04-05 11:00:00	AAPL	Stock	1.5046	1.5086	1.4936	1.5014	79098628.0
2005-04-05 12:00:00	AAPL	Stock	1.5018	1.5082	1.4964	1.5007	46594772.0
2005-04-05 13:00:00	AAPL	Stock	1.501	1.5054	1.4964	1.5025	49963452.0
2005-04-05 14:00:00	AAPL	Stock	1.5021	1.5043	1.4886	1.4907	81414816.0
2005-04-05 15:00:00	AAPL	Stock	1.4907	1.4964	1.4886	1.4957	62544104.0
2005-04-05 16:00:00	AAPL	Stock	1.4952	1.4967	1.4911	1.4911	2751560.0
2005-04-05 17:00:00	AAPL	Stock	1.4943	1.4961	1.4943	1.4961	368172.0
2005-04-05 18:00:00	AAPL	Stock	1.495	1.4954	1.4943	1.4943	21840.0
2005-04-05 08:00:00	MSFT	Stock	24.2	24.25	24.2	24.25	14673.0
2005-04-05 09:00:00	MSFT	Stock	24.24	24.28	24.12	24.26	8494737.0
2005-04-05 10:00:00	MSFT	Stock	24.26	24.5	24.2	24.39	14900174.0
2005-04-05 11:00:00	MSFT	Stock	24.39	24.48	24.3	24.47	11918704.0
2005-04-05 12:00:00	MSFT	Stock	24.47	24.5	24.41	24.43	5579433.0
2005-04-05 13:00:00	MSFT	Stock	24.42	24.46	24.36	24.42	4782801.0
2005-04-05 14:00:00	MSFT	Stock	24.43	24.48	24.33	24.44	9552820.0
2005-04-05 15:00:00	MSFT	Stock	24.45	24.5	24.42	24.46	10182011.0
2005-04-05 16:00:00	MSFT	Stock	24.47	24.48	24.42	24.44	5571455.0
2005-04-05 17:00:00	MSFT	Stock	24.44	24.5	24.42	24.47	47425.0
2005-04-05 18:00:00	MSFT	Stock	24.45	24.45	24.45	24.45	100.0
2005-04-05 09:00:00	NVDA	Stock	0.1937	0.1991	0.1937	0.1982	58613280.0
2005-04-05 10:00:00	NVDA	Stock	0.1982	0.1984	0.1945	0.1948	70021440.0
2005-04-05 11:00:00	NVDA	Stock	0.1948	0.195	0.1927	0.1929	31716480.0
2005-04-05 12:00:00	NVDA	Stock	0.1929	0.1932	0.1916	0.1922	53763120.0
2005-04-05 13:00:00	NVDA	Stock	0.1922	0.193	0.192	0.1927	60090000.0
2005-04-05 14:00:00	NVDA	Stock	0.1927	0.1933	0.1903	0.1908	77238240.0
2005-04-05 15:00:00	NVDA	Stock	0.1909	0.1922	0.1909	0.1915	68387520.0
2005-04-05 16:00:00	NVDA	Stock	0.1917	0.1935	0.1908	0.1908	1594320.0
2005-04-05 17:00:00	NVDA	Stock	0.1912	0.1912	0.1912	0.1912	100440.0
2005-04-05 08:00:00	AMZN	Stock	1.75	1.75	1.75	1.75	14000.0
2005-04-05 09:00:00	AMZN	Stock	1.755	1.764	1.7535	1.7595	16198680.0
2005-04-05 10:00:00	AMZN	Stock	1.7595	1.761	1.752	1.753	14090520.0
2005-04-05 11:00:00	AMZN	Stock	1.753	1.7625	1.7495	1.758	13083800.0
2005-04-05 12:00:00	AMZN	Stock	1.758	1.7625	1.756	1.7605	5518800.0
2005-04-05 13:00:00	AMZN	Stock	1.7605	1.767	1.7595	1.764	9655280.0
2005-04-05 14:00:00	AMZN	Stock	1.764	1.767	1.7615	1.7626	19149460.0
2005-04-05 15:00:00	AMZN	Stock	1.763	1.767	1.762	1.765	18590380.0
2005-04-05 16:00:00	AMZN	Stock	1.764	1.7655	1.7625	1.764	1520300.0
2005-04-05 17:00:00	AMZN	Stock	1.7655	1.7655	1.762	1.764	262000.0
2005-04-05 18:00:00	AMZN	Stock	1.7655	1.7655	1.7655	1.7655	44000.0
2005-04-05 09:00:00	CL	Stock	26.01	26.19	26.01	26.13	348000.0
2005-04-05 10:00:00	CL	Stock	26.115	26.245	26.115	26.18	509400.0
2005-04-05 11:00:00	CL	Stock	26.17	26.17	26.055	26.08	400200.0
2005-04-05 12:00:00	CL	Stock	26.075	26.15	26.055	26.125	290800.0
2005-04-05 13:00:00	CL	Stock	26.125	26.2	26.1	26.16	298600.0
2005-04-05 14:00:00	CL	Stock	26.16	26.205	26.02	26.095	402000.0
2005-04-05 15:00:00	CL	Stock	26.095	26.19	26.085	26.16	479600.0
2005-04-05 16:00:00	CL	Stock	26.155	26.155	26.135	26.135	800.0

> showing 50 of 25,157 rows — these rows as CSV

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