PREVIEW / stock_1hour / 2000-02-25
file: by_date/stock_1hour/2000/2000-02-25.parquet size: 282 KB rows: 14,487 symbols: 1,137
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 |
|---|---|---|---|---|---|---|---|
| 2000-02-25 09:00:00 | AAPL | Stock | 1.0251 | 1.0357 | 1.0162 | 1.0301 | 30956800.0 |
| 2000-02-25 10:00:00 | AAPL | Stock | 1.031 | 1.0446 | 1.0279 | 1.0318 | 45270400.0 |
| 2000-02-25 11:00:00 | AAPL | Stock | 1.0318 | 1.0318 | 1.0145 | 1.0259 | 27104000.0 |
| 2000-02-25 12:00:00 | AAPL | Stock | 1.0246 | 1.0402 | 1.0218 | 1.0307 | 24136000.0 |
| 2000-02-25 13:00:00 | AAPL | Stock | 1.0313 | 1.0313 | 1.0142 | 1.0142 | 21683200.0 |
| 2000-02-25 14:00:00 | AAPL | Stock | 1.0145 | 1.0201 | 1.0089 | 1.0145 | 24864000.0 |
| 2000-02-25 15:00:00 | AAPL | Stock | 1.0134 | 1.0145 | 0.9833 | 0.9855 | 58475200.0 |
| 2000-02-25 16:00:00 | AAPL | Stock | 0.9855 | 0.9872 | 0.9855 | 0.9855 | 2038400.0 |
| 2000-02-25 09:00:00 | MSFT | Stock | 47.3438 | 47.3438 | 46.6875 | 47.0 | 5667000.0 |
| 2000-02-25 10:00:00 | MSFT | Stock | 47.0312 | 47.25 | 46.5 | 46.5 | 8945800.0 |
| 2000-02-25 11:00:00 | MSFT | Stock | 46.5312 | 46.7812 | 46.2188 | 46.25 | 7590000.0 |
| 2000-02-25 12:00:00 | MSFT | Stock | 46.25 | 46.5938 | 46.25 | 46.4688 | 5475200.0 |
| 2000-02-25 13:00:00 | MSFT | Stock | 46.5 | 46.5625 | 45.75 | 45.9375 | 8732000.0 |
| 2000-02-25 14:00:00 | MSFT | Stock | 45.9375 | 46.0625 | 45.7188 | 46.0 | 8328400.0 |
| 2000-02-25 15:00:00 | MSFT | Stock | 46.0312 | 46.25 | 45.3125 | 45.6562 | 16817200.0 |
| 2000-02-25 16:00:00 | MSFT | Stock | 45.6562 | 45.7812 | 45.625 | 45.6562 | 389600.0 |
| 2000-02-25 09:00:00 | NVDA | Stock | 0.1361 | 0.1361 | 0.1328 | 0.1328 | 10080000.0 |
| 2000-02-25 10:00:00 | NVDA | Stock | 0.1328 | 0.1339 | 0.1292 | 0.1311 | 51600000.0 |
| 2000-02-25 11:00:00 | NVDA | Stock | 0.131 | 0.131 | 0.1273 | 0.1276 | 39600000.0 |
| 2000-02-25 12:00:00 | NVDA | Stock | 0.1276 | 0.1276 | 0.1219 | 0.1263 | 69504000.0 |
| 2000-02-25 13:00:00 | NVDA | Stock | 0.126 | 0.1277 | 0.126 | 0.1267 | 45936000.0 |
| 2000-02-25 14:00:00 | NVDA | Stock | 0.1268 | 0.1276 | 0.1266 | 0.1272 | 37824000.0 |
| 2000-02-25 15:00:00 | NVDA | Stock | 0.1271 | 0.1288 | 0.1271 | 0.1273 | 14112000.0 |
| 2000-02-25 16:00:00 | NVDA | Stock | 0.1275 | 0.1275 | 0.1275 | 0.1275 | 2112000.0 |
| 2000-02-25 09:00:00 | AMZN | Stock | 3.3719 | 3.4062 | 3.325 | 3.3625 | 8742000.0 |
| 2000-02-25 10:00:00 | AMZN | Stock | 3.3656 | 3.3906 | 3.2875 | 3.3219 | 13894000.0 |
| 2000-02-25 11:00:00 | AMZN | Stock | 3.3188 | 3.3562 | 3.3 | 3.3156 | 9306000.0 |
| 2000-02-25 12:00:00 | AMZN | Stock | 3.3156 | 3.3562 | 3.3125 | 3.325 | 3868000.0 |
| 2000-02-25 13:00:00 | AMZN | Stock | 3.325 | 3.35 | 3.2812 | 3.2812 | 10138000.0 |
| 2000-02-25 14:00:00 | AMZN | Stock | 3.2812 | 3.3188 | 3.2625 | 3.3 | 10222000.0 |
| 2000-02-25 15:00:00 | AMZN | Stock | 3.3 | 3.4688 | 3.2594 | 3.4562 | 29200000.0 |
| 2000-02-25 16:00:00 | AMZN | Stock | 3.4562 | 3.4625 | 3.4344 | 3.4562 | 404000.0 |
| 2000-02-25 09:00:00 | CL | Stock | 24.5938 | 24.8438 | 24.5 | 24.75 | 779400.0 |
| 2000-02-25 10:00:00 | CL | Stock | 24.75 | 24.8438 | 24.5 | 24.6562 | 1027200.0 |
| 2000-02-25 11:00:00 | CL | Stock | 24.6562 | 24.8125 | 24.6562 | 24.8125 | 966800.0 |
| 2000-02-25 12:00:00 | CL | Stock | 24.7812 | 24.875 | 24.75 | 24.7812 | 392000.0 |
| 2000-02-25 13:00:00 | CL | Stock | 24.8125 | 24.8125 | 24.5 | 24.5938 | 1077000.0 |
| 2000-02-25 14:00:00 | CL | Stock | 24.5625 | 24.625 | 24.25 | 24.3438 | 340200.0 |
| 2000-02-25 15:00:00 | CL | Stock | 24.3438 | 24.4688 | 24.0 | 24.0938 | 1210200.0 |
| 2000-02-25 16:00:00 | CL | Stock | 24.125 | 24.125 | 24.125 | 24.125 | 116400.0 |
> showing 40 of 14,487 rows — these rows as CSV