PREVIEW / stock_1hour / 2005-12-16

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-16.parquet
  size:    610 KB
  rows:    28,937
  symbols: 2,155

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
2005-12-16 05:00:00	AAPL	Stock	2.575	2.575	2.575	2.575	10500.0
2005-12-16 08:00:00	AAPL	Stock	2.5929	2.5929	2.5793	2.5875	469252.0
2005-12-16 09:00:00	AAPL	Stock	2.5875	2.5982	2.5429	2.5575	236949076.0
2005-12-16 10:00:00	AAPL	Stock	2.5579	2.5693	2.5539	2.5624	48979896.0
2005-12-16 11:00:00	AAPL	Stock	2.5625	2.58	2.5621	2.5707	54535516.0
2005-12-16 12:00:00	AAPL	Stock	2.5696	2.5757	2.5571	2.5592	48045088.0
2005-12-16 13:00:00	AAPL	Stock	2.5593	2.5664	2.5532	2.5636	39507860.0
2005-12-16 14:00:00	AAPL	Stock	2.5643	2.5704	2.5514	2.5532	45729096.0
2005-12-16 15:00:00	AAPL	Stock	2.5532	2.5614	2.5379	2.54	102944520.0
2005-12-16 16:00:00	AAPL	Stock	2.5396	2.5486	2.5379	2.5418	15579088.0
2005-12-16 17:00:00	AAPL	Stock	2.5421	2.5491	2.5396	2.5414	1503152.0
2005-12-16 18:00:00	AAPL	Stock	2.5411	2.5479	2.5393	2.5411	2315936.0
2005-12-16 07:00:00	MSFT	Stock	27.0	27.0	26.95	26.95	2000.0
2005-12-16 08:00:00	MSFT	Stock	26.9	27.03	26.9	26.96	29220.0
2005-12-16 09:00:00	MSFT	Stock	26.97	27.05	26.81	26.85	28703847.0
2005-12-16 10:00:00	MSFT	Stock	26.85	26.93	26.84	26.92	7552469.0
2005-12-16 11:00:00	MSFT	Stock	26.92	27.08	26.89	26.94	4785501.0
2005-12-16 12:00:00	MSFT	Stock	26.94	27.06	26.89	26.95	6050371.0
2005-12-16 13:00:00	MSFT	Stock	26.95	26.99	26.87	26.95	6075555.0
2005-12-16 14:00:00	MSFT	Stock	26.95	27.005	26.93	26.97	7223892.0
2005-12-16 15:00:00	MSFT	Stock	26.97	27.05	26.9	26.92	13664992.0
2005-12-16 16:00:00	MSFT	Stock	26.97	26.97	26.82	26.9	2732093.0
2005-12-16 17:00:00	MSFT	Stock	26.96	26.96	26.84	26.89	394202.0
2005-12-16 18:00:00	MSFT	Stock	26.86	26.908	26.84	26.87	75210.0
2005-12-16 08:00:00	NVDA	Stock	0.3042	0.3071	0.3	0.3071	240000.0
2005-12-16 09:00:00	NVDA	Stock	0.3054	0.3079	0.3046	0.3074	49632360.0
2005-12-16 10:00:00	NVDA	Stock	0.3074	0.3076	0.3048	0.3062	23058240.0
2005-12-16 11:00:00	NVDA	Stock	0.3062	0.3076	0.3061	0.3065	16759920.0
2005-12-16 12:00:00	NVDA	Stock	0.3066	0.3076	0.3058	0.3072	18617400.0
2005-12-16 13:00:00	NVDA	Stock	0.3074	0.3074	0.3053	0.3061	22544400.0
2005-12-16 14:00:00	NVDA	Stock	0.3061	0.3075	0.3058	0.3059	37190280.0
2005-12-16 15:00:00	NVDA	Stock	0.3058	0.3084	0.3026	0.3077	227624280.0
2005-12-16 16:00:00	NVDA	Stock	0.3073	0.3087	0.3055	0.3071	41940840.0
2005-12-16 17:00:00	NVDA	Stock	0.3071	0.3071	0.3069	0.3069	13742880.0
2005-12-16 08:00:00	AMZN	Stock	2.475	2.475	2.475	2.475	20000.0
2005-12-16 09:00:00	AMZN	Stock	2.474	2.491	2.4625	2.4815	37089040.0
2005-12-16 10:00:00	AMZN	Stock	2.482	2.496	2.477	2.4855	10129120.0
2005-12-16 11:00:00	AMZN	Stock	2.485	2.4884	2.469	2.4695	7781360.0
2005-12-16 12:00:00	AMZN	Stock	2.47	2.474	2.464	2.468	6870740.0
2005-12-16 13:00:00	AMZN	Stock	2.4685	2.4775	2.465	2.4775	5659880.0
2005-12-16 14:00:00	AMZN	Stock	2.4765	2.484	2.467	2.4675	9401920.0
2005-12-16 15:00:00	AMZN	Stock	2.4675	2.472	2.4605	2.4605	23165760.0
2005-12-16 16:00:00	AMZN	Stock	2.462	2.4655	2.4595	2.4605	1727520.0
2005-12-16 17:00:00	AMZN	Stock	2.4605	2.4618	2.4593	2.4618	728680.0
2005-12-16 18:00:00	AMZN	Stock	2.4615	2.4615	2.4615	2.4615	7900.0
2005-12-16 08:00:00	CL	Stock	28.195	28.195	28.195	28.195	6200.0
2005-12-16 09:00:00	CL	Stock	28.27	28.48	28.27	28.435	1221400.0
2005-12-16 10:00:00	CL	Stock	28.43	28.575	28.39	28.55	935000.0
2005-12-16 11:00:00	CL	Stock	28.54	28.54	28.155	28.16	595400.0
2005-12-16 12:00:00	CL	Stock	28.16	28.265	28.13	28.135	320800.0

> showing 50 of 28,937 rows — these rows as CSV

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