PREVIEW / stock_1hour / 2002-10-10
file: by_date/stock_1hour/2002/2002-10-10.parquet size: 410 KB rows: 19,679 symbols: 1,492
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-10-10 08:00:00 | AAPL | Stock | 0.2431 | 0.2431 | 0.2431 | 0.2431 | 33600.0 |
| 2002-10-10 09:00:00 | AAPL | Stock | 0.2434 | 0.2493 | 0.2395 | 0.2464 | 36351784.0 |
| 2002-10-10 10:00:00 | AAPL | Stock | 0.2463 | 0.2527 | 0.2457 | 0.2519 | 80313408.0 |
| 2002-10-10 11:00:00 | AAPL | Stock | 0.2517 | 0.2521 | 0.2486 | 0.2502 | 37718408.0 |
| 2002-10-10 12:00:00 | AAPL | Stock | 0.2502 | 0.2521 | 0.2498 | 0.2514 | 19449024.0 |
| 2002-10-10 13:00:00 | AAPL | Stock | 0.2514 | 0.2539 | 0.2509 | 0.2527 | 39378248.0 |
| 2002-10-10 14:00:00 | AAPL | Stock | 0.2527 | 0.2534 | 0.2488 | 0.252 | 32524296.0 |
| 2002-10-10 15:00:00 | AAPL | Stock | 0.252 | 0.2532 | 0.2486 | 0.2516 | 44700432.0 |
| 2002-10-10 16:00:00 | AAPL | Stock | 0.2521 | 0.2527 | 0.25 | 0.2521 | 8226400.0 |
| 2002-10-10 17:00:00 | AAPL | Stock | 0.2521 | 0.2521 | 0.2521 | 0.2521 | 240800.0 |
| 2002-10-10 08:00:00 | MSFT | Stock | 22.075 | 22.15 | 21.9 | 22.07 | 212498.0 |
| 2002-10-10 09:00:00 | MSFT | Stock | 22.095 | 22.2065 | 21.685 | 21.76 | 14005860.0 |
| 2002-10-10 10:00:00 | MSFT | Stock | 21.76 | 22.844 | 21.735 | 22.78 | 26061058.0 |
| 2002-10-10 11:00:00 | MSFT | Stock | 22.7745 | 22.875 | 22.505 | 22.6 | 15816404.0 |
| 2002-10-10 12:00:00 | MSFT | Stock | 22.6 | 22.745 | 22.525 | 22.74 | 9180330.0 |
| 2002-10-10 13:00:00 | MSFT | Stock | 22.7445 | 23.03 | 22.705 | 22.965 | 17292518.0 |
| 2002-10-10 14:00:00 | MSFT | Stock | 22.96 | 23.1 | 22.8 | 23.08 | 11355290.0 |
| 2002-10-10 15:00:00 | MSFT | Stock | 23.065 | 23.31 | 23.01 | 23.185 | 18370152.0 |
| 2002-10-10 16:00:00 | MSFT | Stock | 23.19 | 23.3 | 23.075 | 23.26 | 2387880.0 |
| 2002-10-10 17:00:00 | MSFT | Stock | 23.275 | 23.325 | 22.6481 | 23.225 | 183700.0 |
| 2002-10-10 18:00:00 | MSFT | Stock | 23.19 | 23.225 | 23.19 | 23.215 | 46600.0 |
| 2002-10-10 08:00:00 | NVDA | Stock | 0.0613 | 0.0622 | 0.0613 | 0.0621 | 792000.0 |
| 2002-10-10 09:00:00 | NVDA | Stock | 0.0621 | 0.064 | 0.0608 | 0.0618 | 52862040.0 |
| 2002-10-10 10:00:00 | NVDA | Stock | 0.062 | 0.0644 | 0.062 | 0.0644 | 123841440.0 |
| 2002-10-10 11:00:00 | NVDA | Stock | 0.0641 | 0.065 | 0.0629 | 0.0632 | 96623160.0 |
| 2002-10-10 12:00:00 | NVDA | Stock | 0.0632 | 0.0643 | 0.063 | 0.0638 | 46518000.0 |
| 2002-10-10 13:00:00 | NVDA | Stock | 0.0636 | 0.066 | 0.0636 | 0.0652 | 73460880.0 |
| 2002-10-10 14:00:00 | NVDA | Stock | 0.0653 | 0.0657 | 0.0642 | 0.0657 | 45543480.0 |
| 2002-10-10 15:00:00 | NVDA | Stock | 0.0657 | 0.0666 | 0.0643 | 0.0646 | 71683320.0 |
| 2002-10-10 16:00:00 | NVDA | Stock | 0.0646 | 0.0657 | 0.0642 | 0.065 | 13668000.0 |
| 2002-10-10 17:00:00 | NVDA | Stock | 0.065 | 0.065 | 0.0641 | 0.0649 | 1284000.0 |
| 2002-10-10 18:00:00 | NVDA | Stock | 0.065 | 0.065 | 0.065 | 0.065 | 432000.0 |
| 2002-10-10 08:00:00 | AMZN | Stock | 0.854 | 0.8626 | 0.8505 | 0.86 | 168000.0 |
| 2002-10-10 09:00:00 | AMZN | Stock | 0.86 | 0.887 | 0.8535 | 0.882 | 36809760.0 |
| 2002-10-10 10:00:00 | AMZN | Stock | 0.8815 | 0.8925 | 0.878 | 0.8845 | 48338980.0 |
| 2002-10-10 11:00:00 | AMZN | Stock | 0.8845 | 0.888 | 0.8725 | 0.8765 | 24812000.0 |
| 2002-10-10 12:00:00 | AMZN | Stock | 0.877 | 0.88 | 0.873 | 0.876 | 12114800.0 |
| 2002-10-10 13:00:00 | AMZN | Stock | 0.877 | 0.8885 | 0.8765 | 0.8855 | 19320960.0 |
| 2002-10-10 14:00:00 | AMZN | Stock | 0.886 | 0.8975 | 0.8825 | 0.8905 | 19817200.0 |
| 2002-10-10 15:00:00 | AMZN | Stock | 0.89 | 0.8985 | 0.8855 | 0.8975 | 35353200.0 |
| 2002-10-10 16:00:00 | AMZN | Stock | 0.8975 | 0.925 | 0.8895 | 0.895 | 4571740.0 |
| 2002-10-10 17:00:00 | AMZN | Stock | 0.8965 | 0.898 | 0.8848 | 0.898 | 122000.0 |
| 2002-10-10 18:00:00 | AMZN | Stock | 0.896 | 0.898 | 0.8925 | 0.8925 | 137600.0 |
| 2002-10-10 09:00:00 | CL | Stock | 27.275 | 27.45 | 27.15 | 27.15 | 465000.0 |
| 2002-10-10 10:00:00 | CL | Stock | 27.15 | 27.75 | 27.15 | 27.75 | 771200.0 |
| 2002-10-10 11:00:00 | CL | Stock | 27.745 | 27.75 | 27.505 | 27.575 | 449600.0 |
| 2002-10-10 12:00:00 | CL | Stock | 27.575 | 27.59 | 27.38 | 27.475 | 742600.0 |
| 2002-10-10 13:00:00 | CL | Stock | 27.475 | 27.78 | 27.475 | 27.71 | 1057000.0 |
| 2002-10-10 14:00:00 | CL | Stock | 27.7 | 27.74 | 27.5 | 27.65 | 803200.0 |
| 2002-10-10 15:00:00 | CL | Stock | 27.625 | 27.75 | 27.6 | 27.675 | 931400.0 |
> showing 50 of 19,679 rows — these rows as CSV