PREVIEW / stock_1hour / 2004-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-04-21.parquet
  size:    507 KB
  rows:    23,726
  symbols: 1,765

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-04-21 09:00:00	AAPL	Stock	0.4943	0.5013	0.4916	0.5011	42987840.0
2004-04-21 10:00:00	AAPL	Stock	0.5011	0.5021	0.4888	0.4909	54384512.0
2004-04-21 11:00:00	AAPL	Stock	0.4907	0.4979	0.4898	0.4971	28513352.0
2004-04-21 12:00:00	AAPL	Stock	0.4968	0.4975	0.4913	0.4938	25189248.0
2004-04-21 13:00:00	AAPL	Stock	0.4938	0.4964	0.4934	0.4946	22818040.0
2004-04-21 14:00:00	AAPL	Stock	0.4948	0.4989	0.4945	0.4946	40744256.0
2004-04-21 15:00:00	AAPL	Stock	0.4946	0.4977	0.4939	0.4968	63511000.0
2004-04-21 16:00:00	AAPL	Stock	0.4957	0.497	0.4884	0.4925	12672800.0
2004-04-21 17:00:00	AAPL	Stock	0.4961	0.4995	0.4961	0.4995	179200.0
2004-04-21 18:00:00	AAPL	Stock	0.4964	0.4964	0.4952	0.4952	44800.0
2004-04-21 08:00:00	MSFT	Stock	25.46	25.5	25.35	25.5	23318.0
2004-04-21 09:00:00	MSFT	Stock	25.48	25.48	25.2	25.32	5342678.0
2004-04-21 10:00:00	MSFT	Stock	25.329	25.43	25.21	25.3	8657700.0
2004-04-21 11:00:00	MSFT	Stock	25.3	25.39	25.2	25.37	5846534.0
2004-04-21 12:00:00	MSFT	Stock	25.37	25.41	25.28	25.33	5007825.0
2004-04-21 13:00:00	MSFT	Stock	25.32	25.41	25.3	25.3994	3797148.0
2004-04-21 14:00:00	MSFT	Stock	25.39	25.45	25.3	25.31	7268445.0
2004-04-21 15:00:00	MSFT	Stock	25.31	25.49	25.27	25.46	9293279.0
2004-04-21 16:00:00	MSFT	Stock	25.45	25.48	25.3125	25.43	552467.0
2004-04-21 17:00:00	MSFT	Stock	25.43	25.48	25.3532	25.41	116083.0
2004-04-21 18:00:00	MSFT	Stock	25.41	25.45	25.41	25.44	9740.0
2004-04-21 08:00:00	NVDA	Stock	0.1886	0.1886	0.1883	0.1883	243000.0
2004-04-21 09:00:00	NVDA	Stock	0.1886	0.1917	0.1883	0.1917	62795280.0
2004-04-21 10:00:00	NVDA	Stock	0.1917	0.195	0.1894	0.19	140875440.0
2004-04-21 11:00:00	NVDA	Stock	0.1898	0.1902	0.1887	0.1896	63122760.0
2004-04-21 12:00:00	NVDA	Stock	0.1894	0.1919	0.1888	0.1902	124083120.0
2004-04-21 13:00:00	NVDA	Stock	0.1902	0.1913	0.1897	0.1899	44521200.0
2004-04-21 14:00:00	NVDA	Stock	0.19	0.1903	0.1887	0.189	52906680.0
2004-04-21 15:00:00	NVDA	Stock	0.189	0.19	0.187	0.1885	144765240.0
2004-04-21 16:00:00	NVDA	Stock	0.1885	0.1888	0.1877	0.1883	9354480.0
2004-04-21 17:00:00	NVDA	Stock	0.188	0.1904	0.1877	0.1877	588000.0
2004-04-21 08:00:00	AMZN	Stock	2.275	2.275	2.2665	2.2665	28000.0
2004-04-21 09:00:00	AMZN	Stock	2.2665	2.3245	2.26	2.316	20729480.0
2004-04-21 10:00:00	AMZN	Stock	2.3175	2.32	2.2635	2.286	29725200.0
2004-04-21 11:00:00	AMZN	Stock	2.286	2.286	2.2455	2.273	18735880.0
2004-04-21 12:00:00	AMZN	Stock	2.2745	2.29	2.27	2.2865	6751760.0
2004-04-21 13:00:00	AMZN	Stock	2.2865	2.287	2.263	2.2695	10145220.0
2004-04-21 14:00:00	AMZN	Stock	2.2699	2.2775	2.2625	2.2735	11695240.0
2004-04-21 15:00:00	AMZN	Stock	2.2735	2.286	2.2715	2.281	12016720.0
2004-04-21 16:00:00	AMZN	Stock	2.2815	2.319	2.25	2.286	1494840.0
2004-04-21 17:00:00	AMZN	Stock	2.295	2.309	2.2791	2.288	254400.0
2004-04-21 18:00:00	AMZN	Stock	2.288	2.29	2.288	2.288	92000.0
2004-04-21 08:00:00	CL	Stock	28.365	28.365	28.365	28.365	400.0
2004-04-21 09:00:00	CL	Stock	28.5	28.645	28.5	28.64	991200.0
2004-04-21 10:00:00	CL	Stock	28.645	28.735	28.3	28.38	2068200.0
2004-04-21 11:00:00	CL	Stock	28.38	28.43	28.23	28.38	695600.0
2004-04-21 12:00:00	CL	Stock	28.38	28.425	28.2	28.25	881800.0
2004-04-21 13:00:00	CL	Stock	28.24	28.255	28.155	28.25	181200.0
2004-04-21 14:00:00	CL	Stock	28.245	28.265	28.125	28.15	546200.0
2004-04-21 15:00:00	CL	Stock	28.15	28.245	27.995	28.14	1121400.0

> showing 50 of 23,726 rows — these rows as CSV

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