PREVIEW / stock_1hour / 2006-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-28.parquet
  size:    614 KB
  rows:    29,800
  symbols: 2,381

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
2006-09-28 08:00:00	AAPL	Stock	2.7279	2.7496	2.7268	2.7482	4097828.0
2006-09-28 09:00:00	AAPL	Stock	2.7496	2.7671	2.7404	2.7532	127888208.0
2006-09-28 10:00:00	AAPL	Stock	2.7532	2.7625	2.7221	2.7368	193918480.0
2006-09-28 11:00:00	AAPL	Stock	2.7368	2.7432	2.7171	2.7225	88694816.0
2006-09-28 12:00:00	AAPL	Stock	2.7225	2.7343	2.7125	2.7325	82052712.0
2006-09-28 13:00:00	AAPL	Stock	2.7321	2.7471	2.7289	2.7407	68116216.0
2006-09-28 14:00:00	AAPL	Stock	2.7407	2.7464	2.7314	2.7357	56228900.0
2006-09-28 15:00:00	AAPL	Stock	2.7354	2.7525	2.7329	2.7518	86909060.0
2006-09-28 16:00:00	AAPL	Stock	2.7518	2.7582	2.7496	2.7504	2026976.0
2006-09-28 17:00:00	AAPL	Stock	2.7511	2.7604	2.75	2.7604	1100316.0
2006-09-28 18:00:00	AAPL	Stock	2.7604	2.7618	2.7524	2.7611	438508.0
2006-09-28 19:00:00	AAPL	Stock	2.7639	2.7639	2.7589	2.7589	106400.0
2006-09-28 07:00:00	MSFT	Stock	27.56	27.56	27.56	27.56	900.0
2006-09-28 08:00:00	MSFT	Stock	27.56	27.6	27.51	27.53	174862.0
2006-09-28 09:00:00	MSFT	Stock	27.51	27.57	27.39	27.47	6000299.0
2006-09-28 10:00:00	MSFT	Stock	27.46	27.5	27.4	27.44	7575121.0
2006-09-28 11:00:00	MSFT	Stock	27.45	27.5	27.42	27.422	6673033.0
2006-09-28 12:00:00	MSFT	Stock	27.42	27.5	27.33	27.371	4964720.0
2006-09-28 13:00:00	MSFT	Stock	27.37	27.44	27.34	27.39	3350212.0
2006-09-28 14:00:00	MSFT	Stock	27.39	27.39	27.26	27.31	4926078.0
2006-09-28 15:00:00	MSFT	Stock	27.32	27.42	27.3	27.39	8424335.0
2006-09-28 16:00:00	MSFT	Stock	27.38	27.43	27.37	27.38	64960.0
2006-09-28 17:00:00	MSFT	Stock	27.4	27.42	27.37	27.42	5200.0
2006-09-28 18:00:00	MSFT	Stock	27.42	27.45	27.399	27.4	854963.0
2006-09-28 19:00:00	MSFT	Stock	27.42	27.42	27.42	27.42	334.0
2006-09-28 07:00:00	NVDA	Stock	0.4795	0.4795	0.4795	0.4795	6000.0
2006-09-28 08:00:00	NVDA	Stock	0.489	0.4955	0.4837	0.49	4762200.0
2006-09-28 09:00:00	NVDA	Stock	0.4888	0.4915	0.4805	0.4865	163509180.0
2006-09-28 10:00:00	NVDA	Stock	0.4865	0.4933	0.4858	0.4893	123344160.0
2006-09-28 11:00:00	NVDA	Stock	0.4895	0.4948	0.488	0.4882	73738200.0
2006-09-28 12:00:00	NVDA	Stock	0.4883	0.4915	0.487	0.491	52530900.0
2006-09-28 13:00:00	NVDA	Stock	0.4911	0.4947	0.4905	0.4938	67351980.0
2006-09-28 14:00:00	NVDA	Stock	0.4938	0.4947	0.49	0.4918	60170160.0
2006-09-28 15:00:00	NVDA	Stock	0.4917	0.4928	0.4893	0.4927	79774500.0
2006-09-28 16:00:00	NVDA	Stock	0.4928	0.4928	0.4915	0.4922	10243500.0
2006-09-28 17:00:00	NVDA	Stock	0.4928	0.4967	0.4928	0.4967	200280.0
2006-09-28 18:00:00	NVDA	Stock	0.4975	0.4983	0.4928	0.4983	29789280.0
2006-09-28 19:00:00	NVDA	Stock	0.4965	0.4965	0.4958	0.4963	58320.0
2006-09-28 08:00:00	AMZN	Stock	1.616	1.616	1.616	1.616	50000.0
2006-09-28 09:00:00	AMZN	Stock	1.614	1.6225	1.5905	1.5925	10742140.0
2006-09-28 10:00:00	AMZN	Stock	1.5925	1.599	1.58	1.5805	23398780.0
2006-09-28 11:00:00	AMZN	Stock	1.5805	1.585	1.5625	1.5625	19623540.0
2006-09-28 12:00:00	AMZN	Stock	1.563	1.577	1.561	1.5745	14538840.0
2006-09-28 13:00:00	AMZN	Stock	1.5745	1.5905	1.5725	1.5835	14545360.0
2006-09-28 14:00:00	AMZN	Stock	1.5835	1.5935	1.5805	1.586	10869680.0
2006-09-28 15:00:00	AMZN	Stock	1.586	1.5995	1.581	1.592	26984040.0
2006-09-28 16:00:00	AMZN	Stock	1.593	1.595	1.586	1.586	412120.0
2006-09-28 17:00:00	AMZN	Stock	1.5895	1.59	1.5895	1.59	30000.0
2006-09-28 18:00:00	AMZN	Stock	1.593	1.593	1.593	1.593	3360.0
2006-09-28 09:00:00	CL	Stock	31.05	31.185	30.935	31.135	246200.0

> showing 50 of 29,800 rows — these rows as CSV

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