PREVIEW / stock_1hour / 2000-10-13
file: by_date/stock_1hour/2000/2000-10-13.parquet size: 309 KB rows: 15,905 symbols: 1,238
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-10-13 08:00:00 | AAPL | Stock | 0.3566 | 0.3605 | 0.3538 | 0.3571 | 1932000.0 |
| 2000-10-13 09:00:00 | AAPL | Stock | 0.3594 | 0.3638 | 0.3538 | 0.3583 | 107402400.0 |
| 2000-10-13 10:00:00 | AAPL | Stock | 0.3583 | 0.3783 | 0.3571 | 0.3772 | 263597600.0 |
| 2000-10-13 11:00:00 | AAPL | Stock | 0.3772 | 0.3884 | 0.3728 | 0.3783 | 213623200.0 |
| 2000-10-13 12:00:00 | AAPL | Stock | 0.3783 | 0.3817 | 0.3772 | 0.3817 | 90692000.0 |
| 2000-10-13 13:00:00 | AAPL | Stock | 0.3817 | 0.394 | 0.3795 | 0.3929 | 156290400.0 |
| 2000-10-13 14:00:00 | AAPL | Stock | 0.3934 | 0.394 | 0.3839 | 0.3895 | 111003200.0 |
| 2000-10-13 15:00:00 | AAPL | Stock | 0.3895 | 0.3951 | 0.3839 | 0.3934 | 210593600.0 |
| 2000-10-13 16:00:00 | AAPL | Stock | 0.394 | 0.3945 | 0.3571 | 0.3906 | 49884800.0 |
| 2000-10-13 17:00:00 | AAPL | Stock | 0.3906 | 0.394 | 0.3895 | 0.3895 | 929600.0 |
| 2000-10-13 18:00:00 | AAPL | Stock | 0.3906 | 0.3917 | 0.3906 | 0.3906 | 44800.0 |
| 2000-10-13 08:00:00 | MSFT | Stock | 27.1875 | 27.5 | 27.0 | 27.25 | 57600.0 |
| 2000-10-13 09:00:00 | MSFT | Stock | 27.2812 | 27.2812 | 26.75 | 27.2188 | 12008800.0 |
| 2000-10-13 10:00:00 | MSFT | Stock | 27.25 | 27.4375 | 26.875 | 26.9688 | 12448400.0 |
| 2000-10-13 11:00:00 | MSFT | Stock | 26.9688 | 27.0312 | 26.7812 | 26.875 | 12433200.0 |
| 2000-10-13 12:00:00 | MSFT | Stock | 26.8594 | 26.9375 | 26.25 | 26.3125 | 18102800.0 |
| 2000-10-13 13:00:00 | MSFT | Stock | 26.3125 | 26.6406 | 26.0625 | 26.2188 | 13066800.0 |
| 2000-10-13 14:00:00 | MSFT | Stock | 26.2188 | 26.875 | 26.1562 | 26.8125 | 13692600.0 |
| 2000-10-13 15:00:00 | MSFT | Stock | 26.8125 | 27.0 | 26.375 | 26.8438 | 15612800.0 |
| 2000-10-13 16:00:00 | MSFT | Stock | 26.875 | 27.125 | 26.4688 | 27.0312 | 4310000.0 |
| 2000-10-13 17:00:00 | MSFT | Stock | 27.0 | 27.125 | 26.9375 | 27.0312 | 37000.0 |
| 2000-10-13 18:00:00 | MSFT | Stock | 27.0 | 27.125 | 27.0 | 27.0625 | 16200.0 |
| 2000-10-13 08:00:00 | NVDA | Stock | 0.2625 | 0.2625 | 0.2617 | 0.2625 | 312000.0 |
| 2000-10-13 09:00:00 | NVDA | Stock | 0.262 | 0.2724 | 0.2599 | 0.2724 | 36600000.0 |
| 2000-10-13 10:00:00 | NVDA | Stock | 0.2719 | 0.2792 | 0.2682 | 0.2734 | 59688000.0 |
| 2000-10-13 11:00:00 | NVDA | Stock | 0.2742 | 0.275 | 0.2688 | 0.2719 | 58800000.0 |
| 2000-10-13 12:00:00 | NVDA | Stock | 0.2724 | 0.2771 | 0.2714 | 0.2759 | 66216000.0 |
| 2000-10-13 13:00:00 | NVDA | Stock | 0.2742 | 0.2786 | 0.2727 | 0.2772 | 62016000.0 |
| 2000-10-13 14:00:00 | NVDA | Stock | 0.2771 | 0.2792 | 0.2766 | 0.2781 | 103392000.0 |
| 2000-10-13 15:00:00 | NVDA | Stock | 0.2776 | 0.2779 | 0.2708 | 0.2714 | 121176000.0 |
| 2000-10-13 16:00:00 | NVDA | Stock | 0.2714 | 0.2781 | 0.2708 | 0.2708 | 43176000.0 |
| 2000-10-13 08:00:00 | AMZN | Stock | 1.25 | 1.2625 | 1.2375 | 1.2531 | 236000.0 |
| 2000-10-13 09:00:00 | AMZN | Stock | 1.25 | 1.2656 | 1.175 | 1.2656 | 37670000.0 |
| 2000-10-13 10:00:00 | AMZN | Stock | 1.2641 | 1.4 | 1.2594 | 1.3031 | 29160000.0 |
| 2000-10-13 11:00:00 | AMZN | Stock | 1.3031 | 1.3438 | 1.275 | 1.3344 | 11228000.0 |
| 2000-10-13 12:00:00 | AMZN | Stock | 1.3344 | 1.35 | 1.3 | 1.3094 | 8480000.0 |
| 2000-10-13 13:00:00 | AMZN | Stock | 1.3125 | 1.3531 | 1.3094 | 1.3438 | 9652000.0 |
| 2000-10-13 14:00:00 | AMZN | Stock | 1.3438 | 1.3938 | 1.3375 | 1.3906 | 12986000.0 |
| 2000-10-13 15:00:00 | AMZN | Stock | 1.3891 | 1.4438 | 1.3719 | 1.4203 | 27480000.0 |
| 2000-10-13 16:00:00 | AMZN | Stock | 1.4188 | 1.425 | 1.2203 | 1.4188 | 3088000.0 |
| 2000-10-13 17:00:00 | AMZN | Stock | 1.4 | 1.4313 | 1.3969 | 1.4313 | 116000.0 |
| 2000-10-13 18:00:00 | AMZN | Stock | 1.4313 | 1.4562 | 1.4313 | 1.4562 | 68000.0 |
| 2000-10-13 09:00:00 | CL | Stock | 24.4 | 24.5 | 24.375 | 24.5 | 469000.0 |
| 2000-10-13 10:00:00 | CL | Stock | 24.495 | 24.725 | 24.475 | 24.57 | 888200.0 |
| 2000-10-13 11:00:00 | CL | Stock | 24.58 | 24.74 | 24.58 | 24.74 | 534800.0 |
| 2000-10-13 12:00:00 | CL | Stock | 24.735 | 24.805 | 24.725 | 24.8 | 903800.0 |
| 2000-10-13 13:00:00 | CL | Stock | 24.82 | 24.82 | 24.75 | 24.775 | 807200.0 |
| 2000-10-13 14:00:00 | CL | Stock | 24.78 | 25.055 | 24.78 | 25.05 | 558400.0 |
| 2000-10-13 15:00:00 | CL | Stock | 25.045 | 25.215 | 25.045 | 25.21 | 1510400.0 |
| 2000-10-13 16:00:00 | CL | Stock | 25.21 | 25.21 | 24.86 | 24.86 | 1044200.0 |
> showing 50 of 15,905 rows — these rows as CSV