PREVIEW / stock_1hour / 2006-05-11

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-11.parquet
  size:    613 KB
  rows:    29,152
  symbols: 2,270

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
2006-05-11 04:00:00	AAPL	Stock	2.5204	2.5204	2.5204	2.5204	11200.0
2006-05-11 07:00:00	AAPL	Stock	2.5232	2.5232	2.5232	2.5232	2800.0
2006-05-11 08:00:00	AAPL	Stock	2.5204	2.5307	2.5204	2.5307	297528.0
2006-05-11 09:00:00	AAPL	Stock	2.5286	2.5307	2.475	2.4811	92186388.0
2006-05-11 10:00:00	AAPL	Stock	2.4814	2.4904	2.4571	2.4582	128452408.0
2006-05-11 11:00:00	AAPL	Stock	2.4579	2.46	2.4125	2.4275	204590484.0
2006-05-11 12:00:00	AAPL	Stock	2.4275	2.4454	2.4189	2.4421	101899756.0
2006-05-11 13:00:00	AAPL	Stock	2.4421	2.4457	2.4257	2.4404	81527180.0
2006-05-11 14:00:00	AAPL	Stock	2.4407	2.4475	2.4254	2.4329	82885348.0
2006-05-11 15:00:00	AAPL	Stock	2.4329	2.4425	2.4268	2.4343	107282084.0
2006-05-11 16:00:00	AAPL	Stock	2.4346	2.4361	2.4304	2.4357	2650788.0
2006-05-11 17:00:00	AAPL	Stock	2.4354	2.4368	2.4329	2.4357	459620.0
2006-05-11 18:00:00	AAPL	Stock	2.4357	2.4361	2.4357	2.4357	212492.0
2006-05-11 08:00:00	MSFT	Stock	23.8	23.84	23.72	23.78	232743.0
2006-05-11 09:00:00	MSFT	Stock	23.76	23.89	23.6	23.63	6363460.0
2006-05-11 10:00:00	MSFT	Stock	23.63	23.66	23.5	23.51	11233553.0
2006-05-11 11:00:00	MSFT	Stock	23.5	23.54	23.26	23.28	15734530.0
2006-05-11 12:00:00	MSFT	Stock	23.28	23.4	23.25	23.33	14172053.0
2006-05-11 13:00:00	MSFT	Stock	23.34	23.38	23.24	23.34	12782632.0
2006-05-11 14:00:00	MSFT	Stock	23.35	23.38	23.19	23.2	11165040.0
2006-05-11 15:00:00	MSFT	Stock	23.21	23.35	23.15	23.22	19255723.0
2006-05-11 16:00:00	MSFT	Stock	23.21	23.26	23.21	23.25	345284.0
2006-05-11 17:00:00	MSFT	Stock	23.25	23.28	23.21	23.24	10785.0
2006-05-11 18:00:00	MSFT	Stock	23.24	23.25	23.23	23.25	7670.0
2006-05-11 08:00:00	NVDA	Stock	0.4958	0.4967	0.4942	0.4942	163500.0
2006-05-11 09:00:00	NVDA	Stock	0.495	0.5017	0.489	0.4907	129346260.0
2006-05-11 10:00:00	NVDA	Stock	0.4895	0.4897	0.4765	0.4775	205469280.0
2006-05-11 11:00:00	NVDA	Stock	0.4773	0.4818	0.4753	0.4807	92365080.0
2006-05-11 12:00:00	NVDA	Stock	0.4807	0.4817	0.4773	0.479	74107080.0
2006-05-11 13:00:00	NVDA	Stock	0.479	0.4825	0.4788	0.4818	60067740.0
2006-05-11 14:00:00	NVDA	Stock	0.4817	0.4833	0.4752	0.4757	127811940.0
2006-05-11 15:00:00	NVDA	Stock	0.4758	0.4785	0.4707	0.4742	217721520.0
2006-05-11 16:00:00	NVDA	Stock	0.4745	0.5025	0.4543	0.4692	173710140.0
2006-05-11 17:00:00	NVDA	Stock	0.4697	0.4887	0.4597	0.4817	92406360.0
2006-05-11 18:00:00	NVDA	Stock	0.4813	0.483	0.4775	0.482	5431800.0
2006-05-11 08:00:00	AMZN	Stock	1.708	1.7185	1.708	1.7185	76200.0
2006-05-11 09:00:00	AMZN	Stock	1.7185	1.7185	1.677	1.681	13578880.0
2006-05-11 10:00:00	AMZN	Stock	1.681	1.6855	1.664	1.6734	25762960.0
2006-05-11 11:00:00	AMZN	Stock	1.673	1.675	1.661	1.664	13055460.0
2006-05-11 12:00:00	AMZN	Stock	1.6645	1.6785	1.6575	1.6725	19217100.0
2006-05-11 13:00:00	AMZN	Stock	1.6725	1.6755	1.6665	1.6725	8950440.0
2006-05-11 14:00:00	AMZN	Stock	1.6725	1.6815	1.6605	1.661	17509640.0
2006-05-11 15:00:00	AMZN	Stock	1.6615	1.677	1.654	1.677	46483640.0
2006-05-11 16:00:00	AMZN	Stock	1.675	1.6925	1.675	1.687	2898840.0
2006-05-11 17:00:00	AMZN	Stock	1.6865	1.6865	1.685	1.685	42500.0
2006-05-11 09:00:00	CL	Stock	29.735	29.765	29.34	29.355	506000.0
2006-05-11 10:00:00	CL	Stock	29.345	29.465	29.235	29.435	1004400.0
2006-05-11 11:00:00	CL	Stock	29.44	29.465	29.335	29.38	606400.0
2006-05-11 12:00:00	CL	Stock	29.38	29.5	29.315	29.495	439800.0
2006-05-11 13:00:00	CL	Stock	29.495	29.555	29.365	29.495	507200.0

> showing 50 of 29,152 rows — these rows as CSV

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