PREVIEW / stock_1hour / 2003-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-28.parquet
  size:    482 KB
  rows:    22,656
  symbols: 1,599

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-28 08:00:00	AAPL	Stock	0.3821	0.4018	0.3821	0.3871	582400.0
2003-07-28 09:00:00	AAPL	Stock	0.3839	0.3848	0.3757	0.377	24302320.0
2003-07-28 10:00:00	AAPL	Stock	0.377	0.38	0.3763	0.3795	29618288.0
2003-07-28 11:00:00	AAPL	Stock	0.3795	0.3805	0.3777	0.3788	20206928.0
2003-07-28 12:00:00	AAPL	Stock	0.3786	0.3786	0.3764	0.3771	10180240.0
2003-07-28 13:00:00	AAPL	Stock	0.377	0.3789	0.3757	0.3773	15785000.0
2003-07-28 14:00:00	AAPL	Stock	0.3773	0.3773	0.3741	0.3763	19276992.0
2003-07-28 15:00:00	AAPL	Stock	0.3762	0.3771	0.3725	0.3743	32621344.0
2003-07-28 16:00:00	AAPL	Stock	0.3743	0.3764	0.3738	0.3742	2542400.0
2003-07-28 17:00:00	AAPL	Stock	0.375	0.3752	0.375	0.3752	16800.0
2003-07-28 08:00:00	MSFT	Stock	26.92	27.12	26.89	27.05	102510.0
2003-07-28 09:00:00	MSFT	Stock	27.05	27.051	26.76	26.81	5359558.0
2003-07-28 10:00:00	MSFT	Stock	26.96	26.99	26.79	26.88	7249231.0
2003-07-28 11:00:00	MSFT	Stock	26.88	26.93	26.63	26.64	6290682.0
2003-07-28 12:00:00	MSFT	Stock	26.64	26.7	26.51	26.5988	5955531.0
2003-07-28 13:00:00	MSFT	Stock	26.599	26.77	26.52	26.69	5101736.0
2003-07-28 14:00:00	MSFT	Stock	26.68	26.72	26.5	26.699	6826837.0
2003-07-28 15:00:00	MSFT	Stock	26.698	26.78	26.49	26.62	9830453.0
2003-07-28 16:00:00	MSFT	Stock	26.6	26.81	26.58	26.67	528763.0
2003-07-28 17:00:00	MSFT	Stock	26.67	26.67	26.6	26.63	65175.0
2003-07-28 18:00:00	MSFT	Stock	26.62	26.68	26.62	26.68	4479.0
2003-07-28 08:00:00	NVDA	Stock	0.1758	0.1765	0.1757	0.1764	144000.0
2003-07-28 09:00:00	NVDA	Stock	0.1757	0.1773	0.1719	0.1736	88238160.0
2003-07-28 10:00:00	NVDA	Stock	0.1736	0.1745	0.1714	0.172	156592800.0
2003-07-28 11:00:00	NVDA	Stock	0.172	0.1724	0.1704	0.1705	77371560.0
2003-07-28 12:00:00	NVDA	Stock	0.1705	0.1711	0.1694	0.1707	52442040.0
2003-07-28 13:00:00	NVDA	Stock	0.1706	0.1708	0.1699	0.1704	61561200.0
2003-07-28 14:00:00	NVDA	Stock	0.1705	0.1711	0.1697	0.1708	72346200.0
2003-07-28 15:00:00	NVDA	Stock	0.1709	0.1717	0.1693	0.1701	122653560.0
2003-07-28 16:00:00	NVDA	Stock	0.1702	0.1703	0.1696	0.1701	7336680.0
2003-07-28 17:00:00	NVDA	Stock	0.17	0.17	0.1518	0.1625	29016600.0
2003-07-28 18:00:00	NVDA	Stock	0.1623	0.1632	0.1614	0.1615	2643240.0
2003-07-28 08:00:00	AMZN	Stock	2.08	2.0855	2.065	2.075	316080.0
2003-07-28 09:00:00	AMZN	Stock	2.0785	2.0785	2.0435	2.0525	18956880.0
2003-07-28 10:00:00	AMZN	Stock	2.054	2.0675	2.05	2.061	22282980.0
2003-07-28 11:00:00	AMZN	Stock	2.061	2.075	2.0585	2.0605	15667980.0
2003-07-28 12:00:00	AMZN	Stock	2.06	2.0665	2.0505	2.0575	16801500.0
2003-07-28 13:00:00	AMZN	Stock	2.058	2.0715	2.0555	2.0635	9637260.0
2003-07-28 14:00:00	AMZN	Stock	2.064	2.0745	2.0615	2.0735	8620760.0
2003-07-28 15:00:00	AMZN	Stock	2.0745	2.109	2.0685	2.103	45188000.0
2003-07-28 16:00:00	AMZN	Stock	2.102	2.111	2.0606	2.1075	2331980.0
2003-07-28 17:00:00	AMZN	Stock	2.1104	2.1104	2.105	2.108	326000.0
2003-07-28 18:00:00	AMZN	Stock	2.11	2.112	2.108	2.108	45360.0
2003-07-28 09:00:00	CL	Stock	27.825	27.885	27.69	27.725	286400.0
2003-07-28 10:00:00	CL	Stock	27.725	27.83	27.675	27.795	462200.0
2003-07-28 11:00:00	CL	Stock	27.8	27.87	27.75	27.765	737800.0
2003-07-28 12:00:00	CL	Stock	27.77	27.845	27.74	27.785	263000.0
2003-07-28 13:00:00	CL	Stock	27.795	27.885	27.755	27.825	177200.0
2003-07-28 14:00:00	CL	Stock	27.825	27.845	27.735	27.845	233400.0
2003-07-28 15:00:00	CL	Stock	27.845	27.855	27.76	27.79	520000.0

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

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