PREVIEW / stock_30min / 2005-01-21
file: by_date/stock_30min/2005/2005-01-21.parquet size: 815 KB rows: 43,486 symbols: 1,908
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-21 08:00:00 | AAPL | Stock | 1.2813 | 1.2821 | 1.2668 | 1.2763 | 2911440.0 |
| 2005-01-21 08:30:00 | AAPL | Stock | 1.2763 | 1.2813 | 1.2763 | 1.2802 | 2993704.0 |
| 2005-01-21 09:00:00 | AAPL | Stock | 1.2802 | 1.2802 | 1.2582 | 1.2745 | 12024824.0 |
| 2005-01-21 09:30:00 | AAPL | Stock | 1.2718 | 1.2786 | 1.263 | 1.2721 | 226658488.0 |
| 2005-01-21 10:00:00 | AAPL | Stock | 1.2721 | 1.2746 | 1.267 | 1.2711 | 84923272.0 |
| 2005-01-21 10:30:00 | AAPL | Stock | 1.2711 | 1.2714 | 1.2636 | 1.2668 | 64196384.0 |
| 2005-01-21 11:00:00 | AAPL | Stock | 1.2666 | 1.2714 | 1.2643 | 1.2704 | 34542816.0 |
| 2005-01-21 11:30:00 | AAPL | Stock | 1.2696 | 1.2705 | 1.2682 | 1.2696 | 32188800.0 |
| 2005-01-21 12:00:00 | AAPL | Stock | 1.2698 | 1.2705 | 1.2618 | 1.2641 | 37690408.0 |
| 2005-01-21 12:30:00 | AAPL | Stock | 1.2641 | 1.267 | 1.262 | 1.2659 | 28083328.0 |
| 2005-01-21 13:00:00 | AAPL | Stock | 1.2659 | 1.2661 | 1.2604 | 1.263 | 38900792.0 |
| 2005-01-21 13:30:00 | AAPL | Stock | 1.2629 | 1.2641 | 1.2559 | 1.2604 | 69962984.0 |
| 2005-01-21 14:00:00 | AAPL | Stock | 1.2605 | 1.2639 | 1.2593 | 1.2613 | 33115768.0 |
| 2005-01-21 14:30:00 | AAPL | Stock | 1.2609 | 1.2621 | 1.252 | 1.2534 | 62122200.0 |
| 2005-01-21 15:00:00 | AAPL | Stock | 1.2534 | 1.2627 | 1.25 | 1.2609 | 71161888.0 |
| 2005-01-21 15:30:00 | AAPL | Stock | 1.2609 | 1.2618 | 1.2529 | 1.2595 | 96319608.0 |
| 2005-01-21 16:00:00 | AAPL | Stock | 1.2595 | 1.2698 | 1.2563 | 1.2609 | 6253296.0 |
| 2005-01-21 16:30:00 | AAPL | Stock | 1.2596 | 1.2613 | 1.2595 | 1.2613 | 408800.0 |
| 2005-01-21 17:00:00 | AAPL | Stock | 1.2611 | 1.2625 | 1.2611 | 1.2616 | 400400.0 |
| 2005-01-21 17:30:00 | AAPL | Stock | 1.2625 | 1.2643 | 1.2625 | 1.2625 | 385896.0 |
| 2005-01-21 18:00:00 | AAPL | Stock | 1.2634 | 1.2634 | 1.2625 | 1.2625 | 44800.0 |
| 2005-01-21 08:00:00 | MSFT | Stock | 26.06 | 26.06 | 25.91 | 25.98 | 416402.0 |
| 2005-01-21 08:30:00 | MSFT | Stock | 25.98 | 26.02 | 25.97 | 26.0 | 47775.0 |
| 2005-01-21 09:00:00 | MSFT | Stock | 26.0 | 26.0 | 25.86 | 25.95 | 529265.0 |
| 2005-01-21 09:30:00 | MSFT | Stock | 25.94 | 26.09 | 25.75 | 26.07 | 17633411.0 |
| 2005-01-21 10:00:00 | MSFT | Stock | 26.07 | 26.1 | 25.97 | 26.04 | 5890287.0 |
| 2005-01-21 10:30:00 | MSFT | Stock | 26.05 | 26.13 | 26.02 | 26.09 | 5710832.0 |
| 2005-01-21 11:00:00 | MSFT | Stock | 26.08 | 26.09 | 26.0 | 26.03 | 3661977.0 |
| 2005-01-21 11:30:00 | MSFT | Stock | 26.03 | 26.072 | 25.97 | 25.98 | 2198756.0 |
| 2005-01-21 12:00:00 | MSFT | Stock | 25.97 | 25.98 | 25.91 | 25.92 | 3225598.0 |
| 2005-01-21 12:30:00 | MSFT | Stock | 25.92 | 25.98 | 25.9 | 25.93 | 3453443.0 |
| 2005-01-21 13:00:00 | MSFT | Stock | 25.93 | 25.94 | 25.85 | 25.91 | 3935374.0 |
| 2005-01-21 13:30:00 | MSFT | Stock | 25.91 | 25.92 | 25.83 | 25.87 | 4734721.0 |
| 2005-01-21 14:00:00 | MSFT | Stock | 25.87 | 25.93 | 25.86 | 25.89 | 2552278.0 |
| 2005-01-21 14:30:00 | MSFT | Stock | 25.88 | 25.9 | 25.75 | 25.77 | 3941931.0 |
| 2005-01-21 15:00:00 | MSFT | Stock | 25.76 | 25.779 | 25.66 | 25.77 | 4723048.0 |
| 2005-01-21 15:30:00 | MSFT | Stock | 25.76 | 25.84 | 25.65 | 25.65 | 8906967.0 |
| 2005-01-21 16:00:00 | MSFT | Stock | 25.65 | 25.94 | 25.65 | 25.65 | 2832956.0 |
| 2005-01-21 16:30:00 | MSFT | Stock | 25.69 | 25.71 | 25.65 | 25.7 | 15400.0 |
| 2005-01-21 17:00:00 | MSFT | Stock | 25.7 | 25.7 | 25.68 | 25.69 | 8103.0 |
| 2005-01-21 17:30:00 | MSFT | Stock | 25.69 | 25.69 | 25.67 | 25.69 | 4597.0 |
| 2005-01-21 18:00:00 | MSFT | Stock | 25.7 | 25.7 | 25.7 | 25.7 | 1647.0 |
| 2005-01-21 09:00:00 | NVDA | Stock | 0.1786 | 0.1793 | 0.1783 | 0.1786 | 659520.0 |
| 2005-01-21 09:30:00 | NVDA | Stock | 0.1786 | 0.1814 | 0.178 | 0.1792 | 66328800.0 |
| 2005-01-21 10:00:00 | NVDA | Stock | 0.1792 | 0.1818 | 0.1786 | 0.1817 | 71041920.0 |
| 2005-01-21 10:30:00 | NVDA | Stock | 0.1817 | 0.1822 | 0.1804 | 0.1808 | 52877760.0 |
| 2005-01-21 11:00:00 | NVDA | Stock | 0.1808 | 0.182 | 0.1804 | 0.181 | 38319960.0 |
| 2005-01-21 11:30:00 | NVDA | Stock | 0.1815 | 0.1815 | 0.1809 | 0.1811 | 12276120.0 |
| 2005-01-21 12:00:00 | NVDA | Stock | 0.1811 | 0.1815 | 0.18 | 0.1802 | 26673240.0 |
| 2005-01-21 12:30:00 | NVDA | Stock | 0.1802 | 0.1817 | 0.1802 | 0.1814 | 31108920.0 |
> showing 50 of 43,486 rows — these rows as CSV