PREVIEW / stock_1hour / 2008-12-24
file: by_date/stock_1hour/2008/2008-12-24.parquet size: 530 KB rows: 24,318 symbols: 3,269
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-24 08:00:00 | AAPL | Stock | 3.075 | 3.0761 | 3.0454 | 3.0643 | 1166452.0 |
| 2008-12-24 09:00:00 | AAPL | Stock | 3.0679 | 3.085 | 3.0211 | 3.0429 | 69415724.0 |
| 2008-12-24 10:00:00 | AAPL | Stock | 3.0429 | 3.0479 | 3.0196 | 3.0312 | 91634648.0 |
| 2008-12-24 11:00:00 | AAPL | Stock | 3.0314 | 3.0457 | 3.0286 | 3.0321 | 45100104.0 |
| 2008-12-24 12:00:00 | AAPL | Stock | 3.0325 | 3.0493 | 3.0236 | 3.0393 | 55307112.0 |
| 2008-12-24 13:00:00 | AAPL | Stock | 3.035 | 3.04 | 3.0307 | 3.0357 | 5816748.0 |
| 2008-12-24 14:00:00 | AAPL | Stock | 3.0371 | 3.0389 | 3.0343 | 3.0389 | 46144.0 |
| 2008-12-24 15:00:00 | AAPL | Stock | 3.0357 | 3.0382 | 3.0339 | 3.0382 | 28000.0 |
| 2008-12-24 16:00:00 | AAPL | Stock | 3.0364 | 3.0389 | 3.0357 | 3.0389 | 13972.0 |
| 2008-12-24 08:00:00 | MSFT | Stock | 19.37 | 19.37 | 19.26 | 19.33 | 22279.0 |
| 2008-12-24 09:00:00 | MSFT | Stock | 19.33 | 19.45 | 19.15 | 19.2 | 3202031.0 |
| 2008-12-24 10:00:00 | MSFT | Stock | 19.2 | 19.3 | 19.16 | 19.19 | 4569508.0 |
| 2008-12-24 11:00:00 | MSFT | Stock | 19.19 | 19.24 | 19.16 | 19.18 | 3268240.0 |
| 2008-12-24 12:00:00 | MSFT | Stock | 19.19 | 19.23 | 19.1 | 19.16 | 4588917.0 |
| 2008-12-24 13:00:00 | MSFT | Stock | 19.16 | 19.22 | 19.15 | 19.17 | 1155945.0 |
| 2008-12-24 14:00:00 | MSFT | Stock | 19.17 | 19.22 | 19.17 | 19.18 | 4800.0 |
| 2008-12-24 15:00:00 | MSFT | Stock | 19.22 | 19.24 | 19.17 | 19.18 | 8576.0 |
| 2008-12-24 16:00:00 | MSFT | Stock | 19.17 | 19.17 | 19.17 | 19.17 | 100.0 |
| 2008-12-24 09:00:00 | NVDA | Stock | 0.1938 | 0.1985 | 0.19 | 0.1903 | 37198720.0 |
| 2008-12-24 10:00:00 | NVDA | Stock | 0.1903 | 0.1925 | 0.189 | 0.192 | 48580720.0 |
| 2008-12-24 11:00:00 | NVDA | Stock | 0.192 | 0.193 | 0.191 | 0.1918 | 26205760.0 |
| 2008-12-24 12:00:00 | NVDA | Stock | 0.1918 | 0.193 | 0.1915 | 0.1925 | 30111080.0 |
| 2008-12-24 13:00:00 | NVDA | Stock | 0.193 | 0.193 | 0.193 | 0.193 | 3085520.0 |
| 2008-12-24 08:00:00 | AMZN | Stock | 2.563 | 2.563 | 2.5625 | 2.5625 | 8000.0 |
| 2008-12-24 09:00:00 | AMZN | Stock | 2.572 | 2.5975 | 2.5585 | 2.565 | 7426300.0 |
| 2008-12-24 10:00:00 | AMZN | Stock | 2.5645 | 2.5785 | 2.5505 | 2.5705 | 12241120.0 |
| 2008-12-24 11:00:00 | AMZN | Stock | 2.5705 | 2.58 | 2.5617 | 2.5798 | 5246380.0 |
| 2008-12-24 12:00:00 | AMZN | Stock | 2.58 | 2.5845 | 2.565 | 2.569 | 6809560.0 |
| 2008-12-24 13:00:00 | AMZN | Stock | 2.5695 | 2.572 | 2.5695 | 2.572 | 769760.0 |
| 2008-12-24 09:00:00 | TLT | Stock | 121.34 | 121.34 | 120.73 | 121.08 | 179213.0 |
| 2008-12-24 10:00:00 | TLT | Stock | 121.13 | 121.14 | 121.02 | 121.07 | 125971.0 |
| 2008-12-24 11:00:00 | TLT | Stock | 121.07 | 121.1256 | 121.01 | 121.096 | 96127.0 |
| 2008-12-24 12:00:00 | TLT | Stock | 121.12 | 121.2 | 120.62 | 120.9 | 313010.0 |
| 2008-12-24 14:00:00 | TLT | Stock | 121.19 | 121.19 | 121.19 | 121.19 | 300.0 |
| 2008-12-24 09:00:00 | CL | Stock | 33.175 | 33.425 | 33.0 | 33.375 | 508694.0 |
| 2008-12-24 10:00:00 | CL | Stock | 33.365 | 33.665 | 33.33 | 33.64 | 822528.0 |
| 2008-12-24 11:00:00 | CL | Stock | 33.635 | 33.76 | 33.5 | 33.55 | 655800.0 |
| 2008-12-24 12:00:00 | CL | Stock | 33.55 | 33.87 | 33.54 | 33.79 | 1199892.0 |
| 2008-12-24 13:00:00 | CL | Stock | 33.78 | 33.81 | 33.78 | 33.81 | 92800.0 |
> showing 39 of 24,318 rows — these rows as CSV