PREVIEW / stock_1hour / 2002-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-06-25.parquet
  size:    411 KB
  rows:    19,035
  symbols: 1,442

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
2002-06-25 09:00:00	AAPL	Stock	0.3093	0.3145	0.308	0.312	33219200.0
2002-06-25 10:00:00	AAPL	Stock	0.3127	0.3157	0.305	0.3089	42280000.0
2002-06-25 11:00:00	AAPL	Stock	0.3089	0.3141	0.3089	0.3102	22640800.0
2002-06-25 12:00:00	AAPL	Stock	0.3102	0.3102	0.3038	0.3041	20283200.0
2002-06-25 13:00:00	AAPL	Stock	0.3041	0.3063	0.3013	0.3032	37996000.0
2002-06-25 14:00:00	AAPL	Stock	0.303	0.3061	0.3011	0.3038	37592800.0
2002-06-25 15:00:00	AAPL	Stock	0.3034	0.3063	0.3027	0.3063	49240800.0
2002-06-25 16:00:00	AAPL	Stock	0.3061	0.3082	0.3045	0.3069	15075200.0
2002-06-25 17:00:00	AAPL	Stock	0.3057	0.3064	0.3057	0.3061	1579200.0
2002-06-25 08:00:00	MSFT	Stock	27.25	27.32	27.155	27.245	47800.0
2002-06-25 09:00:00	MSFT	Stock	27.235	27.45	27.065	27.18	9532000.0
2002-06-25 10:00:00	MSFT	Stock	27.2	27.5	27.055	27.3895	13384400.0
2002-06-25 11:00:00	MSFT	Stock	27.385	27.476	27.109	27.276	8274000.0
2002-06-25 12:00:00	MSFT	Stock	27.275	27.32	26.85	26.975	7395000.0
2002-06-25 13:00:00	MSFT	Stock	26.965	27.2	26.755	26.815	9524200.0
2002-06-25 14:00:00	MSFT	Stock	26.815	27.075	26.58	26.658	9992200.0
2002-06-25 15:00:00	MSFT	Stock	26.656	26.8775	26.4	26.475	11372200.0
2002-06-25 16:00:00	MSFT	Stock	26.46	27.4445	26.45	26.545	4017400.0
2002-06-25 17:00:00	MSFT	Stock	26.5	26.5	26.35	26.375	92000.0
2002-06-25 18:00:00	MSFT	Stock	26.35	26.375	26.25	26.25	25400.0
2002-06-25 08:00:00	NVDA	Stock	0.1933	0.1962	0.1933	0.1954	1008000.0
2002-06-25 09:00:00	NVDA	Stock	0.1963	0.1967	0.1902	0.1922	144036000.0
2002-06-25 10:00:00	NVDA	Stock	0.1924	0.1953	0.1871	0.1883	192036000.0
2002-06-25 11:00:00	NVDA	Stock	0.1882	0.1894	0.1845	0.1875	102060000.0
2002-06-25 12:00:00	NVDA	Stock	0.1877	0.1879	0.1792	0.182	125652000.0
2002-06-25 13:00:00	NVDA	Stock	0.1822	0.1829	0.1796	0.1816	105144000.0
2002-06-25 14:00:00	NVDA	Stock	0.1816	0.1845	0.1796	0.1806	102468000.0
2002-06-25 15:00:00	NVDA	Stock	0.1806	0.1818	0.1752	0.1763	235092000.0
2002-06-25 16:00:00	NVDA	Stock	0.1762	0.1845	0.1751	0.1758	19680000.0
2002-06-25 17:00:00	NVDA	Stock	0.1758	0.1764	0.1723	0.1735	2160000.0
2002-06-25 18:00:00	NVDA	Stock	0.1738	0.1738	0.1725	0.1725	276000.0
2002-06-25 08:00:00	AMZN	Stock	0.8695	0.8765	0.8475	0.8495	1098000.0
2002-06-25 09:00:00	AMZN	Stock	0.8495	0.87	0.8065	0.8215	53574000.0
2002-06-25 10:00:00	AMZN	Stock	0.8205	0.8376	0.814	0.8229	38428000.0
2002-06-25 11:00:00	AMZN	Stock	0.8225	0.8275	0.808	0.8185	21630000.0
2002-06-25 12:00:00	AMZN	Stock	0.8185	0.8195	0.8045	0.8085	23642000.0
2002-06-25 13:00:00	AMZN	Stock	0.8085	0.8155	0.776	0.7835	35390000.0
2002-06-25 14:00:00	AMZN	Stock	0.782	0.7915	0.7775	0.7785	23348000.0
2002-06-25 15:00:00	AMZN	Stock	0.7785	0.8475	0.752	0.767	51374000.0
2002-06-25 16:00:00	AMZN	Stock	0.7675	0.8023	0.758	0.8023	7878000.0
2002-06-25 17:00:00	AMZN	Stock	0.764	0.767	0.7615	0.767	818000.0
2002-06-25 18:00:00	AMZN	Stock	0.7615	0.7615	0.7615	0.7615	10000.0
2002-06-25 09:00:00	CL	Stock	24.725	24.75	24.635	24.695	411600.0
2002-06-25 10:00:00	CL	Stock	24.7	24.725	24.385	24.6	905800.0
2002-06-25 11:00:00	CL	Stock	24.6	24.65	24.475	24.535	895400.0
2002-06-25 12:00:00	CL	Stock	24.535	24.6	24.19	24.2	737600.0
2002-06-25 13:00:00	CL	Stock	24.15	24.48	24.12	24.135	445800.0
2002-06-25 14:00:00	CL	Stock	24.11	24.3	23.975	24.0	754200.0
2002-06-25 15:00:00	CL	Stock	24.01	24.155	23.85	23.95	1139000.0
2002-06-25 16:00:00	CL	Stock	23.95	24.6	23.875	24.32	496800.0

> showing 50 of 19,035 rows — these rows as CSV

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