PREVIEW / stock_1hour / 2001-10-22
file: by_date/stock_1hour/2001/2001-10-22.parquet size: 363 KB rows: 17,461 symbols: 1,350
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-22 09:00:00 | AAPL | Stock | 0.325 | 0.3304 | 0.323 | 0.3288 | 30452800.0 |
| 2001-10-22 10:00:00 | AAPL | Stock | 0.3287 | 0.3341 | 0.3271 | 0.3309 | 34059200.0 |
| 2001-10-22 11:00:00 | AAPL | Stock | 0.3313 | 0.3334 | 0.3304 | 0.3327 | 16632000.0 |
| 2001-10-22 12:00:00 | AAPL | Stock | 0.3327 | 0.3338 | 0.3291 | 0.3304 | 120052800.0 |
| 2001-10-22 13:00:00 | AAPL | Stock | 0.3304 | 0.3329 | 0.3289 | 0.3321 | 12504800.0 |
| 2001-10-22 14:00:00 | AAPL | Stock | 0.3323 | 0.3379 | 0.3297 | 0.3357 | 38298400.0 |
| 2001-10-22 15:00:00 | AAPL | Stock | 0.3357 | 0.3405 | 0.335 | 0.3395 | 103829600.0 |
| 2001-10-22 16:00:00 | AAPL | Stock | 0.3396 | 0.3402 | 0.3257 | 0.3395 | 24141600.0 |
| 2001-10-22 17:00:00 | AAPL | Stock | 0.3405 | 0.3405 | 0.3391 | 0.3395 | 156800.0 |
| 2001-10-22 08:00:00 | MSFT | Stock | 28.95 | 29.075 | 28.78 | 29.05 | 30800.0 |
| 2001-10-22 09:00:00 | MSFT | Stock | 29.025 | 29.4555 | 28.44 | 29.385 | 12686400.0 |
| 2001-10-22 10:00:00 | MSFT | Stock | 29.385 | 29.775 | 29.325 | 29.645 | 13533600.0 |
| 2001-10-22 11:00:00 | MSFT | Stock | 29.67 | 29.825 | 29.515 | 29.69 | 6990200.0 |
| 2001-10-22 12:00:00 | MSFT | Stock | 29.69 | 29.875 | 29.585 | 29.74 | 5153000.0 |
| 2001-10-22 13:00:00 | MSFT | Stock | 29.725 | 29.78 | 29.45 | 29.58 | 6493600.0 |
| 2001-10-22 14:00:00 | MSFT | Stock | 29.585 | 29.89 | 29.505 | 29.8045 | 6930200.0 |
| 2001-10-22 15:00:00 | MSFT | Stock | 29.8 | 30.09 | 29.75 | 30.075 | 14790600.0 |
| 2001-10-22 16:00:00 | MSFT | Stock | 30.08 | 30.15 | 28.765 | 30.07 | 2437000.0 |
| 2001-10-22 17:00:00 | MSFT | Stock | 30.075 | 30.15 | 30.075 | 30.15 | 18800.0 |
| 2001-10-22 18:00:00 | MSFT | Stock | 30.15 | 30.15 | 30.105 | 30.105 | 2800.0 |
| 2001-10-22 08:00:00 | NVDA | Stock | 0.3708 | 0.3708 | 0.3668 | 0.3668 | 6408000.0 |
| 2001-10-22 09:00:00 | NVDA | Stock | 0.3667 | 0.3733 | 0.3608 | 0.3693 | 126960000.0 |
| 2001-10-22 10:00:00 | NVDA | Stock | 0.3692 | 0.3833 | 0.3667 | 0.3781 | 220212000.0 |
| 2001-10-22 11:00:00 | NVDA | Stock | 0.3777 | 0.3803 | 0.3692 | 0.3714 | 72852000.0 |
| 2001-10-22 12:00:00 | NVDA | Stock | 0.3714 | 0.3772 | 0.3703 | 0.3721 | 75696000.0 |
| 2001-10-22 13:00:00 | NVDA | Stock | 0.3721 | 0.3728 | 0.3587 | 0.3621 | 126120000.0 |
| 2001-10-22 14:00:00 | NVDA | Stock | 0.3617 | 0.3744 | 0.3596 | 0.3737 | 115944000.0 |
| 2001-10-22 15:00:00 | NVDA | Stock | 0.3737 | 0.38 | 0.3702 | 0.3783 | 177960000.0 |
| 2001-10-22 16:00:00 | NVDA | Stock | 0.3783 | 0.3833 | 0.3637 | 0.3783 | 19104000.0 |
| 2001-10-22 17:00:00 | NVDA | Stock | 0.3784 | 0.3784 | 0.3746 | 0.3762 | 756000.0 |
| 2001-10-22 18:00:00 | NVDA | Stock | 0.3762 | 0.3762 | 0.3758 | 0.3758 | 888000.0 |
| 2001-10-22 08:00:00 | AMZN | Stock | 0.4 | 0.4045 | 0.4 | 0.403 | 40000.0 |
| 2001-10-22 09:00:00 | AMZN | Stock | 0.401 | 0.4355 | 0.401 | 0.431 | 19494000.0 |
| 2001-10-22 10:00:00 | AMZN | Stock | 0.431 | 0.44 | 0.4225 | 0.4325 | 16764000.0 |
| 2001-10-22 11:00:00 | AMZN | Stock | 0.4325 | 0.4345 | 0.425 | 0.432 | 6952000.0 |
| 2001-10-22 12:00:00 | AMZN | Stock | 0.432 | 0.44 | 0.43 | 0.434 | 8490000.0 |
| 2001-10-22 13:00:00 | AMZN | Stock | 0.433 | 0.4355 | 0.42 | 0.424 | 5826000.0 |
| 2001-10-22 14:00:00 | AMZN | Stock | 0.424 | 0.437 | 0.4235 | 0.4345 | 7298000.0 |
| 2001-10-22 15:00:00 | AMZN | Stock | 0.4345 | 0.44 | 0.431 | 0.4375 | 14220000.0 |
| 2001-10-22 16:00:00 | AMZN | Stock | 0.4375 | 0.443 | 0.42 | 0.44 | 1176000.0 |
| 2001-10-22 17:00:00 | AMZN | Stock | 0.443 | 0.443 | 0.4385 | 0.443 | 178000.0 |
| 2001-10-22 18:00:00 | AMZN | Stock | 0.4425 | 0.443 | 0.4425 | 0.443 | 38000.0 |
| 2001-10-22 09:00:00 | CL | Stock | 29.05 | 29.375 | 29.005 | 29.355 | 245800.0 |
| 2001-10-22 10:00:00 | CL | Stock | 29.325 | 29.4 | 29.125 | 29.35 | 375400.0 |
| 2001-10-22 11:00:00 | CL | Stock | 29.36 | 29.445 | 29.26 | 29.415 | 297000.0 |
| 2001-10-22 12:00:00 | CL | Stock | 29.42 | 29.47 | 29.29 | 29.375 | 290400.0 |
| 2001-10-22 13:00:00 | CL | Stock | 29.4 | 29.5 | 29.335 | 29.5 | 280800.0 |
| 2001-10-22 14:00:00 | CL | Stock | 29.5 | 29.745 | 29.45 | 29.725 | 428200.0 |
| 2001-10-22 15:00:00 | CL | Stock | 29.73 | 29.825 | 29.625 | 29.705 | 681600.0 |
| 2001-10-22 16:00:00 | CL | Stock | 29.7 | 29.705 | 29.7 | 29.705 | 43000.0 |
> showing 50 of 17,461 rows — these rows as CSV