PREVIEW / stock_1hour / 2003-07-11
file: by_date/stock_1hour/2003/2003-07-11.parquet size: 436 KB rows: 20,759 symbols: 1,580
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-11 08:00:00 | AAPL | Stock | 0.3496 | 0.3496 | 0.3496 | 0.3496 | 464800.0 |
| 2003-07-11 09:00:00 | AAPL | Stock | 0.3498 | 0.3554 | 0.3498 | 0.3525 | 17056256.0 |
| 2003-07-11 10:00:00 | AAPL | Stock | 0.3529 | 0.3568 | 0.3513 | 0.3548 | 19615512.0 |
| 2003-07-11 11:00:00 | AAPL | Stock | 0.3548 | 0.3571 | 0.353 | 0.3571 | 11231808.0 |
| 2003-07-11 12:00:00 | AAPL | Stock | 0.3568 | 0.3571 | 0.3505 | 0.3505 | 17209248.0 |
| 2003-07-11 13:00:00 | AAPL | Stock | 0.3505 | 0.3545 | 0.3488 | 0.3543 | 22146936.0 |
| 2003-07-11 14:00:00 | AAPL | Stock | 0.3543 | 0.3543 | 0.3512 | 0.3525 | 9456888.0 |
| 2003-07-11 15:00:00 | AAPL | Stock | 0.3525 | 0.3548 | 0.3521 | 0.3546 | 21579544.0 |
| 2003-07-11 16:00:00 | AAPL | Stock | 0.3546 | 0.3546 | 0.3516 | 0.3545 | 1533952.0 |
| 2003-07-11 17:00:00 | AAPL | Stock | 0.3545 | 0.3545 | 0.3536 | 0.3543 | 123200.0 |
| 2003-07-11 18:00:00 | AAPL | Stock | 0.3543 | 0.3543 | 0.3543 | 0.3543 | 56000.0 |
| 2003-07-11 08:00:00 | MSFT | Stock | 26.99 | 27.01 | 26.88 | 26.98 | 42011.0 |
| 2003-07-11 09:00:00 | MSFT | Stock | 26.99 | 27.14 | 26.89 | 27.1311 | 6036347.0 |
| 2003-07-11 10:00:00 | MSFT | Stock | 27.14 | 27.27 | 27.0 | 27.19 | 7481540.0 |
| 2003-07-11 11:00:00 | MSFT | Stock | 27.19 | 27.43 | 27.11 | 27.42 | 7732800.0 |
| 2003-07-11 12:00:00 | MSFT | Stock | 27.43 | 27.45 | 27.35 | 27.38 | 4741681.0 |
| 2003-07-11 13:00:00 | MSFT | Stock | 27.38 | 27.41 | 27.3 | 27.345 | 4671736.0 |
| 2003-07-11 14:00:00 | MSFT | Stock | 27.35 | 27.38 | 27.11 | 27.16 | 5546272.0 |
| 2003-07-11 15:00:00 | MSFT | Stock | 27.1659 | 27.45 | 27.11 | 27.3 | 8149740.0 |
| 2003-07-11 16:00:00 | MSFT | Stock | 27.3 | 27.4 | 27.02 | 27.33 | 469580.0 |
| 2003-07-11 17:00:00 | MSFT | Stock | 27.35 | 27.37 | 26.97 | 26.97 | 9246.0 |
| 2003-07-11 18:00:00 | MSFT | Stock | 27.33 | 27.352 | 27.33 | 27.35 | 4355.0 |
| 2003-07-11 08:00:00 | NVDA | Stock | 0.2025 | 0.2033 | 0.2008 | 0.2032 | 528000.0 |
| 2003-07-11 09:00:00 | NVDA | Stock | 0.2031 | 0.2062 | 0.2031 | 0.2034 | 82158600.0 |
| 2003-07-11 10:00:00 | NVDA | Stock | 0.2035 | 0.2054 | 0.2018 | 0.2041 | 113430600.0 |
| 2003-07-11 11:00:00 | NVDA | Stock | 0.2039 | 0.205 | 0.2032 | 0.2048 | 47458920.0 |
| 2003-07-11 12:00:00 | NVDA | Stock | 0.2048 | 0.2057 | 0.2038 | 0.205 | 62157840.0 |
| 2003-07-11 13:00:00 | NVDA | Stock | 0.205 | 0.2059 | 0.2046 | 0.2054 | 32107080.0 |
| 2003-07-11 14:00:00 | NVDA | Stock | 0.2052 | 0.2055 | 0.2025 | 0.2028 | 47225040.0 |
| 2003-07-11 15:00:00 | NVDA | Stock | 0.2028 | 0.2042 | 0.2021 | 0.2037 | 78964440.0 |
| 2003-07-11 16:00:00 | NVDA | Stock | 0.2037 | 0.2042 | 0.2033 | 0.2039 | 1758000.0 |
| 2003-07-11 17:00:00 | NVDA | Stock | 0.2041 | 0.2054 | 0.2041 | 0.2054 | 312000.0 |
| 2003-07-11 18:00:00 | NVDA | Stock | 0.2046 | 0.2046 | 0.2046 | 0.2046 | 12000.0 |
| 2003-07-11 08:00:00 | AMZN | Stock | 1.92 | 1.92 | 1.9045 | 1.9125 | 112000.0 |
| 2003-07-11 09:00:00 | AMZN | Stock | 1.9125 | 1.92 | 1.8835 | 1.8835 | 34170380.0 |
| 2003-07-11 10:00:00 | AMZN | Stock | 1.8835 | 1.89 | 1.8635 | 1.8725 | 46338640.0 |
| 2003-07-11 11:00:00 | AMZN | Stock | 1.872 | 1.879 | 1.8575 | 1.86 | 22748760.0 |
| 2003-07-11 12:00:00 | AMZN | Stock | 1.8605 | 1.8975 | 1.855 | 1.888 | 21757920.0 |
| 2003-07-11 13:00:00 | AMZN | Stock | 1.888 | 1.911 | 1.873 | 1.8822 | 38696420.0 |
| 2003-07-11 14:00:00 | AMZN | Stock | 1.882 | 1.8935 | 1.8695 | 1.875 | 26604340.0 |
| 2003-07-11 15:00:00 | AMZN | Stock | 1.875 | 1.8865 | 1.8705 | 1.8805 | 18599280.0 |
| 2003-07-11 16:00:00 | AMZN | Stock | 1.8805 | 1.885 | 1.878 | 1.885 | 1345100.0 |
| 2003-07-11 17:00:00 | AMZN | Stock | 1.879 | 1.8825 | 1.8761 | 1.8761 | 124600.0 |
| 2003-07-11 09:00:00 | CL | Stock | 28.65 | 28.675 | 28.5 | 28.53 | 440600.0 |
| 2003-07-11 10:00:00 | CL | Stock | 28.55 | 28.693 | 28.51 | 28.58 | 574800.0 |
| 2003-07-11 11:00:00 | CL | Stock | 28.58 | 28.62 | 28.54 | 28.605 | 264200.0 |
| 2003-07-11 12:00:00 | CL | Stock | 28.615 | 28.665 | 28.575 | 28.655 | 597800.0 |
| 2003-07-11 13:00:00 | CL | Stock | 28.65 | 28.66 | 28.57 | 28.625 | 143200.0 |
| 2003-07-11 14:00:00 | CL | Stock | 28.625 | 28.625 | 28.505 | 28.52 | 183800.0 |
| 2003-07-11 15:00:00 | CL | Stock | 28.525 | 28.65 | 28.5 | 28.635 | 476400.0 |
> showing 50 of 20,759 rows — these rows as CSV