PREVIEW / stock_1hour / 2006-09-05

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-05.parquet
  size:    601 KB
  rows:    29,034
  symbols: 2,359

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-09-05 06:00:00	AAPL	Stock	2.4357	2.4421	2.4357	2.4357	12600.0
2006-09-05 08:00:00	AAPL	Stock	2.4429	2.4643	2.4394	2.4625	3190488.0
2006-09-05 09:00:00	AAPL	Stock	2.4618	2.4775	2.4511	2.46	110568444.0
2006-09-05 10:00:00	AAPL	Stock	2.46	2.4796	2.4482	2.4496	130612104.0
2006-09-05 11:00:00	AAPL	Stock	2.4498	2.4961	2.4496	2.4939	162171100.0
2006-09-05 12:00:00	AAPL	Stock	2.4936	2.4982	2.4871	2.4911	88285764.0
2006-09-05 13:00:00	AAPL	Stock	2.4907	2.5136	2.4839	2.5093	155584996.0
2006-09-05 14:00:00	AAPL	Stock	2.5089	2.5336	2.5046	2.5332	130366152.0
2006-09-05 15:00:00	AAPL	Stock	2.5332	2.5536	2.5279	2.5529	211869112.0
2006-09-05 16:00:00	AAPL	Stock	2.5525	2.5632	2.5493	2.5611	5006988.0
2006-09-05 17:00:00	AAPL	Stock	2.5611	2.5668	2.5607	2.5668	1469104.0
2006-09-05 18:00:00	AAPL	Stock	2.5668	2.5707	2.5646	2.5654	591528.0
2006-09-05 04:00:00	MSFT	Stock	25.84	25.84	25.84	25.84	100.0
2006-09-05 06:00:00	MSFT	Stock	25.83	25.83	25.83	25.83	1000.0
2006-09-05 07:00:00	MSFT	Stock	25.85	25.85	25.85	25.85	1000.0
2006-09-05 08:00:00	MSFT	Stock	25.84	25.85	25.8	25.8	14245.0
2006-09-05 09:00:00	MSFT	Stock	25.8	25.83	25.56	25.761	8639531.0
2006-09-05 10:00:00	MSFT	Stock	25.76	25.96	25.73	25.77	11199330.0
2006-09-05 11:00:00	MSFT	Stock	25.76	25.85	25.75	25.841	4865298.0
2006-09-05 12:00:00	MSFT	Stock	25.85	25.85	25.73	25.74	4331700.0
2006-09-05 13:00:00	MSFT	Stock	25.74	25.75	25.61	25.66	3009934.0
2006-09-05 14:00:00	MSFT	Stock	25.67	25.77	25.66	25.72	3926286.0
2006-09-05 15:00:00	MSFT	Stock	25.72	25.73	25.6	25.62	6523611.0
2006-09-05 16:00:00	MSFT	Stock	25.61	25.9	25.6	25.61	261050.0
2006-09-05 17:00:00	MSFT	Stock	25.61	25.68	25.61	25.63	20842.0
2006-09-05 18:00:00	MSFT	Stock	25.62	25.63	25.61	25.61	5070.0
2006-09-05 08:00:00	NVDA	Stock	0.4633	0.4665	0.4633	0.4648	302940.0
2006-09-05 09:00:00	NVDA	Stock	0.4647	0.47	0.4603	0.4607	53668320.0
2006-09-05 10:00:00	NVDA	Stock	0.4607	0.4672	0.4595	0.4672	74300520.0
2006-09-05 11:00:00	NVDA	Stock	0.4672	0.4768	0.4672	0.476	107619840.0
2006-09-05 12:00:00	NVDA	Stock	0.476	0.476	0.4725	0.4733	56060760.0
2006-09-05 13:00:00	NVDA	Stock	0.4733	0.4735	0.4682	0.4687	64693440.0
2006-09-05 14:00:00	NVDA	Stock	0.4687	0.4758	0.4677	0.4758	75683100.0
2006-09-05 15:00:00	NVDA	Stock	0.4758	0.4758	0.4727	0.475	67079040.0
2006-09-05 16:00:00	NVDA	Stock	0.475	0.4758	0.4702	0.4748	891960.0
2006-09-05 17:00:00	NVDA	Stock	0.4733	0.4742	0.4727	0.4727	322200.0
2006-09-05 08:00:00	AMZN	Stock	1.5885	1.5885	1.5875	1.5875	9000.0
2006-09-05 09:00:00	AMZN	Stock	1.5825	1.5875	1.562	1.5735	14513340.0
2006-09-05 10:00:00	AMZN	Stock	1.573	1.589	1.5705	1.5875	23110700.0
2006-09-05 11:00:00	AMZN	Stock	1.5875	1.614	1.586	1.6095	27645280.0
2006-09-05 12:00:00	AMZN	Stock	1.6095	1.613	1.5985	1.607	15238200.0
2006-09-05 13:00:00	AMZN	Stock	1.6065	1.607	1.597	1.6005	11098800.0
2006-09-05 14:00:00	AMZN	Stock	1.6005	1.6125	1.5995	1.609	15461500.0
2006-09-05 15:00:00	AMZN	Stock	1.609	1.615	1.606	1.612	36306420.0
2006-09-05 16:00:00	AMZN	Stock	1.6125	1.614	1.598	1.609	170000.0
2006-09-05 17:00:00	AMZN	Stock	1.609	1.6105	1.609	1.609	76000.0
2006-09-05 09:00:00	CL	Stock	30.375	30.47	30.205	30.21	345600.0
2006-09-05 10:00:00	CL	Stock	30.22	30.3675	30.17	30.32	594400.0
2006-09-05 11:00:00	CL	Stock	30.325	30.355	30.255	30.28	445800.0
2006-09-05 12:00:00	CL	Stock	30.28	30.32	30.265	30.285	354000.0

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

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