PREVIEW / stock_1hour / 2003-05-13
file: by_date/stock_1hour/2003/2003-05-13.parquet size: 429 KB rows: 21,298 symbols: 1,576
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-05-13 08:00:00 | AAPL | Stock | 0.3286 | 0.3321 | 0.3282 | 0.3289 | 112000.0 |
| 2003-05-13 09:00:00 | AAPL | Stock | 0.3285 | 0.333 | 0.3282 | 0.3329 | 68310816.0 |
| 2003-05-13 10:00:00 | AAPL | Stock | 0.3329 | 0.3346 | 0.3305 | 0.3318 | 71044680.0 |
| 2003-05-13 11:00:00 | AAPL | Stock | 0.332 | 0.3338 | 0.3304 | 0.3338 | 34986000.0 |
| 2003-05-13 12:00:00 | AAPL | Stock | 0.3338 | 0.3388 | 0.333 | 0.3377 | 84813960.0 |
| 2003-05-13 13:00:00 | AAPL | Stock | 0.3379 | 0.338 | 0.3338 | 0.3339 | 31492272.0 |
| 2003-05-13 14:00:00 | AAPL | Stock | 0.3338 | 0.3341 | 0.3316 | 0.3329 | 42126336.0 |
| 2003-05-13 15:00:00 | AAPL | Stock | 0.3327 | 0.3332 | 0.3205 | 0.3327 | 86503088.0 |
| 2003-05-13 16:00:00 | AAPL | Stock | 0.3323 | 0.3336 | 0.3309 | 0.3323 | 3372096.0 |
| 2003-05-13 17:00:00 | AAPL | Stock | 0.3323 | 0.3333 | 0.3311 | 0.3311 | 957600.0 |
| 2003-05-13 18:00:00 | AAPL | Stock | 0.3309 | 0.3334 | 0.3309 | 0.3334 | 50400.0 |
| 2003-05-13 08:00:00 | MSFT | Stock | 26.2 | 26.25 | 26.0 | 26.05 | 98026.0 |
| 2003-05-13 09:00:00 | MSFT | Stock | 26.06 | 26.21 | 26.01 | 26.1 | 6788509.0 |
| 2003-05-13 10:00:00 | MSFT | Stock | 26.1 | 26.17 | 26.0 | 26.09 | 7645995.0 |
| 2003-05-13 11:00:00 | MSFT | Stock | 26.09 | 26.2 | 26.06 | 26.14 | 5554480.0 |
| 2003-05-13 12:00:00 | MSFT | Stock | 26.15 | 26.171 | 26.068 | 26.14 | 3655937.0 |
| 2003-05-13 13:00:00 | MSFT | Stock | 26.151 | 26.19 | 25.97 | 25.98 | 5562988.0 |
| 2003-05-13 14:00:00 | MSFT | Stock | 25.983 | 26.055 | 25.9 | 25.94 | 5494456.0 |
| 2003-05-13 15:00:00 | MSFT | Stock | 25.94 | 26.0 | 25.89 | 26.0 | 5236645.0 |
| 2003-05-13 16:00:00 | MSFT | Stock | 26.0 | 26.0494 | 25.9 | 25.93 | 432365.0 |
| 2003-05-13 17:00:00 | MSFT | Stock | 25.93 | 26.1199 | 25.9 | 25.91 | 335265.0 |
| 2003-05-13 18:00:00 | MSFT | Stock | 25.911 | 25.99 | 25.9 | 25.99 | 13489.0 |
| 2003-05-13 08:00:00 | NVDA | Stock | 0.1683 | 0.1731 | 0.1637 | 0.1672 | 24677280.0 |
| 2003-05-13 09:00:00 | NVDA | Stock | 0.1672 | 0.1731 | 0.1662 | 0.169 | 480063720.0 |
| 2003-05-13 10:00:00 | NVDA | Stock | 0.1688 | 0.1693 | 0.1667 | 0.1683 | 347699040.0 |
| 2003-05-13 11:00:00 | NVDA | Stock | 0.1683 | 0.1713 | 0.1682 | 0.171 | 233482800.0 |
| 2003-05-13 12:00:00 | NVDA | Stock | 0.171 | 0.1725 | 0.1699 | 0.1712 | 179847000.0 |
| 2003-05-13 13:00:00 | NVDA | Stock | 0.1712 | 0.1719 | 0.169 | 0.1691 | 141378720.0 |
| 2003-05-13 14:00:00 | NVDA | Stock | 0.169 | 0.1702 | 0.1679 | 0.1693 | 151912560.0 |
| 2003-05-13 15:00:00 | NVDA | Stock | 0.1693 | 0.17 | 0.1687 | 0.1698 | 132717840.0 |
| 2003-05-13 16:00:00 | NVDA | Stock | 0.1697 | 0.17 | 0.1692 | 0.1696 | 10445040.0 |
| 2003-05-13 17:00:00 | NVDA | Stock | 0.1694 | 0.1716 | 0.1692 | 0.1693 | 3192000.0 |
| 2003-05-13 18:00:00 | NVDA | Stock | 0.1692 | 0.1692 | 0.1685 | 0.1685 | 1656000.0 |
| 2003-05-13 08:00:00 | AMZN | Stock | 1.571 | 1.583 | 1.571 | 1.575 | 224000.0 |
| 2003-05-13 09:00:00 | AMZN | Stock | 1.575 | 1.5895 | 1.572 | 1.5895 | 25190500.0 |
| 2003-05-13 10:00:00 | AMZN | Stock | 1.589 | 1.606 | 1.581 | 1.6035 | 29439680.0 |
| 2003-05-13 11:00:00 | AMZN | Stock | 1.6035 | 1.64 | 1.5995 | 1.6375 | 56958600.0 |
| 2003-05-13 12:00:00 | AMZN | Stock | 1.6375 | 1.6675 | 1.6335 | 1.662 | 57604900.0 |
| 2003-05-13 13:00:00 | AMZN | Stock | 1.662 | 1.6745 | 1.6415 | 1.6445 | 40245300.0 |
| 2003-05-13 14:00:00 | AMZN | Stock | 1.6445 | 1.6544 | 1.6325 | 1.648 | 37334200.0 |
| 2003-05-13 15:00:00 | AMZN | Stock | 1.6475 | 1.6565 | 1.6415 | 1.648 | 40098940.0 |
| 2003-05-13 16:00:00 | AMZN | Stock | 1.648 | 1.649 | 1.638 | 1.6485 | 4232740.0 |
| 2003-05-13 17:00:00 | AMZN | Stock | 1.647 | 1.6501 | 1.585 | 1.6465 | 653700.0 |
| 2003-05-13 18:00:00 | AMZN | Stock | 1.6465 | 1.6465 | 1.646 | 1.646 | 64000.0 |
| 2003-05-13 09:00:00 | CL | Stock | 29.125 | 29.125 | 28.94 | 28.945 | 429200.0 |
| 2003-05-13 10:00:00 | CL | Stock | 28.945 | 28.975 | 28.74 | 28.88 | 558800.0 |
| 2003-05-13 11:00:00 | CL | Stock | 28.88 | 28.91 | 28.815 | 28.875 | 322000.0 |
| 2003-05-13 12:00:00 | CL | Stock | 28.875 | 28.91 | 28.845 | 28.855 | 504000.0 |
| 2003-05-13 13:00:00 | CL | Stock | 28.855 | 28.86 | 28.75 | 28.8 | 243400.0 |
| 2003-05-13 14:00:00 | CL | Stock | 28.8 | 28.805 | 28.665 | 28.71 | 470400.0 |
> showing 50 of 21,298 rows — these rows as CSV