PREVIEW / stock_1hour / 2008-10-22

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-22.parquet
  size:    809 KB
  rows:    41,089
  symbols: 3,319

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-10-22 04:00:00	AAPL	Stock	3.5711	3.6071	3.5711	3.5893	53200.0
2008-10-22 05:00:00	AAPL	Stock	3.5832	3.5832	3.56	3.5786	72520.0
2008-10-22 06:00:00	AAPL	Stock	3.5725	3.6214	3.5607	3.5714	1484448.0
2008-10-22 07:00:00	AAPL	Stock	3.5714	3.575	3.475	3.5296	11963924.0
2008-10-22 08:00:00	AAPL	Stock	3.5893	3.6286	3.4946	3.5236	47190164.0
2008-10-22 09:00:00	AAPL	Stock	3.5239	3.6161	3.4386	3.5489	519950032.0
2008-10-22 10:00:00	AAPL	Stock	3.5479	3.5632	3.4625	3.5414	424269720.0
2008-10-22 11:00:00	AAPL	Stock	3.5414	3.56	3.4804	3.5321	232674232.0
2008-10-22 12:00:00	AAPL	Stock	3.5304	3.5661	3.5161	3.5364	146985440.0
2008-10-22 13:00:00	AAPL	Stock	3.535	3.5357	3.4643	3.4893	186569124.0
2008-10-22 14:00:00	AAPL	Stock	3.4893	3.4986	3.4061	3.4393	244801396.0
2008-10-22 15:00:00	AAPL	Stock	3.4379	3.4643	3.3189	3.4539	376122852.0
2008-10-22 16:00:00	AAPL	Stock	3.4561	3.544	3.3876	3.4393	35823172.0
2008-10-22 17:00:00	AAPL	Stock	3.4379	3.4414	3.4143	3.4321	1278452.0
2008-10-22 18:00:00	AAPL	Stock	3.4293	3.4464	3.4232	3.4464	552524.0
2008-10-22 19:00:00	AAPL	Stock	3.44	3.4464	3.4282	3.4368	839020.0
2008-10-22 20:00:00	AAPL	Stock	3.4996	3.4996	3.4996	3.4996	470400.0
2008-10-22 04:00:00	MSFT	Stock	23.55	23.55	23.55	23.55	200.0
2008-10-22 05:00:00	MSFT	Stock	23.37	23.37	23.37	23.37	100.0
2008-10-22 06:00:00	MSFT	Stock	23.37	23.37	23.37	23.37	100.0
2008-10-22 07:00:00	MSFT	Stock	23.4	23.4	23.19	23.4	15740.0
2008-10-22 08:00:00	MSFT	Stock	23.4	23.65	23.21	23.26	131705.0
2008-10-22 09:00:00	MSFT	Stock	23.25	23.26	22.42	22.49	13635961.0
2008-10-22 10:00:00	MSFT	Stock	22.48	22.64	22.2	22.5	20266986.0
2008-10-22 11:00:00	MSFT	Stock	22.49	22.5	22.07	22.32	12830038.0
2008-10-22 12:00:00	MSFT	Stock	22.308	22.55	22.25	22.488	11624945.0
2008-10-22 13:00:00	MSFT	Stock	22.48	22.482	22.0	22.098	12098861.0
2008-10-22 14:00:00	MSFT	Stock	22.11	22.16	21.8	21.93	15703995.0
2008-10-22 15:00:00	MSFT	Stock	21.93	21.97	20.9	21.61	47804237.0
2008-10-22 16:00:00	MSFT	Stock	21.48	22.071	21.433	21.64	10582716.0
2008-10-22 17:00:00	MSFT	Stock	21.64	21.69	21.45	21.6	147117.0
2008-10-22 18:00:00	MSFT	Stock	21.6	21.75	21.58	21.74	23051.0
2008-10-22 19:00:00	MSFT	Stock	21.75	21.79	21.7	21.78	17280.0
2008-10-22 20:00:00	MSFT	Stock	23.85	23.85	23.85	23.85	13300.0
2008-10-22 08:00:00	NVDA	Stock	0.1843	0.1843	0.1775	0.1788	455800.0
2008-10-22 09:00:00	NVDA	Stock	0.1788	0.1838	0.175	0.1807	90203760.0
2008-10-22 10:00:00	NVDA	Stock	0.1805	0.185	0.1793	0.1835	97474520.0
2008-10-22 11:00:00	NVDA	Stock	0.1835	0.1838	0.1798	0.1803	60124240.0
2008-10-22 12:00:00	NVDA	Stock	0.1803	0.1828	0.1788	0.1814	45431240.0
2008-10-22 13:00:00	NVDA	Stock	0.1813	0.1813	0.1763	0.1768	55545720.0
2008-10-22 14:00:00	NVDA	Stock	0.1768	0.177	0.1728	0.1732	74641440.0
2008-10-22 15:00:00	NVDA	Stock	0.1733	0.1738	0.1685	0.1735	152947520.0
2008-10-22 16:00:00	NVDA	Stock	0.172	0.185	0.1718	0.1738	23504720.0
2008-10-22 17:00:00	NVDA	Stock	0.1738	0.174	0.173	0.1738	190000.0
2008-10-22 18:00:00	NVDA	Stock	0.174	0.1753	0.174	0.1753	319200.0
2008-10-22 19:00:00	NVDA	Stock	0.1753	0.1753	0.1753	0.1753	46080.0
2008-10-22 04:00:00	AMZN	Stock	2.5535	2.5535	2.5535	2.5535	2000.0
2008-10-22 08:00:00	AMZN	Stock	2.542	2.542	2.495	2.515	422540.0
2008-10-22 09:00:00	AMZN	Stock	2.5125	2.5245	2.3965	2.4025	28132300.0
2008-10-22 10:00:00	AMZN	Stock	2.401	2.5005	2.395	2.5	37080520.0

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

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