PREVIEW / stock_1hour / 2008-12-10

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-10.parquet
  size:    791 KB
  rows:    40,190
  symbols: 3,327

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-12-10 04:00:00	AAPL	Stock	3.5357	3.6107	3.4643	3.6107	11200.0
2008-12-10 05:00:00	AAPL	Stock	3.6064	3.6064	3.6064	3.6064	5600.0
2008-12-10 06:00:00	AAPL	Stock	3.5875	3.5875	3.5375	3.5568	141680.0
2008-12-10 07:00:00	AAPL	Stock	3.5568	3.5661	3.5146	3.5179	2099692.0
2008-12-10 08:00:00	AAPL	Stock	3.5264	3.5589	3.51	3.5261	4853324.0
2008-12-10 09:00:00	AAPL	Stock	3.5236	3.53	3.4643	3.5268	137940320.0
2008-12-10 10:00:00	AAPL	Stock	3.5268	3.5532	3.4657	3.4779	163174592.0
2008-12-10 11:00:00	AAPL	Stock	3.4782	3.5064	3.4561	3.4725	125454644.0
2008-12-10 12:00:00	AAPL	Stock	3.4725	3.4929	3.4554	3.4643	99220100.0
2008-12-10 13:00:00	AAPL	Stock	3.4639	3.4996	3.4482	3.4575	93710568.0
2008-12-10 14:00:00	AAPL	Stock	3.4575	3.4964	3.4464	3.4731	126586656.0
2008-12-10 15:00:00	AAPL	Stock	3.4739	3.5214	3.4679	3.5029	151845708.0
2008-12-10 16:00:00	AAPL	Stock	3.5043	3.5107	3.4671	3.5054	14628796.0
2008-12-10 17:00:00	AAPL	Stock	3.5036	3.5054	3.5007	3.5025	115416.0
2008-12-10 18:00:00	AAPL	Stock	3.5021	3.5075	3.5018	3.5029	343728.0
2008-12-10 19:00:00	AAPL	Stock	3.5029	3.5036	3.4971	3.5036	243320.0
2008-12-10 08:00:00	MSFT	Stock	20.9	20.9	20.75	20.75	8090.0
2008-12-10 09:00:00	MSFT	Stock	20.72	20.95	20.5	20.8	5279657.0
2008-12-10 10:00:00	MSFT	Stock	20.8	20.82	20.38	20.39	7726410.0
2008-12-10 11:00:00	MSFT	Stock	20.39	20.9	20.34	20.82	7445542.0
2008-12-10 12:00:00	MSFT	Stock	20.82	20.96	20.55	20.621	5959063.0
2008-12-10 13:00:00	MSFT	Stock	20.621	20.82	20.55	20.56	7186507.0
2008-12-10 14:00:00	MSFT	Stock	20.56	20.59	20.3	20.51	10573310.0
2008-12-10 15:00:00	MSFT	Stock	20.51	20.9	20.44	20.58	13189721.0
2008-12-10 16:00:00	MSFT	Stock	20.56	20.75	20.48	20.61	3391243.0
2008-12-10 17:00:00	MSFT	Stock	20.55	20.55	20.53	20.53	1562.0
2008-12-10 18:00:00	MSFT	Stock	20.57	20.57	20.53	20.53	2277.0
2008-12-10 19:00:00	MSFT	Stock	20.53	20.56	20.5	20.56	1441.0
2008-12-10 07:00:00	NVDA	Stock	0.2027	0.2027	0.2027	0.2027	80000.0
2008-12-10 08:00:00	NVDA	Stock	0.1995	0.2	0.1965	0.2	224000.0
2008-12-10 09:00:00	NVDA	Stock	0.2005	0.2075	0.1958	0.206	130654280.0
2008-12-10 10:00:00	NVDA	Stock	0.206	0.2125	0.206	0.2092	160348440.0
2008-12-10 11:00:00	NVDA	Stock	0.2095	0.2163	0.2092	0.2148	140853120.0
2008-12-10 12:00:00	NVDA	Stock	0.2145	0.216	0.2088	0.2105	94157320.0
2008-12-10 13:00:00	NVDA	Stock	0.2105	0.215	0.2085	0.2092	84103480.0
2008-12-10 14:00:00	NVDA	Stock	0.209	0.2145	0.2078	0.2122	127956000.0
2008-12-10 15:00:00	NVDA	Stock	0.2125	0.2188	0.212	0.2138	206468520.0
2008-12-10 16:00:00	NVDA	Stock	0.2138	0.2145	0.21	0.21	910160.0
2008-12-10 17:00:00	NVDA	Stock	0.213	0.213	0.213	0.213	20000.0
2008-12-10 19:00:00	NVDA	Stock	0.2138	0.2188	0.2138	0.2188	50120.0
2008-12-10 08:00:00	AMZN	Stock	2.6	2.6	2.59	2.59	34000.0
2008-12-10 09:00:00	AMZN	Stock	2.5875	2.59	2.45	2.4835	31267080.0
2008-12-10 10:00:00	AMZN	Stock	2.485	2.519	2.45	2.4625	25809200.0
2008-12-10 11:00:00	AMZN	Stock	2.4655	2.504	2.4545	2.4785	17155880.0
2008-12-10 12:00:00	AMZN	Stock	2.4785	2.4935	2.452	2.4585	12846880.0
2008-12-10 13:00:00	AMZN	Stock	2.458	2.4785	2.417	2.4275	16780220.0
2008-12-10 14:00:00	AMZN	Stock	2.4255	2.4685	2.4175	2.465	20955460.0
2008-12-10 15:00:00	AMZN	Stock	2.4645	2.494	2.453	2.485	25757780.0
2008-12-10 16:00:00	AMZN	Stock	2.4825	2.485	2.468	2.485	710180.0
2008-12-10 17:00:00	AMZN	Stock	2.48	2.482	2.475	2.475	6000.0

> showing 50 of 40,190 rows — these rows as CSV

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