PREVIEW / stock_1hour / 2001-10-24
file: by_date/stock_1hour/2001/2001-10-24.parquet size: 356 KB rows: 16,727 symbols: 1,336
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-10-24 08:00:00 | AAPL | Stock | 0.3246 | 0.3286 | 0.3239 | 0.325 | 840000.0 |
| 2001-10-24 09:00:00 | AAPL | Stock | 0.3252 | 0.3252 | 0.317 | 0.3223 | 46362400.0 |
| 2001-10-24 10:00:00 | AAPL | Stock | 0.3221 | 0.3368 | 0.322 | 0.3325 | 95194400.0 |
| 2001-10-24 11:00:00 | AAPL | Stock | 0.3323 | 0.337 | 0.3307 | 0.3363 | 32664800.0 |
| 2001-10-24 12:00:00 | AAPL | Stock | 0.3363 | 0.3404 | 0.3354 | 0.3371 | 26969600.0 |
| 2001-10-24 13:00:00 | AAPL | Stock | 0.337 | 0.3407 | 0.335 | 0.3366 | 40689600.0 |
| 2001-10-24 14:00:00 | AAPL | Stock | 0.3366 | 0.3393 | 0.3334 | 0.3375 | 37620800.0 |
| 2001-10-24 15:00:00 | AAPL | Stock | 0.3373 | 0.3409 | 0.3363 | 0.3384 | 81614400.0 |
| 2001-10-24 16:00:00 | AAPL | Stock | 0.338 | 0.3389 | 0.3373 | 0.3384 | 5807200.0 |
| 2001-10-24 17:00:00 | AAPL | Stock | 0.3382 | 0.3382 | 0.3382 | 0.3382 | 5600.0 |
| 2001-10-24 08:00:00 | MSFT | Stock | 30.25 | 30.75 | 30.175 | 30.175 | 126200.0 |
| 2001-10-24 09:00:00 | MSFT | Stock | 30.245 | 30.35 | 29.81 | 30.12 | 9635600.0 |
| 2001-10-24 10:00:00 | MSFT | Stock | 30.115 | 30.7 | 29.8985 | 30.55 | 17846400.0 |
| 2001-10-24 11:00:00 | MSFT | Stock | 30.555 | 30.735 | 30.445 | 30.7 | 7884200.0 |
| 2001-10-24 12:00:00 | MSFT | Stock | 30.705 | 30.75 | 30.455 | 30.695 | 10104400.0 |
| 2001-10-24 13:00:00 | MSFT | Stock | 30.695 | 30.81 | 30.45 | 30.45 | 9364200.0 |
| 2001-10-24 14:00:00 | MSFT | Stock | 30.445 | 30.715 | 30.375 | 30.56 | 10805600.0 |
| 2001-10-24 15:00:00 | MSFT | Stock | 30.56 | 30.775 | 30.4195 | 30.66 | 8597800.0 |
| 2001-10-24 16:00:00 | MSFT | Stock | 30.66 | 30.7 | 30.4424 | 30.65 | 2643000.0 |
| 2001-10-24 17:00:00 | MSFT | Stock | 30.472 | 30.645 | 30.472 | 30.6 | 54400.0 |
| 2001-10-24 18:00:00 | MSFT | Stock | 30.65 | 30.65 | 30.625 | 30.625 | 4200.0 |
| 2001-10-24 08:00:00 | NVDA | Stock | 0.3718 | 0.3718 | 0.3642 | 0.3646 | 8688000.0 |
| 2001-10-24 09:00:00 | NVDA | Stock | 0.3643 | 0.3717 | 0.3627 | 0.365 | 204024000.0 |
| 2001-10-24 10:00:00 | NVDA | Stock | 0.3649 | 0.3762 | 0.3608 | 0.3711 | 285288000.0 |
| 2001-10-24 11:00:00 | NVDA | Stock | 0.3713 | 0.3792 | 0.3677 | 0.3787 | 123168000.0 |
| 2001-10-24 12:00:00 | NVDA | Stock | 0.3792 | 0.3876 | 0.3755 | 0.387 | 131964000.0 |
| 2001-10-24 13:00:00 | NVDA | Stock | 0.3871 | 0.3883 | 0.38 | 0.3809 | 113448000.0 |
| 2001-10-24 14:00:00 | NVDA | Stock | 0.3809 | 0.3846 | 0.3777 | 0.3818 | 150696000.0 |
| 2001-10-24 15:00:00 | NVDA | Stock | 0.3818 | 0.3891 | 0.3802 | 0.3874 | 155520000.0 |
| 2001-10-24 16:00:00 | NVDA | Stock | 0.3883 | 0.3898 | 0.3873 | 0.3897 | 13068000.0 |
| 2001-10-24 17:00:00 | NVDA | Stock | 0.3897 | 0.3937 | 0.3892 | 0.3896 | 768000.0 |
| 2001-10-24 18:00:00 | NVDA | Stock | 0.3892 | 0.39 | 0.3888 | 0.39 | 504000.0 |
| 2001-10-24 08:00:00 | AMZN | Stock | 0.4375 | 0.4775 | 0.3965 | 0.41 | 15290000.0 |
| 2001-10-24 09:00:00 | AMZN | Stock | 0.4075 | 0.425 | 0.3825 | 0.39 | 127438000.0 |
| 2001-10-24 10:00:00 | AMZN | Stock | 0.391 | 0.404 | 0.3875 | 0.388 | 107102000.0 |
| 2001-10-24 11:00:00 | AMZN | Stock | 0.3885 | 0.3895 | 0.3775 | 0.3835 | 69332000.0 |
| 2001-10-24 12:00:00 | AMZN | Stock | 0.3825 | 0.391 | 0.382 | 0.39 | 27162000.0 |
| 2001-10-24 13:00:00 | AMZN | Stock | 0.39 | 0.393 | 0.3835 | 0.384 | 27354000.0 |
| 2001-10-24 14:00:00 | AMZN | Stock | 0.384 | 0.3865 | 0.3735 | 0.3785 | 64182000.0 |
| 2001-10-24 15:00:00 | AMZN | Stock | 0.3785 | 0.3835 | 0.37 | 0.382 | 72394000.0 |
| 2001-10-24 16:00:00 | AMZN | Stock | 0.382 | 0.3835 | 0.375 | 0.379 | 3306000.0 |
| 2001-10-24 17:00:00 | AMZN | Stock | 0.382 | 0.382 | 0.3765 | 0.3775 | 382000.0 |
| 2001-10-24 18:00:00 | AMZN | Stock | 0.379 | 0.3795 | 0.378 | 0.3795 | 182000.0 |
| 2001-10-24 09:00:00 | CL | Stock | 29.225 | 29.495 | 29.18 | 29.35 | 325200.0 |
| 2001-10-24 10:00:00 | CL | Stock | 29.335 | 29.525 | 29.2 | 29.405 | 858800.0 |
| 2001-10-24 11:00:00 | CL | Stock | 29.4 | 29.41 | 29.2 | 29.235 | 306400.0 |
| 2001-10-24 12:00:00 | CL | Stock | 29.225 | 29.225 | 29.025 | 29.04 | 316000.0 |
| 2001-10-24 13:00:00 | CL | Stock | 29.04 | 29.29 | 29.025 | 29.105 | 437400.0 |
| 2001-10-24 14:00:00 | CL | Stock | 29.105 | 29.19 | 29.025 | 29.165 | 277000.0 |
| 2001-10-24 15:00:00 | CL | Stock | 29.17 | 29.245 | 29.075 | 29.225 | 441000.0 |
> showing 50 of 16,727 rows — these rows as CSV