PREVIEW / stock_1hour / 2008-12-26

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-26.parquet
  size:    764 KB
  rows:    38,566
  symbols: 3,300

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-26 08:00:00	AAPL	Stock	3.0389	3.1032	3.0389	3.0911	2131444.0
2008-12-26 09:00:00	AAPL	Stock	3.0893	3.1221	3.0768	3.0893	56227192.0
2008-12-26 10:00:00	AAPL	Stock	3.0893	3.1021	3.0604	3.0689	59415272.0
2008-12-26 11:00:00	AAPL	Stock	3.0696	3.075	3.0443	3.0571	43131956.0
2008-12-26 12:00:00	AAPL	Stock	3.0571	3.0693	3.0546	3.0589	33042576.0
2008-12-26 13:00:00	AAPL	Stock	3.0586	3.0729	3.0582	3.0682	23697548.0
2008-12-26 14:00:00	AAPL	Stock	3.0686	3.0775	3.0629	3.0721	31218824.0
2008-12-26 15:00:00	AAPL	Stock	3.0725	3.0814	3.0625	3.065	54347860.0
2008-12-26 16:00:00	AAPL	Stock	3.0671	3.0745	3.0618	3.0668	3532592.0
2008-12-26 17:00:00	AAPL	Stock	3.0693	3.0725	3.0661	3.0725	209020.0
2008-12-26 18:00:00	AAPL	Stock	3.0714	3.0714	3.0646	3.0714	645456.0
2008-12-26 19:00:00	AAPL	Stock	3.0714	3.0732	3.0689	3.0714	190484.0
2008-12-26 08:00:00	MSFT	Stock	19.29	19.3	19.0	19.3	4880.0
2008-12-26 09:00:00	MSFT	Stock	19.3	19.34	19.16	19.22	1727636.0
2008-12-26 10:00:00	MSFT	Stock	19.22	19.27	19.16	19.2	3048819.0
2008-12-26 11:00:00	MSFT	Stock	19.21	19.22	19.16	19.22	2544856.0
2008-12-26 12:00:00	MSFT	Stock	19.22	19.26	19.15	19.15	2182072.0
2008-12-26 13:00:00	MSFT	Stock	19.15	19.17	19.11	19.14	1499218.0
2008-12-26 14:00:00	MSFT	Stock	19.13	19.14	19.1	19.12	1730099.0
2008-12-26 15:00:00	MSFT	Stock	19.12	19.17	19.09	19.12	4272038.0
2008-12-26 16:00:00	MSFT	Stock	19.11	19.175	19.09	19.12	5746724.0
2008-12-26 17:00:00	MSFT	Stock	19.12	19.13	19.11	19.12	2300.0
2008-12-26 18:00:00	MSFT	Stock	19.12	19.13	19.12	19.12	1800.0
2008-12-26 19:00:00	MSFT	Stock	19.13	19.13	19.13	19.13	1890.0
2008-12-26 09:00:00	NVDA	Stock	0.193	0.1955	0.1875	0.1879	21360360.0
2008-12-26 10:00:00	NVDA	Stock	0.1879	0.1895	0.1825	0.185	57085600.0
2008-12-26 11:00:00	NVDA	Stock	0.1853	0.1858	0.1838	0.1848	23510520.0
2008-12-26 12:00:00	NVDA	Stock	0.1845	0.185	0.1843	0.1846	18356200.0
2008-12-26 13:00:00	NVDA	Stock	0.1845	0.1864	0.1845	0.186	16411160.0
2008-12-26 14:00:00	NVDA	Stock	0.186	0.1863	0.1853	0.1863	21643400.0
2008-12-26 15:00:00	NVDA	Stock	0.1863	0.1885	0.186	0.1878	63606600.0
2008-12-26 16:00:00	NVDA	Stock	0.188	0.189	0.187	0.1873	248000.0
2008-12-26 17:00:00	NVDA	Stock	0.1873	0.1873	0.1868	0.1868	128000.0
2008-12-26 08:00:00	AMZN	Stock	2.6	2.744	2.6	2.7165	2256160.0
2008-12-26 09:00:00	AMZN	Stock	2.715	2.72	2.62	2.62	36541100.0
2008-12-26 10:00:00	AMZN	Stock	2.62	2.645	2.6185	2.6275	20362860.0
2008-12-26 11:00:00	AMZN	Stock	2.6284	2.636	2.602	2.615	15647800.0
2008-12-26 12:00:00	AMZN	Stock	2.615	2.624	2.5805	2.59	15782300.0
2008-12-26 13:00:00	AMZN	Stock	2.589	2.5955	2.5775	2.59	10309080.0
2008-12-26 14:00:00	AMZN	Stock	2.5896	2.603	2.5795	2.594	12506660.0
2008-12-26 15:00:00	AMZN	Stock	2.594	2.606	2.5885	2.589	22264560.0
2008-12-26 16:00:00	AMZN	Stock	2.589	2.5925	2.5795	2.5845	317300.0
2008-12-26 17:00:00	AMZN	Stock	2.5815	2.5815	2.575	2.5815	238440.0
2008-12-26 18:00:00	AMZN	Stock	2.5825	2.5825	2.5715	2.58	35260.0
2008-12-26 19:00:00	AMZN	Stock	2.5765	2.5825	2.5765	2.5825	35760.0
2008-12-26 08:00:00	TLT	Stock	121.19	121.19	121.19	121.19	1400.0
2008-12-26 09:00:00	TLT	Stock	121.59	121.82	121.22	121.71	74055.0
2008-12-26 10:00:00	TLT	Stock	121.75	121.9699	121.51	121.5276	112730.0
2008-12-26 11:00:00	TLT	Stock	121.52	121.64	121.416	121.6355	37245.0
2008-12-26 12:00:00	TLT	Stock	121.64	121.843	121.5	121.58	35947.0

> showing 50 of 38,566 rows — these rows as CSV

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