PREVIEW / stock_1hour / 2008-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-04.parquet
  size:    797 KB
  rows:    39,356
  symbols: 3,262

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
2008-04-04 07:00:00	AAPL	Stock	5.4286	5.4464	5.4286	5.4386	54964.0
2008-04-04 08:00:00	AAPL	Stock	5.4393	5.4636	5.3668	5.4439	12230876.0
2008-04-04 09:00:00	AAPL	Stock	5.4446	5.4761	5.3982	5.4414	134997576.0
2008-04-04 10:00:00	AAPL	Stock	5.4414	5.4604	5.385	5.4314	175166992.0
2008-04-04 11:00:00	AAPL	Stock	5.4314	5.46	5.4214	5.4304	102810736.0
2008-04-04 12:00:00	AAPL	Stock	5.4309	5.4911	5.4271	5.4886	87459876.0
2008-04-04 13:00:00	AAPL	Stock	5.4889	5.5255	5.4796	5.4918	93922976.0
2008-04-04 14:00:00	AAPL	Stock	5.4918	5.5089	5.4657	5.4732	79093448.0
2008-04-04 15:00:00	AAPL	Stock	5.4732	5.4793	5.4321	5.4671	134873956.0
2008-04-04 16:00:00	AAPL	Stock	5.4671	5.4671	5.4429	5.46	8635900.0
2008-04-04 17:00:00	AAPL	Stock	5.4607	5.4889	5.3975	5.4775	2142168.0
2008-04-04 18:00:00	AAPL	Stock	5.48	5.4804	5.4736	5.475	149604.0
2008-04-04 19:00:00	AAPL	Stock	5.4736	5.4786	5.4721	5.4746	290304.0
2008-04-04 08:00:00	MSFT	Stock	29.09	29.22	29.06	29.17	44689.0
2008-04-04 09:00:00	MSFT	Stock	29.18	29.18	28.76	28.9	5224542.0
2008-04-04 10:00:00	MSFT	Stock	28.91	28.93	28.74	28.85	6390271.0
2008-04-04 11:00:00	MSFT	Stock	28.85	28.96	28.8	28.89	4102920.0
2008-04-04 12:00:00	MSFT	Stock	28.88	29.19	28.88	29.171	6028287.0
2008-04-04 13:00:00	MSFT	Stock	29.17	29.26	29.1	29.11	4144400.0
2008-04-04 14:00:00	MSFT	Stock	29.11	29.23	29.11	29.17	3941528.0
2008-04-04 15:00:00	MSFT	Stock	29.16	29.23	29.09	29.16	10435985.0
2008-04-04 16:00:00	MSFT	Stock	29.16	29.75	29.028	29.4	2721168.0
2008-04-04 17:00:00	MSFT	Stock	29.43	29.58	29.4	29.55	85087.0
2008-04-04 18:00:00	MSFT	Stock	29.55	29.67	29.46	29.6	64675.0
2008-04-04 19:00:00	MSFT	Stock	29.6	29.63	29.56	29.6	13107.0
2008-04-04 08:00:00	NVDA	Stock	0.5	0.5	0.4945	0.4963	4760800.0
2008-04-04 09:00:00	NVDA	Stock	0.4972	0.4972	0.4738	0.4775	225630440.0
2008-04-04 10:00:00	NVDA	Stock	0.4778	0.4798	0.4698	0.4748	253013040.0
2008-04-04 11:00:00	NVDA	Stock	0.4748	0.4772	0.4738	0.4763	143125280.0
2008-04-04 12:00:00	NVDA	Stock	0.4763	0.4832	0.4763	0.4815	150060120.0
2008-04-04 13:00:00	NVDA	Stock	0.4815	0.482	0.4775	0.4795	102541840.0
2008-04-04 14:00:00	NVDA	Stock	0.4795	0.4815	0.476	0.4768	149243080.0
2008-04-04 15:00:00	NVDA	Stock	0.477	0.4778	0.4683	0.4695	332235640.0
2008-04-04 16:00:00	NVDA	Stock	0.469	0.4763	0.4675	0.4683	76286080.0
2008-04-04 17:00:00	NVDA	Stock	0.4683	0.4784	0.4675	0.4683	2359200.0
2008-04-04 18:00:00	NVDA	Stock	0.4683	0.475	0.4683	0.4695	12302000.0
2008-04-04 19:00:00	NVDA	Stock	0.4695	0.4713	0.4685	0.4713	169840.0
2008-04-04 08:00:00	AMZN	Stock	3.7625	3.775	3.7305	3.77	316220.0
2008-04-04 09:00:00	AMZN	Stock	3.7505	3.7785	3.714	3.757	16195360.0
2008-04-04 10:00:00	AMZN	Stock	3.755	3.7765	3.73	3.753	16779320.0
2008-04-04 11:00:00	AMZN	Stock	3.753	3.7865	3.7515	3.7825	12563200.0
2008-04-04 12:00:00	AMZN	Stock	3.784	3.83	3.781	3.8285	14260780.0
2008-04-04 13:00:00	AMZN	Stock	3.8295	3.8915	3.826	3.883	23145260.0
2008-04-04 14:00:00	AMZN	Stock	3.883	3.8875	3.851	3.8655	19431220.0
2008-04-04 15:00:00	AMZN	Stock	3.8665	3.879	3.808	3.842	32971780.0
2008-04-04 16:00:00	AMZN	Stock	3.8435	3.844	3.8153	3.8355	799540.0
2008-04-04 17:00:00	AMZN	Stock	3.754	3.8414	3.7386	3.8414	3212480.0
2008-04-04 18:00:00	AMZN	Stock	3.83	3.83	3.83	3.83	2000.0
2008-04-04 19:00:00	AMZN	Stock	3.8325	3.8325	3.832	3.832	16000.0
2008-04-04 08:00:00	TLT	Stock	94.8	94.84	94.64	94.66	23500.0

> showing 50 of 39,356 rows — these rows as CSV

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