PREVIEW / stock_1hour / 2008-12-11

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-11.parquet
  size:    802 KB
  rows:    40,796
  symbols: 3,342

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-11 08:00:00	AAPL	Stock	3.5043	3.5054	3.4675	3.4686	826868.0
2008-12-11 09:00:00	AAPL	Stock	3.4679	3.5082	3.4207	3.5029	102085340.0
2008-12-11 10:00:00	AAPL	Stock	3.5032	3.5936	3.5007	3.5668	209788600.0
2008-12-11 11:00:00	AAPL	Stock	3.5657	3.5946	3.55	3.5846	107405900.0
2008-12-11 12:00:00	AAPL	Stock	3.5854	3.6157	3.5771	3.5875	94204824.0
2008-12-11 13:00:00	AAPL	Stock	3.5875	3.5893	3.5357	3.5396	77275184.0
2008-12-11 14:00:00	AAPL	Stock	3.5407	3.5493	3.4121	3.4214	161679308.0
2008-12-11 15:00:00	AAPL	Stock	3.4221	3.4289	3.3868	3.3936	251388396.0
2008-12-11 16:00:00	AAPL	Stock	3.3936	3.5145	3.3821	3.3839	31391248.0
2008-12-11 17:00:00	AAPL	Stock	3.3857	3.3929	3.3704	3.3821	860972.0
2008-12-11 18:00:00	AAPL	Stock	3.3839	3.3929	3.3768	3.3807	1853376.0
2008-12-11 19:00:00	AAPL	Stock	3.3768	3.3804	3.35	3.3571	855456.0
2008-12-11 06:00:00	MSFT	Stock	20.61	20.61	20.61	20.61	300.0
2008-12-11 07:00:00	MSFT	Stock	20.61	20.61	20.4	20.4	5761.0
2008-12-11 08:00:00	MSFT	Stock	20.52	20.52	20.22	20.24	71374.0
2008-12-11 09:00:00	MSFT	Stock	20.24	20.3	19.74	19.98	8719670.0
2008-12-11 10:00:00	MSFT	Stock	19.99	20.07	19.82	19.87	12510525.0
2008-12-11 11:00:00	MSFT	Stock	19.87	20.0	19.77	19.96	7232595.0
2008-12-11 12:00:00	MSFT	Stock	19.96	20.02	19.78	19.88	6508789.0
2008-12-11 13:00:00	MSFT	Stock	19.87	19.89	19.68	19.7	9524513.0
2008-12-11 14:00:00	MSFT	Stock	19.7	19.79	19.49	19.53	8850457.0
2008-12-11 15:00:00	MSFT	Stock	19.528	19.85	19.31	19.51	19838532.0
2008-12-11 16:00:00	MSFT	Stock	19.45	19.975	19.3	19.4	8812112.0
2008-12-11 17:00:00	MSFT	Stock	19.4	19.45	19.35	19.39	49276.0
2008-12-11 18:00:00	MSFT	Stock	19.38	19.41	19.31	19.31	38046.0
2008-12-11 19:00:00	MSFT	Stock	19.37	19.38	19.25	19.27	28819.0
2008-12-11 08:00:00	NVDA	Stock	0.2112	0.2112	0.21	0.21	96000.0
2008-12-11 09:00:00	NVDA	Stock	0.21	0.218	0.2062	0.2129	70435800.0
2008-12-11 10:00:00	NVDA	Stock	0.2128	0.2185	0.2108	0.2175	97896320.0
2008-12-11 11:00:00	NVDA	Stock	0.2178	0.22	0.2138	0.2172	67636400.0
2008-12-11 12:00:00	NVDA	Stock	0.2172	0.2188	0.2163	0.2178	35883120.0
2008-12-11 13:00:00	NVDA	Stock	0.2178	0.218	0.2108	0.211	65244320.0
2008-12-11 14:00:00	NVDA	Stock	0.211	0.2122	0.2038	0.2047	56986480.0
2008-12-11 15:00:00	NVDA	Stock	0.2045	0.207	0.2023	0.2047	159228120.0
2008-12-11 16:00:00	NVDA	Stock	0.205	0.2148	0.2025	0.2025	934520.0
2008-12-11 17:00:00	NVDA	Stock	0.2027	0.2027	0.2027	0.2027	4000.0
2008-12-11 18:00:00	NVDA	Stock	0.2062	0.2062	0.2023	0.2062	236000.0
2008-12-11 19:00:00	NVDA	Stock	0.2038	0.2038	0.2023	0.2023	18000.0
2008-12-11 07:00:00	AMZN	Stock	2.485	2.485	2.485	2.485	9000.0
2008-12-11 08:00:00	AMZN	Stock	2.426	2.475	2.426	2.4485	182000.0
2008-12-11 09:00:00	AMZN	Stock	2.4355	2.4725	2.4085	2.4652	18618600.0
2008-12-11 10:00:00	AMZN	Stock	2.4652	2.5165	2.4355	2.4875	29595100.0
2008-12-11 11:00:00	AMZN	Stock	2.4885	2.4965	2.457	2.4965	11978620.0
2008-12-11 12:00:00	AMZN	Stock	2.497	2.524	2.4905	2.5233	11470460.0
2008-12-11 13:00:00	AMZN	Stock	2.5245	2.5245	2.487	2.488	14179160.0
2008-12-11 14:00:00	AMZN	Stock	2.4883	2.5025	2.435	2.444	17954020.0
2008-12-11 15:00:00	AMZN	Stock	2.443	2.4485	2.4125	2.4125	38904320.0
2008-12-11 16:00:00	AMZN	Stock	2.4125	2.4205	2.41	2.41	1816760.0
2008-12-11 17:00:00	AMZN	Stock	2.4125	2.4135	2.4035	2.4035	56560.0
2008-12-11 18:00:00	AMZN	Stock	2.4125	2.4125	2.4125	2.4125	10000.0

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

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