PREVIEW / stock_1hour / 2005-04-08

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-08.parquet
  size:    526 KB
  rows:    24,790
  symbols: 1,942

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
2005-04-08 08:00:00	AAPL	Stock	1.5643	1.5714	1.5571	1.56	879060.0
2005-04-08 09:00:00	AAPL	Stock	1.56	1.5875	1.5575	1.575	137538072.0
2005-04-08 10:00:00	AAPL	Stock	1.5754	1.5768	1.5632	1.5704	110534284.0
2005-04-08 11:00:00	AAPL	Stock	1.5707	1.5732	1.5668	1.5693	78211392.0
2005-04-08 12:00:00	AAPL	Stock	1.5689	1.5714	1.5661	1.569	58667616.0
2005-04-08 13:00:00	AAPL	Stock	1.5689	1.5786	1.5675	1.5757	63321776.0
2005-04-08 14:00:00	AAPL	Stock	1.5754	1.5757	1.5643	1.5729	61074580.0
2005-04-08 15:00:00	AAPL	Stock	1.5725	1.5729	1.555	1.5625	128386888.0
2005-04-08 16:00:00	AAPL	Stock	1.5636	1.5661	1.5607	1.5607	3365712.0
2005-04-08 17:00:00	AAPL	Stock	1.5614	1.5614	1.5589	1.5589	186340.0
2005-04-08 18:00:00	AAPL	Stock	1.5607	1.5636	1.5607	1.5621	338800.0
2005-04-08 08:00:00	MSFT	Stock	25.05	25.09	25.05	25.09	21884.0
2005-04-08 09:00:00	MSFT	Stock	25.09	25.23	24.99	25.181	7713707.0
2005-04-08 10:00:00	MSFT	Stock	25.182	25.25	25.11	25.15	7970696.0
2005-04-08 11:00:00	MSFT	Stock	25.15	25.15	25.02	25.07	6873732.0
2005-04-08 12:00:00	MSFT	Stock	25.06	25.11	25.03	25.06	2997235.0
2005-04-08 13:00:00	MSFT	Stock	25.052	25.07	25.0	25.01	3835796.0
2005-04-08 14:00:00	MSFT	Stock	25.01	25.03	24.91	24.98	5465594.0
2005-04-08 15:00:00	MSFT	Stock	24.98	25.0	24.91	24.94	9973767.0
2005-04-08 16:00:00	MSFT	Stock	24.93	24.98	24.91	24.93	1120614.0
2005-04-08 17:00:00	MSFT	Stock	24.94	24.94	24.94	24.94	100.0
2005-04-08 18:00:00	MSFT	Stock	24.94	24.97	24.94	24.97	2400.0
2005-04-08 08:00:00	NVDA	Stock	0.1983	0.1983	0.1983	0.1983	12000.0
2005-04-08 09:00:00	NVDA	Stock	0.1987	0.202	0.1975	0.2017	59869800.0
2005-04-08 10:00:00	NVDA	Stock	0.2017	0.2032	0.2008	0.2019	128534160.0
2005-04-08 11:00:00	NVDA	Stock	0.2019	0.2021	0.1992	0.1997	45645840.0
2005-04-08 12:00:00	NVDA	Stock	0.1998	0.1998	0.1981	0.1982	36312120.0
2005-04-08 13:00:00	NVDA	Stock	0.1982	0.2013	0.1982	0.201	29263200.0
2005-04-08 14:00:00	NVDA	Stock	0.2009	0.2014	0.1989	0.199	54277440.0
2005-04-08 15:00:00	NVDA	Stock	0.199	0.1992	0.195	0.1953	193055760.0
2005-04-08 16:00:00	NVDA	Stock	0.1954	0.1962	0.1952	0.1952	56418000.0
2005-04-08 18:00:00	NVDA	Stock	0.1959	0.1959	0.1958	0.1958	120000.0
2005-04-08 08:00:00	AMZN	Stock	1.74	1.74	1.74	1.74	4000.0
2005-04-08 09:00:00	AMZN	Stock	1.74	1.7465	1.7375	1.742	4027540.0
2005-04-08 10:00:00	AMZN	Stock	1.7415	1.744	1.732	1.7385	12542940.0
2005-04-08 11:00:00	AMZN	Stock	1.7385	1.7415	1.7305	1.733	7337640.0
2005-04-08 12:00:00	AMZN	Stock	1.7325	1.7375	1.7315	1.733	4835020.0
2005-04-08 13:00:00	AMZN	Stock	1.733	1.742	1.733	1.737	5146320.0
2005-04-08 14:00:00	AMZN	Stock	1.737	1.7385	1.729	1.732	11917540.0
2005-04-08 15:00:00	AMZN	Stock	1.732	1.733	1.729	1.73	12563320.0
2005-04-08 16:00:00	AMZN	Stock	1.7305	1.735	1.725	1.735	325980.0
2005-04-08 09:00:00	CL	Stock	26.77	26.84	26.66	26.76	268600.0
2005-04-08 10:00:00	CL	Stock	26.75	26.925	26.75	26.835	526000.0
2005-04-08 11:00:00	CL	Stock	26.835	26.835	26.585	26.625	519400.0
2005-04-08 12:00:00	CL	Stock	26.62	26.78	26.62	26.7	295800.0
2005-04-08 13:00:00	CL	Stock	26.7	26.85	26.69	26.845	293600.0
2005-04-08 14:00:00	CL	Stock	26.84	26.84	26.715	26.76	308200.0
2005-04-08 15:00:00	CL	Stock	26.76	26.82	26.705	26.75	656800.0
2005-04-08 16:00:00	CL	Stock	26.77	26.77	26.77	26.77	4800.0
2005-04-08 17:00:00	CL	Stock	26.75	26.75	26.75	26.75	200.0

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

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