PREVIEW / stock_1hour / 2003-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-16.parquet
  size:    459 KB
  rows:    21,401
  symbols: 1,586

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-16 08:00:00	AAPL	Stock	0.357	0.358	0.3568	0.358	241920.0
2003-07-16 09:00:00	AAPL	Stock	0.3571	0.3571	0.3502	0.3521	22828120.0
2003-07-16 10:00:00	AAPL	Stock	0.3523	0.3529	0.3461	0.3495	28147056.0
2003-07-16 11:00:00	AAPL	Stock	0.3491	0.3527	0.3474	0.3509	26360488.0
2003-07-16 12:00:00	AAPL	Stock	0.3509	0.3546	0.3505	0.3534	21655592.0
2003-07-16 13:00:00	AAPL	Stock	0.3536	0.3545	0.3511	0.3518	12951624.0
2003-07-16 14:00:00	AAPL	Stock	0.352	0.3538	0.3496	0.3521	14742000.0
2003-07-16 15:00:00	AAPL	Stock	0.3523	0.357	0.3493	0.3552	66449600.0
2003-07-16 16:00:00	AAPL	Stock	0.355	0.3633	0.3455	0.3591	35456176.0
2003-07-16 17:00:00	AAPL	Stock	0.3598	0.362	0.3548	0.3608	4361616.0
2003-07-16 18:00:00	AAPL	Stock	0.3607	0.3618	0.3607	0.3618	761600.0
2003-07-16 08:00:00	MSFT	Stock	27.7	27.7	27.45	27.62	1094286.0
2003-07-16 09:00:00	MSFT	Stock	27.62	27.66	27.34	27.479	6898502.0
2003-07-16 10:00:00	MSFT	Stock	27.48	27.49	27.23	27.36	7677853.0
2003-07-16 11:00:00	MSFT	Stock	27.36	27.4	27.2	27.34	5319524.0
2003-07-16 12:00:00	MSFT	Stock	27.34	27.41	27.32	27.352	4027871.0
2003-07-16 13:00:00	MSFT	Stock	27.36	27.42	27.29	27.3215	3800827.0
2003-07-16 14:00:00	MSFT	Stock	27.329	27.41	27.27	27.4	3766876.0
2003-07-16 15:00:00	MSFT	Stock	27.4	27.56	27.29	27.52	8699714.0
2003-07-16 16:00:00	MSFT	Stock	27.52	27.57	27.33	27.48	4311853.0
2003-07-16 17:00:00	MSFT	Stock	27.44	27.53	27.1	27.2	557465.0
2003-07-16 18:00:00	MSFT	Stock	27.2	27.289	27.17	27.289	5480.0
2003-07-16 08:00:00	NVDA	Stock	0.2008	0.2008	0.1996	0.1996	384000.0
2003-07-16 09:00:00	NVDA	Stock	0.1996	0.2	0.1941	0.1947	142437960.0
2003-07-16 10:00:00	NVDA	Stock	0.1949	0.195	0.1883	0.1905	164755440.0
2003-07-16 11:00:00	NVDA	Stock	0.1903	0.1904	0.1888	0.1895	88599840.0
2003-07-16 12:00:00	NVDA	Stock	0.1895	0.1917	0.1894	0.191	93535440.0
2003-07-16 13:00:00	NVDA	Stock	0.191	0.1929	0.1902	0.1909	81234000.0
2003-07-16 14:00:00	NVDA	Stock	0.191	0.1917	0.1897	0.1915	76968360.0
2003-07-16 15:00:00	NVDA	Stock	0.1915	0.1933	0.19	0.1925	120231000.0
2003-07-16 16:00:00	NVDA	Stock	0.193	0.193	0.1917	0.1917	20416440.0
2003-07-16 17:00:00	NVDA	Stock	0.1921	0.193	0.1875	0.1927	993000.0
2003-07-16 18:00:00	NVDA	Stock	0.19	0.19	0.1892	0.1892	270000.0
2003-07-16 08:00:00	AMZN	Stock	1.945	1.945	1.94	1.945	42000.0
2003-07-16 09:00:00	AMZN	Stock	1.933	1.933	1.8875	1.907	14034200.0
2003-07-16 10:00:00	AMZN	Stock	1.907	1.909	1.8835	1.892	21643480.0
2003-07-16 11:00:00	AMZN	Stock	1.893	1.8945	1.876	1.882	12537320.0
2003-07-16 12:00:00	AMZN	Stock	1.8823	1.9055	1.881	1.8988	12905060.0
2003-07-16 13:00:00	AMZN	Stock	1.8995	1.905	1.8875	1.889	8143260.0
2003-07-16 14:00:00	AMZN	Stock	1.8885	1.894	1.8775	1.88	11471220.0
2003-07-16 15:00:00	AMZN	Stock	1.88	1.8845	1.866	1.8845	21235780.0
2003-07-16 16:00:00	AMZN	Stock	1.884	1.8875	1.8745	1.8745	2749540.0
2003-07-16 17:00:00	AMZN	Stock	1.8775	1.884	1.8625	1.8625	216000.0
2003-07-16 18:00:00	AMZN	Stock	1.865	1.87	1.86	1.87	34000.0
2003-07-16 09:00:00	CL	Stock	28.5	28.56	28.44	28.505	151200.0
2003-07-16 10:00:00	CL	Stock	28.505	28.52	28.24	28.325	491200.0
2003-07-16 11:00:00	CL	Stock	28.32	28.3225	28.1	28.14	343200.0
2003-07-16 12:00:00	CL	Stock	28.11	28.16	28.03	28.135	517600.0
2003-07-16 13:00:00	CL	Stock	28.13	28.2	28.085	28.1	443800.0
2003-07-16 14:00:00	CL	Stock	28.115	28.205	28.1	28.2	497400.0

> showing 50 of 21,401 rows — these rows as CSV

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