PREVIEW / stock_1hour / 2001-02-15
file: by_date/stock_1hour/2001/2001-02-15.parquet size: 359 KB rows: 16,607 symbols: 1,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 |
|---|---|---|---|---|---|---|---|
| 2001-02-15 08:00:00 | AAPL | Stock | 0.3493 | 0.3549 | 0.3482 | 0.3521 | 1478400.0 |
| 2001-02-15 09:00:00 | AAPL | Stock | 0.3516 | 0.3616 | 0.3493 | 0.3594 | 52141600.0 |
| 2001-02-15 10:00:00 | AAPL | Stock | 0.3594 | 0.3661 | 0.3583 | 0.3616 | 64786400.0 |
| 2001-02-15 11:00:00 | AAPL | Stock | 0.3616 | 0.3627 | 0.3527 | 0.3571 | 68275200.0 |
| 2001-02-15 12:00:00 | AAPL | Stock | 0.3571 | 0.3661 | 0.356 | 0.365 | 24147200.0 |
| 2001-02-15 13:00:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3616 | 0.3638 | 18620000.0 |
| 2001-02-15 14:00:00 | AAPL | Stock | 0.3638 | 0.3672 | 0.3616 | 0.3627 | 26320000.0 |
| 2001-02-15 15:00:00 | AAPL | Stock | 0.3616 | 0.365 | 0.3527 | 0.3583 | 40320000.0 |
| 2001-02-15 16:00:00 | AAPL | Stock | 0.3583 | 0.3583 | 0.3493 | 0.3527 | 5650400.0 |
| 2001-02-15 17:00:00 | AAPL | Stock | 0.3571 | 0.3583 | 0.3516 | 0.3516 | 78400.0 |
| 2001-02-15 18:00:00 | AAPL | Stock | 0.3516 | 0.3516 | 0.3516 | 0.3516 | 11200.0 |
| 2001-02-15 08:00:00 | MSFT | Stock | 29.3438 | 30.0 | 29.25 | 29.625 | 230400.0 |
| 2001-02-15 09:00:00 | MSFT | Stock | 29.5625 | 29.625 | 29.0938 | 29.4688 | 11811400.0 |
| 2001-02-15 10:00:00 | MSFT | Stock | 29.4688 | 30.0938 | 29.4688 | 29.9062 | 15379200.0 |
| 2001-02-15 11:00:00 | MSFT | Stock | 29.875 | 29.9688 | 29.4688 | 29.8125 | 5096600.0 |
| 2001-02-15 12:00:00 | MSFT | Stock | 29.8125 | 30.0938 | 29.625 | 30.0 | 5037000.0 |
| 2001-02-15 13:00:00 | MSFT | Stock | 30.0 | 30.0938 | 29.6562 | 29.7812 | 4496000.0 |
| 2001-02-15 14:00:00 | MSFT | Stock | 29.7812 | 29.9688 | 29.4688 | 29.5625 | 5801000.0 |
| 2001-02-15 15:00:00 | MSFT | Stock | 29.5625 | 29.6562 | 28.9375 | 29.4375 | 12815800.0 |
| 2001-02-15 16:00:00 | MSFT | Stock | 29.4375 | 29.8125 | 28.75 | 29.0625 | 2029000.0 |
| 2001-02-15 17:00:00 | MSFT | Stock | 29.1562 | 29.1875 | 28.5 | 28.5 | 107000.0 |
| 2001-02-15 18:00:00 | MSFT | Stock | 28.75 | 28.75 | 28.625 | 28.75 | 5000.0 |
| 2001-02-15 08:00:00 | NVDA | Stock | 0.2146 | 0.2167 | 0.2135 | 0.2167 | 1536000.0 |
| 2001-02-15 09:00:00 | NVDA | Stock | 0.2146 | 0.2365 | 0.2146 | 0.2341 | 270000000.0 |
| 2001-02-15 10:00:00 | NVDA | Stock | 0.2341 | 0.2391 | 0.2323 | 0.2391 | 279408000.0 |
| 2001-02-15 11:00:00 | NVDA | Stock | 0.238 | 0.2391 | 0.2331 | 0.2367 | 101664000.0 |
| 2001-02-15 12:00:00 | NVDA | Stock | 0.2365 | 0.2391 | 0.2354 | 0.2367 | 85488000.0 |
| 2001-02-15 13:00:00 | NVDA | Stock | 0.2367 | 0.2367 | 0.232 | 0.2341 | 97488000.0 |
| 2001-02-15 14:00:00 | NVDA | Stock | 0.2341 | 0.2375 | 0.2333 | 0.2359 | 62064000.0 |
| 2001-02-15 15:00:00 | NVDA | Stock | 0.2354 | 0.2367 | 0.2323 | 0.2352 | 154080000.0 |
| 2001-02-15 16:00:00 | NVDA | Stock | 0.2354 | 0.2372 | 0.2286 | 0.2297 | 19296000.0 |
| 2001-02-15 17:00:00 | NVDA | Stock | 0.2297 | 0.2305 | 0.2297 | 0.2297 | 456000.0 |
| 2001-02-15 18:00:00 | NVDA | Stock | 0.2297 | 0.2297 | 0.2297 | 0.2297 | 96000.0 |
| 2001-02-15 08:00:00 | AMZN | Stock | 0.6562 | 0.6922 | 0.625 | 0.675 | 5200000.0 |
| 2001-02-15 09:00:00 | AMZN | Stock | 0.6719 | 0.7188 | 0.6625 | 0.7156 | 61280000.0 |
| 2001-02-15 10:00:00 | AMZN | Stock | 0.7156 | 0.7219 | 0.6938 | 0.7125 | 70840000.0 |
| 2001-02-15 11:00:00 | AMZN | Stock | 0.7094 | 0.7125 | 0.7 | 0.7031 | 30214000.0 |
| 2001-02-15 12:00:00 | AMZN | Stock | 0.7031 | 0.7062 | 0.6969 | 0.7031 | 43388000.0 |
| 2001-02-15 13:00:00 | AMZN | Stock | 0.7031 | 0.7125 | 0.7031 | 0.7062 | 24716000.0 |
| 2001-02-15 14:00:00 | AMZN | Stock | 0.7031 | 0.7188 | 0.7031 | 0.7125 | 26816000.0 |
| 2001-02-15 15:00:00 | AMZN | Stock | 0.7156 | 0.7313 | 0.7094 | 0.7219 | 43942000.0 |
| 2001-02-15 16:00:00 | AMZN | Stock | 0.7219 | 0.725 | 0.7062 | 0.7125 | 3076000.0 |
| 2001-02-15 17:00:00 | AMZN | Stock | 0.7125 | 0.7125 | 0.7094 | 0.7125 | 350000.0 |
| 2001-02-15 18:00:00 | AMZN | Stock | 0.7125 | 0.7125 | 0.7094 | 0.7125 | 82000.0 |
| 2001-02-15 09:00:00 | CL | Stock | 28.05 | 28.1 | 27.905 | 27.945 | 345600.0 |
| 2001-02-15 10:00:00 | CL | Stock | 27.94 | 28.375 | 27.925 | 28.375 | 534000.0 |
| 2001-02-15 11:00:00 | CL | Stock | 28.365 | 28.53 | 28.35 | 28.385 | 485400.0 |
| 2001-02-15 12:00:00 | CL | Stock | 28.34 | 28.595 | 28.34 | 28.45 | 409200.0 |
| 2001-02-15 13:00:00 | CL | Stock | 28.495 | 28.525 | 28.445 | 28.515 | 271000.0 |
| 2001-02-15 14:00:00 | CL | Stock | 28.51 | 28.54 | 28.375 | 28.48 | 227800.0 |
> showing 50 of 16,607 rows — these rows as CSV