PREVIEW / stock_30min / 2002-09-19
file: by_date/stock_30min/2002/2002-09-19.parquet size: 599 KB rows: 31,324 symbols: 1,498
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-19 08:00:00 | AAPL | Stock | 0.2675 | 0.2675 | 0.2675 | 0.2675 | 11200.0 |
| 2002-09-19 09:00:00 | AAPL | Stock | 0.2673 | 0.2673 | 0.2634 | 0.2636 | 324800.0 |
| 2002-09-19 09:30:00 | AAPL | Stock | 0.2634 | 0.2643 | 0.2602 | 0.2616 | 34179264.0 |
| 2002-09-19 10:00:00 | AAPL | Stock | 0.2618 | 0.2636 | 0.2611 | 0.2629 | 18244408.0 |
| 2002-09-19 10:30:00 | AAPL | Stock | 0.263 | 0.263 | 0.2609 | 0.2621 | 8738408.0 |
| 2002-09-19 11:00:00 | AAPL | Stock | 0.262 | 0.2636 | 0.2614 | 0.2614 | 12443088.0 |
| 2002-09-19 11:30:00 | AAPL | Stock | 0.2614 | 0.2625 | 0.2604 | 0.2609 | 5793760.0 |
| 2002-09-19 12:00:00 | AAPL | Stock | 0.2609 | 0.2625 | 0.2607 | 0.2618 | 7926632.0 |
| 2002-09-19 12:30:00 | AAPL | Stock | 0.2618 | 0.2625 | 0.2613 | 0.2614 | 7728056.0 |
| 2002-09-19 13:00:00 | AAPL | Stock | 0.2614 | 0.2616 | 0.2595 | 0.2595 | 5919592.0 |
| 2002-09-19 13:30:00 | AAPL | Stock | 0.2595 | 0.26 | 0.2589 | 0.2598 | 13711600.0 |
| 2002-09-19 14:00:00 | AAPL | Stock | 0.2595 | 0.2614 | 0.2591 | 0.2602 | 11873736.0 |
| 2002-09-19 14:30:00 | AAPL | Stock | 0.26 | 0.2607 | 0.2589 | 0.2589 | 8721440.0 |
| 2002-09-19 15:00:00 | AAPL | Stock | 0.2591 | 0.2602 | 0.2586 | 0.2598 | 16145024.0 |
| 2002-09-19 15:30:00 | AAPL | Stock | 0.2598 | 0.2611 | 0.2595 | 0.2604 | 35590240.0 |
| 2002-09-19 16:00:00 | AAPL | Stock | 0.2604 | 0.2616 | 0.2596 | 0.2604 | 5745880.0 |
| 2002-09-19 16:30:00 | AAPL | Stock | 0.2604 | 0.2604 | 0.2604 | 0.2604 | 1758400.0 |
| 2002-09-19 17:00:00 | AAPL | Stock | 0.26 | 0.2604 | 0.26 | 0.2604 | 2430400.0 |
| 2002-09-19 08:00:00 | MSFT | Stock | 23.875 | 23.875 | 23.2 | 23.345 | 309936.0 |
| 2002-09-19 08:30:00 | MSFT | Stock | 23.35 | 23.489 | 23.3 | 23.425 | 323800.0 |
| 2002-09-19 09:00:00 | MSFT | Stock | 23.42 | 23.875 | 23.315 | 23.315 | 243948.0 |
| 2002-09-19 09:30:00 | MSFT | Stock | 23.34 | 23.625 | 23.295 | 23.555 | 11231876.0 |
| 2002-09-19 10:00:00 | MSFT | Stock | 23.56 | 23.72 | 23.4945 | 23.5715 | 9744114.0 |
| 2002-09-19 10:30:00 | MSFT | Stock | 23.56 | 23.815 | 23.51 | 23.755 | 6054852.0 |
| 2002-09-19 11:00:00 | MSFT | Stock | 23.75 | 23.895 | 23.69 | 23.705 | 5984248.0 |
| 2002-09-19 11:30:00 | MSFT | Stock | 23.71 | 23.845 | 23.64 | 23.65 | 3956600.0 |
| 2002-09-19 12:00:00 | MSFT | Stock | 23.65 | 23.825 | 23.645 | 23.805 | 4861526.0 |
| 2002-09-19 12:30:00 | MSFT | Stock | 23.8 | 23.91 | 23.765 | 23.775 | 3998366.0 |
| 2002-09-19 13:00:00 | MSFT | Stock | 23.7805 | 23.7805 | 23.615 | 23.66 | 2706136.0 |
| 2002-09-19 13:30:00 | MSFT | Stock | 23.68 | 23.735 | 23.6 | 23.63 | 2845876.0 |
| 2002-09-19 14:00:00 | MSFT | Stock | 23.63 | 23.795 | 23.615 | 23.745 | 3435622.0 |
| 2002-09-19 14:30:00 | MSFT | Stock | 23.74 | 23.805 | 23.585 | 23.615 | 5323094.0 |
| 2002-09-19 15:00:00 | MSFT | Stock | 23.625 | 23.7485 | 23.51 | 23.71 | 7364902.0 |
| 2002-09-19 15:30:00 | MSFT | Stock | 23.71 | 23.8 | 23.595 | 23.6 | 7182094.0 |
| 2002-09-19 16:00:00 | MSFT | Stock | 23.624 | 23.645 | 23.5 | 23.605 | 799834.0 |
| 2002-09-19 16:30:00 | MSFT | Stock | 23.605 | 23.83 | 23.59 | 23.77 | 342450.0 |
| 2002-09-19 17:00:00 | MSFT | Stock | 23.795 | 23.8 | 23.6 | 23.6 | 159600.0 |
| 2002-09-19 17:30:00 | MSFT | Stock | 23.77 | 23.84 | 23.6 | 23.7765 | 14450.0 |
| 2002-09-19 18:00:00 | MSFT | Stock | 23.8 | 23.8 | 23.755 | 23.785 | 11400.0 |
| 2002-09-19 08:30:00 | NVDA | Stock | 0.0782 | 0.0782 | 0.0767 | 0.0771 | 840000.0 |
| 2002-09-19 09:00:00 | NVDA | Stock | 0.0771 | 0.0787 | 0.0767 | 0.0771 | 1422000.0 |
| 2002-09-19 09:30:00 | NVDA | Stock | 0.0772 | 0.0779 | 0.0762 | 0.0775 | 97679280.0 |
| 2002-09-19 10:00:00 | NVDA | Stock | 0.0775 | 0.0787 | 0.0768 | 0.0775 | 67260600.0 |
| 2002-09-19 10:30:00 | NVDA | Stock | 0.0777 | 0.0787 | 0.0772 | 0.0784 | 51341400.0 |
| 2002-09-19 11:00:00 | NVDA | Stock | 0.0785 | 0.08 | 0.0778 | 0.078 | 62709720.0 |
| 2002-09-19 11:30:00 | NVDA | Stock | 0.078 | 0.0789 | 0.0777 | 0.0777 | 23946960.0 |
| 2002-09-19 12:00:00 | NVDA | Stock | 0.0779 | 0.0785 | 0.0776 | 0.0779 | 29273040.0 |
| 2002-09-19 12:30:00 | NVDA | Stock | 0.0778 | 0.0783 | 0.0774 | 0.0777 | 34400280.0 |
| 2002-09-19 13:00:00 | NVDA | Stock | 0.0776 | 0.0777 | 0.0769 | 0.077 | 23828400.0 |
| 2002-09-19 13:30:00 | NVDA | Stock | 0.077 | 0.0775 | 0.0767 | 0.0773 | 28244520.0 |
> showing 50 of 31,324 rows — these rows as CSV