PREVIEW / stock_1hour / 2006-02-02

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-02.parquet
  size:    619 KB
  rows:    29,200
  symbols: 2,184

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-02-02 07:00:00	AAPL	Stock	2.6789	2.6789	2.6646	2.6646	5740.0
2006-02-02 08:00:00	AAPL	Stock	2.6789	2.6936	2.675	2.6811	1035216.0
2006-02-02 09:00:00	AAPL	Stock	2.6825	2.6914	2.655	2.6554	77579684.0
2006-02-02 10:00:00	AAPL	Stock	2.6554	2.6575	2.6082	2.6146	172007920.0
2006-02-02 11:00:00	AAPL	Stock	2.6143	2.6264	2.6032	2.6103	106822996.0
2006-02-02 12:00:00	AAPL	Stock	2.61	2.6196	2.5893	2.6021	95607036.0
2006-02-02 13:00:00	AAPL	Stock	2.6014	2.615	2.5986	2.6068	50697472.0
2006-02-02 14:00:00	AAPL	Stock	2.6068	2.6107	2.5886	2.5893	60277896.0
2006-02-02 15:00:00	AAPL	Stock	2.5893	2.6036	2.5732	2.5743	120758288.0
2006-02-02 16:00:00	AAPL	Stock	2.5743	2.5764	2.5536	2.5661	4579764.0
2006-02-02 17:00:00	AAPL	Stock	2.5661	2.575	2.5625	2.5679	5101936.0
2006-02-02 18:00:00	AAPL	Stock	2.5668	2.5693	2.5643	2.5693	343644.0
2006-02-02 07:00:00	MSFT	Stock	27.97	28.0	27.95	27.99	11200.0
2006-02-02 08:00:00	MSFT	Stock	28.0	28.04	27.93	28.04	23273.0
2006-02-02 09:00:00	MSFT	Stock	27.97	28.05	27.82	27.83	5004638.0
2006-02-02 10:00:00	MSFT	Stock	27.83	27.9	27.65	27.7	8717854.0
2006-02-02 11:00:00	MSFT	Stock	27.7	27.71	27.58	27.66	9036552.0
2006-02-02 12:00:00	MSFT	Stock	27.65	27.74	27.6	27.62	4990629.0
2006-02-02 13:00:00	MSFT	Stock	27.62	27.64	27.55	27.63	6385418.0
2006-02-02 14:00:00	MSFT	Stock	27.62	27.67	27.57	27.64	6137701.0
2006-02-02 15:00:00	MSFT	Stock	27.64	27.72	27.59	27.67	11588719.0
2006-02-02 16:00:00	MSFT	Stock	27.68	27.7	27.61	27.62	167724.0
2006-02-02 17:00:00	MSFT	Stock	27.65	27.65	27.63	27.63	700.0
2006-02-02 18:00:00	MSFT	Stock	27.64	27.65	27.63	27.65	5477.0
2006-02-02 08:00:00	NVDA	Stock	0.3749	0.3749	0.3749	0.3749	19320.0
2006-02-02 09:00:00	NVDA	Stock	0.375	0.3786	0.3713	0.3714	49822080.0
2006-02-02 10:00:00	NVDA	Stock	0.3713	0.3723	0.3667	0.3671	71401200.0
2006-02-02 11:00:00	NVDA	Stock	0.3671	0.3682	0.3643	0.3662	65725560.0
2006-02-02 12:00:00	NVDA	Stock	0.3662	0.3689	0.3658	0.3673	77026920.0
2006-02-02 13:00:00	NVDA	Stock	0.3671	0.3671	0.3649	0.3658	49216800.0
2006-02-02 14:00:00	NVDA	Stock	0.3657	0.3657	0.3637	0.3639	44727000.0
2006-02-02 15:00:00	NVDA	Stock	0.3637	0.3654	0.3629	0.363	79478040.0
2006-02-02 16:00:00	NVDA	Stock	0.3637	0.364	0.3627	0.3635	688200.0
2006-02-02 17:00:00	NVDA	Stock	0.3636	0.3636	0.3636	0.3636	22320.0
2006-02-02 18:00:00	NVDA	Stock	0.3613	0.3641	0.3611	0.3641	290760.0
2006-02-02 08:00:00	AMZN	Stock	2.2005	2.2005	2.194	2.194	92000.0
2006-02-02 09:00:00	AMZN	Stock	2.1935	2.202	2.1655	2.1715	23998000.0
2006-02-02 10:00:00	AMZN	Stock	2.1705	2.18	2.1625	2.177	27781880.0
2006-02-02 11:00:00	AMZN	Stock	2.177	2.1845	2.172	2.1725	25147440.0
2006-02-02 12:00:00	AMZN	Stock	2.1725	2.181	2.163	2.1635	18268020.0
2006-02-02 13:00:00	AMZN	Stock	2.1635	2.164	2.148	2.1555	28996260.0
2006-02-02 14:00:00	AMZN	Stock	2.1555	2.169	2.155	2.161	32125180.0
2006-02-02 15:00:00	AMZN	Stock	2.161	2.1935	2.137	2.141	118066080.0
2006-02-02 16:00:00	AMZN	Stock	2.141	2.1625	1.8675	1.9615	159348260.0
2006-02-02 17:00:00	AMZN	Stock	1.964	1.995	1.95	1.9555	35518380.0
2006-02-02 18:00:00	AMZN	Stock	1.9565	1.9625	1.954	1.961	1630760.0
2006-02-02 08:00:00	CL	Stock	27.65	27.65	27.65	27.65	21200.0
2006-02-02 09:00:00	CL	Stock	27.65	27.65	27.5	27.51	388600.0
2006-02-02 10:00:00	CL	Stock	27.505	27.615	27.43	27.585	956000.0
2006-02-02 11:00:00	CL	Stock	27.575	27.595	27.4	27.475	498800.0

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

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