PREVIEW / stock_30min / 2002-10-18
file: by_date/stock_30min/2002/2002-10-18.parquet size: 608 KB rows: 31,868 symbols: 1,485
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-18 08:00:00 | AAPL | Stock | 0.252 | 0.252 | 0.252 | 0.252 | 22400.0 |
| 2002-10-18 08:30:00 | AAPL | Stock | 0.2518 | 0.2518 | 0.25 | 0.25 | 211344.0 |
| 2002-10-18 09:00:00 | AAPL | Stock | 0.2502 | 0.2527 | 0.2491 | 0.25 | 3820656.0 |
| 2002-10-18 09:30:00 | AAPL | Stock | 0.25 | 0.2509 | 0.2488 | 0.2504 | 53304552.0 |
| 2002-10-18 10:00:00 | AAPL | Stock | 0.2502 | 0.255 | 0.2502 | 0.2532 | 39808216.0 |
| 2002-10-18 10:30:00 | AAPL | Stock | 0.2532 | 0.2539 | 0.2516 | 0.253 | 26053552.0 |
| 2002-10-18 11:00:00 | AAPL | Stock | 0.2529 | 0.2554 | 0.2529 | 0.2536 | 22768200.0 |
| 2002-10-18 11:30:00 | AAPL | Stock | 0.2536 | 0.2545 | 0.2527 | 0.2534 | 10052336.0 |
| 2002-10-18 12:00:00 | AAPL | Stock | 0.2534 | 0.2536 | 0.2507 | 0.2507 | 13423536.0 |
| 2002-10-18 12:30:00 | AAPL | Stock | 0.2511 | 0.252 | 0.2509 | 0.2518 | 7202888.0 |
| 2002-10-18 13:00:00 | AAPL | Stock | 0.2518 | 0.2533 | 0.2518 | 0.2532 | 8140664.0 |
| 2002-10-18 13:30:00 | AAPL | Stock | 0.2532 | 0.2552 | 0.253 | 0.2545 | 7366016.0 |
| 2002-10-18 14:00:00 | AAPL | Stock | 0.2545 | 0.2552 | 0.254 | 0.2541 | 13851936.0 |
| 2002-10-18 14:30:00 | AAPL | Stock | 0.2541 | 0.2554 | 0.2541 | 0.2548 | 12943560.0 |
| 2002-10-18 15:00:00 | AAPL | Stock | 0.2548 | 0.2554 | 0.2536 | 0.255 | 12283712.0 |
| 2002-10-18 15:30:00 | AAPL | Stock | 0.2548 | 0.2563 | 0.2539 | 0.2563 | 21402528.0 |
| 2002-10-18 16:00:00 | AAPL | Stock | 0.2557 | 0.2566 | 0.2541 | 0.2566 | 9014992.0 |
| 2002-10-18 16:30:00 | AAPL | Stock | 0.2533 | 0.2561 | 0.2533 | 0.2561 | 2856000.0 |
| 2002-10-18 17:30:00 | AAPL | Stock | 0.2561 | 0.2561 | 0.2561 | 0.2561 | 268800.0 |
| 2002-10-18 18:00:00 | AAPL | Stock | 0.2561 | 0.2561 | 0.2561 | 0.2561 | 638400.0 |
| 2002-10-18 08:00:00 | MSFT | Stock | 25.75 | 27.5 | 25.555 | 25.975 | 2182200.0 |
| 2002-10-18 08:30:00 | MSFT | Stock | 26.005 | 26.5 | 25.5 | 26.21 | 1211356.0 |
| 2002-10-18 09:00:00 | MSFT | Stock | 26.23 | 26.435 | 25.505 | 26.3 | 2612938.0 |
| 2002-10-18 09:30:00 | MSFT | Stock | 26.3 | 26.36 | 25.58 | 25.735 | 28537268.0 |
| 2002-10-18 10:00:00 | MSFT | Stock | 25.735 | 26.235 | 25.57 | 26.055 | 19506416.0 |
| 2002-10-18 10:30:00 | MSFT | Stock | 26.055 | 26.376 | 26.055 | 26.27 | 14679084.0 |
| 2002-10-18 11:00:00 | MSFT | Stock | 26.27 | 26.6 | 26.26 | 26.429 | 16439600.0 |
| 2002-10-18 11:30:00 | MSFT | Stock | 26.4255 | 26.595 | 26.41 | 26.44 | 7439380.0 |
| 2002-10-18 12:00:00 | MSFT | Stock | 26.44 | 26.45 | 26.177 | 26.24 | 7716558.0 |
| 2002-10-18 12:30:00 | MSFT | Stock | 26.245 | 26.37 | 26.225 | 26.315 | 3968384.0 |
| 2002-10-18 13:00:00 | MSFT | Stock | 26.325 | 26.4215 | 26.225 | 26.405 | 3865330.0 |
| 2002-10-18 13:30:00 | MSFT | Stock | 26.405 | 26.45 | 26.3235 | 26.39 | 3589328.0 |
| 2002-10-18 14:00:00 | MSFT | Stock | 26.415 | 26.5145 | 26.275 | 26.285 | 5435882.0 |
| 2002-10-18 14:30:00 | MSFT | Stock | 26.2895 | 26.55 | 26.28 | 26.515 | 6967276.0 |
| 2002-10-18 15:00:00 | MSFT | Stock | 26.515 | 26.52 | 26.26 | 26.41 | 6657772.0 |
| 2002-10-18 15:30:00 | MSFT | Stock | 26.405 | 26.595 | 26.325 | 26.57 | 15224368.0 |
| 2002-10-18 16:00:00 | MSFT | Stock | 26.575 | 26.65 | 26.225 | 26.62 | 4338712.0 |
| 2002-10-18 16:30:00 | MSFT | Stock | 26.62 | 26.645 | 26.575 | 26.62 | 106022.0 |
| 2002-10-18 17:00:00 | MSFT | Stock | 26.625 | 26.625 | 26.6 | 26.625 | 46588.0 |
| 2002-10-18 17:30:00 | MSFT | Stock | 26.6 | 26.605 | 26.575 | 26.575 | 46000.0 |
| 2002-10-18 18:00:00 | MSFT | Stock | 26.595 | 26.595 | 26.535 | 26.595 | 107660.0 |
| 2002-10-18 08:00:00 | NVDA | Stock | 0.0772 | 0.0772 | 0.0758 | 0.0758 | 132000.0 |
| 2002-10-18 08:30:00 | NVDA | Stock | 0.0758 | 0.0779 | 0.0754 | 0.0758 | 1406520.0 |
| 2002-10-18 09:00:00 | NVDA | Stock | 0.0767 | 0.0776 | 0.0758 | 0.0768 | 1680000.0 |
| 2002-10-18 09:30:00 | NVDA | Stock | 0.0772 | 0.0772 | 0.0743 | 0.0746 | 67730040.0 |
| 2002-10-18 10:00:00 | NVDA | Stock | 0.0746 | 0.0765 | 0.0742 | 0.0762 | 46763040.0 |
| 2002-10-18 10:30:00 | NVDA | Stock | 0.076 | 0.0771 | 0.0758 | 0.0767 | 24401760.0 |
| 2002-10-18 11:00:00 | NVDA | Stock | 0.0769 | 0.079 | 0.0768 | 0.0774 | 47453040.0 |
| 2002-10-18 11:30:00 | NVDA | Stock | 0.0775 | 0.0787 | 0.0775 | 0.0781 | 33165840.0 |
| 2002-10-18 12:00:00 | NVDA | Stock | 0.0779 | 0.0779 | 0.0765 | 0.077 | 54111120.0 |
> showing 50 of 31,868 rows — these rows as CSV