PREVIEW / stock_30min / 2005-01-18
file: by_date/stock_30min/2005/2005-01-18.parquet size: 822 KB rows: 44,229 symbols: 1,917
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-18 08:00:00 | AAPL | Stock | 1.2554 | 1.2554 | 1.2516 | 1.2516 | 318640.0 |
| 2005-01-18 08:30:00 | AAPL | Stock | 1.2514 | 1.2514 | 1.2457 | 1.2486 | 648200.0 |
| 2005-01-18 09:00:00 | AAPL | Stock | 1.2486 | 1.25 | 1.2429 | 1.2452 | 4454576.0 |
| 2005-01-18 09:30:00 | AAPL | Stock | 1.2454 | 1.2532 | 1.237 | 1.2375 | 202264608.0 |
| 2005-01-18 10:00:00 | AAPL | Stock | 1.2373 | 1.2554 | 1.2359 | 1.2546 | 151923072.0 |
| 2005-01-18 10:30:00 | AAPL | Stock | 1.2548 | 1.2613 | 1.2491 | 1.2577 | 117141976.0 |
| 2005-01-18 11:00:00 | AAPL | Stock | 1.2579 | 1.2582 | 1.2468 | 1.2484 | 64233176.0 |
| 2005-01-18 11:30:00 | AAPL | Stock | 1.2491 | 1.2573 | 1.2484 | 1.2545 | 42598248.0 |
| 2005-01-18 12:00:00 | AAPL | Stock | 1.2545 | 1.2589 | 1.2545 | 1.2579 | 34047776.0 |
| 2005-01-18 12:30:00 | AAPL | Stock | 1.2579 | 1.2584 | 1.2543 | 1.2554 | 26825176.0 |
| 2005-01-18 13:00:00 | AAPL | Stock | 1.2554 | 1.2557 | 1.2455 | 1.2514 | 60084248.0 |
| 2005-01-18 13:30:00 | AAPL | Stock | 1.2513 | 1.2541 | 1.2496 | 1.2525 | 30035488.0 |
| 2005-01-18 14:00:00 | AAPL | Stock | 1.2525 | 1.2563 | 1.252 | 1.2555 | 33348672.0 |
| 2005-01-18 14:30:00 | AAPL | Stock | 1.2555 | 1.2566 | 1.2475 | 1.2554 | 66119648.0 |
| 2005-01-18 15:00:00 | AAPL | Stock | 1.2554 | 1.2604 | 1.2545 | 1.258 | 77188104.0 |
| 2005-01-18 15:30:00 | AAPL | Stock | 1.258 | 1.2625 | 1.2536 | 1.2618 | 80819592.0 |
| 2005-01-18 16:00:00 | AAPL | Stock | 1.2616 | 1.2625 | 1.2602 | 1.262 | 3596824.0 |
| 2005-01-18 16:30:00 | AAPL | Stock | 1.2625 | 1.2634 | 1.2598 | 1.2616 | 1451912.0 |
| 2005-01-18 17:00:00 | AAPL | Stock | 1.2616 | 1.2625 | 1.2604 | 1.2604 | 584416.0 |
| 2005-01-18 17:30:00 | AAPL | Stock | 1.2604 | 1.262 | 1.2604 | 1.2616 | 163800.0 |
| 2005-01-18 18:00:00 | AAPL | Stock | 1.2614 | 1.2625 | 1.2607 | 1.2607 | 114800.0 |
| 2005-01-18 08:00:00 | MSFT | Stock | 26.07 | 26.1 | 26.04 | 26.04 | 12560.0 |
| 2005-01-18 08:30:00 | MSFT | Stock | 26.03 | 26.05 | 26.01 | 26.05 | 6000.0 |
| 2005-01-18 09:00:00 | MSFT | Stock | 26.02 | 26.1 | 26.0 | 26.02 | 131440.0 |
| 2005-01-18 09:30:00 | MSFT | Stock | 26.03 | 26.031 | 25.84 | 25.94 | 11233383.0 |
| 2005-01-18 10:00:00 | MSFT | Stock | 25.932 | 26.06 | 25.93 | 26.05 | 7023919.0 |
| 2005-01-18 10:30:00 | MSFT | Stock | 26.05 | 26.14 | 26.05 | 26.09 | 6343312.0 |
| 2005-01-18 11:00:00 | MSFT | Stock | 26.09 | 26.2 | 26.08 | 26.16 | 5687246.0 |
| 2005-01-18 11:30:00 | MSFT | Stock | 26.15 | 26.29 | 26.15 | 26.2 | 4742513.0 |
| 2005-01-18 12:00:00 | MSFT | Stock | 26.21 | 26.3 | 26.2 | 26.27 | 3364007.0 |
| 2005-01-18 12:30:00 | MSFT | Stock | 26.27 | 26.27 | 26.21 | 26.21 | 1996806.0 |
| 2005-01-18 13:00:00 | MSFT | Stock | 26.21 | 26.28 | 26.2 | 26.27 | 1831313.0 |
| 2005-01-18 13:30:00 | MSFT | Stock | 26.28 | 26.35 | 26.27 | 26.3 | 2782429.0 |
| 2005-01-18 14:00:00 | MSFT | Stock | 26.3 | 26.33 | 26.28 | 26.32 | 2296717.0 |
| 2005-01-18 14:30:00 | MSFT | Stock | 26.33 | 26.35 | 26.17 | 26.23 | 4936800.0 |
| 2005-01-18 15:00:00 | MSFT | Stock | 26.22 | 26.3 | 26.17 | 26.21 | 4433255.0 |
| 2005-01-18 15:30:00 | MSFT | Stock | 26.22 | 26.33 | 26.2 | 26.31 | 8229648.0 |
| 2005-01-18 16:00:00 | MSFT | Stock | 26.3 | 26.35 | 26.3 | 26.31 | 660431.0 |
| 2005-01-18 16:30:00 | MSFT | Stock | 26.31 | 26.32 | 26.29 | 26.31 | 8643.0 |
| 2005-01-18 17:00:00 | MSFT | Stock | 26.31 | 26.31 | 26.29 | 26.29 | 3555.0 |
| 2005-01-18 17:30:00 | MSFT | Stock | 26.31 | 26.31 | 26.29 | 26.31 | 69072.0 |
| 2005-01-18 18:00:00 | MSFT | Stock | 26.31 | 26.32 | 26.31 | 26.31 | 1175.0 |
| 2005-01-18 08:30:00 | NVDA | Stock | 0.1792 | 0.1793 | 0.1792 | 0.1793 | 120000.0 |
| 2005-01-18 09:00:00 | NVDA | Stock | 0.1792 | 0.1792 | 0.1772 | 0.1772 | 713040.0 |
| 2005-01-18 09:30:00 | NVDA | Stock | 0.1772 | 0.1792 | 0.1768 | 0.1791 | 28059480.0 |
| 2005-01-18 10:00:00 | NVDA | Stock | 0.1791 | 0.1805 | 0.1784 | 0.1805 | 25191480.0 |
| 2005-01-18 10:30:00 | NVDA | Stock | 0.1803 | 0.1815 | 0.1799 | 0.1805 | 29582640.0 |
| 2005-01-18 11:00:00 | NVDA | Stock | 0.1805 | 0.1811 | 0.1804 | 0.181 | 27642120.0 |
| 2005-01-18 11:30:00 | NVDA | Stock | 0.1808 | 0.1819 | 0.1808 | 0.1814 | 36679080.0 |
| 2005-01-18 12:00:00 | NVDA | Stock | 0.1814 | 0.1824 | 0.1811 | 0.182 | 23236080.0 |
> showing 50 of 44,229 rows — these rows as CSV