PREVIEW / stock_1hour / 2004-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-01.parquet
  size:    509 KB
  rows:    24,509
  symbols: 1,778

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-06-01 08:00:00	AAPL	Stock	0.5029	0.5029	0.5016	0.5016	28000.0
2004-06-01 09:00:00	AAPL	Stock	0.5011	0.5021	0.4943	0.5004	26748848.0
2004-06-01 10:00:00	AAPL	Stock	0.5004	0.5036	0.4968	0.4993	28714336.0
2004-06-01 11:00:00	AAPL	Stock	0.4995	0.4996	0.4959	0.4966	20367200.0
2004-06-01 12:00:00	AAPL	Stock	0.4968	0.4984	0.4948	0.4979	21346080.0
2004-06-01 13:00:00	AAPL	Stock	0.4979	0.4988	0.4959	0.4966	14007672.0
2004-06-01 14:00:00	AAPL	Stock	0.4964	0.4973	0.493	0.4941	24993248.0
2004-06-01 15:00:00	AAPL	Stock	0.4941	0.5007	0.4939	0.5004	37890888.0
2004-06-01 16:00:00	AAPL	Stock	0.5002	0.5018	0.5002	0.5018	4623528.0
2004-06-01 18:00:00	AAPL	Stock	0.5011	0.5025	0.5011	0.5025	352688.0
2004-06-01 08:00:00	MSFT	Stock	26.15	26.24	26.1	26.2	218401.0
2004-06-01 09:00:00	MSFT	Stock	26.2	26.24	26.1	26.22	5889247.0
2004-06-01 10:00:00	MSFT	Stock	26.22	26.27	26.1	26.15	6919889.0
2004-06-01 11:00:00	MSFT	Stock	26.15	26.17	25.97	25.99	8053478.0
2004-06-01 12:00:00	MSFT	Stock	25.99	26.04	25.97	25.98	5215168.0
2004-06-01 13:00:00	MSFT	Stock	25.99	26.01	25.89	25.93	4391468.0
2004-06-01 14:00:00	MSFT	Stock	25.93	25.97	25.87	25.97	3756507.0
2004-06-01 15:00:00	MSFT	Stock	25.97	26.16	25.95	26.11	11027671.0
2004-06-01 16:00:00	MSFT	Stock	26.1	26.16	26.06	26.16	761379.0
2004-06-01 17:00:00	MSFT	Stock	26.13	26.13	26.11	26.11	8049.0
2004-06-01 18:00:00	MSFT	Stock	26.08	26.12	26.08	26.12	300.0
2004-06-01 08:00:00	NVDA	Stock	0.1937	0.1946	0.1937	0.1946	336000.0
2004-06-01 09:00:00	NVDA	Stock	0.1946	0.1956	0.1918	0.1952	52814880.0
2004-06-01 10:00:00	NVDA	Stock	0.1952	0.1972	0.1948	0.196	60233760.0
2004-06-01 11:00:00	NVDA	Stock	0.196	0.1962	0.1929	0.1937	34586040.0
2004-06-01 12:00:00	NVDA	Stock	0.1937	0.1946	0.1934	0.1938	20498760.0
2004-06-01 13:00:00	NVDA	Stock	0.1939	0.1941	0.193	0.1935	16749120.0
2004-06-01 14:00:00	NVDA	Stock	0.1933	0.1937	0.1922	0.1929	19466160.0
2004-06-01 15:00:00	NVDA	Stock	0.193	0.1953	0.1928	0.1952	60522600.0
2004-06-01 16:00:00	NVDA	Stock	0.1952	0.1962	0.1952	0.1952	23907720.0
2004-06-01 18:00:00	NVDA	Stock	0.1952	0.1952	0.1952	0.1952	194400.0
2004-06-01 08:00:00	AMZN	Stock	2.4	2.4075	2.4	2.4045	100000.0
2004-06-01 09:00:00	AMZN	Stock	2.4045	2.468	2.385	2.45	41442000.0
2004-06-01 10:00:00	AMZN	Stock	2.45	2.4625	2.435	2.445	37640140.0
2004-06-01 11:00:00	AMZN	Stock	2.445	2.453	2.436	2.4435	23174740.0
2004-06-01 12:00:00	AMZN	Stock	2.444	2.4615	2.439	2.46	18081720.0
2004-06-01 13:00:00	AMZN	Stock	2.4595	2.4645	2.455	2.464	17152960.0
2004-06-01 14:00:00	AMZN	Stock	2.464	2.4815	2.4606	2.4805	31294940.0
2004-06-01 15:00:00	AMZN	Stock	2.4805	2.5225	2.4755	2.5113	81362620.0
2004-06-01 16:00:00	AMZN	Stock	2.513	2.52	2.5105	2.511	1973480.0
2004-06-01 17:00:00	AMZN	Stock	2.511	2.512	2.51	2.512	122800.0
2004-06-01 18:00:00	AMZN	Stock	2.513	2.515	2.513	2.515	16000.0
2004-06-01 09:00:00	CL	Stock	28.64	28.665	28.505	28.565	331800.0
2004-06-01 10:00:00	CL	Stock	28.565	28.615	28.44	28.555	392400.0
2004-06-01 11:00:00	CL	Stock	28.55	28.66	28.505	28.585	273800.0
2004-06-01 12:00:00	CL	Stock	28.59	28.71	28.57	28.655	173200.0
2004-06-01 13:00:00	CL	Stock	28.655	28.815	28.655	28.795	364200.0
2004-06-01 14:00:00	CL	Stock	28.785	28.79	28.56	28.65	258400.0
2004-06-01 15:00:00	CL	Stock	28.645	28.79	28.585	28.755	454600.0
2004-06-01 16:00:00	CL	Stock	28.77	28.77	28.7665	28.7665	43000.0

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

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