PREVIEW / stock_1hour / 2007-04-05

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-05.parquet
  size:    667 KB
  rows:    31,772
  symbols: 2,577

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
2007-04-05 06:00:00	AAPL	Stock	3.3614	3.3764	3.3614	3.3764	8400.0
2007-04-05 08:00:00	AAPL	Stock	3.3696	3.3704	3.3621	3.3621	353836.0
2007-04-05 09:00:00	AAPL	Stock	3.3625	3.3661	3.34	3.3496	55005608.0
2007-04-05 10:00:00	AAPL	Stock	3.3496	3.36	3.3432	3.3546	78286208.0
2007-04-05 11:00:00	AAPL	Stock	3.3546	3.3625	3.3482	3.3611	50172220.0
2007-04-05 12:00:00	AAPL	Stock	3.3611	3.3646	3.3536	3.3557	35643580.0
2007-04-05 13:00:00	AAPL	Stock	3.3557	3.36	3.3532	3.3582	26339096.0
2007-04-05 14:00:00	AAPL	Stock	3.3582	3.3714	3.3546	3.3689	39462136.0
2007-04-05 15:00:00	AAPL	Stock	3.3686	3.3811	3.365	3.3811	59077116.0
2007-04-05 16:00:00	AAPL	Stock	3.3814	3.3836	3.3693	3.3786	5194616.0
2007-04-05 17:00:00	AAPL	Stock	3.3804	3.3811	3.3779	3.3789	187376.0
2007-04-05 18:00:00	AAPL	Stock	3.3786	3.3786	3.3768	3.3768	23100.0
2007-04-05 19:00:00	AAPL	Stock	3.3771	3.3804	3.3768	3.3804	99176.0
2007-04-05 08:00:00	MSFT	Stock	28.48	28.48	28.4	28.42	5100.0
2007-04-05 09:00:00	MSFT	Stock	28.38	28.56	28.3	28.51	4469336.0
2007-04-05 10:00:00	MSFT	Stock	28.51	28.542	28.47	28.49	3481540.0
2007-04-05 11:00:00	MSFT	Stock	28.49	28.58	28.49	28.52	4167440.0
2007-04-05 12:00:00	MSFT	Stock	28.52	28.55	28.5	28.52	3039557.0
2007-04-05 13:00:00	MSFT	Stock	28.52	28.6	28.52	28.555	2401951.0
2007-04-05 14:00:00	MSFT	Stock	28.55	28.65	28.54	28.55	4180827.0
2007-04-05 15:00:00	MSFT	Stock	28.55	28.61	28.51	28.55	7068966.0
2007-04-05 16:00:00	MSFT	Stock	28.55	28.61	28.51	28.57	110159.0
2007-04-05 17:00:00	MSFT	Stock	28.52	28.52	28.51	28.51	650.0
2007-04-05 19:00:00	MSFT	Stock	28.55	28.55	28.55	28.55	100.0
2007-04-05 08:00:00	NVDA	Stock	0.4803	0.4803	0.4803	0.4803	66000.0
2007-04-05 09:00:00	NVDA	Stock	0.4797	0.4905	0.4783	0.489	87791820.0
2007-04-05 10:00:00	NVDA	Stock	0.4889	0.493	0.488	0.4897	136909260.0
2007-04-05 11:00:00	NVDA	Stock	0.4898	0.51	0.4868	0.509	359538840.0
2007-04-05 12:00:00	NVDA	Stock	0.509	0.511	0.5023	0.5053	185980800.0
2007-04-05 13:00:00	NVDA	Stock	0.5052	0.5107	0.505	0.5075	119376720.0
2007-04-05 14:00:00	NVDA	Stock	0.5073	0.51	0.505	0.5093	121540680.0
2007-04-05 15:00:00	NVDA	Stock	0.5092	0.5155	0.5091	0.5155	286182900.0
2007-04-05 16:00:00	NVDA	Stock	0.5153	0.5155	0.5135	0.515	13174920.0
2007-04-05 17:00:00	NVDA	Stock	0.5142	0.5148	0.5133	0.5135	760140.0
2007-04-05 18:00:00	NVDA	Stock	0.5135	0.5142	0.5133	0.5142	255000.0
2007-04-05 19:00:00	NVDA	Stock	0.5133	0.5155	0.5133	0.515	168000.0
2007-04-05 08:00:00	AMZN	Stock	2.08	2.08	2.0765	2.0765	46000.0
2007-04-05 09:00:00	AMZN	Stock	2.0765	2.0825	2.075	2.0805	7117760.0
2007-04-05 10:00:00	AMZN	Stock	2.0805	2.082	2.073	2.0755	10226720.0
2007-04-05 11:00:00	AMZN	Stock	2.076	2.081	2.072	2.0805	6259620.0
2007-04-05 12:00:00	AMZN	Stock	2.0805	2.088	2.078	2.0845	6898860.0
2007-04-05 13:00:00	AMZN	Stock	2.0845	2.086	2.082	2.086	7295960.0
2007-04-05 14:00:00	AMZN	Stock	2.0855	2.086	2.083	2.084	5064020.0
2007-04-05 15:00:00	AMZN	Stock	2.0835	2.0865	2.079	2.084	14426740.0
2007-04-05 16:00:00	AMZN	Stock	2.084	2.084	2.0805	2.0835	3687660.0
2007-04-05 17:00:00	AMZN	Stock	2.0805	2.0805	2.0805	2.0805	2000.0
2007-04-05 18:00:00	AMZN	Stock	2.0835	2.0835	2.0835	2.0835	24000.0
2007-04-05 19:00:00	AMZN	Stock	2.0835	2.0835	2.0835	2.0835	10000.0
2007-04-05 09:00:00	CL	Stock	33.12	33.22	33.025	33.17	159000.0
2007-04-05 10:00:00	CL	Stock	33.17	33.28	33.125	33.225	454568.0

> showing 50 of 31,772 rows — these rows as CSV

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