PREVIEW / stock_1hour / 2007-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-09.parquet
  size:    815 KB
  rows:    40,061
  symbols: 3,183

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-11-09 04:00:00	AAPL	Stock	6.4371	6.4482	6.3996	6.4114	260400.0
2007-11-09 05:00:00	AAPL	Stock	6.4079	6.4079	6.3293	6.3304	168000.0
2007-11-09 06:00:00	AAPL	Stock	6.3393	6.3532	6.3039	6.3039	213164.0
2007-11-09 07:00:00	AAPL	Stock	6.3125	6.3161	6.2393	6.2607	1047256.0
2007-11-09 08:00:00	AAPL	Stock	6.2536	6.26	6.0893	6.1571	11972716.0
2007-11-09 09:00:00	AAPL	Stock	6.1571	6.2543	6.0357	6.1975	232578192.0
2007-11-09 10:00:00	AAPL	Stock	6.1968	6.2286	6.0714	6.1006	231205912.0
2007-11-09 11:00:00	AAPL	Stock	6.1014	6.1521	6.0057	6.1365	228946536.0
2007-11-09 12:00:00	AAPL	Stock	6.1375	6.16	6.0446	6.09	153064660.0
2007-11-09 13:00:00	AAPL	Stock	6.09	6.1357	6.0471	6.0471	134999116.0
2007-11-09 14:00:00	AAPL	Stock	6.0468	6.1696	6.0318	6.1107	194458852.0
2007-11-09 15:00:00	AAPL	Stock	6.1104	6.1593	5.9004	5.9057	308495068.0
2007-11-09 16:00:00	AAPL	Stock	5.9046	6.1039	5.8554	5.9046	25799816.0
2007-11-09 17:00:00	AAPL	Stock	5.9054	6.1039	5.8929	5.8996	2704408.0
2007-11-09 18:00:00	AAPL	Stock	5.8964	6.0421	5.8679	5.875	960120.0
2007-11-09 19:00:00	AAPL	Stock	5.8786	5.8921	5.875	5.8793	574140.0
2007-11-09 07:00:00	MSFT	Stock	34.5	34.5	34.5	34.5	500.0
2007-11-09 08:00:00	MSFT	Stock	34.5	34.74	34.05	34.35	218061.0
2007-11-09 09:00:00	MSFT	Stock	34.38	34.54	33.65	33.96	17097010.0
2007-11-09 10:00:00	MSFT	Stock	33.96	34.28	33.83	33.85	19141563.0
2007-11-09 11:00:00	MSFT	Stock	33.85	34.04	33.74	33.77	19294433.0
2007-11-09 12:00:00	MSFT	Stock	33.78	34.02	33.66	33.722	15985313.0
2007-11-09 13:00:00	MSFT	Stock	33.72	33.77	33.65	33.69	12741895.0
2007-11-09 14:00:00	MSFT	Stock	33.68	34.12	33.67	33.98	13292429.0
2007-11-09 15:00:00	MSFT	Stock	33.98	34.41	33.66	33.67	23958142.0
2007-11-09 16:00:00	MSFT	Stock	33.73	33.955	33.57	33.67	3402471.0
2007-11-09 17:00:00	MSFT	Stock	33.75	33.9	33.69	33.7	32272.0
2007-11-09 18:00:00	MSFT	Stock	33.7	33.7	33.64	33.67	13459.0
2007-11-09 19:00:00	MSFT	Stock	33.67	33.68	33.6	33.68	12118.0
2007-11-09 07:00:00	NVDA	Stock	0.8982	0.8982	0.875	0.897	822920.0
2007-11-09 08:00:00	NVDA	Stock	0.897	0.9	0.8688	0.8688	5061840.0
2007-11-09 09:00:00	NVDA	Stock	0.868	0.871	0.8162	0.8405	160196520.0
2007-11-09 10:00:00	NVDA	Stock	0.8404	0.85	0.8245	0.8445	157670840.0
2007-11-09 11:00:00	NVDA	Stock	0.8448	0.85	0.8363	0.8448	100816840.0
2007-11-09 12:00:00	NVDA	Stock	0.8448	0.8612	0.8435	0.854	90840200.0
2007-11-09 13:00:00	NVDA	Stock	0.854	0.8648	0.8478	0.85	54257000.0
2007-11-09 14:00:00	NVDA	Stock	0.8495	0.8677	0.8478	0.865	75435920.0
2007-11-09 15:00:00	NVDA	Stock	0.865	0.87	0.8325	0.8338	160758520.0
2007-11-09 16:00:00	NVDA	Stock	0.834	0.8546	0.8268	0.834	55543800.0
2007-11-09 17:00:00	NVDA	Stock	0.834	0.8479	0.834	0.8358	1154520.0
2007-11-09 18:00:00	NVDA	Stock	0.8358	0.8358	0.8325	0.8325	122680.0
2007-11-09 19:00:00	NVDA	Stock	0.8325	0.8338	0.8322	0.8338	129720.0
2007-11-09 05:00:00	AMZN	Stock	4.1685	4.1685	4.1685	4.1685	2000.0
2007-11-09 06:00:00	AMZN	Stock	4.14	4.14	4.14	4.14	2000.0
2007-11-09 08:00:00	AMZN	Stock	4.179	4.179	4.1	4.125	271020.0
2007-11-09 09:00:00	AMZN	Stock	4.138	4.179	4.0115	4.0325	50413200.0
2007-11-09 10:00:00	AMZN	Stock	4.0325	4.0885	4.022	4.053	28265940.0
2007-11-09 11:00:00	AMZN	Stock	4.053	4.063	4.0045	4.051	23830180.0
2007-11-09 12:00:00	AMZN	Stock	4.0495	4.052	4.014	4.0205	21633700.0
2007-11-09 13:00:00	AMZN	Stock	4.0215	4.0314	3.9535	3.9535	23965320.0

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

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