PREVIEW / stock_1hour / 2008-12-31

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-31.parquet
  size:    855 KB
  rows:    41,747
  symbols: 3,409

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-31 07:00:00	AAPL	Stock	3.1068	3.1143	3.0893	3.0893	47600.0
2008-12-31 08:00:00	AAPL	Stock	3.0832	3.0968	3.0679	3.075	1345120.0
2008-12-31 09:00:00	AAPL	Stock	3.075	3.1154	3.0632	3.0993	64276324.0
2008-12-31 10:00:00	AAPL	Stock	3.0989	3.1064	3.08	3.095	78790320.0
2008-12-31 11:00:00	AAPL	Stock	3.095	3.1171	3.09	3.1125	65413124.0
2008-12-31 12:00:00	AAPL	Stock	3.1125	3.1336	3.1004	3.1282	71171940.0
2008-12-31 13:00:00	AAPL	Stock	3.1279	3.1314	3.1	3.11	67739868.0
2008-12-31 14:00:00	AAPL	Stock	3.11	3.1168	3.0864	3.1004	72777376.0
2008-12-31 15:00:00	AAPL	Stock	3.1004	3.1071	3.0479	3.0479	139537692.0
2008-12-31 16:00:00	AAPL	Stock	3.0482	3.0981	3.0371	3.05	36956976.0
2008-12-31 17:00:00	AAPL	Stock	3.0482	3.0529	3.0479	3.05	516264.0
2008-12-31 18:00:00	AAPL	Stock	3.0493	3.05	3.0482	3.0482	159040.0
2008-12-31 19:00:00	AAPL	Stock	3.0496	3.0536	3.0486	3.0532	136472.0
2008-12-31 08:00:00	MSFT	Stock	19.3	19.3	19.2	19.3	7240.0
2008-12-31 09:00:00	MSFT	Stock	19.3	19.55	19.27	19.49	4108635.0
2008-12-31 10:00:00	MSFT	Stock	19.49	19.55	19.38	19.482	4885024.0
2008-12-31 11:00:00	MSFT	Stock	19.48	19.62	19.48	19.57	4768149.0
2008-12-31 12:00:00	MSFT	Stock	19.57	19.65	19.55	19.602	3770770.0
2008-12-31 13:00:00	MSFT	Stock	19.61	19.62	19.53	19.6	3559263.0
2008-12-31 14:00:00	MSFT	Stock	19.6	19.68	19.53	19.64	4815277.0
2008-12-31 15:00:00	MSFT	Stock	19.64	19.67	19.4	19.44	12128186.0
2008-12-31 16:00:00	MSFT	Stock	19.45	19.596	19.3	19.44	6662708.0
2008-12-31 17:00:00	MSFT	Stock	19.35	19.39	19.33	19.39	6500.0
2008-12-31 18:00:00	MSFT	Stock	19.38	19.38	19.35	19.35	1157.0
2008-12-31 19:00:00	MSFT	Stock	19.38	19.38	19.34	19.34	4767.0
2008-12-31 08:00:00	NVDA	Stock	0.201	0.201	0.201	0.201	4000.0
2008-12-31 09:00:00	NVDA	Stock	0.1985	0.2	0.1945	0.1954	39830800.0
2008-12-31 10:00:00	NVDA	Stock	0.1952	0.202	0.195	0.2015	41586920.0
2008-12-31 11:00:00	NVDA	Stock	0.2016	0.206	0.201	0.2053	67341880.0
2008-12-31 12:00:00	NVDA	Stock	0.205	0.2068	0.203	0.2045	58619320.0
2008-12-31 13:00:00	NVDA	Stock	0.2045	0.2047	0.2023	0.2035	26381640.0
2008-12-31 14:00:00	NVDA	Stock	0.2038	0.2047	0.2025	0.2047	34679920.0
2008-12-31 15:00:00	NVDA	Stock	0.2047	0.2062	0.2013	0.202	138270280.0
2008-12-31 16:00:00	NVDA	Stock	0.2013	0.2023	0.199	0.1998	1364800.0
2008-12-31 17:00:00	NVDA	Stock	0.2	0.2	0.2	0.2	4000.0
2008-12-31 18:00:00	NVDA	Stock	0.2	0.2	0.2	0.2	23600.0
2008-12-31 19:00:00	NVDA	Stock	0.2	0.2	0.2	0.2	20000.0
2008-12-31 07:00:00	AMZN	Stock	2.5275	2.5275	2.5275	2.5275	2000.0
2008-12-31 08:00:00	AMZN	Stock	2.526	2.5275	2.525	2.5255	70640.0
2008-12-31 09:00:00	AMZN	Stock	2.5255	2.537	2.4955	2.5275	12339660.0
2008-12-31 10:00:00	AMZN	Stock	2.5275	2.544	2.507	2.527	13940220.0
2008-12-31 11:00:00	AMZN	Stock	2.5275	2.55	2.5215	2.535	11029880.0
2008-12-31 12:00:00	AMZN	Stock	2.535	2.5705	2.535	2.5595	12879800.0
2008-12-31 13:00:00	AMZN	Stock	2.56	2.5685	2.5455	2.5625	8664680.0
2008-12-31 14:00:00	AMZN	Stock	2.5635	2.58	2.5635	2.577	17406500.0
2008-12-31 15:00:00	AMZN	Stock	2.5773	2.5845	2.542	2.566	42501420.0
2008-12-31 16:00:00	AMZN	Stock	2.5575	2.564	2.5355	2.5525	12346820.0
2008-12-31 18:00:00	AMZN	Stock	2.556	2.5565	2.556	2.5565	6000.0
2008-12-31 08:00:00	TLT	Stock	121.94	121.94	121.3	121.3	669.0
2008-12-31 09:00:00	TLT	Stock	121.41	122.0	121.41	121.75	152012.0

> showing 50 of 41,747 rows — these rows as CSV

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