PREVIEW / stock_30min / 2001-07-19
file: by_date/stock_30min/2001/2001-07-19.parquet size: 543 KB rows: 28,215 symbols: 1,309
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 |
|---|---|---|---|---|---|---|---|
| 2001-07-19 08:00:00 | AAPL | Stock | 0.375 | 0.375 | 0.3711 | 0.3732 | 481600.0 |
| 2001-07-19 08:30:00 | AAPL | Stock | 0.3777 | 0.3825 | 0.3748 | 0.3777 | 1327200.0 |
| 2001-07-19 09:00:00 | AAPL | Stock | 0.377 | 0.3795 | 0.375 | 0.3791 | 2531200.0 |
| 2001-07-19 09:30:00 | AAPL | Stock | 0.3791 | 0.3825 | 0.372 | 0.3721 | 74093600.0 |
| 2001-07-19 10:00:00 | AAPL | Stock | 0.3732 | 0.3768 | 0.3721 | 0.3734 | 67788000.0 |
| 2001-07-19 10:30:00 | AAPL | Stock | 0.3729 | 0.3759 | 0.3718 | 0.3739 | 62445600.0 |
| 2001-07-19 11:00:00 | AAPL | Stock | 0.3736 | 0.3741 | 0.3648 | 0.3648 | 65738400.0 |
| 2001-07-19 11:30:00 | AAPL | Stock | 0.3655 | 0.3661 | 0.3616 | 0.3661 | 45164000.0 |
| 2001-07-19 12:00:00 | AAPL | Stock | 0.3661 | 0.3668 | 0.3613 | 0.3618 | 55960800.0 |
| 2001-07-19 12:30:00 | AAPL | Stock | 0.3616 | 0.3641 | 0.3598 | 0.3614 | 29943200.0 |
| 2001-07-19 13:00:00 | AAPL | Stock | 0.3614 | 0.3632 | 0.3604 | 0.3618 | 40902400.0 |
| 2001-07-19 13:30:00 | AAPL | Stock | 0.3616 | 0.3625 | 0.3588 | 0.3598 | 35487200.0 |
| 2001-07-19 14:00:00 | AAPL | Stock | 0.3596 | 0.3598 | 0.3571 | 0.3571 | 59410400.0 |
| 2001-07-19 14:30:00 | AAPL | Stock | 0.358 | 0.3589 | 0.3538 | 0.3554 | 72861600.0 |
| 2001-07-19 15:00:00 | AAPL | Stock | 0.3552 | 0.3568 | 0.3527 | 0.3557 | 61320000.0 |
| 2001-07-19 15:30:00 | AAPL | Stock | 0.3557 | 0.3571 | 0.3546 | 0.3563 | 108421600.0 |
| 2001-07-19 16:00:00 | AAPL | Stock | 0.3564 | 0.365 | 0.3554 | 0.358 | 18827200.0 |
| 2001-07-19 16:30:00 | AAPL | Stock | 0.3559 | 0.3559 | 0.3536 | 0.3536 | 16800.0 |
| 2001-07-19 17:00:00 | AAPL | Stock | 0.3545 | 0.3545 | 0.3529 | 0.3545 | 95200.0 |
| 2001-07-19 17:30:00 | AAPL | Stock | 0.3536 | 0.3563 | 0.3536 | 0.3545 | 436800.0 |
| 2001-07-19 18:00:00 | AAPL | Stock | 0.3545 | 0.3545 | 0.352 | 0.352 | 145600.0 |
| 2001-07-19 08:00:00 | MSFT | Stock | 35.625 | 35.725 | 35.285 | 35.7 | 197400.0 |
| 2001-07-19 08:30:00 | MSFT | Stock | 35.675 | 35.82 | 35.15 | 35.8 | 369000.0 |
| 2001-07-19 09:00:00 | MSFT | Stock | 35.8 | 35.825 | 35.285 | 35.585 | 569400.0 |
| 2001-07-19 09:30:00 | MSFT | Stock | 35.61 | 36.0 | 35.57 | 35.985 | 7451400.0 |
| 2001-07-19 10:00:00 | MSFT | Stock | 35.985 | 36.235 | 35.93 | 36.045 | 7796400.0 |
| 2001-07-19 10:30:00 | MSFT | Stock | 36.045 | 36.195 | 35.885 | 36.165 | 4335200.0 |
| 2001-07-19 11:00:00 | MSFT | Stock | 36.175 | 36.25 | 36.15 | 36.195 | 5900400.0 |
| 2001-07-19 11:30:00 | MSFT | Stock | 36.195 | 36.25 | 36.16 | 36.19 | 2992400.0 |
| 2001-07-19 12:00:00 | MSFT | Stock | 36.19 | 36.31 | 36.1 | 36.185 | 3010400.0 |
| 2001-07-19 12:30:00 | MSFT | Stock | 36.19 | 36.39 | 36.115 | 36.36 | 3405200.0 |
| 2001-07-19 13:00:00 | MSFT | Stock | 36.365 | 36.5 | 36.32 | 36.4 | 3478400.0 |
| 2001-07-19 13:30:00 | MSFT | Stock | 36.395 | 36.47 | 36.215 | 36.325 | 2944200.0 |
| 2001-07-19 14:00:00 | MSFT | Stock | 36.335 | 36.36 | 36.12 | 36.245 | 2808600.0 |
| 2001-07-19 14:30:00 | MSFT | Stock | 36.245 | 36.28 | 36.025 | 36.05 | 4735800.0 |
| 2001-07-19 15:00:00 | MSFT | Stock | 36.065 | 36.115 | 35.8 | 36.015 | 5413400.0 |
| 2001-07-19 15:30:00 | MSFT | Stock | 36.01 | 36.3 | 35.785 | 36.295 | 6865800.0 |
| 2001-07-19 16:00:00 | MSFT | Stock | 36.3 | 36.5 | 35.0 | 35.5 | 5927400.0 |
| 2001-07-19 16:30:00 | MSFT | Stock | 35.55 | 37.125 | 35.0 | 35.005 | 2731200.0 |
| 2001-07-19 17:00:00 | MSFT | Stock | 35.0 | 35.39 | 34.585 | 34.825 | 2350600.0 |
| 2001-07-19 17:30:00 | MSFT | Stock | 34.85 | 36.25 | 34.56 | 34.925 | 728400.0 |
| 2001-07-19 18:00:00 | MSFT | Stock | 34.91 | 34.95 | 34.6 | 34.6 | 158600.0 |
| 2001-07-19 08:00:00 | NVDA | Stock | 0.3165 | 0.3188 | 0.3165 | 0.3188 | 4848000.0 |
| 2001-07-19 08:30:00 | NVDA | Stock | 0.3196 | 0.3219 | 0.3196 | 0.3219 | 1608000.0 |
| 2001-07-19 09:00:00 | NVDA | Stock | 0.3213 | 0.3226 | 0.3165 | 0.3208 | 1704000.0 |
| 2001-07-19 09:30:00 | NVDA | Stock | 0.3208 | 0.3315 | 0.3198 | 0.3315 | 89232000.0 |
| 2001-07-19 10:00:00 | NVDA | Stock | 0.3317 | 0.3347 | 0.3264 | 0.3278 | 94224000.0 |
| 2001-07-19 10:30:00 | NVDA | Stock | 0.3277 | 0.3316 | 0.3256 | 0.3313 | 65880000.0 |
| 2001-07-19 11:00:00 | NVDA | Stock | 0.3316 | 0.3338 | 0.331 | 0.3324 | 91032000.0 |
| 2001-07-19 11:30:00 | NVDA | Stock | 0.3325 | 0.3333 | 0.33 | 0.3313 | 68208000.0 |
> showing 50 of 28,215 rows — these rows as CSV