PREVIEW / stock_1hour / 2006-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-03.parquet
  size:    615 KB
  rows:    29,520
  symbols: 2,311

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-08-03 07:00:00	AAPL	Stock	2.4304	2.4304	2.4304	2.4304	2800.0
2006-08-03 08:00:00	AAPL	Stock	2.425	2.4336	2.3664	2.4182	2895480.0
2006-08-03 09:00:00	AAPL	Stock	2.4175	2.4579	2.4175	2.4564	92935724.0
2006-08-03 10:00:00	AAPL	Stock	2.4564	2.4857	2.4375	2.48	221284616.0
2006-08-03 11:00:00	AAPL	Stock	2.4796	2.4804	2.4493	2.4539	96056940.0
2006-08-03 12:00:00	AAPL	Stock	2.4539	2.4657	2.4529	2.4654	46229484.0
2006-08-03 13:00:00	AAPL	Stock	2.465	2.4975	2.4646	2.495	128881060.0
2006-08-03 14:00:00	AAPL	Stock	2.4954	2.5	2.4904	2.4975	108034248.0
2006-08-03 15:00:00	AAPL	Stock	2.4975	2.4989	2.4779	2.4871	134594180.0
2006-08-03 16:00:00	AAPL	Stock	2.4857	2.4929	2.4744	2.4929	3147004.0
2006-08-03 17:00:00	AAPL	Stock	2.4911	2.4911	2.4861	2.4886	224952.0
2006-08-03 18:00:00	AAPL	Stock	2.4875	2.4875	2.4807	2.4807	210784.0
2006-08-03 06:00:00	MSFT	Stock	24.2	24.2	24.2	24.2	2400.0
2006-08-03 07:00:00	MSFT	Stock	24.2	24.2	24.2	24.2	100.0
2006-08-03 08:00:00	MSFT	Stock	24.3	24.3	24.09	24.12	58160.0
2006-08-03 09:00:00	MSFT	Stock	24.12	24.42	24.1	24.39	5157565.0
2006-08-03 10:00:00	MSFT	Stock	24.38	24.43	24.34	24.41	5959094.0
2006-08-03 11:00:00	MSFT	Stock	24.41	24.43	24.26	24.28	3654482.0
2006-08-03 12:00:00	MSFT	Stock	24.29	24.31	24.26	24.27	2836581.0
2006-08-03 13:00:00	MSFT	Stock	24.27	24.44	24.27	24.422	6413898.0
2006-08-03 14:00:00	MSFT	Stock	24.42	24.48	24.35	24.39	6914916.0
2006-08-03 15:00:00	MSFT	Stock	24.39	24.4	24.2	24.22	8576910.0
2006-08-03 16:00:00	MSFT	Stock	24.23	24.24	24.14	24.23	189736.0
2006-08-03 17:00:00	MSFT	Stock	24.18	24.23	24.17	24.19	22400.0
2006-08-03 18:00:00	MSFT	Stock	24.21	24.21	24.2	24.2	200.0
2006-08-03 06:00:00	NVDA	Stock	0.3833	0.3833	0.3833	0.3833	6000.0
2006-08-03 07:00:00	NVDA	Stock	0.3808	0.3832	0.3808	0.3832	497880.0
2006-08-03 08:00:00	NVDA	Stock	0.3825	0.3898	0.3792	0.3858	5514540.0
2006-08-03 09:00:00	NVDA	Stock	0.3858	0.3862	0.3747	0.3832	96075660.0
2006-08-03 10:00:00	NVDA	Stock	0.3832	0.3978	0.3832	0.3935	180586440.0
2006-08-03 11:00:00	NVDA	Stock	0.3935	0.3943	0.3892	0.3922	82864080.0
2006-08-03 12:00:00	NVDA	Stock	0.3922	0.397	0.392	0.396	61299780.0
2006-08-03 13:00:00	NVDA	Stock	0.3958	0.403	0.3958	0.4017	105536160.0
2006-08-03 14:00:00	NVDA	Stock	0.4017	0.4157	0.4015	0.4125	183403380.0
2006-08-03 15:00:00	NVDA	Stock	0.4125	0.4133	0.4043	0.4053	150432360.0
2006-08-03 16:00:00	NVDA	Stock	0.4052	0.4058	0.3984	0.405	858420.0
2006-08-03 17:00:00	NVDA	Stock	0.405	0.4058	0.4043	0.4058	312720.0
2006-08-03 07:00:00	AMZN	Stock	1.2995	1.2995	1.2995	1.2995	6000.0
2006-08-03 08:00:00	AMZN	Stock	1.2995	1.3045	1.295	1.295	502380.0
2006-08-03 09:00:00	AMZN	Stock	1.295	1.31	1.295	1.3075	9089360.0
2006-08-03 10:00:00	AMZN	Stock	1.3072	1.308	1.299	1.3015	14909660.0
2006-08-03 11:00:00	AMZN	Stock	1.3015	1.314	1.301	1.3135	13415300.0
2006-08-03 12:00:00	AMZN	Stock	1.3135	1.3305	1.3105	1.3215	16867220.0
2006-08-03 13:00:00	AMZN	Stock	1.322	1.345	1.322	1.3395	21822660.0
2006-08-03 14:00:00	AMZN	Stock	1.34	1.34	1.322	1.3365	17955320.0
2006-08-03 15:00:00	AMZN	Stock	1.337	1.3445	1.3285	1.3315	37888880.0
2006-08-03 16:00:00	AMZN	Stock	1.332	1.334	1.3244	1.3265	1632480.0
2006-08-03 17:00:00	AMZN	Stock	1.33	1.33	1.33	1.33	2000.0
2006-08-03 18:00:00	AMZN	Stock	1.3295	1.3295	1.3295	1.3295	7980.0
2006-08-03 09:00:00	CL	Stock	29.425	29.62	29.395	29.575	333800.0

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

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