PREVIEW / stock_1hour / 2007-12-03

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-03.parquet
  size:    819 KB
  rows:    40,699
  symbols: 3,223

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-12-03 04:00:00	AAPL	Stock	6.4929	6.4929	6.4929	6.4929	12544.0
2007-12-03 06:00:00	AAPL	Stock	6.4696	6.5	6.4696	6.4975	64400.0
2007-12-03 07:00:00	AAPL	Stock	6.5061	6.5161	6.4732	6.5071	205660.0
2007-12-03 08:00:00	AAPL	Stock	6.4964	6.5464	6.475	6.4757	4182752.0
2007-12-03 09:00:00	AAPL	Stock	6.4786	6.5	6.3882	6.3986	134129856.0
2007-12-03 10:00:00	AAPL	Stock	6.3989	6.5357	6.3846	6.5271	189495404.0
2007-12-03 11:00:00	AAPL	Stock	6.5275	6.5764	6.5004	6.5307	127991276.0
2007-12-03 12:00:00	AAPL	Stock	6.53	6.5339	6.4757	6.4764	88046952.0
2007-12-03 13:00:00	AAPL	Stock	6.4761	6.4818	6.4232	6.4486	111802180.0
2007-12-03 14:00:00	AAPL	Stock	6.4486	6.4732	6.4157	6.4589	87925460.0
2007-12-03 15:00:00	AAPL	Stock	6.4582	6.4614	6.3464	6.3921	190001952.0
2007-12-03 16:00:00	AAPL	Stock	6.3921	6.547	6.3877	6.3943	19148976.0
2007-12-03 17:00:00	AAPL	Stock	6.3964	6.4607	6.3879	6.3946	7643300.0
2007-12-03 18:00:00	AAPL	Stock	6.3971	6.4071	6.3929	6.3929	348852.0
2007-12-03 19:00:00	AAPL	Stock	6.3929	6.3982	6.3857	6.3982	494620.0
2007-12-03 08:00:00	MSFT	Stock	33.5	33.69	33.5	33.55	34889.0
2007-12-03 09:00:00	MSFT	Stock	33.6	33.64	33.36	33.49	5521814.0
2007-12-03 10:00:00	MSFT	Stock	33.5	33.54	33.22	33.4	8526598.0
2007-12-03 11:00:00	MSFT	Stock	33.402	33.5	33.33	33.43	5916062.0
2007-12-03 12:00:00	MSFT	Stock	33.43	33.49	33.39	33.4	3136240.0
2007-12-03 13:00:00	MSFT	Stock	33.4	33.41	32.9	32.96	9627239.0
2007-12-03 14:00:00	MSFT	Stock	32.95	33.08	32.68	32.83	10003561.0
2007-12-03 15:00:00	MSFT	Stock	32.84	32.99	32.75	32.94	14432918.0
2007-12-03 16:00:00	MSFT	Stock	32.93	33.37	32.876	32.92	4486308.0
2007-12-03 17:00:00	MSFT	Stock	32.97	33.196	32.77	32.87	35777.0
2007-12-03 18:00:00	MSFT	Stock	32.9	32.95	32.868	32.94	53400.0
2007-12-03 19:00:00	MSFT	Stock	32.95	32.97	32.95	32.97	5000.0
2007-12-03 08:00:00	NVDA	Stock	0.8	0.8062	0.7885	0.801	912480.0
2007-12-03 09:00:00	NVDA	Stock	0.8	0.8148	0.7938	0.7995	79888840.0
2007-12-03 10:00:00	NVDA	Stock	0.7992	0.8068	0.7878	0.806	78153080.0
2007-12-03 11:00:00	NVDA	Stock	0.8062	0.812	0.799	0.8113	52367640.0
2007-12-03 12:00:00	NVDA	Stock	0.8113	0.8135	0.8052	0.806	47406240.0
2007-12-03 13:00:00	NVDA	Stock	0.806	0.8098	0.799	0.8002	53396040.0
2007-12-03 14:00:00	NVDA	Stock	0.8002	0.806	0.7938	0.8025	52311800.0
2007-12-03 15:00:00	NVDA	Stock	0.8025	0.8055	0.7955	0.7998	92548080.0
2007-12-03 16:00:00	NVDA	Stock	0.799	0.8039	0.797	0.8	19927440.0
2007-12-03 17:00:00	NVDA	Stock	0.8	0.805	0.8	0.805	215360.0
2007-12-03 18:00:00	NVDA	Stock	0.805	0.807	0.8007	0.807	560320.0
2007-12-03 19:00:00	NVDA	Stock	0.8072	0.8072	0.8062	0.8062	78000.0
2007-12-03 08:00:00	AMZN	Stock	4.5345	4.535	4.5025	4.5025	259160.0
2007-12-03 09:00:00	AMZN	Stock	4.5075	4.6125	4.4885	4.5815	21391520.0
2007-12-03 10:00:00	AMZN	Stock	4.5815	4.6115	4.559	4.596	22908780.0
2007-12-03 11:00:00	AMZN	Stock	4.595	4.6025	4.5605	4.563	13307920.0
2007-12-03 12:00:00	AMZN	Stock	4.564	4.597	4.5615	4.578	8141320.0
2007-12-03 13:00:00	AMZN	Stock	4.5775	4.581	4.5615	4.5675	10598020.0
2007-12-03 14:00:00	AMZN	Stock	4.568	4.5845	4.547	4.564	13217240.0
2007-12-03 15:00:00	AMZN	Stock	4.5635	4.581	4.5325	4.5465	22745140.0
2007-12-03 16:00:00	AMZN	Stock	4.5535	4.5858	4.5455	4.5765	6450020.0
2007-12-03 17:00:00	AMZN	Stock	4.5712	4.5773	4.528	4.57	878580.0
2007-12-03 18:00:00	AMZN	Stock	4.563	4.5695	4.5495	4.5695	9700.0

> showing 50 of 40,699 rows — these rows as CSV

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