PREVIEW / stock_1hour / 2003-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-14.parquet
  size:    458 KB
  rows:    22,291
  symbols: 1,596

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-07-14 08:00:00	AAPL	Stock	0.3571	0.3598	0.3554	0.3598	261800.0
2003-07-14 09:00:00	AAPL	Stock	0.3607	0.3612	0.355	0.3595	22815800.0
2003-07-14 10:00:00	AAPL	Stock	0.3593	0.3643	0.3589	0.3627	39541264.0
2003-07-14 11:00:00	AAPL	Stock	0.3629	0.3634	0.3616	0.3618	25064592.0
2003-07-14 12:00:00	AAPL	Stock	0.362	0.362	0.36	0.3616	20698440.0
2003-07-14 13:00:00	AAPL	Stock	0.3616	0.3625	0.3613	0.3625	11362960.0
2003-07-14 14:00:00	AAPL	Stock	0.3623	0.3623	0.3596	0.3602	9796584.0
2003-07-14 15:00:00	AAPL	Stock	0.3602	0.3605	0.3548	0.3554	37991016.0
2003-07-14 16:00:00	AAPL	Stock	0.3554	0.3557	0.3534	0.3557	1668800.0
2003-07-14 08:00:00	MSFT	Stock	27.71	27.96	27.53	27.77	438913.0
2003-07-14 09:00:00	MSFT	Stock	27.77	27.801	27.595	27.67	7766759.0
2003-07-14 10:00:00	MSFT	Stock	27.66	27.79	27.63	27.78	11889003.0
2003-07-14 11:00:00	MSFT	Stock	27.77	27.799	27.64	27.67	5048309.0
2003-07-14 12:00:00	MSFT	Stock	27.67	27.69	27.58	27.6379	5111369.0
2003-07-14 13:00:00	MSFT	Stock	27.64	27.7	27.6	27.69	3660956.0
2003-07-14 14:00:00	MSFT	Stock	27.69	27.72	27.54	27.589	5221405.0
2003-07-14 15:00:00	MSFT	Stock	27.58	27.61	27.05	27.19	14494206.0
2003-07-14 16:00:00	MSFT	Stock	27.19	27.69	27.12	27.26	702839.0
2003-07-14 17:00:00	MSFT	Stock	27.25	27.606	27.23	27.27	1583250.0
2003-07-14 18:00:00	MSFT	Stock	27.27	27.27	27.24	27.24	3200.0
2003-07-14 08:00:00	NVDA	Stock	0.2083	0.2095	0.2066	0.2095	1506720.0
2003-07-14 09:00:00	NVDA	Stock	0.2095	0.21	0.2071	0.2087	91221000.0
2003-07-14 10:00:00	NVDA	Stock	0.2087	0.2091	0.2064	0.208	104967240.0
2003-07-14 11:00:00	NVDA	Stock	0.208	0.2082	0.2072	0.2075	50861640.0
2003-07-14 12:00:00	NVDA	Stock	0.2076	0.2076	0.2039	0.2046	109160880.0
2003-07-14 13:00:00	NVDA	Stock	0.2046	0.2062	0.2043	0.2057	61103280.0
2003-07-14 14:00:00	NVDA	Stock	0.2058	0.207	0.2052	0.2056	56198280.0
2003-07-14 15:00:00	NVDA	Stock	0.2056	0.2056	0.201	0.2018	158190600.0
2003-07-14 16:00:00	NVDA	Stock	0.202	0.2022	0.2016	0.202	1890000.0
2003-07-14 17:00:00	NVDA	Stock	0.202	0.2023	0.2017	0.202	3066000.0
2003-07-14 18:00:00	NVDA	Stock	0.202	0.2022	0.202	0.2022	162000.0
2003-07-14 08:00:00	AMZN	Stock	1.8945	1.91	1.8925	1.91	305800.0
2003-07-14 09:00:00	AMZN	Stock	1.908	1.945	1.9075	1.9395	25772640.0
2003-07-14 10:00:00	AMZN	Stock	1.9385	1.962	1.9358	1.9475	32854800.0
2003-07-14 11:00:00	AMZN	Stock	1.9475	1.9575	1.942	1.953	18244540.0
2003-07-14 12:00:00	AMZN	Stock	1.953	1.9625	1.9445	1.961	17300380.0
2003-07-14 13:00:00	AMZN	Stock	1.9605	1.9775	1.956	1.9765	14833720.0
2003-07-14 14:00:00	AMZN	Stock	1.9765	1.9805	1.9625	1.963	18948660.0
2003-07-14 15:00:00	AMZN	Stock	1.9635	1.9722	1.9445	1.9635	25352900.0
2003-07-14 16:00:00	AMZN	Stock	1.9635	1.974	1.9628	1.9676	1877360.0
2003-07-14 17:00:00	AMZN	Stock	1.9675	1.969	1.9539	1.969	407000.0
2003-07-14 18:00:00	AMZN	Stock	1.97	1.9735	1.97	1.9734	31400.0
2003-07-14 09:00:00	CL	Stock	28.65	28.665	28.515	28.545	335200.0
2003-07-14 10:00:00	CL	Stock	28.54	28.82	28.535	28.82	409400.0
2003-07-14 11:00:00	CL	Stock	28.805	28.82	28.675	28.725	236200.0
2003-07-14 12:00:00	CL	Stock	28.73	28.7495	28.575	28.595	456400.0
2003-07-14 13:00:00	CL	Stock	28.6	28.615	28.545	28.555	406200.0
2003-07-14 14:00:00	CL	Stock	28.56	28.64	28.54	28.595	823600.0
2003-07-14 15:00:00	CL	Stock	28.595	28.61	28.475	28.485	764800.0
2003-07-14 16:00:00	CL	Stock	28.485	28.49	28.485	28.49	29200.0

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

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