PREVIEW / stock_30min / 2005-01-19
file: by_date/stock_30min/2005/2005-01-19.parquet size: 813 KB rows: 43,422 symbols: 1,903
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-19 08:00:00 | AAPL | Stock | 1.2661 | 1.2688 | 1.2545 | 1.2602 | 1359680.0 |
| 2005-01-19 08:30:00 | AAPL | Stock | 1.2602 | 1.2661 | 1.2602 | 1.2621 | 930160.0 |
| 2005-01-19 09:00:00 | AAPL | Stock | 1.263 | 1.263 | 1.2563 | 1.2588 | 1566600.0 |
| 2005-01-19 09:30:00 | AAPL | Stock | 1.2588 | 1.2761 | 1.2584 | 1.2646 | 135915976.0 |
| 2005-01-19 10:00:00 | AAPL | Stock | 1.2646 | 1.2684 | 1.2598 | 1.2638 | 91007896.0 |
| 2005-01-19 10:30:00 | AAPL | Stock | 1.2639 | 1.2671 | 1.2611 | 1.2641 | 47360656.0 |
| 2005-01-19 11:00:00 | AAPL | Stock | 1.2643 | 1.2654 | 1.2614 | 1.2648 | 30814560.0 |
| 2005-01-19 11:30:00 | AAPL | Stock | 1.2648 | 1.2682 | 1.2609 | 1.263 | 52026688.0 |
| 2005-01-19 12:00:00 | AAPL | Stock | 1.2632 | 1.2652 | 1.2614 | 1.263 | 28016184.0 |
| 2005-01-19 12:30:00 | AAPL | Stock | 1.263 | 1.2643 | 1.2543 | 1.2579 | 52781120.0 |
| 2005-01-19 13:00:00 | AAPL | Stock | 1.258 | 1.2634 | 1.2571 | 1.2607 | 35597744.0 |
| 2005-01-19 13:30:00 | AAPL | Stock | 1.2609 | 1.2611 | 1.2571 | 1.2604 | 16184616.0 |
| 2005-01-19 14:00:00 | AAPL | Stock | 1.2602 | 1.2611 | 1.2527 | 1.2607 | 50250704.0 |
| 2005-01-19 14:30:00 | AAPL | Stock | 1.2607 | 1.2623 | 1.2579 | 1.2589 | 38111192.0 |
| 2005-01-19 15:00:00 | AAPL | Stock | 1.2589 | 1.2618 | 1.2496 | 1.2513 | 56773528.0 |
| 2005-01-19 15:30:00 | AAPL | Stock | 1.2509 | 1.253 | 1.2455 | 1.2482 | 94329312.0 |
| 2005-01-19 16:00:00 | AAPL | Stock | 1.2473 | 1.248 | 1.2375 | 1.2375 | 6254584.0 |
| 2005-01-19 16:30:00 | AAPL | Stock | 1.2379 | 1.2438 | 1.2327 | 1.2434 | 2316048.0 |
| 2005-01-19 17:00:00 | AAPL | Stock | 1.242 | 1.2434 | 1.2348 | 1.235 | 949424.0 |
| 2005-01-19 17:30:00 | AAPL | Stock | 1.2357 | 1.2375 | 1.2305 | 1.2321 | 1535072.0 |
| 2005-01-19 18:00:00 | AAPL | Stock | 1.2321 | 1.2526 | 1.2321 | 1.2375 | 3712464.0 |
| 2005-01-19 08:00:00 | MSFT | Stock | 26.31 | 26.31 | 26.25 | 26.25 | 8835.0 |
| 2005-01-19 08:30:00 | MSFT | Stock | 26.25 | 26.31 | 26.25 | 26.26 | 4773.0 |
| 2005-01-19 09:00:00 | MSFT | Stock | 26.26 | 26.28 | 26.2 | 26.2 | 152322.0 |
| 2005-01-19 09:30:00 | MSFT | Stock | 26.2 | 26.26 | 26.12 | 26.13 | 8500504.0 |
| 2005-01-19 10:00:00 | MSFT | Stock | 26.14 | 26.151 | 26.07 | 26.13 | 5356913.0 |
| 2005-01-19 10:30:00 | MSFT | Stock | 26.131 | 26.2 | 26.08 | 26.109 | 3445383.0 |
| 2005-01-19 11:00:00 | MSFT | Stock | 26.1 | 26.14 | 26.09 | 26.11 | 2534671.0 |
| 2005-01-19 11:30:00 | MSFT | Stock | 26.1 | 26.15 | 26.06 | 26.1 | 3013022.0 |
| 2005-01-19 12:00:00 | MSFT | Stock | 26.1 | 26.2 | 26.08 | 26.11 | 2200796.0 |
| 2005-01-19 12:30:00 | MSFT | Stock | 26.11 | 26.12 | 26.02 | 26.092 | 3390148.0 |
| 2005-01-19 13:00:00 | MSFT | Stock | 26.1 | 26.11 | 26.02 | 26.07 | 2562422.0 |
| 2005-01-19 13:30:00 | MSFT | Stock | 26.07 | 26.09 | 26.04 | 26.06 | 1870345.0 |
| 2005-01-19 14:00:00 | MSFT | Stock | 26.07 | 26.11 | 26.04 | 26.09 | 3478058.0 |
| 2005-01-19 14:30:00 | MSFT | Stock | 26.09 | 26.11 | 26.05 | 26.06 | 1872306.0 |
| 2005-01-19 15:00:00 | MSFT | Stock | 26.07 | 26.1 | 25.95 | 25.95 | 6346554.0 |
| 2005-01-19 15:30:00 | MSFT | Stock | 25.95 | 26.01 | 25.92 | 25.97 | 9427060.0 |
| 2005-01-19 16:00:00 | MSFT | Stock | 25.98 | 25.99 | 25.9 | 25.9 | 591976.0 |
| 2005-01-19 16:30:00 | MSFT | Stock | 25.9 | 25.98 | 25.84 | 25.86 | 68050.0 |
| 2005-01-19 17:00:00 | MSFT | Stock | 25.86 | 25.86 | 25.83 | 25.85 | 7671.0 |
| 2005-01-19 17:30:00 | MSFT | Stock | 25.85 | 25.85 | 25.76 | 25.77 | 26146.0 |
| 2005-01-19 18:00:00 | MSFT | Stock | 25.8 | 26.003 | 25.75 | 25.8 | 2858361.0 |
| 2005-01-19 08:30:00 | NVDA | Stock | 0.1817 | 0.1817 | 0.1817 | 0.1817 | 36000.0 |
| 2005-01-19 09:00:00 | NVDA | Stock | 0.1817 | 0.1831 | 0.1817 | 0.1831 | 565920.0 |
| 2005-01-19 09:30:00 | NVDA | Stock | 0.1829 | 0.1833 | 0.1817 | 0.1817 | 41733120.0 |
| 2005-01-19 10:00:00 | NVDA | Stock | 0.1817 | 0.1827 | 0.1817 | 0.182 | 25170840.0 |
| 2005-01-19 10:30:00 | NVDA | Stock | 0.1822 | 0.1822 | 0.1813 | 0.1813 | 21954720.0 |
| 2005-01-19 11:00:00 | NVDA | Stock | 0.1813 | 0.1814 | 0.1795 | 0.1802 | 27499680.0 |
| 2005-01-19 11:30:00 | NVDA | Stock | 0.1801 | 0.1808 | 0.1797 | 0.1799 | 19493280.0 |
| 2005-01-19 12:00:00 | NVDA | Stock | 0.1798 | 0.1803 | 0.1796 | 0.1802 | 12346560.0 |
> showing 50 of 43,422 rows — these rows as CSV