PREVIEW / stock_30min / 2024-09-17
file: by_date/stock_30min/2024/2024-09-17.parquet size: 2.0 MB rows: 98,408 symbols: 799
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-17 04:00:00 | AAPL | Stock | 216.37 | 216.99 | 216.29 | 216.43 | 18828.0 |
| 2024-09-17 04:30:00 | AAPL | Stock | 216.45 | 216.52 | 216.22 | 216.52 | 2930.0 |
| 2024-09-17 05:00:00 | AAPL | Stock | 216.62 | 216.83 | 216.6 | 216.79 | 2184.0 |
| 2024-09-17 05:30:00 | AAPL | Stock | 216.89 | 216.97 | 216.89 | 216.89 | 3895.0 |
| 2024-09-17 06:00:00 | AAPL | Stock | 216.85 | 216.92 | 216.76 | 216.8 | 4311.0 |
| 2024-09-17 06:30:00 | AAPL | Stock | 216.76 | 216.76 | 216.65 | 216.65 | 3604.0 |
| 2024-09-17 07:00:00 | AAPL | Stock | 216.6 | 216.7 | 215.02 | 215.02 | 52658.0 |
| 2024-09-17 07:30:00 | AAPL | Stock | 215.24 | 216.36 | 215.02 | 216.26 | 46255.0 |
| 2024-09-17 08:00:00 | AAPL | Stock | 216.53 | 216.7 | 215.1494 | 216.01 | 105260.0 |
| 2024-09-17 08:30:00 | AAPL | Stock | 216.09 | 216.2 | 215.7 | 216.07 | 67000.0 |
| 2024-09-17 09:00:00 | AAPL | Stock | 216.1 | 216.1708 | 215.45 | 215.79 | 117259.0 |
| 2024-09-17 09:30:00 | AAPL | Stock | 215.75 | 216.5899 | 214.5 | 216.22 | 5905772.0 |
| 2024-09-17 10:00:00 | AAPL | Stock | 216.24 | 216.53 | 215.53 | 216.4 | 2658934.0 |
| 2024-09-17 10:30:00 | AAPL | Stock | 216.4 | 216.9 | 215.84 | 216.1299 | 2365433.0 |
| 2024-09-17 11:00:00 | AAPL | Stock | 216.105 | 216.465 | 215.96 | 216.205 | 1349819.0 |
| 2024-09-17 11:30:00 | AAPL | Stock | 216.2 | 216.84 | 216.11 | 216.6 | 1421014.0 |
| 2024-09-17 12:00:00 | AAPL | Stock | 216.6 | 216.63 | 215.51 | 215.76 | 1841465.0 |
| 2024-09-17 12:30:00 | AAPL | Stock | 215.78 | 216.23 | 215.23 | 215.795 | 1947672.0 |
| 2024-09-17 13:00:00 | AAPL | Stock | 215.81 | 216.215 | 215.63 | 216.16 | 1099869.0 |
| 2024-09-17 13:30:00 | AAPL | Stock | 216.16 | 216.39 | 215.05 | 216.1301 | 1199497.0 |
| 2024-09-17 14:00:00 | AAPL | Stock | 216.14 | 216.39 | 215.9 | 216.15 | 950031.0 |
| 2024-09-17 14:30:00 | AAPL | Stock | 216.14 | 216.17 | 215.3 | 215.84 | 1154358.0 |
| 2024-09-17 15:00:00 | AAPL | Stock | 215.84 | 216.62 | 215.7201 | 216.61 | 1730572.0 |
| 2024-09-17 15:30:00 | AAPL | Stock | 216.6 | 216.85 | 216.17 | 216.85 | 3482109.0 |
| 2024-09-17 16:00:00 | AAPL | Stock | 216.79 | 216.84 | 216.69 | 216.75 | 5583655.0 |
| 2024-09-17 16:30:00 | AAPL | Stock | 216.75 | 216.79 | 216.5625 | 216.6205 | 22625.0 |
| 2024-09-17 17:00:00 | AAPL | Stock | 216.62 | 216.6295 | 216.1 | 216.52 | 9544.0 |
| 2024-09-17 17:30:00 | AAPL | Stock | 216.5 | 216.65 | 216.5 | 216.595 | 3619.0 |
| 2024-09-17 18:00:00 | AAPL | Stock | 216.56 | 216.66 | 216.5022 | 216.5337 | 8248.0 |
| 2024-09-17 18:30:00 | AAPL | Stock | 216.6 | 216.7 | 216.5807 | 216.6 | 4206.0 |
| 2024-09-17 19:00:00 | AAPL | Stock | 216.595 | 216.75 | 216.595 | 216.74 | 6998.0 |
| 2024-09-17 19:30:00 | AAPL | Stock | 216.73 | 216.9 | 216.73 | 216.9 | 14160.0 |
| 2024-09-17 04:00:00 | MSFT | Stock | 436.1 | 437.4 | 436.1 | 436.88 | 5726.0 |
| 2024-09-17 04:30:00 | MSFT | Stock | 436.97 | 438.3 | 436.97 | 438.16 | 7548.0 |
| 2024-09-17 05:00:00 | MSFT | Stock | 438.74 | 439.62 | 438.65 | 439.33 | 15453.0 |
| 2024-09-17 05:30:00 | MSFT | Stock | 439.48 | 439.9 | 439.47 | 439.48 | 3466.0 |
| 2024-09-17 06:00:00 | MSFT | Stock | 439.49 | 440.0 | 439.49 | 440.0 | 4855.0 |
| 2024-09-17 06:30:00 | MSFT | Stock | 440.33 | 440.33 | 437.25 | 437.25 | 14442.0 |
| 2024-09-17 07:00:00 | MSFT | Stock | 437.12 | 438.75 | 437.12 | 438.2 | 12658.0 |
| 2024-09-17 07:30:00 | MSFT | Stock | 438.14 | 439.5 | 437.8 | 438.7 | 26642.0 |
| 2024-09-17 08:00:00 | MSFT | Stock | 437.81 | 439.7 | 434.24 | 439.58 | 82111.0 |
| 2024-09-17 08:30:00 | MSFT | Stock | 439.62 | 440.31 | 438.1 | 438.4 | 82165.0 |
| 2024-09-17 09:00:00 | MSFT | Stock | 438.51 | 440.19 | 438.01 | 440.14 | 75353.0 |
| 2024-09-17 09:30:00 | MSFT | Stock | 440.23 | 441.85 | 436.812 | 439.11 | 2754782.0 |
| 2024-09-17 10:00:00 | MSFT | Stock | 439.2 | 440.2279 | 436.33 | 437.6 | 1145794.0 |
| 2024-09-17 10:30:00 | MSFT | Stock | 437.61 | 439.2 | 436.44 | 436.9 | 663512.0 |
| 2024-09-17 11:00:00 | MSFT | Stock | 436.94 | 437.465 | 435.77 | 435.8 | 502582.0 |
| 2024-09-17 11:30:00 | MSFT | Stock | 435.7843 | 436.12 | 434.63 | 435.98 | 852445.0 |
| 2024-09-17 12:00:00 | MSFT | Stock | 436.0 | 436.15 | 432.82 | 434.02 | 610275.0 |
| 2024-09-17 12:30:00 | MSFT | Stock | 434.01 | 434.21 | 432.27 | 433.65 | 549216.0 |
> showing 50 of 98,408 rows — these rows as CSV