PREVIEW / stock_1hour / 2004-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-05-20.parquet
  size:    493 KB
  rows:    23,625
  symbols: 1,765

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
2004-05-20 08:00:00	AAPL	Stock	0.4682	0.4723	0.4682	0.4714	215600.0
2004-05-20 09:00:00	AAPL	Stock	0.4713	0.4821	0.4713	0.4813	42141624.0
2004-05-20 10:00:00	AAPL	Stock	0.4813	0.4814	0.4757	0.4795	34576864.0
2004-05-20 11:00:00	AAPL	Stock	0.4795	0.4804	0.4773	0.4773	16706144.0
2004-05-20 12:00:00	AAPL	Stock	0.4771	0.4788	0.4741	0.4784	23177392.0
2004-05-20 13:00:00	AAPL	Stock	0.4786	0.4804	0.4775	0.4804	12135648.0
2004-05-20 14:00:00	AAPL	Stock	0.4804	0.4818	0.4771	0.4795	19978336.0
2004-05-20 15:00:00	AAPL	Stock	0.4795	0.48	0.4766	0.4786	39888856.0
2004-05-20 16:00:00	AAPL	Stock	0.4784	0.4784	0.4764	0.477	2081800.0
2004-05-20 17:00:00	AAPL	Stock	0.4743	0.4795	0.4743	0.477	787360.0
2004-05-20 08:00:00	MSFT	Stock	25.65	25.75	25.63	25.75	27620.0
2004-05-20 09:00:00	MSFT	Stock	25.74	25.82	25.6	25.81	6844855.0
2004-05-20 10:00:00	MSFT	Stock	25.82	25.87	25.71	25.8	9566740.0
2004-05-20 11:00:00	MSFT	Stock	25.8	25.85	25.74	25.81	7025461.0
2004-05-20 12:00:00	MSFT	Stock	25.81	25.83	25.59	25.76	7269813.0
2004-05-20 13:00:00	MSFT	Stock	25.76	25.85	25.71	25.798	3732330.0
2004-05-20 14:00:00	MSFT	Stock	25.79	25.83	25.64	25.72	5744618.0
2004-05-20 15:00:00	MSFT	Stock	25.73	25.86	25.67	25.74	10413654.0
2004-05-20 16:00:00	MSFT	Stock	25.74	25.82	25.72	25.78	407727.0
2004-05-20 17:00:00	MSFT	Stock	25.77	25.78	25.73	25.73	26096.0
2004-05-20 18:00:00	MSFT	Stock	25.78	25.85	25.78	25.85	2900.0
2004-05-20 08:00:00	NVDA	Stock	0.1785	0.1785	0.1775	0.1775	216000.0
2004-05-20 09:00:00	NVDA	Stock	0.179	0.1815	0.1776	0.1806	59764080.0
2004-05-20 10:00:00	NVDA	Stock	0.1807	0.1808	0.1784	0.1798	66137040.0
2004-05-20 11:00:00	NVDA	Stock	0.1799	0.18	0.1788	0.1795	22110480.0
2004-05-20 12:00:00	NVDA	Stock	0.1794	0.1794	0.1766	0.1786	45995400.0
2004-05-20 13:00:00	NVDA	Stock	0.1786	0.1786	0.1773	0.1783	23067960.0
2004-05-20 14:00:00	NVDA	Stock	0.1783	0.1787	0.1764	0.1779	27875400.0
2004-05-20 15:00:00	NVDA	Stock	0.1778	0.1782	0.1753	0.1762	113111880.0
2004-05-20 16:00:00	NVDA	Stock	0.1762	0.1766	0.1754	0.1763	2335440.0
2004-05-20 17:00:00	NVDA	Stock	0.1756	0.1757	0.1755	0.1756	437760.0
2004-05-20 08:00:00	AMZN	Stock	2.083	2.09	2.083	2.09	64000.0
2004-05-20 09:00:00	AMZN	Stock	2.086	2.0985	2.075	2.0855	14610320.0
2004-05-20 10:00:00	AMZN	Stock	2.0855	2.087	2.055	2.0625	27889340.0
2004-05-20 11:00:00	AMZN	Stock	2.063	2.0665	2.057	2.0635	9832320.0
2004-05-20 12:00:00	AMZN	Stock	2.0645	2.065	2.04	2.049	18875600.0
2004-05-20 13:00:00	AMZN	Stock	2.049	2.0575	2.04	2.052	11688280.0
2004-05-20 14:00:00	AMZN	Stock	2.0515	2.056	2.046	2.052	11563120.0
2004-05-20 15:00:00	AMZN	Stock	2.0515	2.0575	2.046	2.049	19662180.0
2004-05-20 16:00:00	AMZN	Stock	2.0485	2.054	2.0485	2.053	586440.0
2004-05-20 17:00:00	AMZN	Stock	2.053	2.053	2.048	2.0505	462800.0
2004-05-20 18:00:00	AMZN	Stock	2.051	2.051	2.0505	2.0505	21000.0
2004-05-20 09:00:00	CL	Stock	27.875	28.05	27.755	27.92	258800.0
2004-05-20 10:00:00	CL	Stock	27.92	28.09	27.89	28.01	349200.0
2004-05-20 11:00:00	CL	Stock	28.01	28.03	27.885	27.915	262000.0
2004-05-20 12:00:00	CL	Stock	27.905	27.925	27.83	27.875	373400.0
2004-05-20 13:00:00	CL	Stock	27.88	27.94	27.83	27.935	200600.0
2004-05-20 14:00:00	CL	Stock	27.94	28.07	27.94	28.05	309400.0
2004-05-20 15:00:00	CL	Stock	28.05	28.1	27.975	28.005	689000.0
2004-05-20 16:00:00	CL	Stock	27.985	27.985	27.985	27.985	6000.0

> showing 50 of 23,625 rows — these rows as CSV

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