PREVIEW / stock_1hour / 2008-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-24.parquet
  size:    819 KB
  rows:    39,621
  symbols: 3,292

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-24 05:00:00	AAPL	Stock	5.7796	5.785	5.7796	5.7836	39200.0
2008-04-24 06:00:00	AAPL	Stock	5.7893	5.7929	5.7321	5.7357	364924.0
2008-04-24 07:00:00	AAPL	Stock	5.7325	5.8393	5.7182	5.8393	4294808.0
2008-04-24 08:00:00	AAPL	Stock	5.8393	5.9018	5.7929	5.8821	42196420.0
2008-04-24 09:00:00	AAPL	Stock	5.8821	5.9568	5.6855	5.8329	324166444.0
2008-04-24 10:00:00	AAPL	Stock	5.8329	5.8382	5.7757	5.7864	207043200.0
2008-04-24 11:00:00	AAPL	Stock	5.7857	5.9286	5.7768	5.9114	215571972.0
2008-04-24 12:00:00	AAPL	Stock	5.9104	5.9964	5.9046	5.9857	223247808.0
2008-04-24 13:00:00	AAPL	Stock	5.9857	6.0689	5.9643	6.0529	206775940.0
2008-04-24 14:00:00	AAPL	Stock	6.0532	6.0707	6.0232	6.0632	175730912.0
2008-04-24 15:00:00	AAPL	Stock	6.0625	6.0689	6.0082	6.0329	244866944.0
2008-04-24 16:00:00	AAPL	Stock	6.033	6.0604	5.9231	6.0114	22860292.0
2008-04-24 17:00:00	AAPL	Stock	6.0129	6.0375	6.0111	6.0143	2517340.0
2008-04-24 18:00:00	AAPL	Stock	6.0243	6.0336	6.0107	6.0143	528864.0
2008-04-24 19:00:00	AAPL	Stock	6.0125	6.0168	6.0089	6.0089	273224.0
2008-04-24 07:00:00	MSFT	Stock	31.49	31.49	31.38	31.43	3500.0
2008-04-24 08:00:00	MSFT	Stock	31.42	31.75	31.42	31.6	320610.0
2008-04-24 09:00:00	MSFT	Stock	31.6	31.84	31.29	31.33	10918457.0
2008-04-24 10:00:00	MSFT	Stock	31.33	31.69	31.16	31.69	13598040.0
2008-04-24 11:00:00	MSFT	Stock	31.69	31.89	31.59	31.82	14543614.0
2008-04-24 12:00:00	MSFT	Stock	31.82	31.97	31.77	31.848	11513139.0
2008-04-24 13:00:00	MSFT	Stock	31.849	31.93	31.55	31.759	12048060.0
2008-04-24 14:00:00	MSFT	Stock	31.75	31.89	31.64	31.88	10567101.0
2008-04-24 15:00:00	MSFT	Stock	31.87	32.1	31.63	31.68	28711627.0
2008-04-24 16:00:00	MSFT	Stock	31.68	32.5	30.0	30.27	11225849.0
2008-04-24 17:00:00	MSFT	Stock	30.26	30.49	30.0	30.38	947437.0
2008-04-24 18:00:00	MSFT	Stock	30.38	30.49	30.2	30.21	731390.0
2008-04-24 19:00:00	MSFT	Stock	30.2	30.24	30.17	30.2	170929.0
2008-04-24 08:00:00	NVDA	Stock	0.5038	0.5112	0.5038	0.5085	435000.0
2008-04-24 09:00:00	NVDA	Stock	0.511	0.5165	0.4992	0.4992	74073680.0
2008-04-24 10:00:00	NVDA	Stock	0.4992	0.4995	0.4912	0.4968	123982160.0
2008-04-24 11:00:00	NVDA	Stock	0.4965	0.5043	0.496	0.501	80805280.0
2008-04-24 12:00:00	NVDA	Stock	0.501	0.506	0.501	0.5035	70019840.0
2008-04-24 13:00:00	NVDA	Stock	0.5032	0.504	0.4992	0.502	54348000.0
2008-04-24 14:00:00	NVDA	Stock	0.502	0.5043	0.5015	0.5043	72244680.0
2008-04-24 15:00:00	NVDA	Stock	0.5043	0.5053	0.4982	0.499	156579080.0
2008-04-24 16:00:00	NVDA	Stock	0.4982	0.502	0.4925	0.494	15436280.0
2008-04-24 17:00:00	NVDA	Stock	0.4952	0.4952	0.4938	0.4938	96000.0
2008-04-24 18:00:00	NVDA	Stock	0.4938	0.4938	0.4932	0.4938	191880.0
2008-04-24 19:00:00	NVDA	Stock	0.4945	0.495	0.4945	0.495	26600.0
2008-04-24 07:00:00	AMZN	Stock	3.8135	3.83	3.7825	3.82	1297500.0
2008-04-24 08:00:00	AMZN	Stock	3.83	3.8885	3.818	3.8775	4558200.0
2008-04-24 09:00:00	AMZN	Stock	3.8725	3.95	3.8465	3.881	96486220.0
2008-04-24 10:00:00	AMZN	Stock	3.881	3.9	3.852	3.883	57365020.0
2008-04-24 11:00:00	AMZN	Stock	3.883	3.9585	3.8705	3.94	59094660.0
2008-04-24 12:00:00	AMZN	Stock	3.9395	3.9505	3.893	3.9055	32010060.0
2008-04-24 13:00:00	AMZN	Stock	3.9065	3.9355	3.897	3.9335	25245060.0
2008-04-24 14:00:00	AMZN	Stock	3.9335	4.0	3.927	3.998	38275960.0
2008-04-24 15:00:00	AMZN	Stock	3.998	4.0265	3.8665	3.8775	77982320.0
2008-04-24 16:00:00	AMZN	Stock	3.875	3.9174	3.855	3.861	14331580.0

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

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