PREVIEW / stock_1hour / 2004-05-27

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-05-27.parquet
  size:    511 KB
  rows:    24,392
  symbols: 1,770

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-27 08:00:00	AAPL	Stock	0.5118	0.5118	0.5107	0.5107	16800.0
2004-05-27 09:00:00	AAPL	Stock	0.5116	0.5116	0.5063	0.5084	30969568.0
2004-05-27 10:00:00	AAPL	Stock	0.5084	0.5107	0.5041	0.5074	35300944.0
2004-05-27 11:00:00	AAPL	Stock	0.5075	0.5089	0.5029	0.5075	34155240.0
2004-05-27 12:00:00	AAPL	Stock	0.5075	0.5075	0.4998	0.5004	33851608.0
2004-05-27 13:00:00	AAPL	Stock	0.5002	0.5005	0.4968	0.4986	20067656.0
2004-05-27 14:00:00	AAPL	Stock	0.4986	0.5036	0.4986	0.5029	19735408.0
2004-05-27 15:00:00	AAPL	Stock	0.5027	0.5043	0.4998	0.5027	37037448.0
2004-05-27 16:00:00	AAPL	Stock	0.5027	0.5043	0.5017	0.5017	2762200.0
2004-05-27 17:00:00	AAPL	Stock	0.503	0.5043	0.503	0.5043	77840.0
2004-05-27 08:00:00	MSFT	Stock	26.14	26.2	26.1	26.2	207852.0
2004-05-27 09:00:00	MSFT	Stock	26.2	26.25	26.01	26.09	6058238.0
2004-05-27 10:00:00	MSFT	Stock	26.09	26.16	26.06	26.14	7041995.0
2004-05-27 11:00:00	MSFT	Stock	26.14	26.17	25.95	26.041	8071134.0
2004-05-27 12:00:00	MSFT	Stock	26.05	26.09	25.95	25.97	5162739.0
2004-05-27 13:00:00	MSFT	Stock	25.96	26.04	25.92	26.0	4384753.0
2004-05-27 14:00:00	MSFT	Stock	25.99	26.1	25.99	26.08	4418337.0
2004-05-27 15:00:00	MSFT	Stock	26.08	26.18	26.04	26.18	10878253.0
2004-05-27 16:00:00	MSFT	Stock	26.18	26.27	26.0774	26.26	535042.0
2004-05-27 17:00:00	MSFT	Stock	26.26	26.27	26.07	26.21	86329.0
2004-05-27 18:00:00	MSFT	Stock	26.23	26.23	26.2	26.2	12700.0
2004-05-27 09:00:00	NVDA	Stock	0.1896	0.199	0.1896	0.1905	75814920.0
2004-05-27 10:00:00	NVDA	Stock	0.1905	0.1934	0.1904	0.1926	108658320.0
2004-05-27 11:00:00	NVDA	Stock	0.1925	0.1927	0.1897	0.1904	78637080.0
2004-05-27 12:00:00	NVDA	Stock	0.1902	0.1905	0.1886	0.1886	55055640.0
2004-05-27 13:00:00	NVDA	Stock	0.1886	0.1891	0.1882	0.1887	29503080.0
2004-05-27 14:00:00	NVDA	Stock	0.1887	0.1893	0.1884	0.189	61084560.0
2004-05-27 15:00:00	NVDA	Stock	0.1891	0.1894	0.1878	0.1885	81608400.0
2004-05-27 16:00:00	NVDA	Stock	0.1885	0.1887	0.1867	0.1882	28698600.0
2004-05-27 17:00:00	NVDA	Stock	0.1885	0.1885	0.1885	0.1885	63240.0
2004-05-27 08:00:00	AMZN	Stock	2.237	2.254	2.235	2.254	134000.0
2004-05-27 09:00:00	AMZN	Stock	2.26	2.276	2.2425	2.245	19401760.0
2004-05-27 10:00:00	AMZN	Stock	2.245	2.2925	2.2445	2.283	36797600.0
2004-05-27 11:00:00	AMZN	Stock	2.282	2.284	2.272	2.2775	24094240.0
2004-05-27 12:00:00	AMZN	Stock	2.278	2.2825	2.265	2.2785	23531720.0
2004-05-27 13:00:00	AMZN	Stock	2.279	2.296	2.2745	2.293	25633840.0
2004-05-27 14:00:00	AMZN	Stock	2.293	2.365	2.2915	2.3635	64266680.0
2004-05-27 15:00:00	AMZN	Stock	2.363	2.3915	2.3605	2.3855	76668360.0
2004-05-27 16:00:00	AMZN	Stock	2.3835	2.3895	2.377	2.38	3843020.0
2004-05-27 17:00:00	AMZN	Stock	2.3775	2.385	2.377	2.385	345360.0
2004-05-27 18:00:00	AMZN	Stock	2.3825	2.3825	2.38	2.38	26000.0
2004-05-27 09:00:00	CL	Stock	28.945	29.155	28.945	29.085	666800.0
2004-05-27 10:00:00	CL	Stock	29.09	29.26	29.09	29.175	749200.0
2004-05-27 11:00:00	CL	Stock	29.175	29.175	28.965	29.03	389800.0
2004-05-27 12:00:00	CL	Stock	29.025	29.05	28.865	28.865	177800.0
2004-05-27 13:00:00	CL	Stock	28.81	28.85	28.76	28.78	384000.0
2004-05-27 14:00:00	CL	Stock	28.77	28.83	28.755	28.805	396800.0
2004-05-27 15:00:00	CL	Stock	28.805	28.825	28.76	28.76	872000.0
2004-05-27 16:00:00	CL	Stock	28.76	28.76	28.76	28.76	21000.0
2004-05-27 17:00:00	CL	Stock	28.76	28.76	28.76	28.76	3400.0

> showing 50 of 24,392 rows — these rows as CSV

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