PREVIEW / stock_1hour / 2006-02-03

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-03.parquet
  size:    594 KB
  rows:    28,143
  symbols: 2,180

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-03 07:00:00	AAPL	Stock	2.5779	2.5779	2.5768	2.5768	54684.0
2006-02-03 08:00:00	AAPL	Stock	2.5714	2.5921	2.5714	2.5857	4383736.0
2006-02-03 09:00:00	AAPL	Stock	2.5829	2.5829	2.5375	2.5604	100285724.0
2006-02-03 10:00:00	AAPL	Stock	2.5604	2.5996	2.5571	2.5896	165466140.0
2006-02-03 11:00:00	AAPL	Stock	2.5875	2.5964	2.575	2.5843	85622712.0
2006-02-03 12:00:00	AAPL	Stock	2.5839	2.5857	2.5611	2.5643	49034664.0
2006-02-03 13:00:00	AAPL	Stock	2.5643	2.5864	2.5639	2.5711	65481276.0
2006-02-03 14:00:00	AAPL	Stock	2.5711	2.5721	2.5489	2.56	64155672.0
2006-02-03 15:00:00	AAPL	Stock	2.5604	2.5707	2.5371	2.5661	142438520.0
2006-02-03 16:00:00	AAPL	Stock	2.5664	2.5675	2.56	2.56	2506000.0
2006-02-03 17:00:00	AAPL	Stock	2.5643	2.5668	2.5625	2.5661	147056.0
2006-02-03 18:00:00	AAPL	Stock	2.5661	2.5661	2.5625	2.5625	37464.0
2006-02-03 08:00:00	MSFT	Stock	27.65	27.68	27.55	27.55	29952.0
2006-02-03 09:00:00	MSFT	Stock	27.55	27.6	27.34	27.42	7581097.0
2006-02-03 10:00:00	MSFT	Stock	27.42	27.55	27.391	27.55	12193554.0
2006-02-03 11:00:00	MSFT	Stock	27.54	27.66	27.5	27.58	14545234.0
2006-02-03 12:00:00	MSFT	Stock	27.58	27.67	27.55	27.58	6627421.0
2006-02-03 13:00:00	MSFT	Stock	27.58	27.7	27.55	27.6	7368778.0
2006-02-03 14:00:00	MSFT	Stock	27.6	27.64	27.48	27.52	11677374.0
2006-02-03 15:00:00	MSFT	Stock	27.52	27.56	27.46	27.54	13300653.0
2006-02-03 16:00:00	MSFT	Stock	27.53	27.54	27.48	27.51	372469.0
2006-02-03 17:00:00	MSFT	Stock	27.51	27.65	27.51	27.6	12668.0
2006-02-03 18:00:00	MSFT	Stock	27.6	27.6	27.6	27.6	800.0
2006-02-03 08:00:00	NVDA	Stock	0.3635	0.3635	0.3593	0.3593	96000.0
2006-02-03 09:00:00	NVDA	Stock	0.3592	0.3642	0.3575	0.3636	48654960.0
2006-02-03 10:00:00	NVDA	Stock	0.3637	0.3675	0.3636	0.3657	73822680.0
2006-02-03 11:00:00	NVDA	Stock	0.366	0.3713	0.3634	0.3665	131432160.0
2006-02-03 12:00:00	NVDA	Stock	0.3667	0.3693	0.3643	0.3661	42067320.0
2006-02-03 13:00:00	NVDA	Stock	0.3663	0.3697	0.3658	0.3662	40347240.0
2006-02-03 14:00:00	NVDA	Stock	0.3662	0.3681	0.364	0.3677	45677760.0
2006-02-03 15:00:00	NVDA	Stock	0.3679	0.3682	0.3647	0.3667	91552440.0
2006-02-03 16:00:00	NVDA	Stock	0.3668	0.3674	0.3666	0.3668	552840.0
2006-02-03 04:00:00	AMZN	Stock	1.95	1.95	1.95	1.95	4600.0
2006-02-03 05:00:00	AMZN	Stock	1.95	1.9505	1.95	1.95	34600.0
2006-02-03 06:00:00	AMZN	Stock	1.93	1.934	1.915	1.925	237400.0
2006-02-03 07:00:00	AMZN	Stock	1.925	1.9255	1.896	1.896	180000.0
2006-02-03 08:00:00	AMZN	Stock	1.9	1.937	1.895	1.93	14656840.0
2006-02-03 09:00:00	AMZN	Stock	1.93	1.931	1.8755	1.8995	174492260.0
2006-02-03 10:00:00	AMZN	Stock	1.8995	1.905	1.869	1.8735	164525840.0
2006-02-03 11:00:00	AMZN	Stock	1.873	1.9045	1.8685	1.8935	63432120.0
2006-02-03 12:00:00	AMZN	Stock	1.894	1.9085	1.8835	1.895	46708520.0
2006-02-03 13:00:00	AMZN	Stock	1.895	1.925	1.8915	1.9085	57795960.0
2006-02-03 14:00:00	AMZN	Stock	1.9095	1.9135	1.889	1.8915	45691000.0
2006-02-03 15:00:00	AMZN	Stock	1.892	1.919	1.8885	1.9165	93705660.0
2006-02-03 16:00:00	AMZN	Stock	1.9165	1.92	1.912	1.917	3328000.0
2006-02-03 17:00:00	AMZN	Stock	1.9175	1.9175	1.915	1.915	51900.0
2006-02-03 18:00:00	AMZN	Stock	1.9175	1.918	1.9175	1.918	30000.0
2006-02-03 09:00:00	CL	Stock	27.225	27.4	27.205	27.385	295200.0
2006-02-03 10:00:00	CL	Stock	27.385	27.445	27.23	27.3	477000.0
2006-02-03 11:00:00	CL	Stock	27.29	27.355	27.23	27.33	371600.0

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

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