PREVIEW / stock_1hour / 2003-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-08-28.parquet
  size:    463 KB
  rows:    22,143
  symbols: 1,614

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
2003-08-28 08:00:00	AAPL	Stock	0.3836	0.3838	0.3836	0.3838	140000.0
2003-08-28 09:00:00	AAPL	Stock	0.3836	0.3878	0.3821	0.3863	39822216.0
2003-08-28 10:00:00	AAPL	Stock	0.3864	0.3869	0.382	0.3861	37754976.0
2003-08-28 11:00:00	AAPL	Stock	0.3855	0.3884	0.3845	0.3877	29900976.0
2003-08-28 12:00:00	AAPL	Stock	0.3877	0.3923	0.3875	0.3911	40538512.0
2003-08-28 13:00:00	AAPL	Stock	0.3911	0.3957	0.3904	0.3938	49614992.0
2003-08-28 14:00:00	AAPL	Stock	0.3938	0.3946	0.3913	0.3932	24480624.0
2003-08-28 15:00:00	AAPL	Stock	0.393	0.3968	0.3923	0.3966	47299840.0
2003-08-28 16:00:00	AAPL	Stock	0.3966	0.3973	0.3952	0.3963	4911200.0
2003-08-28 17:00:00	AAPL	Stock	0.3946	0.3963	0.3946	0.3963	240800.0
2003-08-28 18:00:00	AAPL	Stock	0.3963	0.3963	0.3963	0.3963	22400.0
2003-08-28 08:00:00	MSFT	Stock	26.43	26.5	26.38	26.489	17445.0
2003-08-28 09:00:00	MSFT	Stock	26.489	26.55	26.36	26.43	6765605.0
2003-08-28 10:00:00	MSFT	Stock	26.43	26.44	26.24	26.28	10736590.0
2003-08-28 11:00:00	MSFT	Stock	26.28	26.4	26.25	26.37	3653806.0
2003-08-28 12:00:00	MSFT	Stock	26.37	26.4	26.32	26.35	3470118.0
2003-08-28 13:00:00	MSFT	Stock	26.3515	26.38	26.3	26.369	2999880.0
2003-08-28 14:00:00	MSFT	Stock	26.36	26.45	26.31	26.439	4477991.0
2003-08-28 15:00:00	MSFT	Stock	26.44	26.55	26.4	26.55	8180013.0
2003-08-28 16:00:00	MSFT	Stock	26.53	26.58	26.39	26.53	710305.0
2003-08-28 17:00:00	MSFT	Stock	26.43	26.53	26.3928	26.53	6500.0
2003-08-28 18:00:00	MSFT	Stock	26.44	26.44	26.42	26.43	5500.0
2003-08-28 08:00:00	NVDA	Stock	0.1558	0.1558	0.1554	0.1554	756000.0
2003-08-28 09:00:00	NVDA	Stock	0.155	0.1557	0.1477	0.1494	161347920.0
2003-08-28 10:00:00	NVDA	Stock	0.1494	0.1521	0.1484	0.1497	129217560.0
2003-08-28 11:00:00	NVDA	Stock	0.1497	0.1504	0.1487	0.149	132990600.0
2003-08-28 12:00:00	NVDA	Stock	0.1491	0.1496	0.1483	0.1492	81615120.0
2003-08-28 13:00:00	NVDA	Stock	0.1492	0.1492	0.1483	0.1487	59854200.0
2003-08-28 14:00:00	NVDA	Stock	0.1487	0.1497	0.1487	0.1492	80580000.0
2003-08-28 15:00:00	NVDA	Stock	0.1493	0.1497	0.1485	0.1497	111630720.0
2003-08-28 16:00:00	NVDA	Stock	0.1492	0.15	0.1486	0.1492	9424800.0
2003-08-28 17:00:00	NVDA	Stock	0.1488	0.1497	0.1486	0.1492	920400.0
2003-08-28 18:00:00	NVDA	Stock	0.1492	0.1492	0.1492	0.1492	324000.0
2003-08-28 08:00:00	AMZN	Stock	2.2925	2.3005	2.2925	2.2945	370000.0
2003-08-28 09:00:00	AMZN	Stock	2.2965	2.3025	2.252	2.259	27024180.0
2003-08-28 10:00:00	AMZN	Stock	2.259	2.2675	2.2405	2.262	32691360.0
2003-08-28 11:00:00	AMZN	Stock	2.262	2.279	2.2585	2.275	16219480.0
2003-08-28 12:00:00	AMZN	Stock	2.2745	2.282	2.264	2.2765	12371640.0
2003-08-28 13:00:00	AMZN	Stock	2.2768	2.288	2.274	2.28	7151120.0
2003-08-28 14:00:00	AMZN	Stock	2.2805	2.285	2.275	2.2835	9130740.0
2003-08-28 15:00:00	AMZN	Stock	2.2835	2.295	2.274	2.295	20361020.0
2003-08-28 16:00:00	AMZN	Stock	2.295	2.3	2.2862	2.2925	1340000.0
2003-08-28 17:00:00	AMZN	Stock	2.2875	2.299	2.2875	2.295	107000.0
2003-08-28 18:00:00	AMZN	Stock	2.289	2.295	2.289	2.295	72000.0
2003-08-28 09:00:00	CL	Stock	27.775	27.775	27.57	27.6	258400.0
2003-08-28 10:00:00	CL	Stock	27.6	27.655	27.5	27.63	487200.0
2003-08-28 11:00:00	CL	Stock	27.63	27.73	27.585	27.715	304800.0
2003-08-28 12:00:00	CL	Stock	27.72	27.755	27.6	27.695	257200.0
2003-08-28 13:00:00	CL	Stock	27.69	27.695	27.6	27.615	230200.0
2003-08-28 14:00:00	CL	Stock	27.62	27.655	27.58	27.595	225200.0

> showing 50 of 22,143 rows — these rows as CSV

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