PREVIEW / stock_1hour / 2006-02-08

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-08.parquet
  size:    579 KB
  rows:    27,620
  symbols: 2,191

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-08 06:00:00	AAPL	Stock	2.4304	2.4304	2.4304	2.4304	2800.0
2006-02-08 07:00:00	AAPL	Stock	2.4304	2.4304	2.4304	2.4304	2800.0
2006-02-08 08:00:00	AAPL	Stock	2.4346	2.4464	2.4321	2.4364	4849768.0
2006-02-08 09:00:00	AAPL	Stock	2.4375	2.4554	2.4004	2.4089	117296788.0
2006-02-08 10:00:00	AAPL	Stock	2.4089	2.41	2.3571	2.3896	233406516.0
2006-02-08 11:00:00	AAPL	Stock	2.39	2.445	2.3782	2.4186	113130808.0
2006-02-08 12:00:00	AAPL	Stock	2.4189	2.4671	2.4186	2.4522	156402764.0
2006-02-08 13:00:00	AAPL	Stock	2.4521	2.4561	2.4293	2.4346	87550344.0
2006-02-08 14:00:00	AAPL	Stock	2.4339	2.4411	2.4186	2.4375	79400888.0
2006-02-08 15:00:00	AAPL	Stock	2.4368	2.4643	2.4336	2.4557	139339060.0
2006-02-08 16:00:00	AAPL	Stock	2.4557	2.4575	2.4482	2.4543	4341708.0
2006-02-08 17:00:00	AAPL	Stock	2.4539	2.4575	2.4536	2.4554	5692596.0
2006-02-08 18:00:00	AAPL	Stock	2.4568	2.4571	2.4546	2.4554	150640.0
2006-02-08 06:00:00	MSFT	Stock	27.0	27.05	27.0	27.0	700.0
2006-02-08 07:00:00	MSFT	Stock	27.18	27.18	27.18	27.18	200.0
2006-02-08 08:00:00	MSFT	Stock	27.04	27.1	27.04	27.09	22217.0
2006-02-08 09:00:00	MSFT	Stock	27.1	27.13	26.87	26.89	6269693.0
2006-02-08 10:00:00	MSFT	Stock	26.9	26.94	26.75	26.76	8013344.0
2006-02-08 11:00:00	MSFT	Stock	26.76	26.83	26.71	26.772	6569344.0
2006-02-08 12:00:00	MSFT	Stock	26.77	26.9	26.77	26.83	7362091.0
2006-02-08 13:00:00	MSFT	Stock	26.82	26.85	26.79	26.85	3294569.0
2006-02-08 14:00:00	MSFT	Stock	26.84	26.89	26.78	26.81	7105739.0
2006-02-08 15:00:00	MSFT	Stock	26.82	26.937	26.8	26.91	10906914.0
2006-02-08 16:00:00	MSFT	Stock	26.92	26.95	26.86	26.95	320971.0
2006-02-08 17:00:00	MSFT	Stock	26.91	26.94	26.9	26.92	5876.0
2006-02-08 18:00:00	MSFT	Stock	26.9	26.92	26.9	26.9	401.0
2006-02-08 09:00:00	NVDA	Stock	0.3659	0.3696	0.3648	0.3689	38793840.0
2006-02-08 10:00:00	NVDA	Stock	0.3688	0.3726	0.368	0.372	64224000.0
2006-02-08 11:00:00	NVDA	Stock	0.3721	0.3724	0.3702	0.3717	40464240.0
2006-02-08 12:00:00	NVDA	Stock	0.3716	0.3736	0.3702	0.3702	49733280.0
2006-02-08 13:00:00	NVDA	Stock	0.3703	0.3711	0.3687	0.3687	49586040.0
2006-02-08 14:00:00	NVDA	Stock	0.3687	0.3697	0.3676	0.3691	47019000.0
2006-02-08 15:00:00	NVDA	Stock	0.3692	0.3742	0.369	0.3742	89045400.0
2006-02-08 16:00:00	NVDA	Stock	0.3743	0.3746	0.3722	0.3722	766080.0
2006-02-08 18:00:00	NVDA	Stock	0.3714	0.3714	0.3714	0.3714	84000.0
2006-02-08 09:00:00	AMZN	Stock	1.885	1.891	1.8555	1.861	21818760.0
2006-02-08 10:00:00	AMZN	Stock	1.8606	1.871	1.8577	1.863	20868460.0
2006-02-08 11:00:00	AMZN	Stock	1.8635	1.897	1.863	1.8965	20013220.0
2006-02-08 12:00:00	AMZN	Stock	1.8965	1.909	1.892	1.8996	18806760.0
2006-02-08 13:00:00	AMZN	Stock	1.9	1.9015	1.884	1.9005	11667240.0
2006-02-08 14:00:00	AMZN	Stock	1.9005	1.9025	1.887	1.8975	19664400.0
2006-02-08 15:00:00	AMZN	Stock	1.8975	1.9195	1.8955	1.9085	31524240.0
2006-02-08 16:00:00	AMZN	Stock	1.9085	1.9085	1.856	1.905	335800.0
2006-02-08 17:00:00	AMZN	Stock	1.9085	1.9085	1.905	1.905	2521000.0
2006-02-08 18:00:00	AMZN	Stock	1.91	1.91	1.9085	1.9085	18000.0
2006-02-08 09:00:00	CL	Stock	26.86	26.905	26.8	26.85	322200.0
2006-02-08 10:00:00	CL	Stock	26.85	27.015	26.78	27.005	467400.0
2006-02-08 11:00:00	CL	Stock	27.005	27.09	26.98	27.03	320600.0
2006-02-08 12:00:00	CL	Stock	27.031	27.04	26.925	26.925	330600.0
2006-02-08 13:00:00	CL	Stock	26.9285	26.98	26.89	26.975	274400.0

> showing 50 of 27,620 rows — these rows as CSV

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