PREVIEW / stock_1hour / 2008-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-09.parquet
  size:    828 KB
  rows:    39,920
  symbols: 3,271

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
2008-05-09 07:00:00	AAPL	Stock	6.5661	6.5857	6.5571	6.5571	110600.0
2008-05-09 08:00:00	AAPL	Stock	6.5561	6.5804	6.5529	6.5729	3994116.0
2008-05-09 09:00:00	AAPL	Stock	6.5732	6.575	6.5325	6.5507	103828452.0
2008-05-09 10:00:00	AAPL	Stock	6.5507	6.5804	6.525	6.55	146480096.0
2008-05-09 11:00:00	AAPL	Stock	6.55	6.5554	6.5054	6.5207	83234060.0
2008-05-09 12:00:00	AAPL	Stock	6.5204	6.5221	6.4775	6.5179	78804012.0
2008-05-09 13:00:00	AAPL	Stock	6.5179	6.5232	6.4875	6.5186	65763432.0
2008-05-09 14:00:00	AAPL	Stock	6.5182	6.5346	6.5096	6.5229	63657860.0
2008-05-09 15:00:00	AAPL	Stock	6.5232	6.5579	6.5125	6.5468	110532828.0
2008-05-09 16:00:00	AAPL	Stock	6.5489	6.5568	6.5004	6.5529	5370036.0
2008-05-09 17:00:00	AAPL	Stock	6.5507	6.5625	6.5482	6.5571	399952.0
2008-05-09 18:00:00	AAPL	Stock	6.5546	6.5571	6.5507	6.5571	179200.0
2008-05-09 19:00:00	AAPL	Stock	6.5554	6.5568	6.5525	6.5546	181720.0
2008-05-09 06:00:00	MSFT	Stock	29.25	29.25	29.25	29.25	100.0
2008-05-09 08:00:00	MSFT	Stock	29.2	29.2	29.04	29.08	18625.0
2008-05-09 09:00:00	MSFT	Stock	29.07	29.21	28.95	29.12	7101542.0
2008-05-09 10:00:00	MSFT	Stock	29.12	29.55	29.1	29.44	11434457.0
2008-05-09 11:00:00	MSFT	Stock	29.45	29.52	29.35	29.43	7780033.0
2008-05-09 12:00:00	MSFT	Stock	29.43	29.48	29.39	29.43	4096057.0
2008-05-09 13:00:00	MSFT	Stock	29.43	29.44	29.24	29.36	3881706.0
2008-05-09 14:00:00	MSFT	Stock	29.361	29.4	29.31	29.37	5294529.0
2008-05-09 15:00:00	MSFT	Stock	29.36	29.44	29.32	29.39	9690883.0
2008-05-09 16:00:00	MSFT	Stock	29.39	29.47	29.31	29.37	911842.0
2008-05-09 17:00:00	MSFT	Stock	29.35	29.38	29.108	29.37	47432.0
2008-05-09 18:00:00	MSFT	Stock	29.37	29.37	29.37	29.37	4051.0
2008-05-09 19:00:00	MSFT	Stock	29.37	29.39	29.34	29.34	7990.0
2008-05-09 04:00:00	NVDA	Stock	0.5287	0.5287	0.5287	0.5287	10000.0
2008-05-09 06:00:00	NVDA	Stock	0.5322	0.5322	0.5322	0.5322	4000.0
2008-05-09 07:00:00	NVDA	Stock	0.525	0.5395	0.525	0.5395	113960.0
2008-05-09 08:00:00	NVDA	Stock	0.5325	0.5612	0.5312	0.5502	38385160.0
2008-05-09 09:00:00	NVDA	Stock	0.5508	0.5738	0.5465	0.558	525436880.0
2008-05-09 10:00:00	NVDA	Stock	0.5582	0.5788	0.5555	0.5752	487489080.0
2008-05-09 11:00:00	NVDA	Stock	0.5752	0.5848	0.5722	0.5848	156304040.0
2008-05-09 12:00:00	NVDA	Stock	0.5845	0.5858	0.5765	0.5792	132325800.0
2008-05-09 13:00:00	NVDA	Stock	0.5792	0.5792	0.566	0.5662	152272640.0
2008-05-09 14:00:00	NVDA	Stock	0.5662	0.5712	0.561	0.5612	173292600.0
2008-05-09 15:00:00	NVDA	Stock	0.5612	0.5635	0.5542	0.5632	297215040.0
2008-05-09 16:00:00	NVDA	Stock	0.5632	0.5706	0.5589	0.565	59654200.0
2008-05-09 17:00:00	NVDA	Stock	0.5645	0.565	0.5645	0.565	122400.0
2008-05-09 18:00:00	NVDA	Stock	0.565	0.565	0.565	0.565	188880.0
2008-05-09 19:00:00	NVDA	Stock	0.5662	0.5735	0.565	0.5735	972800.0
2008-05-09 08:00:00	AMZN	Stock	3.635	3.639	3.605	3.6245	10400.0
2008-05-09 09:00:00	AMZN	Stock	3.608	3.667	3.593	3.5945	14044020.0
2008-05-09 10:00:00	AMZN	Stock	3.5945	3.648	3.5945	3.618	14367800.0
2008-05-09 11:00:00	AMZN	Stock	3.6175	3.625	3.6085	3.6126	10155980.0
2008-05-09 12:00:00	AMZN	Stock	3.613	3.6145	3.5925	3.608	6953320.0
2008-05-09 13:00:00	AMZN	Stock	3.6065	3.612	3.583	3.6065	9560960.0
2008-05-09 14:00:00	AMZN	Stock	3.6065	3.6165	3.589	3.6005	8763460.0
2008-05-09 15:00:00	AMZN	Stock	3.601	3.6205	3.5935	3.619	15990560.0
2008-05-09 16:00:00	AMZN	Stock	3.6205	3.6205	3.571	3.595	2265380.0

> showing 50 of 39,920 rows — these rows as CSV

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