PREVIEW / stock_1hour / 2004-04-30

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-04-30.parquet
  size:    523 KB
  rows:    24,455
  symbols: 1,772

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-30 09:00:00	AAPL	Stock	0.4795	0.4814	0.4691	0.4691	58392432.0
2004-04-30 10:00:00	AAPL	Stock	0.4688	0.4798	0.4682	0.4745	51310504.0
2004-04-30 11:00:00	AAPL	Stock	0.4745	0.4754	0.4691	0.4704	25364248.0
2004-04-30 12:00:00	AAPL	Stock	0.4704	0.4707	0.4636	0.4643	41114920.0
2004-04-30 13:00:00	AAPL	Stock	0.4643	0.4663	0.4598	0.4627	41407520.0
2004-04-30 14:00:00	AAPL	Stock	0.4629	0.4655	0.4604	0.4636	32658752.0
2004-04-30 15:00:00	AAPL	Stock	0.4636	0.4643	0.4552	0.4605	115661672.0
2004-04-30 16:00:00	AAPL	Stock	0.4604	0.4634	0.4589	0.4595	3030720.0
2004-04-30 08:00:00	MSFT	Stock	26.75	26.75	26.55	26.65	39135.0
2004-04-30 09:00:00	MSFT	Stock	26.65	26.66	26.4	26.47	4518227.0
2004-04-30 10:00:00	MSFT	Stock	26.46	26.75	26.42	26.58	9419382.0
2004-04-30 11:00:00	MSFT	Stock	26.58	26.62	26.35	26.5	7582405.0
2004-04-30 12:00:00	MSFT	Stock	26.51	26.55	26.31	26.3609	6593622.0
2004-04-30 13:00:00	MSFT	Stock	26.36	26.48	26.3	26.44	5609640.0
2004-04-30 14:00:00	MSFT	Stock	26.43	26.54	26.32	26.38	4934271.0
2004-04-30 15:00:00	MSFT	Stock	26.38	26.39	26.03	26.03	13617340.0
2004-04-30 16:00:00	MSFT	Stock	26.07	26.17	25.96	26.13	1156346.0
2004-04-30 17:00:00	MSFT	Stock	26.05	26.13	26.05	26.13	8206.0
2004-04-30 18:00:00	MSFT	Stock	26.1	26.13	26.1	26.13	2500.0
2004-04-30 08:00:00	NVDA	Stock	0.1792	0.1792	0.1792	0.1792	24000.0
2004-04-30 09:00:00	NVDA	Stock	0.1792	0.1792	0.1762	0.1764	51015840.0
2004-04-30 10:00:00	NVDA	Stock	0.1764	0.1767	0.1732	0.175	133852560.0
2004-04-30 11:00:00	NVDA	Stock	0.1749	0.1762	0.1743	0.1747	39548760.0
2004-04-30 12:00:00	NVDA	Stock	0.1747	0.1755	0.1726	0.1729	45892440.0
2004-04-30 13:00:00	NVDA	Stock	0.1727	0.1753	0.1722	0.1741	63162840.0
2004-04-30 14:00:00	NVDA	Stock	0.1742	0.1747	0.1727	0.1728	21613440.0
2004-04-30 15:00:00	NVDA	Stock	0.1727	0.1728	0.1703	0.1712	68942520.0
2004-04-30 16:00:00	NVDA	Stock	0.1712	0.1714	0.1672	0.1706	1727040.0
2004-04-30 18:00:00	NVDA	Stock	0.1708	0.1708	0.1708	0.1708	240000.0
2004-04-30 08:00:00	AMZN	Stock	2.314	2.314	2.314	2.314	4000.0
2004-04-30 09:00:00	AMZN	Stock	2.315	2.32	2.284	2.3	15096040.0
2004-04-30 10:00:00	AMZN	Stock	2.2995	2.3	2.253	2.2695	23967340.0
2004-04-30 11:00:00	AMZN	Stock	2.2685	2.2925	2.2525	2.2525	17724480.0
2004-04-30 12:00:00	AMZN	Stock	2.2545	2.2545	2.2015	2.213	23886320.0
2004-04-30 13:00:00	AMZN	Stock	2.213	2.233	2.2035	2.2095	13914940.0
2004-04-30 14:00:00	AMZN	Stock	2.211	2.2145	2.2	2.204	19069980.0
2004-04-30 15:00:00	AMZN	Stock	2.204	2.206	2.1655	2.18	43369340.0
2004-04-30 16:00:00	AMZN	Stock	2.1785	2.18	2.173	2.18	1779360.0
2004-04-30 17:00:00	AMZN	Stock	2.1775	2.1775	2.173	2.173	786320.0
2004-04-30 18:00:00	AMZN	Stock	2.18	2.18	2.18	2.18	2000.0
2004-04-30 09:00:00	CL	Stock	29.075	29.075	28.885	28.955	524800.0
2004-04-30 10:00:00	CL	Stock	28.94	29.1	28.94	29.06	971000.0
2004-04-30 11:00:00	CL	Stock	29.055	29.085	29.005	29.07	607200.0
2004-04-30 12:00:00	CL	Stock	29.07	29.125	29.01	29.1	550000.0
2004-04-30 13:00:00	CL	Stock	29.095	29.24	29.071	29.155	610200.0
2004-04-30 14:00:00	CL	Stock	29.155	29.175	29.065	29.085	613600.0
2004-04-30 15:00:00	CL	Stock	29.09	29.12	28.955	28.955	1113600.0
2004-04-30 16:00:00	CL	Stock	28.94	28.945	28.94	28.94	8200.0
2004-04-30 17:00:00	CL	Stock	28.94	28.94	28.94	28.94	1600.0

> showing 49 of 24,455 rows — these rows as CSV

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