PREVIEW / stock_1hour / 2003-09-10
file: by_date/stock_1hour/2003/2003-09-10.parquet size: 463 KB rows: 21,948 symbols: 1,616
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-09-10 08:00:00 | AAPL | Stock | 0.3994 | 0.3994 | 0.3982 | 0.3982 | 28000.0 |
| 2003-09-10 09:00:00 | AAPL | Stock | 0.3977 | 0.4038 | 0.3948 | 0.403 | 23641912.0 |
| 2003-09-10 10:00:00 | AAPL | Stock | 0.4029 | 0.4029 | 0.3982 | 0.4018 | 25115832.0 |
| 2003-09-10 11:00:00 | AAPL | Stock | 0.4014 | 0.4029 | 0.3986 | 0.4007 | 17834712.0 |
| 2003-09-10 12:00:00 | AAPL | Stock | 0.4005 | 0.4025 | 0.4 | 0.4013 | 12417776.0 |
| 2003-09-10 13:00:00 | AAPL | Stock | 0.4013 | 0.4029 | 0.4007 | 0.4011 | 11394936.0 |
| 2003-09-10 14:00:00 | AAPL | Stock | 0.4009 | 0.4013 | 0.3973 | 0.3977 | 25100208.0 |
| 2003-09-10 15:00:00 | AAPL | Stock | 0.398 | 0.3989 | 0.3952 | 0.3977 | 77312760.0 |
| 2003-09-10 16:00:00 | AAPL | Stock | 0.398 | 0.4009 | 0.3961 | 0.3975 | 7878696.0 |
| 2003-09-10 17:00:00 | AAPL | Stock | 0.3975 | 0.3991 | 0.3975 | 0.3975 | 957600.0 |
| 2003-09-10 08:00:00 | MSFT | Stock | 28.25 | 28.37 | 28.1 | 28.1 | 23700.0 |
| 2003-09-10 09:00:00 | MSFT | Stock | 28.14 | 28.38 | 27.9 | 28.12 | 9608728.0 |
| 2003-09-10 10:00:00 | MSFT | Stock | 28.121 | 28.13 | 27.95 | 28.06 | 6494566.0 |
| 2003-09-10 11:00:00 | MSFT | Stock | 28.06 | 28.08 | 27.92 | 28.02 | 4429089.0 |
| 2003-09-10 12:00:00 | MSFT | Stock | 28.02 | 28.07 | 27.96 | 28.04 | 3578146.0 |
| 2003-09-10 13:00:00 | MSFT | Stock | 28.04 | 28.08 | 27.93 | 27.96 | 3551061.0 |
| 2003-09-10 14:00:00 | MSFT | Stock | 27.96 | 28.021 | 27.62 | 27.7 | 9059754.0 |
| 2003-09-10 15:00:00 | MSFT | Stock | 27.69 | 27.77 | 27.53 | 27.536 | 9661102.0 |
| 2003-09-10 16:00:00 | MSFT | Stock | 27.53 | 27.8802 | 27.52 | 27.7 | 1816304.0 |
| 2003-09-10 17:00:00 | MSFT | Stock | 27.68 | 27.68 | 27.53 | 27.68 | 214900.0 |
| 2003-09-10 18:00:00 | MSFT | Stock | 27.66 | 28.233 | 27.631 | 28.233 | 5700.0 |
| 2003-09-10 08:00:00 | NVDA | Stock | 0.1692 | 0.1729 | 0.1684 | 0.17 | 3014400.0 |
| 2003-09-10 09:00:00 | NVDA | Stock | 0.17 | 0.1728 | 0.1667 | 0.17 | 198102000.0 |
| 2003-09-10 10:00:00 | NVDA | Stock | 0.17 | 0.1701 | 0.1661 | 0.1687 | 211781040.0 |
| 2003-09-10 11:00:00 | NVDA | Stock | 0.1687 | 0.1691 | 0.1635 | 0.1652 | 191484240.0 |
| 2003-09-10 12:00:00 | NVDA | Stock | 0.1654 | 0.1662 | 0.1649 | 0.1655 | 87541920.0 |
| 2003-09-10 13:00:00 | NVDA | Stock | 0.1656 | 0.1662 | 0.1635 | 0.1641 | 104462520.0 |
| 2003-09-10 14:00:00 | NVDA | Stock | 0.164 | 0.1643 | 0.1617 | 0.1627 | 158545800.0 |
| 2003-09-10 15:00:00 | NVDA | Stock | 0.1627 | 0.163 | 0.1597 | 0.161 | 279498360.0 |
| 2003-09-10 16:00:00 | NVDA | Stock | 0.1611 | 0.1651 | 0.1606 | 0.1618 | 25253520.0 |
| 2003-09-10 17:00:00 | NVDA | Stock | 0.1608 | 0.1628 | 0.1608 | 0.1617 | 3408000.0 |
| 2003-09-10 08:00:00 | AMZN | Stock | 2.316 | 2.3175 | 2.3125 | 2.3125 | 169000.0 |
| 2003-09-10 09:00:00 | AMZN | Stock | 2.315 | 2.3615 | 2.312 | 2.3525 | 23566720.0 |
| 2003-09-10 10:00:00 | AMZN | Stock | 2.3525 | 2.3575 | 2.3235 | 2.3315 | 29051780.0 |
| 2003-09-10 11:00:00 | AMZN | Stock | 2.3325 | 2.345 | 2.3305 | 2.3425 | 18470700.0 |
| 2003-09-10 12:00:00 | AMZN | Stock | 2.3425 | 2.349 | 2.336 | 2.3445 | 10345360.0 |
| 2003-09-10 13:00:00 | AMZN | Stock | 2.3445 | 2.345 | 2.336 | 2.3393 | 11990940.0 |
| 2003-09-10 14:00:00 | AMZN | Stock | 2.3395 | 2.3445 | 2.3225 | 2.328 | 21666100.0 |
| 2003-09-10 15:00:00 | AMZN | Stock | 2.328 | 2.329 | 2.3035 | 2.3045 | 24293080.0 |
| 2003-09-10 16:00:00 | AMZN | Stock | 2.303 | 2.3145 | 2.303 | 2.3125 | 4138320.0 |
| 2003-09-10 17:00:00 | AMZN | Stock | 2.3125 | 2.314 | 2.304 | 2.304 | 308000.0 |
| 2003-09-10 09:00:00 | CL | Stock | 27.925 | 28.175 | 27.925 | 28.145 | 202200.0 |
| 2003-09-10 10:00:00 | CL | Stock | 28.15 | 28.295 | 28.05 | 28.235 | 346800.0 |
| 2003-09-10 11:00:00 | CL | Stock | 28.25 | 28.265 | 28.17 | 28.2 | 211400.0 |
| 2003-09-10 12:00:00 | CL | Stock | 28.205 | 28.245 | 28.19 | 28.2 | 154400.0 |
| 2003-09-10 13:00:00 | CL | Stock | 28.205 | 28.21 | 28.115 | 28.155 | 249800.0 |
| 2003-09-10 14:00:00 | CL | Stock | 28.155 | 28.175 | 28.06 | 28.115 | 358000.0 |
| 2003-09-10 15:00:00 | CL | Stock | 28.12 | 28.145 | 28.01 | 28.015 | 480800.0 |
| 2003-09-10 16:00:00 | CL | Stock | 28.02 | 28.0202 | 28.02 | 28.02 | 96200.0 |
| 2003-09-10 17:00:00 | CL | Stock | 28.02 | 28.02 | 28.02 | 28.02 | 800.0 |
> showing 50 of 21,948 rows — these rows as CSV