PREVIEW / stock_1hour / 2004-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-04-28.parquet
  size:    508 KB
  rows:    23,810
  symbols: 1,759

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-28 09:00:00	AAPL	Stock	0.4805	0.4823	0.475	0.4795	28591472.0
2004-04-28 10:00:00	AAPL	Stock	0.4796	0.4813	0.4741	0.4763	18730544.0
2004-04-28 11:00:00	AAPL	Stock	0.4761	0.4779	0.4732	0.477	22883056.0
2004-04-28 12:00:00	AAPL	Stock	0.477	0.4789	0.4748	0.4788	14498848.0
2004-04-28 13:00:00	AAPL	Stock	0.4786	0.4788	0.4761	0.4777	8483048.0
2004-04-28 14:00:00	AAPL	Stock	0.4777	0.4782	0.473	0.4739	21228312.0
2004-04-28 15:00:00	AAPL	Stock	0.4739	0.4761	0.4704	0.4743	68169640.0
2004-04-28 16:00:00	AAPL	Stock	0.4743	0.4745	0.4718	0.472	3221400.0
2004-04-28 08:00:00	MSFT	Stock	27.21	27.21	27.12	27.13	130790.0
2004-04-28 09:00:00	MSFT	Stock	27.12	27.15	26.88	26.97	6865552.0
2004-04-28 10:00:00	MSFT	Stock	26.96	27.0	26.8	26.81	8649253.0
2004-04-28 11:00:00	MSFT	Stock	26.8	26.89	26.62	26.73	11640754.0
2004-04-28 12:00:00	MSFT	Stock	26.73	26.81	26.67	26.79	4732584.0
2004-04-28 13:00:00	MSFT	Stock	26.8	26.86	26.68	26.709	5535162.0
2004-04-28 14:00:00	MSFT	Stock	26.7	26.8	26.65	26.66	8172447.0
2004-04-28 15:00:00	MSFT	Stock	26.66	26.7	26.47	26.57	15620924.0
2004-04-28 16:00:00	MSFT	Stock	26.57	26.767	26.55	26.58	793654.0
2004-04-28 17:00:00	MSFT	Stock	26.57	26.6978	26.53	26.6	55948.0
2004-04-28 18:00:00	MSFT	Stock	26.6	26.6	26.6	26.6	200.0
2004-04-28 09:00:00	NVDA	Stock	0.1841	0.1863	0.1833	0.1838	62519400.0
2004-04-28 10:00:00	NVDA	Stock	0.1837	0.1873	0.1823	0.1829	107399880.0
2004-04-28 11:00:00	NVDA	Stock	0.1833	0.1864	0.1832	0.1864	45993720.0
2004-04-28 12:00:00	NVDA	Stock	0.1862	0.1871	0.1862	0.1868	25599480.0
2004-04-28 13:00:00	NVDA	Stock	0.1867	0.1874	0.1857	0.1867	32882520.0
2004-04-28 14:00:00	NVDA	Stock	0.1867	0.1869	0.1855	0.1855	38488440.0
2004-04-28 15:00:00	NVDA	Stock	0.1855	0.1859	0.1834	0.1836	71269320.0
2004-04-28 16:00:00	NVDA	Stock	0.1837	0.1839	0.1836	0.1836	854160.0
2004-04-28 17:00:00	NVDA	Stock	0.1838	0.1838	0.1838	0.1838	12000.0
2004-04-28 08:00:00	AMZN	Stock	2.41	2.41	2.39	2.39	90000.0
2004-04-28 09:00:00	AMZN	Stock	2.392	2.4175	2.3665	2.375	20459740.0
2004-04-28 10:00:00	AMZN	Stock	2.374	2.3925	2.3615	2.38	19385180.0
2004-04-28 11:00:00	AMZN	Stock	2.38	2.3805	2.3625	2.37	10525760.0
2004-04-28 12:00:00	AMZN	Stock	2.37	2.374	2.3645	2.3715	4482500.0
2004-04-28 13:00:00	AMZN	Stock	2.3715	2.374	2.35	2.3625	10623300.0
2004-04-28 14:00:00	AMZN	Stock	2.3625	2.3825	2.3555	2.3625	12970920.0
2004-04-28 15:00:00	AMZN	Stock	2.363	2.371	2.332	2.3485	23505980.0
2004-04-28 16:00:00	AMZN	Stock	2.3485	2.354	2.34	2.3445	1643200.0
2004-04-28 17:00:00	AMZN	Stock	2.351	2.354	2.3445	2.345	104640.0
2004-04-28 18:00:00	AMZN	Stock	2.3395	2.3395	2.3395	2.3395	2000.0
2004-04-28 09:00:00	CL	Stock	28.435	28.435	28.215	28.28	416600.0
2004-04-28 10:00:00	CL	Stock	28.26	28.33	28.25	28.275	529600.0
2004-04-28 11:00:00	CL	Stock	28.27	28.3	28.225	28.25	361800.0
2004-04-28 12:00:00	CL	Stock	28.25	28.27	28.205	28.235	291200.0
2004-04-28 13:00:00	CL	Stock	28.23	28.25	28.185	28.245	238400.0
2004-04-28 14:00:00	CL	Stock	28.245	28.275	28.125	28.155	481800.0
2004-04-28 15:00:00	CL	Stock	28.16	28.325	28.14	28.21	944200.0
2004-04-28 16:00:00	CL	Stock	28.2	28.2115	28.2	28.2115	33800.0
2004-04-28 17:00:00	CL	Stock	28.2	28.2	28.2	28.2	800.0

> showing 48 of 23,810 rows — these rows as CSV

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