PREVIEW / stock_1hour / 2001-10-25
file: by_date/stock_1hour/2001/2001-10-25.parquet size: 366 KB rows: 17,826 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-25 08:00:00 | AAPL | Stock | 0.3383 | 0.3383 | 0.3205 | 0.3295 | 515200.0 |
| 2001-10-25 09:00:00 | AAPL | Stock | 0.3286 | 0.332 | 0.3254 | 0.3294 | 28996800.0 |
| 2001-10-25 10:00:00 | AAPL | Stock | 0.3291 | 0.3304 | 0.3243 | 0.328 | 50080800.0 |
| 2001-10-25 11:00:00 | AAPL | Stock | 0.3279 | 0.3325 | 0.3252 | 0.3293 | 15820000.0 |
| 2001-10-25 12:00:00 | AAPL | Stock | 0.3291 | 0.3348 | 0.3286 | 0.3316 | 16945600.0 |
| 2001-10-25 13:00:00 | AAPL | Stock | 0.3316 | 0.3368 | 0.3316 | 0.3327 | 18944800.0 |
| 2001-10-25 14:00:00 | AAPL | Stock | 0.3327 | 0.3438 | 0.3327 | 0.3398 | 46670400.0 |
| 2001-10-25 15:00:00 | AAPL | Stock | 0.3398 | 0.3436 | 0.3384 | 0.3407 | 60653600.0 |
| 2001-10-25 16:00:00 | AAPL | Stock | 0.3405 | 0.3427 | 0.335 | 0.335 | 9850400.0 |
| 2001-10-25 17:00:00 | AAPL | Stock | 0.3357 | 0.3427 | 0.3357 | 0.3427 | 1372000.0 |
| 2001-10-25 08:00:00 | MSFT | Stock | 30.5 | 30.6625 | 30.16 | 30.265 | 246600.0 |
| 2001-10-25 09:00:00 | MSFT | Stock | 30.25 | 30.41 | 29.85 | 30.0 | 11168200.0 |
| 2001-10-25 10:00:00 | MSFT | Stock | 29.985 | 30.055 | 29.785 | 29.995 | 10480400.0 |
| 2001-10-25 11:00:00 | MSFT | Stock | 30.0 | 30.125 | 29.825 | 29.955 | 5764600.0 |
| 2001-10-25 12:00:00 | MSFT | Stock | 29.96 | 30.17 | 29.92 | 30.105 | 5208800.0 |
| 2001-10-25 13:00:00 | MSFT | Stock | 30.1 | 30.57 | 30.1 | 30.32 | 9558000.0 |
| 2001-10-25 14:00:00 | MSFT | Stock | 30.33 | 31.225 | 30.315 | 31.02 | 15943200.0 |
| 2001-10-25 15:00:00 | MSFT | Stock | 31.0 | 31.3 | 30.97 | 31.28 | 12651200.0 |
| 2001-10-25 16:00:00 | MSFT | Stock | 31.255 | 31.3 | 30.4595 | 31.175 | 2059200.0 |
| 2001-10-25 17:00:00 | MSFT | Stock | 30.3 | 31.28 | 30.3 | 31.12 | 610200.0 |
| 2001-10-25 18:00:00 | MSFT | Stock | 31.16 | 31.16 | 31.16 | 31.16 | 1000.0 |
| 2001-10-25 08:00:00 | NVDA | Stock | 0.3792 | 0.3827 | 0.3779 | 0.38 | 2556000.0 |
| 2001-10-25 09:00:00 | NVDA | Stock | 0.3792 | 0.3825 | 0.3733 | 0.382 | 117816000.0 |
| 2001-10-25 10:00:00 | NVDA | Stock | 0.3822 | 0.3902 | 0.3754 | 0.3882 | 212232000.0 |
| 2001-10-25 11:00:00 | NVDA | Stock | 0.3882 | 0.3891 | 0.3787 | 0.3798 | 135768000.0 |
| 2001-10-25 12:00:00 | NVDA | Stock | 0.38 | 0.3858 | 0.38 | 0.3857 | 86604000.0 |
| 2001-10-25 13:00:00 | NVDA | Stock | 0.3853 | 0.3892 | 0.3837 | 0.3874 | 88332000.0 |
| 2001-10-25 14:00:00 | NVDA | Stock | 0.3871 | 0.4037 | 0.3862 | 0.4007 | 198648000.0 |
| 2001-10-25 15:00:00 | NVDA | Stock | 0.4013 | 0.4178 | 0.3996 | 0.4103 | 233280000.0 |
| 2001-10-25 16:00:00 | NVDA | Stock | 0.4102 | 0.4128 | 0.3787 | 0.4109 | 59832000.0 |
| 2001-10-25 17:00:00 | NVDA | Stock | 0.4067 | 0.4109 | 0.4048 | 0.4058 | 1080000.0 |
| 2001-10-25 18:00:00 | NVDA | Stock | 0.4062 | 0.4062 | 0.4058 | 0.4058 | 96000.0 |
| 2001-10-25 08:00:00 | AMZN | Stock | 0.392 | 0.4 | 0.378 | 0.378 | 754000.0 |
| 2001-10-25 09:00:00 | AMZN | Stock | 0.3825 | 0.3825 | 0.3575 | 0.3655 | 27402000.0 |
| 2001-10-25 10:00:00 | AMZN | Stock | 0.368 | 0.3705 | 0.36 | 0.369 | 24804000.0 |
| 2001-10-25 11:00:00 | AMZN | Stock | 0.368 | 0.3765 | 0.3652 | 0.3735 | 17338000.0 |
| 2001-10-25 12:00:00 | AMZN | Stock | 0.3735 | 0.374 | 0.367 | 0.371 | 11748000.0 |
| 2001-10-25 13:00:00 | AMZN | Stock | 0.3715 | 0.3775 | 0.3715 | 0.3765 | 9664000.0 |
| 2001-10-25 14:00:00 | AMZN | Stock | 0.3765 | 0.3834 | 0.3745 | 0.3795 | 21516000.0 |
| 2001-10-25 15:00:00 | AMZN | Stock | 0.3775 | 0.389 | 0.375 | 0.3885 | 50886000.0 |
| 2001-10-25 16:00:00 | AMZN | Stock | 0.3885 | 0.3895 | 0.3775 | 0.383 | 11388000.0 |
| 2001-10-25 17:00:00 | AMZN | Stock | 0.3885 | 0.3885 | 0.3785 | 0.3785 | 120000.0 |
| 2001-10-25 18:00:00 | AMZN | Stock | 0.38 | 0.382 | 0.3785 | 0.3785 | 48000.0 |
| 2001-10-25 09:00:00 | CL | Stock | 29.12 | 29.15 | 28.995 | 29.0 | 236000.0 |
| 2001-10-25 10:00:00 | CL | Stock | 29.03 | 29.03 | 28.575 | 28.825 | 396800.0 |
| 2001-10-25 11:00:00 | CL | Stock | 28.81 | 29.13 | 28.75 | 28.88 | 300600.0 |
| 2001-10-25 12:00:00 | CL | Stock | 28.885 | 28.91 | 28.68 | 28.725 | 190800.0 |
| 2001-10-25 13:00:00 | CL | Stock | 28.73 | 29.125 | 28.725 | 29.105 | 201800.0 |
| 2001-10-25 14:00:00 | CL | Stock | 29.105 | 29.45 | 28.97 | 29.34 | 362200.0 |
| 2001-10-25 15:00:00 | CL | Stock | 29.345 | 29.49 | 29.325 | 29.435 | 468800.0 |
> showing 50 of 17,826 rows — these rows as CSV