PREVIEW / stock_1hour / 2003-07-02
file: by_date/stock_1hour/2003/2003-07-02.parquet size: 482 KB rows: 22,983 symbols: 1,594
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 |
|---|---|---|---|---|---|---|---|
| 2003-07-02 08:00:00 | AAPL | Stock | 0.3418 | 0.3425 | 0.3418 | 0.3425 | 16800.0 |
| 2003-07-02 09:00:00 | AAPL | Stock | 0.3425 | 0.3438 | 0.3393 | 0.3438 | 37921296.0 |
| 2003-07-02 10:00:00 | AAPL | Stock | 0.3436 | 0.3464 | 0.3432 | 0.3454 | 67779320.0 |
| 2003-07-02 11:00:00 | AAPL | Stock | 0.3454 | 0.3457 | 0.3429 | 0.3446 | 21129584.0 |
| 2003-07-02 12:00:00 | AAPL | Stock | 0.3446 | 0.345 | 0.3436 | 0.3447 | 28000896.0 |
| 2003-07-02 13:00:00 | AAPL | Stock | 0.3446 | 0.345 | 0.3439 | 0.3448 | 34639976.0 |
| 2003-07-02 14:00:00 | AAPL | Stock | 0.3446 | 0.3455 | 0.3438 | 0.3443 | 31254664.0 |
| 2003-07-02 15:00:00 | AAPL | Stock | 0.3443 | 0.345 | 0.3418 | 0.3441 | 48044192.0 |
| 2003-07-02 16:00:00 | AAPL | Stock | 0.3441 | 0.3464 | 0.3429 | 0.3441 | 5862304.0 |
| 2003-07-02 17:00:00 | AAPL | Stock | 0.3452 | 0.3452 | 0.3452 | 0.3452 | 2116800.0 |
| 2003-07-02 18:00:00 | AAPL | Stock | 0.3452 | 0.3452 | 0.3452 | 0.3452 | 666400.0 |
| 2003-07-02 08:00:00 | MSFT | Stock | 26.85 | 27.0 | 26.32 | 26.7 | 1486404.0 |
| 2003-07-02 09:00:00 | MSFT | Stock | 26.7 | 26.99 | 26.15 | 26.85 | 21884767.0 |
| 2003-07-02 10:00:00 | MSFT | Stock | 26.87 | 26.92 | 26.76 | 26.89 | 14856163.0 |
| 2003-07-02 11:00:00 | MSFT | Stock | 26.88 | 26.93 | 26.73 | 26.82 | 8052694.0 |
| 2003-07-02 12:00:00 | MSFT | Stock | 26.83 | 26.86 | 26.76 | 26.8 | 5905148.0 |
| 2003-07-02 13:00:00 | MSFT | Stock | 26.79 | 26.81 | 26.69 | 26.72 | 6876076.0 |
| 2003-07-02 14:00:00 | MSFT | Stock | 26.7113 | 26.8 | 26.64 | 26.78 | 6871675.0 |
| 2003-07-02 15:00:00 | MSFT | Stock | 26.77 | 26.9 | 26.68 | 26.87 | 11156548.0 |
| 2003-07-02 16:00:00 | MSFT | Stock | 26.87 | 26.92 | 26.85 | 26.86 | 2457738.0 |
| 2003-07-02 17:00:00 | MSFT | Stock | 26.87 | 26.881 | 26.15 | 26.86 | 1454034.0 |
| 2003-07-02 18:00:00 | MSFT | Stock | 26.881 | 26.89 | 26.85 | 26.88 | 93804.0 |
| 2003-07-02 08:00:00 | NVDA | Stock | 0.1987 | 0.2007 | 0.1987 | 0.1997 | 1392000.0 |
| 2003-07-02 09:00:00 | NVDA | Stock | 0.1996 | 0.2032 | 0.1984 | 0.2022 | 138976200.0 |
| 2003-07-02 10:00:00 | NVDA | Stock | 0.2022 | 0.2031 | 0.1977 | 0.1986 | 167087520.0 |
| 2003-07-02 11:00:00 | NVDA | Stock | 0.1986 | 0.1988 | 0.1954 | 0.1972 | 112059840.0 |
| 2003-07-02 12:00:00 | NVDA | Stock | 0.1972 | 0.1985 | 0.1962 | 0.1985 | 65086560.0 |
| 2003-07-02 13:00:00 | NVDA | Stock | 0.1984 | 0.2005 | 0.1979 | 0.1993 | 86542080.0 |
| 2003-07-02 14:00:00 | NVDA | Stock | 0.1993 | 0.1994 | 0.1974 | 0.1982 | 52330920.0 |
| 2003-07-02 15:00:00 | NVDA | Stock | 0.1983 | 0.1992 | 0.1971 | 0.1982 | 105551880.0 |
| 2003-07-02 16:00:00 | NVDA | Stock | 0.1982 | 0.199 | 0.1972 | 0.1975 | 26763600.0 |
| 2003-07-02 17:00:00 | NVDA | Stock | 0.1975 | 0.1982 | 0.1975 | 0.1977 | 4872000.0 |
| 2003-07-02 18:00:00 | NVDA | Stock | 0.1981 | 0.1981 | 0.1975 | 0.1981 | 648000.0 |
| 2003-07-02 08:00:00 | AMZN | Stock | 1.87 | 1.8744 | 1.8675 | 1.8701 | 134000.0 |
| 2003-07-02 09:00:00 | AMZN | Stock | 1.8701 | 1.886 | 1.857 | 1.8745 | 26491260.0 |
| 2003-07-02 10:00:00 | AMZN | Stock | 1.875 | 1.887 | 1.8685 | 1.883 | 20283540.0 |
| 2003-07-02 11:00:00 | AMZN | Stock | 1.884 | 1.8855 | 1.8705 | 1.875 | 12277300.0 |
| 2003-07-02 12:00:00 | AMZN | Stock | 1.875 | 1.883 | 1.87 | 1.882 | 9591800.0 |
| 2003-07-02 13:00:00 | AMZN | Stock | 1.8825 | 1.8855 | 1.8755 | 1.8815 | 8688940.0 |
| 2003-07-02 14:00:00 | AMZN | Stock | 1.8815 | 1.8825 | 1.87 | 1.8786 | 11902520.0 |
| 2003-07-02 15:00:00 | AMZN | Stock | 1.8785 | 1.8945 | 1.875 | 1.893 | 16291660.0 |
| 2003-07-02 16:00:00 | AMZN | Stock | 1.8925 | 1.894 | 1.878 | 1.878 | 2526000.0 |
| 2003-07-02 17:00:00 | AMZN | Stock | 1.89 | 1.8925 | 1.89 | 1.8925 | 711600.0 |
| 2003-07-02 18:00:00 | AMZN | Stock | 1.8915 | 1.894 | 1.8915 | 1.894 | 168000.0 |
| 2003-07-02 09:00:00 | CL | Stock | 29.25 | 29.26 | 29.15 | 29.24 | 155200.0 |
| 2003-07-02 10:00:00 | CL | Stock | 29.245 | 29.25 | 29.135 | 29.25 | 1108200.0 |
| 2003-07-02 11:00:00 | CL | Stock | 29.25 | 29.29 | 29.17 | 29.19 | 354000.0 |
| 2003-07-02 12:00:00 | CL | Stock | 29.19 | 29.22 | 29.165 | 29.195 | 229400.0 |
| 2003-07-02 13:00:00 | CL | Stock | 29.19 | 29.225 | 29.125 | 29.145 | 265600.0 |
| 2003-07-02 14:00:00 | CL | Stock | 29.135 | 29.195 | 29.1 | 29.195 | 326000.0 |
> showing 50 of 22,983 rows — these rows as CSV