PREVIEW / stock_1hour / 2007-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-05.parquet
  size:    665 KB
  rows:    31,519
  symbols: 2,482

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
2007-01-05 06:00:00	AAPL	Stock	3.0714	3.0714	3.0586	3.0586	72240.0
2007-01-05 07:00:00	AAPL	Stock	3.0671	3.0682	3.0464	3.05	221564.0
2007-01-05 08:00:00	AAPL	Stock	3.05	3.0639	3.0389	3.05	5487608.0
2007-01-05 09:00:00	AAPL	Stock	3.0518	3.0786	3.0371	3.0524	169530032.0
2007-01-05 10:00:00	AAPL	Stock	3.0518	3.0668	3.0311	3.0318	166362168.0
2007-01-05 11:00:00	AAPL	Stock	3.0321	3.0436	3.0143	3.0232	131472264.0
2007-01-05 12:00:00	AAPL	Stock	3.0236	3.0786	3.0229	3.0385	88476948.0
2007-01-05 13:00:00	AAPL	Stock	3.0386	3.0586	3.0321	3.0389	65782360.0
2007-01-05 14:00:00	AAPL	Stock	3.0393	3.0496	3.0311	3.0371	86395540.0
2007-01-05 15:00:00	AAPL	Stock	3.0371	3.0464	3.0307	3.0386	109173876.0
2007-01-05 16:00:00	AAPL	Stock	3.0396	3.0411	3.0329	3.0368	1919484.0
2007-01-05 17:00:00	AAPL	Stock	3.0368	3.0386	3.0357	3.0386	380268.0
2007-01-05 18:00:00	AAPL	Stock	3.0386	3.0386	3.0339	3.035	302344.0
2007-01-05 19:00:00	AAPL	Stock	3.035	3.0354	3.0329	3.0329	178304.0
2007-01-05 08:00:00	MSFT	Stock	29.79	29.79	29.59	29.71	29260.0
2007-01-05 09:00:00	MSFT	Stock	29.66	29.75	29.55	29.61	8783780.0
2007-01-05 10:00:00	MSFT	Stock	29.61	29.75	29.58	29.65	5405892.0
2007-01-05 11:00:00	MSFT	Stock	29.65	29.7	29.45	29.53	5927099.0
2007-01-05 12:00:00	MSFT	Stock	29.52	29.74	29.52	29.62	4011312.0
2007-01-05 13:00:00	MSFT	Stock	29.62	29.71	29.56	29.62	4203628.0
2007-01-05 14:00:00	MSFT	Stock	29.63	29.68	29.56	29.58	5657026.0
2007-01-05 15:00:00	MSFT	Stock	29.59	29.66	29.54	29.64	7679971.0
2007-01-05 16:00:00	MSFT	Stock	29.64	29.68	29.51	29.64	82847.0
2007-01-05 17:00:00	MSFT	Stock	29.64	29.64	29.63	29.63	5015.0
2007-01-05 18:00:00	MSFT	Stock	29.64	29.69	29.64	29.64	5526.0
2007-01-05 19:00:00	MSFT	Stock	29.63	29.69	29.63	29.69	2159.0
2007-01-05 07:00:00	NVDA	Stock	0.5995	0.5995	0.5953	0.5953	18000.0
2007-01-05 08:00:00	NVDA	Stock	0.5935	0.5935	0.59	0.59	669000.0
2007-01-05 09:00:00	NVDA	Stock	0.59	0.5917	0.5667	0.5697	172781280.0
2007-01-05 10:00:00	NVDA	Stock	0.5697	0.5722	0.5638	0.5667	264682500.0
2007-01-05 11:00:00	NVDA	Stock	0.5667	0.569	0.5633	0.5648	186185280.0
2007-01-05 12:00:00	NVDA	Stock	0.5648	0.5837	0.5622	0.5623	112209480.0
2007-01-05 13:00:00	NVDA	Stock	0.5623	0.5718	0.5592	0.562	144581040.0
2007-01-05 14:00:00	NVDA	Stock	0.5618	0.5673	0.5588	0.5593	120539160.0
2007-01-05 15:00:00	NVDA	Stock	0.5595	0.5657	0.557	0.5608	211012560.0
2007-01-05 16:00:00	NVDA	Stock	0.561	0.5615	0.56	0.5615	793440.0
2007-01-05 17:00:00	NVDA	Stock	0.5603	0.561	0.5592	0.561	71580.0
2007-01-05 18:00:00	NVDA	Stock	0.561	0.5625	0.561	0.5625	176760.0
2007-01-05 19:00:00	NVDA	Stock	0.5617	0.5617	0.56	0.56	66420.0
2007-01-05 07:00:00	AMZN	Stock	1.9435	1.9435	1.9435	1.9435	119640.0
2007-01-05 08:00:00	AMZN	Stock	1.94	1.94	1.937	1.937	11000.0
2007-01-05 09:00:00	AMZN	Stock	1.9375	1.9395	1.9205	1.922	11981340.0
2007-01-05 10:00:00	AMZN	Stock	1.922	1.931	1.9185	1.92	14937720.0
2007-01-05 11:00:00	AMZN	Stock	1.92	1.9235	1.88	1.8955	32592680.0
2007-01-05 12:00:00	AMZN	Stock	1.895	1.9385	1.8945	1.899	16401700.0
2007-01-05 13:00:00	AMZN	Stock	1.899	1.9285	1.893	1.908	10657360.0
2007-01-05 14:00:00	AMZN	Stock	1.908	1.908	1.8925	1.905	13595820.0
2007-01-05 15:00:00	AMZN	Stock	1.905	1.9215	1.8985	1.9185	27041940.0
2007-01-05 16:00:00	AMZN	Stock	1.9185	1.9205	1.911	1.911	492000.0
2007-01-05 18:00:00	AMZN	Stock	1.9185	1.9185	1.9185	1.9185	23300.0

> showing 50 of 31,519 rows — these rows as CSV

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