PREVIEW / stock_1hour / 2007-10-30

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-30.parquet
  size:    817 KB
  rows:    40,524
  symbols: 3,160

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-10-30 05:00:00	AAPL	Stock	6.6104	6.6104	6.595	6.595	22400.0
2007-10-30 07:00:00	AAPL	Stock	6.5775	6.5946	6.5579	6.5625	367080.0
2007-10-30 08:00:00	AAPL	Stock	6.5696	6.7036	6.5696	6.6486	21340368.0
2007-10-30 09:00:00	AAPL	Stock	6.6482	6.6696	6.6289	6.64	99371300.0
2007-10-30 10:00:00	AAPL	Stock	6.6396	6.7064	6.5975	6.6982	192105592.0
2007-10-30 11:00:00	AAPL	Stock	6.6975	6.7107	6.6221	6.6721	131227376.0
2007-10-30 12:00:00	AAPL	Stock	6.6729	6.6886	6.6654	6.6839	69385036.0
2007-10-30 13:00:00	AAPL	Stock	6.685	6.7543	6.6843	6.7354	140870996.0
2007-10-30 14:00:00	AAPL	Stock	6.7354	6.7632	6.7046	6.7143	131572728.0
2007-10-30 15:00:00	AAPL	Stock	6.7146	6.7486	6.6786	6.6804	142574880.0
2007-10-30 16:00:00	AAPL	Stock	6.6804	6.709	6.675	6.675	8220352.0
2007-10-30 17:00:00	AAPL	Stock	6.675	6.6864	6.6611	6.6661	1424500.0
2007-10-30 18:00:00	AAPL	Stock	6.6739	6.7062	6.6721	6.6839	719572.0
2007-10-30 19:00:00	AAPL	Stock	6.6857	6.6868	6.6821	6.6839	251160.0
2007-10-30 07:00:00	MSFT	Stock	34.51	34.53	34.51	34.53	2000.0
2007-10-30 08:00:00	MSFT	Stock	34.42	34.57	34.41	34.42	47017.0
2007-10-30 09:00:00	MSFT	Stock	34.44	34.75	34.35	34.69	9871376.0
2007-10-30 10:00:00	MSFT	Stock	34.68	34.89	34.5	34.87	15147409.0
2007-10-30 11:00:00	MSFT	Stock	34.86	34.99	34.75	34.92	11707128.0
2007-10-30 12:00:00	MSFT	Stock	34.92	35.1	34.92	35.09	10491589.0
2007-10-30 13:00:00	MSFT	Stock	35.09	35.38	35.09	35.28	13267917.0
2007-10-30 14:00:00	MSFT	Stock	35.28	35.46	35.27	35.39	15878620.0
2007-10-30 15:00:00	MSFT	Stock	35.39	35.59	35.38	35.58	26145774.0
2007-10-30 16:00:00	MSFT	Stock	35.58	35.6	34.215	35.57	4709006.0
2007-10-30 17:00:00	MSFT	Stock	35.57	35.57	34.39	35.53	63937.0
2007-10-30 18:00:00	MSFT	Stock	35.54	35.56	35.266	35.51	8759.0
2007-10-30 19:00:00	MSFT	Stock	35.5	35.57	35.46	35.57	7351.0
2007-10-30 08:00:00	NVDA	Stock	0.8495	0.8512	0.8398	0.8465	845600.0
2007-10-30 09:00:00	NVDA	Stock	0.85	0.8598	0.8325	0.8565	80364640.0
2007-10-30 10:00:00	NVDA	Stock	0.8565	0.868	0.8523	0.8632	98456520.0
2007-10-30 11:00:00	NVDA	Stock	0.863	0.8725	0.8602	0.8695	57607680.0
2007-10-30 12:00:00	NVDA	Stock	0.8695	0.8792	0.869	0.8788	52931920.0
2007-10-30 13:00:00	NVDA	Stock	0.8788	0.8883	0.875	0.8849	71205120.0
2007-10-30 14:00:00	NVDA	Stock	0.8848	0.8858	0.8728	0.8778	52682800.0
2007-10-30 15:00:00	NVDA	Stock	0.8778	0.88	0.8682	0.8705	97547440.0
2007-10-30 16:00:00	NVDA	Stock	0.8705	0.8762	0.8495	0.8705	12059400.0
2007-10-30 17:00:00	NVDA	Stock	0.8705	0.8832	0.8635	0.871	853520.0
2007-10-30 18:00:00	NVDA	Stock	0.8758	0.8818	0.8632	0.8772	152400.0
2007-10-30 19:00:00	NVDA	Stock	0.875	0.8775	0.875	0.8775	217400.0
2007-10-30 08:00:00	AMZN	Stock	4.4865	4.493	4.4755	4.4885	79400.0
2007-10-30 09:00:00	AMZN	Stock	4.4875	4.5325	4.4745	4.508	13537040.0
2007-10-30 10:00:00	AMZN	Stock	4.5085	4.516	4.4795	4.4875	15193580.0
2007-10-30 11:00:00	AMZN	Stock	4.487	4.488	4.4705	4.4775	12451260.0
2007-10-30 12:00:00	AMZN	Stock	4.477	4.479	4.4575	4.4645	8440540.0
2007-10-30 13:00:00	AMZN	Stock	4.465	4.4815	4.4385	4.4655	12857460.0
2007-10-30 14:00:00	AMZN	Stock	4.466	4.466	4.418	4.4205	14882940.0
2007-10-30 15:00:00	AMZN	Stock	4.42	4.43	4.4025	4.4116	27251200.0
2007-10-30 16:00:00	AMZN	Stock	4.4115	4.479	4.395	4.412	3366980.0
2007-10-30 17:00:00	AMZN	Stock	4.412	4.422	4.4005	4.4025	48440.0
2007-10-30 18:00:00	AMZN	Stock	4.405	4.4085	4.4	4.405	20000.0

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

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