PREVIEW / stock_1hour / 2001-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-12-27.parquet
  size:    390 KB
  rows:    18,734
  symbols: 1,365

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
2001-12-27 09:00:00	AAPL	Stock	0.385	0.3966	0.385	0.3927	39076800.0
2001-12-27 10:00:00	AAPL	Stock	0.3932	0.3952	0.3902	0.3948	30559200.0
2001-12-27 11:00:00	AAPL	Stock	0.3946	0.3973	0.3934	0.3954	30385600.0
2001-12-27 12:00:00	AAPL	Stock	0.3954	0.3958	0.3938	0.3946	10074400.0
2001-12-27 13:00:00	AAPL	Stock	0.3945	0.395	0.3891	0.39	16598400.0
2001-12-27 14:00:00	AAPL	Stock	0.39	0.3943	0.3875	0.3891	23458400.0
2001-12-27 15:00:00	AAPL	Stock	0.3902	0.3945	0.3882	0.3941	24768800.0
2001-12-27 16:00:00	AAPL	Stock	0.3939	0.3998	0.3892	0.395	7285600.0
2001-12-27 17:00:00	AAPL	Stock	0.3941	0.3941	0.394	0.3941	1181600.0
2001-12-27 08:00:00	MSFT	Stock	34.0	34.0	33.98	33.9995	1000.0
2001-12-27 09:00:00	MSFT	Stock	34.0	34.31	33.84	34.27	4679400.0
2001-12-27 10:00:00	MSFT	Stock	34.275	34.355	34.175	34.225	4211000.0
2001-12-27 11:00:00	MSFT	Stock	34.23	34.32	34.175	34.215	3556600.0
2001-12-27 12:00:00	MSFT	Stock	34.215	34.255	34.02	34.06	2822400.0
2001-12-27 13:00:00	MSFT	Stock	34.055	34.06	33.79	33.84	3084800.0
2001-12-27 14:00:00	MSFT	Stock	33.84	33.98	33.63	33.695	4894000.0
2001-12-27 15:00:00	MSFT	Stock	33.7005	33.975	33.67	33.925	6644400.0
2001-12-27 16:00:00	MSFT	Stock	33.9	34.285	33.895	33.995	1358200.0
2001-12-27 17:00:00	MSFT	Stock	33.95	33.95	33.9114	33.95	582800.0
2001-12-27 18:00:00	MSFT	Stock	33.925	33.925	33.925	33.925	600.0
2001-12-27 08:00:00	NVDA	Stock	0.5676	0.5685	0.5676	0.5683	384000.0
2001-12-27 09:00:00	NVDA	Stock	0.5708	0.5804	0.5692	0.5791	150420000.0
2001-12-27 10:00:00	NVDA	Stock	0.5791	0.5805	0.5742	0.5775	146112000.0
2001-12-27 11:00:00	NVDA	Stock	0.5775	0.5807	0.5772	0.5799	107628000.0
2001-12-27 12:00:00	NVDA	Stock	0.5799	0.58	0.5777	0.5782	43236000.0
2001-12-27 13:00:00	NVDA	Stock	0.578	0.5783	0.5756	0.5763	54120000.0
2001-12-27 14:00:00	NVDA	Stock	0.5763	0.5783	0.5749	0.5754	88008000.0
2001-12-27 15:00:00	NVDA	Stock	0.5755	0.5792	0.575	0.5782	108684000.0
2001-12-27 16:00:00	NVDA	Stock	0.5779	0.5787	0.57	0.5787	6672000.0
2001-12-27 17:00:00	NVDA	Stock	0.5782	0.5787	0.5771	0.5787	828000.0
2001-12-27 08:00:00	AMZN	Stock	0.558	0.565	0.55	0.559	578000.0
2001-12-27 09:00:00	AMZN	Stock	0.561	0.5745	0.5565	0.56	50098000.0
2001-12-27 10:00:00	AMZN	Stock	0.56	0.5655	0.552	0.559	30884000.0
2001-12-27 11:00:00	AMZN	Stock	0.559	0.562	0.545	0.548	27876000.0
2001-12-27 12:00:00	AMZN	Stock	0.5485	0.55	0.5325	0.5425	22892000.0
2001-12-27 13:00:00	AMZN	Stock	0.5425	0.5425	0.53	0.535	18892000.0
2001-12-27 14:00:00	AMZN	Stock	0.537	0.5397	0.5285	0.531	23022000.0
2001-12-27 15:00:00	AMZN	Stock	0.531	0.5385	0.5295	0.5315	28762000.0
2001-12-27 16:00:00	AMZN	Stock	0.5305	0.5325	0.53	0.53	6862000.0
2001-12-27 17:00:00	AMZN	Stock	0.53	0.5305	0.529	0.529	1662000.0
2001-12-27 18:00:00	AMZN	Stock	0.53	0.5315	0.53	0.531	30000.0
2001-12-27 09:00:00	CL	Stock	28.95	29.025	28.9	28.945	171200.0
2001-12-27 10:00:00	CL	Stock	28.945	28.975	28.875	28.89	135600.0
2001-12-27 11:00:00	CL	Stock	28.89	28.95	28.875	28.925	135000.0
2001-12-27 12:00:00	CL	Stock	28.925	28.965	28.9	28.925	64400.0
2001-12-27 13:00:00	CL	Stock	28.94	29.0	28.875	28.9	91600.0
2001-12-27 14:00:00	CL	Stock	28.895	28.95	28.875	28.925	157800.0
2001-12-27 15:00:00	CL	Stock	28.945	29.1	28.925	29.065	309400.0
2001-12-27 16:00:00	CL	Stock	29.065	29.08	29.065	29.08	114400.0

> showing 49 of 18,734 rows — these rows as CSV

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