PREVIEW / stock_30min / 2005-07-12
file: by_date/stock_30min/2005/2005-07-12.parquet size: 828 KB rows: 44,988 symbols: 2,019
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-12 07:00:00 | AAPL | Stock | 1.3682 | 1.3682 | 1.3682 | 1.3682 | 53200.0 |
| 2005-07-12 07:30:00 | AAPL | Stock | 1.3682 | 1.3718 | 1.3682 | 1.3714 | 172200.0 |
| 2005-07-12 08:00:00 | AAPL | Stock | 1.375 | 1.3786 | 1.3707 | 1.3707 | 1079400.0 |
| 2005-07-12 08:30:00 | AAPL | Stock | 1.3714 | 1.3725 | 1.3654 | 1.3675 | 421708.0 |
| 2005-07-12 09:00:00 | AAPL | Stock | 1.3679 | 1.3707 | 1.3654 | 1.3654 | 786716.0 |
| 2005-07-12 09:30:00 | AAPL | Stock | 1.3654 | 1.3714 | 1.3611 | 1.3693 | 39769968.0 |
| 2005-07-12 10:00:00 | AAPL | Stock | 1.3696 | 1.37 | 1.3571 | 1.3594 | 38418884.0 |
| 2005-07-12 10:30:00 | AAPL | Stock | 1.3596 | 1.3629 | 1.3589 | 1.3614 | 37791264.0 |
| 2005-07-12 11:00:00 | AAPL | Stock | 1.3614 | 1.3621 | 1.3564 | 1.3582 | 22346828.0 |
| 2005-07-12 11:30:00 | AAPL | Stock | 1.3582 | 1.3607 | 1.3539 | 1.3568 | 26657680.0 |
| 2005-07-12 12:00:00 | AAPL | Stock | 1.3571 | 1.3589 | 1.3546 | 1.3586 | 14508816.0 |
| 2005-07-12 12:30:00 | AAPL | Stock | 1.3582 | 1.3607 | 1.3557 | 1.3582 | 10040884.0 |
| 2005-07-12 13:00:00 | AAPL | Stock | 1.3579 | 1.3596 | 1.3554 | 1.3586 | 18879840.0 |
| 2005-07-12 13:30:00 | AAPL | Stock | 1.3589 | 1.3686 | 1.3586 | 1.3639 | 31914596.0 |
| 2005-07-12 14:00:00 | AAPL | Stock | 1.3639 | 1.3696 | 1.3625 | 1.3629 | 21411964.0 |
| 2005-07-12 14:30:00 | AAPL | Stock | 1.3625 | 1.3682 | 1.3625 | 1.365 | 23056180.0 |
| 2005-07-12 15:00:00 | AAPL | Stock | 1.365 | 1.3675 | 1.3636 | 1.3671 | 35296632.0 |
| 2005-07-12 15:30:00 | AAPL | Stock | 1.3671 | 1.3675 | 1.3614 | 1.3661 | 56985852.0 |
| 2005-07-12 16:00:00 | AAPL | Stock | 1.3657 | 1.3689 | 1.3618 | 1.3618 | 2561608.0 |
| 2005-07-12 16:30:00 | AAPL | Stock | 1.3625 | 1.365 | 1.3621 | 1.3632 | 205380.0 |
| 2005-07-12 17:00:00 | AAPL | Stock | 1.365 | 1.3657 | 1.3627 | 1.3627 | 306600.0 |
| 2005-07-12 17:30:00 | AAPL | Stock | 1.3654 | 1.3661 | 1.3625 | 1.3661 | 453880.0 |
| 2005-07-12 18:00:00 | AAPL | Stock | 1.3629 | 1.3643 | 1.3629 | 1.3643 | 135100.0 |
| 2005-07-12 08:00:00 | MSFT | Stock | 25.25 | 25.25 | 25.21 | 25.23 | 8700.0 |
| 2005-07-12 08:30:00 | MSFT | Stock | 25.21 | 25.25 | 25.21 | 25.22 | 15100.0 |
| 2005-07-12 09:00:00 | MSFT | Stock | 25.22 | 25.25 | 25.21 | 25.24 | 203025.0 |
| 2005-07-12 09:30:00 | MSFT | Stock | 25.24 | 25.31 | 25.21 | 25.238 | 5920605.0 |
| 2005-07-12 10:00:00 | MSFT | Stock | 25.24 | 25.29 | 25.2 | 25.27 | 6588622.0 |
| 2005-07-12 10:30:00 | MSFT | Stock | 25.272 | 25.49 | 25.27 | 25.47 | 8263364.0 |
| 2005-07-12 11:00:00 | MSFT | Stock | 25.47 | 25.49 | 25.42 | 25.45 | 3989369.0 |
| 2005-07-12 11:30:00 | MSFT | Stock | 25.45 | 25.46 | 25.38 | 25.4 | 2536605.0 |
| 2005-07-12 12:00:00 | MSFT | Stock | 25.4 | 25.47 | 25.39 | 25.46 | 2964419.0 |
| 2005-07-12 12:30:00 | MSFT | Stock | 25.46 | 25.49 | 25.45 | 25.47 | 1745803.0 |
| 2005-07-12 13:00:00 | MSFT | Stock | 25.47 | 25.52 | 25.47 | 25.51 | 2602945.0 |
| 2005-07-12 13:30:00 | MSFT | Stock | 25.51 | 25.58 | 25.47 | 25.55 | 4273901.0 |
| 2005-07-12 14:00:00 | MSFT | Stock | 25.55 | 25.58 | 25.45 | 25.552 | 3738972.0 |
| 2005-07-12 14:30:00 | MSFT | Stock | 25.55 | 25.6 | 25.52 | 25.55 | 4196466.0 |
| 2005-07-12 15:00:00 | MSFT | Stock | 25.552 | 25.62 | 25.53 | 25.61 | 5614427.0 |
| 2005-07-12 15:30:00 | MSFT | Stock | 25.6 | 25.61 | 25.44 | 25.59 | 8815673.0 |
| 2005-07-12 16:00:00 | MSFT | Stock | 25.6 | 25.61 | 25.5 | 25.56 | 719180.0 |
| 2005-07-12 16:30:00 | MSFT | Stock | 25.61 | 25.61 | 25.56 | 25.56 | 54999.0 |
| 2005-07-12 17:00:00 | MSFT | Stock | 25.56 | 25.61 | 25.461 | 25.461 | 101000.0 |
| 2005-07-12 17:30:00 | MSFT | Stock | 25.61 | 25.61 | 25.59 | 25.59 | 1800.0 |
| 2005-07-12 18:00:00 | MSFT | Stock | 25.6 | 25.61 | 25.6 | 25.61 | 13496.0 |
| 2005-07-12 09:00:00 | NVDA | Stock | 0.2381 | 0.2381 | 0.2381 | 0.2381 | 16800.0 |
| 2005-07-12 09:30:00 | NVDA | Stock | 0.2378 | 0.2385 | 0.2345 | 0.2347 | 78237600.0 |
| 2005-07-12 10:00:00 | NVDA | Stock | 0.2347 | 0.2347 | 0.2318 | 0.2332 | 61274760.0 |
| 2005-07-12 10:30:00 | NVDA | Stock | 0.2332 | 0.2336 | 0.2328 | 0.2333 | 30181440.0 |
| 2005-07-12 11:00:00 | NVDA | Stock | 0.2333 | 0.2343 | 0.2329 | 0.2331 | 22577160.0 |
| 2005-07-12 11:30:00 | NVDA | Stock | 0.2331 | 0.2333 | 0.2325 | 0.2328 | 22058880.0 |
> showing 50 of 44,988 rows — these rows as CSV