PREVIEW / stock_1hour / 2002-06-26
file: by_date/stock_1hour/2002/2002-06-26.parquet size: 424 KB rows: 19,854 symbols: 1,447
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-06-26 08:00:00 | AAPL | Stock | 0.2946 | 0.3123 | 0.2938 | 0.2946 | 655200.0 |
| 2002-06-26 09:00:00 | AAPL | Stock | 0.2946 | 0.3088 | 0.2945 | 0.3013 | 54107200.0 |
| 2002-06-26 10:00:00 | AAPL | Stock | 0.3014 | 0.3036 | 0.2975 | 0.2993 | 54616800.0 |
| 2002-06-26 11:00:00 | AAPL | Stock | 0.2996 | 0.303 | 0.2991 | 0.3022 | 55020000.0 |
| 2002-06-26 12:00:00 | AAPL | Stock | 0.3029 | 0.303 | 0.2975 | 0.2975 | 17925600.0 |
| 2002-06-26 13:00:00 | AAPL | Stock | 0.2973 | 0.2982 | 0.2891 | 0.29 | 38343200.0 |
| 2002-06-26 14:00:00 | AAPL | Stock | 0.29 | 0.2929 | 0.2854 | 0.2895 | 105050400.0 |
| 2002-06-26 15:00:00 | AAPL | Stock | 0.2898 | 0.298 | 0.2888 | 0.2957 | 94953600.0 |
| 2002-06-26 16:00:00 | AAPL | Stock | 0.2964 | 0.2991 | 0.2929 | 0.2975 | 30083200.0 |
| 2002-06-26 17:00:00 | AAPL | Stock | 0.2923 | 0.2962 | 0.2923 | 0.2923 | 358400.0 |
| 2002-06-26 18:00:00 | AAPL | Stock | 0.2955 | 0.2955 | 0.2955 | 0.2955 | 408800.0 |
| 2002-06-26 08:00:00 | MSFT | Stock | 25.675 | 25.74 | 25.495 | 25.6 | 331400.0 |
| 2002-06-26 09:00:00 | MSFT | Stock | 25.61 | 26.44 | 25.524 | 26.035 | 15036400.0 |
| 2002-06-26 10:00:00 | MSFT | Stock | 26.0385 | 26.17 | 25.7 | 25.95 | 16308800.0 |
| 2002-06-26 11:00:00 | MSFT | Stock | 25.93 | 26.4905 | 25.91 | 26.47 | 12179000.0 |
| 2002-06-26 12:00:00 | MSFT | Stock | 26.47 | 26.475 | 26.18 | 26.185 | 7064600.0 |
| 2002-06-26 13:00:00 | MSFT | Stock | 26.185 | 26.295 | 26.005 | 26.065 | 6789800.0 |
| 2002-06-26 14:00:00 | MSFT | Stock | 26.065 | 26.585 | 25.95 | 26.399 | 13651400.0 |
| 2002-06-26 15:00:00 | MSFT | Stock | 26.403 | 27.195 | 26.35 | 27.065 | 20052600.0 |
| 2002-06-26 16:00:00 | MSFT | Stock | 27.06 | 27.135 | 26.234 | 27.065 | 1553400.0 |
| 2002-06-26 17:00:00 | MSFT | Stock | 27.065 | 27.065 | 26.3014 | 27.05 | 151200.0 |
| 2002-06-26 18:00:00 | MSFT | Stock | 27.05 | 27.065 | 27.05 | 27.05 | 49200.0 |
| 2002-06-26 08:00:00 | NVDA | Stock | 0.161 | 0.1751 | 0.1562 | 0.1598 | 8988000.0 |
| 2002-06-26 09:00:00 | NVDA | Stock | 0.1596 | 0.1627 | 0.1522 | 0.162 | 428568000.0 |
| 2002-06-26 10:00:00 | NVDA | Stock | 0.1622 | 0.1668 | 0.1612 | 0.1648 | 336792000.0 |
| 2002-06-26 11:00:00 | NVDA | Stock | 0.1648 | 0.1732 | 0.1635 | 0.1728 | 226152000.0 |
| 2002-06-26 12:00:00 | NVDA | Stock | 0.1728 | 0.1729 | 0.1653 | 0.1657 | 140220000.0 |
| 2002-06-26 13:00:00 | NVDA | Stock | 0.1657 | 0.1667 | 0.1633 | 0.1642 | 114252000.0 |
| 2002-06-26 14:00:00 | NVDA | Stock | 0.1642 | 0.1677 | 0.1612 | 0.1652 | 210336000.0 |
| 2002-06-26 15:00:00 | NVDA | Stock | 0.1653 | 0.1704 | 0.1642 | 0.1668 | 249048000.0 |
| 2002-06-26 16:00:00 | NVDA | Stock | 0.1667 | 0.17 | 0.1596 | 0.1699 | 34308000.0 |
| 2002-06-26 17:00:00 | NVDA | Stock | 0.1667 | 0.1708 | 0.1661 | 0.1699 | 816000.0 |
| 2002-06-26 18:00:00 | NVDA | Stock | 0.1699 | 0.1707 | 0.1672 | 0.1704 | 384000.0 |
| 2002-06-26 08:00:00 | AMZN | Stock | 0.7295 | 0.73 | 0.7125 | 0.725 | 1144000.0 |
| 2002-06-26 09:00:00 | AMZN | Stock | 0.7175 | 0.774 | 0.7125 | 0.774 | 41186000.0 |
| 2002-06-26 10:00:00 | AMZN | Stock | 0.774 | 0.792 | 0.7665 | 0.7795 | 34174000.0 |
| 2002-06-26 11:00:00 | AMZN | Stock | 0.7806 | 0.792 | 0.7765 | 0.7919 | 13270000.0 |
| 2002-06-26 12:00:00 | AMZN | Stock | 0.7891 | 0.7895 | 0.774 | 0.775 | 12822000.0 |
| 2002-06-26 13:00:00 | AMZN | Stock | 0.7745 | 0.781 | 0.77 | 0.7705 | 9770000.0 |
| 2002-06-26 14:00:00 | AMZN | Stock | 0.7705 | 0.7856 | 0.765 | 0.7795 | 13264000.0 |
| 2002-06-26 15:00:00 | AMZN | Stock | 0.779 | 0.7965 | 0.7765 | 0.791 | 15380000.0 |
| 2002-06-26 16:00:00 | AMZN | Stock | 0.791 | 0.805 | 0.7812 | 0.8 | 1212000.0 |
| 2002-06-26 17:00:00 | AMZN | Stock | 0.7828 | 0.8 | 0.7828 | 0.797 | 182000.0 |
| 2002-06-26 18:00:00 | AMZN | Stock | 0.7925 | 0.7925 | 0.7925 | 0.7925 | 116000.0 |
| 2002-06-26 09:00:00 | CL | Stock | 23.7 | 23.77 | 23.6 | 23.675 | 734200.0 |
| 2002-06-26 10:00:00 | CL | Stock | 23.675 | 23.775 | 23.26 | 23.415 | 995800.0 |
| 2002-06-26 11:00:00 | CL | Stock | 23.41 | 23.5 | 23.18 | 23.45 | 792600.0 |
| 2002-06-26 12:00:00 | CL | Stock | 23.41 | 23.41 | 23.13 | 23.225 | 835400.0 |
| 2002-06-26 13:00:00 | CL | Stock | 23.225 | 23.7 | 22.95 | 23.425 | 1406800.0 |
| 2002-06-26 14:00:00 | CL | Stock | 23.425 | 24.225 | 23.425 | 24.15 | 2024800.0 |
> showing 50 of 19,854 rows — these rows as CSV