PREVIEW / stock_1hour / 2002-10-16
file: by_date/stock_1hour/2002/2002-10-16.parquet size: 419 KB rows: 19,930 symbols: 1,502
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 |
|---|---|---|---|---|---|---|---|
| 2002-10-16 08:00:00 | AAPL | Stock | 0.2648 | 0.2679 | 0.2634 | 0.2661 | 380800.0 |
| 2002-10-16 09:00:00 | AAPL | Stock | 0.2643 | 0.2702 | 0.2643 | 0.2689 | 39609920.0 |
| 2002-10-16 10:00:00 | AAPL | Stock | 0.2689 | 0.2693 | 0.2598 | 0.2605 | 42179368.0 |
| 2002-10-16 11:00:00 | AAPL | Stock | 0.2607 | 0.2616 | 0.26 | 0.2607 | 19214720.0 |
| 2002-10-16 12:00:00 | AAPL | Stock | 0.2607 | 0.2609 | 0.2589 | 0.26 | 15587096.0 |
| 2002-10-16 13:00:00 | AAPL | Stock | 0.26 | 0.2616 | 0.2589 | 0.2593 | 15737568.0 |
| 2002-10-16 14:00:00 | AAPL | Stock | 0.2595 | 0.2613 | 0.2584 | 0.2609 | 29150912.0 |
| 2002-10-16 15:00:00 | AAPL | Stock | 0.2609 | 0.2634 | 0.2582 | 0.2598 | 63177968.0 |
| 2002-10-16 16:00:00 | AAPL | Stock | 0.26 | 0.2638 | 0.2379 | 0.2436 | 59533096.0 |
| 2002-10-16 17:00:00 | AAPL | Stock | 0.2441 | 0.26 | 0.2425 | 0.2514 | 5523728.0 |
| 2002-10-16 18:00:00 | AAPL | Stock | 0.2509 | 0.2527 | 0.2489 | 0.2518 | 940800.0 |
| 2002-10-16 08:00:00 | MSFT | Stock | 25.15 | 26.14 | 25.075 | 25.4 | 312400.0 |
| 2002-10-16 09:00:00 | MSFT | Stock | 25.3055 | 26.14 | 25.15 | 25.55 | 23212640.0 |
| 2002-10-16 10:00:00 | MSFT | Stock | 25.545 | 25.63 | 25.29 | 25.465 | 19360468.0 |
| 2002-10-16 11:00:00 | MSFT | Stock | 25.465 | 25.58 | 25.275 | 25.375 | 11687178.0 |
| 2002-10-16 12:00:00 | MSFT | Stock | 25.37 | 25.375 | 25.245 | 25.295 | 7128024.0 |
| 2002-10-16 13:00:00 | MSFT | Stock | 25.2975 | 25.345 | 25.165 | 25.205 | 7175736.0 |
| 2002-10-16 14:00:00 | MSFT | Stock | 25.205 | 25.3665 | 25.14 | 25.305 | 9326190.0 |
| 2002-10-16 15:00:00 | MSFT | Stock | 25.305 | 25.4 | 25.145 | 25.255 | 12942788.0 |
| 2002-10-16 16:00:00 | MSFT | Stock | 25.21 | 26.035 | 25.175 | 25.49 | 2346648.0 |
| 2002-10-16 17:00:00 | MSFT | Stock | 25.505 | 25.975 | 25.205 | 25.885 | 560490.0 |
| 2002-10-16 18:00:00 | MSFT | Stock | 25.885 | 25.92 | 25.84 | 25.9 | 38520.0 |
| 2002-10-16 08:00:00 | NVDA | Stock | 0.0725 | 0.0729 | 0.0708 | 0.0717 | 3552000.0 |
| 2002-10-16 09:00:00 | NVDA | Stock | 0.0717 | 0.0782 | 0.0709 | 0.0728 | 149339880.0 |
| 2002-10-16 10:00:00 | NVDA | Stock | 0.0729 | 0.074 | 0.0722 | 0.073 | 111128520.0 |
| 2002-10-16 11:00:00 | NVDA | Stock | 0.073 | 0.0732 | 0.0719 | 0.0725 | 53880840.0 |
| 2002-10-16 12:00:00 | NVDA | Stock | 0.0725 | 0.0725 | 0.0709 | 0.0712 | 53098560.0 |
| 2002-10-16 13:00:00 | NVDA | Stock | 0.0712 | 0.0717 | 0.0709 | 0.0712 | 38942760.0 |
| 2002-10-16 14:00:00 | NVDA | Stock | 0.0711 | 0.0722 | 0.0708 | 0.0716 | 55733400.0 |
| 2002-10-16 15:00:00 | NVDA | Stock | 0.0716 | 0.0723 | 0.0708 | 0.0721 | 82628760.0 |
| 2002-10-16 16:00:00 | NVDA | Stock | 0.0721 | 0.0754 | 0.0717 | 0.0729 | 24845880.0 |
| 2002-10-16 17:00:00 | NVDA | Stock | 0.0733 | 0.0748 | 0.0721 | 0.0746 | 2779680.0 |
| 2002-10-16 18:00:00 | NVDA | Stock | 0.0736 | 0.0743 | 0.0733 | 0.0743 | 388920.0 |
| 2002-10-16 08:00:00 | AMZN | Stock | 0.9215 | 0.941 | 0.909 | 0.935 | 319520.0 |
| 2002-10-16 09:00:00 | AMZN | Stock | 0.9325 | 0.9565 | 0.91 | 0.95 | 28114380.0 |
| 2002-10-16 10:00:00 | AMZN | Stock | 0.951 | 0.9695 | 0.9475 | 0.9655 | 30445680.0 |
| 2002-10-16 11:00:00 | AMZN | Stock | 0.9655 | 0.9715 | 0.959 | 0.968 | 17536000.0 |
| 2002-10-16 12:00:00 | AMZN | Stock | 0.9685 | 0.97 | 0.9615 | 0.9685 | 20686100.0 |
| 2002-10-16 13:00:00 | AMZN | Stock | 0.969 | 0.9695 | 0.9555 | 0.9595 | 19005040.0 |
| 2002-10-16 14:00:00 | AMZN | Stock | 0.9595 | 0.966 | 0.9573 | 0.96 | 14299860.0 |
| 2002-10-16 15:00:00 | AMZN | Stock | 0.9595 | 0.9735 | 0.958 | 0.9725 | 24511180.0 |
| 2002-10-16 16:00:00 | AMZN | Stock | 0.9728 | 0.9844 | 0.966 | 0.98 | 14787920.0 |
| 2002-10-16 17:00:00 | AMZN | Stock | 0.98 | 0.991 | 0.9745 | 0.9895 | 180140.0 |
| 2002-10-16 18:00:00 | AMZN | Stock | 0.9895 | 0.9925 | 0.985 | 0.985 | 24000.0 |
| 2002-10-16 09:00:00 | CL | Stock | 27.975 | 27.99 | 27.85 | 27.975 | 752400.0 |
| 2002-10-16 10:00:00 | CL | Stock | 27.975 | 28.095 | 27.675 | 27.83 | 624400.0 |
| 2002-10-16 11:00:00 | CL | Stock | 27.83 | 27.875 | 27.625 | 27.63 | 542200.0 |
| 2002-10-16 12:00:00 | CL | Stock | 27.625 | 27.625 | 27.41 | 27.47 | 765600.0 |
| 2002-10-16 13:00:00 | CL | Stock | 27.475 | 27.475 | 27.34 | 27.4 | 652400.0 |
| 2002-10-16 14:00:00 | CL | Stock | 27.38 | 27.545 | 27.38 | 27.47 | 679000.0 |
> showing 50 of 19,930 rows — these rows as CSV