PREVIEW / stock_1hour / 2008-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-20.parquet
  size:    804 KB
  rows:    40,441
  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-10-20 05:00:00	AAPL	Stock	3.555	3.5939	3.555	3.5939	19852.0
2008-10-20 06:00:00	AAPL	Stock	3.6068	3.6068	3.5614	3.5714	49000.0
2008-10-20 07:00:00	AAPL	Stock	3.5793	3.6071	3.5375	3.5464	440860.0
2008-10-20 08:00:00	AAPL	Stock	3.5568	3.5689	3.5368	3.5571	3345272.0
2008-10-20 09:00:00	AAPL	Stock	3.5579	3.5725	3.4643	3.475	209078688.0
2008-10-20 10:00:00	AAPL	Stock	3.475	3.5121	3.3864	3.4054	316607536.0
2008-10-20 11:00:00	AAPL	Stock	3.4054	3.4843	3.3443	3.4611	232194032.0
2008-10-20 12:00:00	AAPL	Stock	3.4614	3.5171	3.4411	3.4632	194118848.0
2008-10-20 13:00:00	AAPL	Stock	3.4629	3.5036	3.4261	3.4861	168824936.0
2008-10-20 14:00:00	AAPL	Stock	3.4857	3.5196	3.4589	3.4904	154359100.0
2008-10-20 15:00:00	AAPL	Stock	3.49	3.5143	3.4554	3.5143	238855876.0
2008-10-20 16:00:00	AAPL	Stock	3.5154	3.5311	3.4661	3.5025	18046420.0
2008-10-20 17:00:00	AAPL	Stock	3.5082	3.5221	3.4964	3.5179	2084012.0
2008-10-20 18:00:00	AAPL	Stock	3.5189	3.5275	3.5125	3.5125	1521100.0
2008-10-20 19:00:00	AAPL	Stock	3.5136	3.5175	3.5046	3.5143	227976.0
2008-10-20 08:00:00	MSFT	Stock	24.17	24.46	24.17	24.35	13770.0
2008-10-20 09:00:00	MSFT	Stock	24.34	24.35	23.6	23.9	10679361.0
2008-10-20 10:00:00	MSFT	Stock	23.9	23.95	23.15	23.31	15505330.0
2008-10-20 11:00:00	MSFT	Stock	23.3	23.72	23.01	23.66	13280841.0
2008-10-20 12:00:00	MSFT	Stock	23.66	23.93	23.59	23.69	8637269.0
2008-10-20 13:00:00	MSFT	Stock	23.69	24.12	23.61	24.04	8355368.0
2008-10-20 14:00:00	MSFT	Stock	24.04	24.32	23.94	24.2	10729133.0
2008-10-20 15:00:00	MSFT	Stock	24.19	24.75	24.12	24.73	21494503.0
2008-10-20 16:00:00	MSFT	Stock	24.72	24.74	23.879	24.6	3903820.0
2008-10-20 17:00:00	MSFT	Stock	24.62	24.62	24.51	24.59	38260.0
2008-10-20 18:00:00	MSFT	Stock	24.55	24.59	24.55	24.58	12520.0
2008-10-20 19:00:00	MSFT	Stock	24.59	24.6	24.55	24.55	1650.0
2008-10-20 08:00:00	NVDA	Stock	0.1998	0.2025	0.1975	0.1995	393480.0
2008-10-20 09:00:00	NVDA	Stock	0.1992	0.1992	0.1913	0.1945	72182840.0
2008-10-20 10:00:00	NVDA	Stock	0.1948	0.196	0.1913	0.1928	94179120.0
2008-10-20 11:00:00	NVDA	Stock	0.193	0.196	0.1903	0.195	70115000.0
2008-10-20 12:00:00	NVDA	Stock	0.195	0.197	0.1935	0.1955	63507120.0
2008-10-20 13:00:00	NVDA	Stock	0.1955	0.196	0.1923	0.1952	75878920.0
2008-10-20 14:00:00	NVDA	Stock	0.195	0.197	0.1928	0.1948	92853080.0
2008-10-20 15:00:00	NVDA	Stock	0.195	0.1965	0.1935	0.195	111743720.0
2008-10-20 16:00:00	NVDA	Stock	0.1952	0.1958	0.189	0.195	2792520.0
2008-10-20 17:00:00	NVDA	Stock	0.1938	0.1958	0.1925	0.1958	109520.0
2008-10-20 18:00:00	NVDA	Stock	0.1925	0.1925	0.1925	0.1925	64000.0
2008-10-20 19:00:00	NVDA	Stock	0.1903	0.1945	0.19	0.1945	20000.0
2008-10-20 08:00:00	AMZN	Stock	2.6	2.625	2.6	2.6185	67000.0
2008-10-20 09:00:00	AMZN	Stock	2.6075	2.636	2.57	2.6268	22956660.0
2008-10-20 10:00:00	AMZN	Stock	2.628	2.655	2.5155	2.555	35981260.0
2008-10-20 11:00:00	AMZN	Stock	2.553	2.6215	2.4953	2.5965	28355420.0
2008-10-20 12:00:00	AMZN	Stock	2.598	2.606	2.556	2.5605	12677140.0
2008-10-20 13:00:00	AMZN	Stock	2.56	2.5775	2.5415	2.5515	14771060.0
2008-10-20 14:00:00	AMZN	Stock	2.5495	2.6	2.537	2.567	15211060.0
2008-10-20 15:00:00	AMZN	Stock	2.567	2.6485	2.5565	2.6465	33065700.0
2008-10-20 16:00:00	AMZN	Stock	2.6485	2.65	2.565	2.629	5025800.0
2008-10-20 17:00:00	AMZN	Stock	2.6185	2.629	2.6185	2.625	102000.0
2008-10-20 19:00:00	AMZN	Stock	2.634	2.6345	2.634	2.6345	8000.0

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

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