PREVIEW / stock_1hour / 2003-09-17

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-17.parquet
  size:    466 KB
  rows:    22,081
  symbols: 1,609

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-09-17 08:00:00	AAPL	Stock	0.4164	0.4164	0.4018	0.4018	16800.0
2003-09-17 09:00:00	AAPL	Stock	0.3996	0.3996	0.3923	0.393	33474336.0
2003-09-17 10:00:00	AAPL	Stock	0.393	0.3955	0.3916	0.3927	42947072.0
2003-09-17 11:00:00	AAPL	Stock	0.3927	0.3939	0.392	0.3927	27726272.0
2003-09-17 12:00:00	AAPL	Stock	0.3929	0.395	0.3921	0.3943	35399224.0
2003-09-17 13:00:00	AAPL	Stock	0.3943	0.3952	0.3911	0.3927	23150736.0
2003-09-17 14:00:00	AAPL	Stock	0.3927	0.3939	0.3909	0.3918	29054312.0
2003-09-17 15:00:00	AAPL	Stock	0.392	0.397	0.3909	0.3957	59165232.0
2003-09-17 16:00:00	AAPL	Stock	0.3948	0.3955	0.3945	0.395	4552912.0
2003-09-17 08:00:00	MSFT	Stock	28.8	28.94	28.721	28.78	60892.0
2003-09-17 09:00:00	MSFT	Stock	28.78	28.93	28.7	28.82	6173918.0
2003-09-17 10:00:00	MSFT	Stock	28.82	28.95	28.71	28.8	7211264.0
2003-09-17 11:00:00	MSFT	Stock	28.8	28.86	28.77	28.77	3545489.0
2003-09-17 12:00:00	MSFT	Stock	28.772	28.86	28.74	28.83	3963769.0
2003-09-17 13:00:00	MSFT	Stock	28.83	28.84	28.65	28.66	5795283.0
2003-09-17 14:00:00	MSFT	Stock	28.66	28.67	28.47	28.49	7497651.0
2003-09-17 15:00:00	MSFT	Stock	28.49	28.6	28.49	28.56	6293669.0
2003-09-17 16:00:00	MSFT	Stock	28.56	28.7102	28.32	28.5	747800.0
2003-09-17 17:00:00	MSFT	Stock	28.5	28.51	28.47	28.5	25251.0
2003-09-17 18:00:00	MSFT	Stock	28.47	28.47	28.46	28.47	3000.0
2003-09-17 08:00:00	NVDA	Stock	0.1643	0.1664	0.1633	0.1663	2568000.0
2003-09-17 09:00:00	NVDA	Stock	0.1663	0.1686	0.1637	0.1658	213125400.0
2003-09-17 10:00:00	NVDA	Stock	0.1658	0.1665	0.1632	0.1635	196291800.0
2003-09-17 11:00:00	NVDA	Stock	0.1636	0.1652	0.1635	0.1652	84283680.0
2003-09-17 12:00:00	NVDA	Stock	0.1652	0.1662	0.1651	0.1661	51606600.0
2003-09-17 13:00:00	NVDA	Stock	0.166	0.1663	0.1647	0.1647	88671240.0
2003-09-17 14:00:00	NVDA	Stock	0.1648	0.1653	0.1637	0.1644	81077280.0
2003-09-17 15:00:00	NVDA	Stock	0.1642	0.1658	0.1642	0.1655	80179320.0
2003-09-17 16:00:00	NVDA	Stock	0.1656	0.1657	0.1651	0.1656	3901200.0
2003-09-17 17:00:00	NVDA	Stock	0.1657	0.1657	0.1647	0.1654	1210440.0
2003-09-17 18:00:00	NVDA	Stock	0.1648	0.1648	0.1648	0.1648	24000.0
2003-09-17 08:00:00	AMZN	Stock	2.3125	2.3185	2.3125	2.3125	90700.0
2003-09-17 09:00:00	AMZN	Stock	2.3155	2.3515	2.2925	2.3	16652260.0
2003-09-17 10:00:00	AMZN	Stock	2.3	2.302	2.2775	2.2855	19687960.0
2003-09-17 11:00:00	AMZN	Stock	2.2855	2.343	2.279	2.3355	26934820.0
2003-09-17 12:00:00	AMZN	Stock	2.335	2.339	2.3025	2.3025	24130580.0
2003-09-17 13:00:00	AMZN	Stock	2.3025	2.303	2.29	2.3	12269060.0
2003-09-17 14:00:00	AMZN	Stock	2.2991	2.305	2.291	2.3015	12265580.0
2003-09-17 15:00:00	AMZN	Stock	2.3013	2.317	2.3004	2.3085	15863460.0
2003-09-17 16:00:00	AMZN	Stock	2.308	2.3115	2.307	2.308	1313640.0
2003-09-17 17:00:00	AMZN	Stock	2.3085	2.3115	2.3075	2.3075	103980.0
2003-09-17 09:00:00	CL	Stock	27.75	27.75	27.67	27.675	270200.0
2003-09-17 10:00:00	CL	Stock	27.67	27.685	27.535	27.605	347800.0
2003-09-17 11:00:00	CL	Stock	27.605	27.67	27.55	27.635	225400.0
2003-09-17 12:00:00	CL	Stock	27.655	27.665	27.6	27.655	259400.0
2003-09-17 13:00:00	CL	Stock	27.65	27.65	27.55	27.57	242000.0
2003-09-17 14:00:00	CL	Stock	27.58	27.625	27.555	27.61	235200.0
2003-09-17 15:00:00	CL	Stock	27.61	27.655	27.595	27.62	456200.0
2003-09-17 16:00:00	CL	Stock	27.615	27.615	27.595	27.595	85800.0
2003-09-17 17:00:00	CL	Stock	27.595	27.595	27.595	27.595	800.0

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

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