PREVIEW / stock_30min / 2005-07-11
file: by_date/stock_30min/2005/2005-07-11.parquet size: 845 KB rows: 45,390 symbols: 2,028
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-07-11 08:00:00 | AAPL | Stock | 1.375 | 1.3857 | 1.3721 | 1.3796 | 925540.0 |
| 2005-07-11 08:30:00 | AAPL | Stock | 1.3796 | 1.3821 | 1.3754 | 1.3757 | 398664.0 |
| 2005-07-11 09:00:00 | AAPL | Stock | 1.3754 | 1.3814 | 1.37 | 1.3704 | 2844072.0 |
| 2005-07-11 09:30:00 | AAPL | Stock | 1.3704 | 1.3804 | 1.3643 | 1.3654 | 73257156.0 |
| 2005-07-11 10:00:00 | AAPL | Stock | 1.365 | 1.3746 | 1.3493 | 1.3564 | 72183104.0 |
| 2005-07-11 10:30:00 | AAPL | Stock | 1.3568 | 1.3593 | 1.3536 | 1.3571 | 34560680.0 |
| 2005-07-11 11:00:00 | AAPL | Stock | 1.3571 | 1.3661 | 1.3557 | 1.3657 | 34761636.0 |
| 2005-07-11 11:30:00 | AAPL | Stock | 1.3661 | 1.3664 | 1.3614 | 1.3625 | 17332868.0 |
| 2005-07-11 12:00:00 | AAPL | Stock | 1.3629 | 1.3679 | 1.3539 | 1.3556 | 16486036.0 |
| 2005-07-11 12:30:00 | AAPL | Stock | 1.3557 | 1.3593 | 1.3554 | 1.3561 | 13616708.0 |
| 2005-07-11 13:00:00 | AAPL | Stock | 1.3561 | 1.3575 | 1.3546 | 1.3575 | 11368952.0 |
| 2005-07-11 13:30:00 | AAPL | Stock | 1.3575 | 1.3607 | 1.3571 | 1.3593 | 12937120.0 |
| 2005-07-11 14:00:00 | AAPL | Stock | 1.3596 | 1.3618 | 1.3568 | 1.3586 | 16502584.0 |
| 2005-07-11 14:30:00 | AAPL | Stock | 1.3582 | 1.3625 | 1.3582 | 1.3593 | 16280292.0 |
| 2005-07-11 15:00:00 | AAPL | Stock | 1.3596 | 1.3607 | 1.3532 | 1.3561 | 17554768.0 |
| 2005-07-11 15:30:00 | AAPL | Stock | 1.3561 | 1.3607 | 1.3554 | 1.3607 | 33518268.0 |
| 2005-07-11 16:00:00 | AAPL | Stock | 1.3607 | 1.3632 | 1.3568 | 1.3611 | 1625652.0 |
| 2005-07-11 16:30:00 | AAPL | Stock | 1.3611 | 1.3614 | 1.3602 | 1.3611 | 1177680.0 |
| 2005-07-11 17:00:00 | AAPL | Stock | 1.3611 | 1.3625 | 1.3611 | 1.3625 | 204400.0 |
| 2005-07-11 17:30:00 | AAPL | Stock | 1.3614 | 1.3618 | 1.3591 | 1.3618 | 349440.0 |
| 2005-07-11 18:00:00 | AAPL | Stock | 1.3614 | 1.3618 | 1.3607 | 1.3607 | 79800.0 |
| 2005-07-11 08:00:00 | MSFT | Stock | 25.14 | 25.17 | 25.14 | 25.16 | 30354.0 |
| 2005-07-11 08:30:00 | MSFT | Stock | 25.14 | 25.16 | 25.14 | 25.14 | 36670.0 |
| 2005-07-11 09:00:00 | MSFT | Stock | 25.14 | 25.18 | 25.14 | 25.17 | 249437.0 |
| 2005-07-11 09:30:00 | MSFT | Stock | 25.15 | 25.18 | 25.11 | 25.14 | 9528909.0 |
| 2005-07-11 10:00:00 | MSFT | Stock | 25.14 | 25.27 | 25.13 | 25.26 | 5466610.0 |
| 2005-07-11 10:30:00 | MSFT | Stock | 25.26 | 25.32 | 25.23 | 25.27 | 3659407.0 |
| 2005-07-11 11:00:00 | MSFT | Stock | 25.27 | 25.35 | 25.25 | 25.31 | 3759486.0 |
| 2005-07-11 11:30:00 | MSFT | Stock | 25.31 | 25.37 | 25.3 | 25.34 | 4899160.0 |
| 2005-07-11 12:00:00 | MSFT | Stock | 25.341 | 25.35 | 25.25 | 25.262 | 3164915.0 |
| 2005-07-11 12:30:00 | MSFT | Stock | 25.26 | 25.32 | 25.26 | 25.29 | 2284312.0 |
| 2005-07-11 13:00:00 | MSFT | Stock | 25.29 | 25.34 | 25.27 | 25.32 | 3020035.0 |
| 2005-07-11 13:30:00 | MSFT | Stock | 25.33 | 25.38 | 25.28 | 25.28 | 3215874.0 |
| 2005-07-11 14:00:00 | MSFT | Stock | 25.28 | 25.33 | 25.25 | 25.27 | 2675300.0 |
| 2005-07-11 14:30:00 | MSFT | Stock | 25.28 | 25.34 | 25.27 | 25.32 | 2296968.0 |
| 2005-07-11 15:00:00 | MSFT | Stock | 25.32 | 25.32 | 25.19 | 25.22 | 5619194.0 |
| 2005-07-11 15:30:00 | MSFT | Stock | 25.22 | 25.3 | 25.18 | 25.3 | 9005828.0 |
| 2005-07-11 16:00:00 | MSFT | Stock | 25.29 | 25.34 | 25.28 | 25.33 | 306093.0 |
| 2005-07-11 16:30:00 | MSFT | Stock | 25.33 | 25.35 | 25.286 | 25.286 | 155440.0 |
| 2005-07-11 17:00:00 | MSFT | Stock | 25.31 | 25.34 | 25.29 | 25.29 | 2512.0 |
| 2005-07-11 17:30:00 | MSFT | Stock | 25.3 | 25.3 | 25.255 | 25.255 | 4600.0 |
| 2005-07-11 18:00:00 | MSFT | Stock | 25.34 | 25.35 | 25.33 | 25.34 | 8375.0 |
| 2005-07-11 08:00:00 | NVDA | Stock | 0.235 | 0.235 | 0.235 | 0.235 | 60000.0 |
| 2005-07-11 09:00:00 | NVDA | Stock | 0.235 | 0.2367 | 0.2347 | 0.2367 | 1764000.0 |
| 2005-07-11 09:30:00 | NVDA | Stock | 0.2366 | 0.2404 | 0.2356 | 0.2378 | 108457560.0 |
| 2005-07-11 10:00:00 | NVDA | Stock | 0.2377 | 0.2382 | 0.2356 | 0.2362 | 76644360.0 |
| 2005-07-11 10:30:00 | NVDA | Stock | 0.2361 | 0.2386 | 0.2359 | 0.2381 | 26673240.0 |
| 2005-07-11 11:00:00 | NVDA | Stock | 0.2381 | 0.2392 | 0.2377 | 0.2382 | 26557200.0 |
| 2005-07-11 11:30:00 | NVDA | Stock | 0.2382 | 0.2384 | 0.2368 | 0.2369 | 16485600.0 |
| 2005-07-11 12:00:00 | NVDA | Stock | 0.2369 | 0.2374 | 0.2366 | 0.2367 | 11548680.0 |
> showing 50 of 45,390 rows — these rows as CSV