PREVIEW / stock_1hour / 2009-01-16

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-16.parquet
  size:    797 KB
  rows:    39,309
  symbols: 3,309

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
2009-01-16 05:00:00	AAPL	Stock	3.0336	3.0336	3.0336	3.0336	2800.0
2009-01-16 06:00:00	AAPL	Stock	3.0318	3.0336	3.0318	3.0336	11200.0
2009-01-16 07:00:00	AAPL	Stock	3.0246	3.0275	2.9993	3.0	196728.0
2009-01-16 08:00:00	AAPL	Stock	3.0	3.01	2.9911	2.9961	1866004.0
2009-01-16 09:00:00	AAPL	Stock	2.9961	3.0136	2.9161	2.9175	162591548.0
2009-01-16 10:00:00	AAPL	Stock	2.9175	2.9282	2.8771	2.8918	185294256.0
2009-01-16 11:00:00	AAPL	Stock	2.8921	2.9067	2.8714	2.9021	120915620.0
2009-01-16 12:00:00	AAPL	Stock	2.9021	2.9064	2.8714	2.8982	91466732.0
2009-01-16 13:00:00	AAPL	Stock	2.8982	2.9125	2.8789	2.9011	100709700.0
2009-01-16 14:00:00	AAPL	Stock	2.9014	2.9296	2.8936	2.9254	121156840.0
2009-01-16 15:00:00	AAPL	Stock	2.925	2.95	2.8864	2.94	219140852.0
2009-01-16 16:00:00	AAPL	Stock	2.9404	2.9464	2.9096	2.9307	31755024.0
2009-01-16 17:00:00	AAPL	Stock	2.9339	2.9343	2.9157	2.9286	583380.0
2009-01-16 18:00:00	AAPL	Stock	2.9286	2.9286	2.9214	2.9214	323876.0
2009-01-16 19:00:00	AAPL	Stock	2.9268	2.9439	2.9268	2.9393	827932.0
2009-01-16 07:00:00	MSFT	Stock	19.64	19.64	19.5	19.59	7198.0
2009-01-16 08:00:00	MSFT	Stock	19.51	19.6	19.51	19.55	48872.0
2009-01-16 09:00:00	MSFT	Stock	19.55	19.91	19.51	19.72	16006827.0
2009-01-16 10:00:00	MSFT	Stock	19.72	19.78	19.48	19.55	11285135.0
2009-01-16 11:00:00	MSFT	Stock	19.552	19.7	19.32	19.38	7374325.0
2009-01-16 12:00:00	MSFT	Stock	19.38	19.7	19.15	19.32	7009801.0
2009-01-16 13:00:00	MSFT	Stock	19.325	19.43	19.23	19.41	5326375.0
2009-01-16 14:00:00	MSFT	Stock	19.41	19.58	19.35	19.58	6841800.0
2009-01-16 15:00:00	MSFT	Stock	19.575	19.78	19.55	19.72	18179126.0
2009-01-16 16:00:00	MSFT	Stock	19.72	19.73	19.514	19.64	5370676.0
2009-01-16 17:00:00	MSFT	Stock	19.65	19.72	19.65	19.71	6050.0
2009-01-16 18:00:00	MSFT	Stock	19.72	19.72	19.69	19.7	9350.0
2009-01-16 19:00:00	MSFT	Stock	19.68	19.7	19.68	19.7	1387.0
2009-01-16 08:00:00	NVDA	Stock	0.1962	0.1995	0.1935	0.195	541200.0
2009-01-16 09:00:00	NVDA	Stock	0.195	0.2015	0.192	0.1972	150693520.0
2009-01-16 10:00:00	NVDA	Stock	0.1972	0.1995	0.1945	0.1968	127431920.0
2009-01-16 11:00:00	NVDA	Stock	0.1968	0.1972	0.191	0.1925	82552720.0
2009-01-16 12:00:00	NVDA	Stock	0.1925	0.1945	0.1883	0.1935	73781320.0
2009-01-16 13:00:00	NVDA	Stock	0.1938	0.198	0.1928	0.197	64495960.0
2009-01-16 14:00:00	NVDA	Stock	0.1972	0.1992	0.1962	0.1984	87281760.0
2009-01-16 15:00:00	NVDA	Stock	0.1985	0.2005	0.1968	0.1998	193684680.0
2009-01-16 16:00:00	NVDA	Stock	0.1995	0.1998	0.1965	0.1995	18547880.0
2009-01-16 18:00:00	NVDA	Stock	0.1992	0.1995	0.1992	0.1995	98000.0
2009-01-16 08:00:00	AMZN	Stock	2.6245	2.6245	2.5925	2.5925	101300.0
2009-01-16 09:00:00	AMZN	Stock	2.585	2.6055	2.541	2.581	30809900.0
2009-01-16 10:00:00	AMZN	Stock	2.5813	2.6165	2.5545	2.581	28419520.0
2009-01-16 11:00:00	AMZN	Stock	2.5805	2.5915	2.509	2.518	18006500.0
2009-01-16 12:00:00	AMZN	Stock	2.5175	2.5245	2.4765	2.517	20518960.0
2009-01-16 13:00:00	AMZN	Stock	2.5157	2.5375	2.4955	2.52	17041460.0
2009-01-16 14:00:00	AMZN	Stock	2.5195	2.5445	2.511	2.5435	14788080.0
2009-01-16 15:00:00	AMZN	Stock	2.543	2.5815	2.527	2.5805	27609360.0
2009-01-16 16:00:00	AMZN	Stock	2.58	2.58	2.5415	2.5795	6873840.0
2009-01-16 17:00:00	AMZN	Stock	2.576	2.579	2.5755	2.579	10000.0
2009-01-16 18:00:00	AMZN	Stock	2.5775	2.5795	2.5775	2.5795	23000.0
2009-01-16 19:00:00	AMZN	Stock	2.5825	2.5825	2.5825	2.5825	8000.0

> showing 50 of 39,309 rows — these rows as CSV

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