PREVIEW / stock_30min / 2002-09-24
file: by_date/stock_30min/2002/2002-09-24.parquet size: 599 KB rows: 31,243 symbols: 1,480
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-09-24 08:00:00 | AAPL | Stock | 0.2623 | 0.2623 | 0.2623 | 0.2623 | 89600.0 |
| 2002-09-24 08:30:00 | AAPL | Stock | 0.2621 | 0.2621 | 0.2616 | 0.2616 | 128800.0 |
| 2002-09-24 09:00:00 | AAPL | Stock | 0.2616 | 0.2643 | 0.2571 | 0.2579 | 330400.0 |
| 2002-09-24 09:30:00 | AAPL | Stock | 0.2571 | 0.2646 | 0.2571 | 0.258 | 38894800.0 |
| 2002-09-24 10:00:00 | AAPL | Stock | 0.2582 | 0.2634 | 0.2582 | 0.2616 | 34834856.0 |
| 2002-09-24 10:30:00 | AAPL | Stock | 0.2616 | 0.2625 | 0.2605 | 0.2613 | 10469312.0 |
| 2002-09-24 11:00:00 | AAPL | Stock | 0.2613 | 0.2621 | 0.2607 | 0.2616 | 11004168.0 |
| 2002-09-24 11:30:00 | AAPL | Stock | 0.2616 | 0.2621 | 0.2613 | 0.2614 | 14282744.0 |
| 2002-09-24 12:00:00 | AAPL | Stock | 0.2614 | 0.262 | 0.2605 | 0.2614 | 8727432.0 |
| 2002-09-24 12:30:00 | AAPL | Stock | 0.2614 | 0.2616 | 0.258 | 0.2588 | 10116400.0 |
| 2002-09-24 13:00:00 | AAPL | Stock | 0.2588 | 0.2602 | 0.2586 | 0.2602 | 5610080.0 |
| 2002-09-24 13:30:00 | AAPL | Stock | 0.2602 | 0.2609 | 0.2584 | 0.2596 | 13468168.0 |
| 2002-09-24 14:00:00 | AAPL | Stock | 0.2598 | 0.2602 | 0.2579 | 0.2584 | 21818776.0 |
| 2002-09-24 14:30:00 | AAPL | Stock | 0.2586 | 0.2613 | 0.258 | 0.26 | 15533616.0 |
| 2002-09-24 15:00:00 | AAPL | Stock | 0.2599 | 0.2614 | 0.258 | 0.2589 | 20631744.0 |
| 2002-09-24 15:30:00 | AAPL | Stock | 0.2588 | 0.2614 | 0.2579 | 0.2614 | 29630832.0 |
| 2002-09-24 16:00:00 | AAPL | Stock | 0.2605 | 0.2634 | 0.2605 | 0.2614 | 8411200.0 |
| 2002-09-24 16:30:00 | AAPL | Stock | 0.2614 | 0.2614 | 0.2564 | 0.2614 | 2088800.0 |
| 2002-09-24 17:00:00 | AAPL | Stock | 0.2614 | 0.2614 | 0.2614 | 0.2614 | 22400.0 |
| 2002-09-24 17:30:00 | AAPL | Stock | 0.2614 | 0.2614 | 0.2614 | 0.2614 | 28000.0 |
| 2002-09-24 08:00:00 | MSFT | Stock | 22.35 | 22.6 | 22.05 | 22.495 | 360790.0 |
| 2002-09-24 08:30:00 | MSFT | Stock | 22.5 | 22.51 | 22.425 | 22.425 | 96294.0 |
| 2002-09-24 09:00:00 | MSFT | Stock | 22.4195 | 22.615 | 22.37 | 22.375 | 258046.0 |
| 2002-09-24 09:30:00 | MSFT | Stock | 22.415 | 22.75 | 22.315 | 22.57 | 14146572.0 |
| 2002-09-24 10:00:00 | MSFT | Stock | 22.57 | 23.06 | 22.56 | 22.955 | 12186730.0 |
| 2002-09-24 10:30:00 | MSFT | Stock | 22.9555 | 23.025 | 22.69 | 22.69 | 5525912.0 |
| 2002-09-24 11:00:00 | MSFT | Stock | 22.69 | 22.82 | 22.6 | 22.6 | 4259006.0 |
| 2002-09-24 11:30:00 | MSFT | Stock | 22.61 | 22.76 | 22.575 | 22.695 | 3353110.0 |
| 2002-09-24 12:00:00 | MSFT | Stock | 22.6935 | 22.71 | 22.46 | 22.53 | 4322148.0 |
| 2002-09-24 12:30:00 | MSFT | Stock | 22.52 | 22.615 | 22.475 | 22.61 | 3254870.0 |
| 2002-09-24 13:00:00 | MSFT | Stock | 22.61 | 22.71 | 22.575 | 22.71 | 3559432.0 |
| 2002-09-24 13:30:00 | MSFT | Stock | 22.71 | 22.985 | 22.695 | 22.926 | 6210844.0 |
| 2002-09-24 14:00:00 | MSFT | Stock | 22.9225 | 22.93 | 22.49 | 22.537 | 10878214.0 |
| 2002-09-24 14:30:00 | MSFT | Stock | 22.54 | 23.045 | 22.52 | 22.985 | 9402702.0 |
| 2002-09-24 15:00:00 | MSFT | Stock | 22.9835 | 23.24 | 22.95 | 23.1845 | 11504430.0 |
| 2002-09-24 15:30:00 | MSFT | Stock | 23.18 | 23.185 | 22.67 | 22.82 | 9543098.0 |
| 2002-09-24 16:00:00 | MSFT | Stock | 22.82 | 22.875 | 22.715 | 22.85 | 2283892.0 |
| 2002-09-24 16:30:00 | MSFT | Stock | 22.85 | 22.87 | 22.6749 | 22.805 | 1609180.0 |
| 2002-09-24 17:00:00 | MSFT | Stock | 22.83 | 22.84 | 22.7245 | 22.785 | 339230.0 |
| 2002-09-24 17:30:00 | MSFT | Stock | 22.84 | 22.84 | 22.75 | 22.78 | 20200.0 |
| 2002-09-24 18:00:00 | MSFT | Stock | 22.755 | 22.8 | 22.355 | 22.75 | 18600.0 |
| 2002-09-24 08:00:00 | NVDA | Stock | 0.0727 | 0.0729 | 0.0721 | 0.0721 | 408000.0 |
| 2002-09-24 08:30:00 | NVDA | Stock | 0.0721 | 0.0722 | 0.0717 | 0.0722 | 950400.0 |
| 2002-09-24 09:00:00 | NVDA | Stock | 0.0726 | 0.073 | 0.0719 | 0.0728 | 2179200.0 |
| 2002-09-24 09:30:00 | NVDA | Stock | 0.0726 | 0.0735 | 0.0712 | 0.0732 | 87175680.0 |
| 2002-09-24 10:00:00 | NVDA | Stock | 0.0732 | 0.0775 | 0.0732 | 0.0767 | 98641920.0 |
| 2002-09-24 10:30:00 | NVDA | Stock | 0.0762 | 0.0767 | 0.0754 | 0.0758 | 59052240.0 |
| 2002-09-24 11:00:00 | NVDA | Stock | 0.0758 | 0.0762 | 0.0744 | 0.0745 | 31669560.0 |
| 2002-09-24 11:30:00 | NVDA | Stock | 0.0745 | 0.0754 | 0.0743 | 0.0754 | 17455680.0 |
| 2002-09-24 12:00:00 | NVDA | Stock | 0.0754 | 0.0757 | 0.074 | 0.0744 | 20509440.0 |
> showing 50 of 31,243 rows — these rows as CSV