PREVIEW / stock_1hour / 2007-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-05.parquet
  size:    785 KB
  rows:    38,503
  symbols: 3,141

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-05 06:00:00	AAPL	Stock	5.5893	5.5893	5.5893	5.5893	19824.0
2007-10-05 07:00:00	AAPL	Stock	5.5814	5.6014	5.5714	5.5929	224700.0
2007-10-05 08:00:00	AAPL	Stock	5.5893	5.6529	5.5893	5.6321	12524820.0
2007-10-05 09:00:00	AAPL	Stock	5.6321	5.6889	5.6321	5.6571	137477228.0
2007-10-05 10:00:00	AAPL	Stock	5.6571	5.6864	5.6454	5.6854	118739152.0
2007-10-05 11:00:00	AAPL	Stock	5.6857	5.7064	5.6689	5.7043	139757968.0
2007-10-05 12:00:00	AAPL	Stock	5.7043	5.7139	5.6982	5.7075	72872884.0
2007-10-05 13:00:00	AAPL	Stock	5.7075	5.7211	5.6939	5.7161	110773516.0
2007-10-05 14:00:00	AAPL	Stock	5.7161	5.7429	5.6964	5.7036	115488828.0
2007-10-05 15:00:00	AAPL	Stock	5.7036	5.7704	5.6929	5.7696	197696296.0
2007-10-05 16:00:00	AAPL	Stock	5.7704	5.8271	5.6867	5.8214	29252272.0
2007-10-05 17:00:00	AAPL	Stock	5.8214	5.8771	5.8214	5.8614	5904780.0
2007-10-05 18:00:00	AAPL	Stock	5.8607	5.8625	5.8286	5.8286	1716176.0
2007-10-05 19:00:00	AAPL	Stock	5.8286	5.8393	5.8214	5.8357	1028496.0
2007-10-05 08:00:00	MSFT	Stock	29.74	29.93	29.74	29.88	100768.0
2007-10-05 09:00:00	MSFT	Stock	29.9	29.9	29.73	29.78	4472790.0
2007-10-05 10:00:00	MSFT	Stock	29.79	29.89	29.75	29.86	5403374.0
2007-10-05 11:00:00	MSFT	Stock	29.86	29.99	29.86	29.969	8747937.0
2007-10-05 12:00:00	MSFT	Stock	29.97	29.98	29.91	29.92	3093667.0
2007-10-05 13:00:00	MSFT	Stock	29.921	29.96	29.87	29.88	5578790.0
2007-10-05 14:00:00	MSFT	Stock	29.88	29.93	29.85	29.92	5299899.0
2007-10-05 15:00:00	MSFT	Stock	29.93	29.95	29.82	29.87	9235832.0
2007-10-05 16:00:00	MSFT	Stock	29.87	29.97	29.84	29.86	3086672.0
2007-10-05 17:00:00	MSFT	Stock	29.85	29.87	29.85	29.85	1800.0
2007-10-05 18:00:00	MSFT	Stock	29.87	29.87	29.87	29.87	3502.0
2007-10-05 19:00:00	MSFT	Stock	29.87	29.87	29.86	29.86	800.0
2007-10-05 08:00:00	NVDA	Stock	0.9012	0.91	0.9012	0.9098	1376200.0
2007-10-05 09:00:00	NVDA	Stock	0.9098	0.9195	0.904	0.917	55335840.0
2007-10-05 10:00:00	NVDA	Stock	0.917	0.9235	0.914	0.9225	51030520.0
2007-10-05 11:00:00	NVDA	Stock	0.9222	0.9262	0.9205	0.9218	44899040.0
2007-10-05 12:00:00	NVDA	Stock	0.9215	0.9232	0.9185	0.9225	33089880.0
2007-10-05 13:00:00	NVDA	Stock	0.9222	0.926	0.9195	0.9235	34523520.0
2007-10-05 14:00:00	NVDA	Stock	0.9235	0.9283	0.9235	0.928	40853600.0
2007-10-05 15:00:00	NVDA	Stock	0.928	0.9283	0.92	0.9232	63727240.0
2007-10-05 16:00:00	NVDA	Stock	0.9232	0.9258	0.9209	0.9232	19864480.0
2007-10-05 17:00:00	NVDA	Stock	0.9238	0.925	0.9238	0.925	52000.0
2007-10-05 18:00:00	NVDA	Stock	0.923	0.923	0.923	0.923	9800.0
2007-10-05 19:00:00	NVDA	Stock	0.9258	0.9275	0.9258	0.9275	91560.0
2007-10-05 06:00:00	AMZN	Stock	4.618	4.618	4.575	4.575	9040.0
2007-10-05 07:00:00	AMZN	Stock	4.585	4.7075	4.585	4.628	37100.0
2007-10-05 08:00:00	AMZN	Stock	4.66	4.7	4.63	4.6925	838460.0
2007-10-05 09:00:00	AMZN	Stock	4.6925	4.704	4.617	4.6355	15379160.0
2007-10-05 10:00:00	AMZN	Stock	4.634	4.6675	4.6245	4.6604	16395840.0
2007-10-05 11:00:00	AMZN	Stock	4.6605	4.67	4.651	4.6675	14594400.0
2007-10-05 12:00:00	AMZN	Stock	4.667	4.669	4.655	4.6665	9924740.0
2007-10-05 13:00:00	AMZN	Stock	4.6665	4.6835	4.656	4.666	17445700.0
2007-10-05 14:00:00	AMZN	Stock	4.667	4.6725	4.659	4.6706	11845960.0
2007-10-05 15:00:00	AMZN	Stock	4.6705	4.675	4.6525	4.67	20026840.0
2007-10-05 16:00:00	AMZN	Stock	4.6715	4.681	4.6585	4.6715	3913800.0
2007-10-05 17:00:00	AMZN	Stock	4.68	4.69	4.68	4.69	54000.0

> showing 50 of 38,503 rows — these rows as CSV

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