PREVIEW / stock_30min / 2002-06-18
file: by_date/stock_30min/2002/2002-06-18.parquet size: 609 KB rows: 31,783 symbols: 1,436
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 |
|---|---|---|---|---|---|---|---|
| 2002-06-18 08:00:00 | AAPL | Stock | 0.3673 | 0.3673 | 0.3659 | 0.3659 | 453600.0 |
| 2002-06-18 08:30:00 | AAPL | Stock | 0.3641 | 0.3652 | 0.3641 | 0.3652 | 61600.0 |
| 2002-06-18 09:00:00 | AAPL | Stock | 0.3627 | 0.3668 | 0.3618 | 0.3646 | 2340800.0 |
| 2002-06-18 09:30:00 | AAPL | Stock | 0.3646 | 0.367 | 0.3623 | 0.3659 | 51184000.0 |
| 2002-06-18 10:00:00 | AAPL | Stock | 0.3657 | 0.3677 | 0.3637 | 0.3662 | 28050400.0 |
| 2002-06-18 10:30:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3641 | 0.3643 | 20025600.0 |
| 2002-06-18 11:00:00 | AAPL | Stock | 0.3648 | 0.3648 | 0.3593 | 0.3602 | 22125600.0 |
| 2002-06-18 11:30:00 | AAPL | Stock | 0.3602 | 0.3652 | 0.36 | 0.365 | 19101600.0 |
| 2002-06-18 12:00:00 | AAPL | Stock | 0.365 | 0.3668 | 0.3634 | 0.3634 | 12073600.0 |
| 2002-06-18 12:30:00 | AAPL | Stock | 0.3634 | 0.3648 | 0.3625 | 0.3625 | 13832000.0 |
| 2002-06-18 13:00:00 | AAPL | Stock | 0.3625 | 0.3638 | 0.3607 | 0.3613 | 12488000.0 |
| 2002-06-18 13:30:00 | AAPL | Stock | 0.3613 | 0.3632 | 0.3611 | 0.3613 | 10696000.0 |
| 2002-06-18 14:00:00 | AAPL | Stock | 0.3613 | 0.362 | 0.3595 | 0.3604 | 19840800.0 |
| 2002-06-18 14:30:00 | AAPL | Stock | 0.3604 | 0.3618 | 0.3598 | 0.3605 | 22758400.0 |
| 2002-06-18 15:00:00 | AAPL | Stock | 0.3607 | 0.3625 | 0.3602 | 0.3605 | 23402400.0 |
| 2002-06-18 15:30:00 | AAPL | Stock | 0.3605 | 0.3605 | 0.3568 | 0.36 | 40661600.0 |
| 2002-06-18 16:00:00 | AAPL | Stock | 0.3598 | 0.3739 | 0.3579 | 0.3607 | 25642400.0 |
| 2002-06-18 16:30:00 | AAPL | Stock | 0.3375 | 0.3624 | 0.308 | 0.3214 | 6171200.0 |
| 2002-06-18 17:00:00 | AAPL | Stock | 0.3232 | 0.3614 | 0.3155 | 0.3184 | 15836800.0 |
| 2002-06-18 17:30:00 | AAPL | Stock | 0.3191 | 0.3601 | 0.3089 | 0.3107 | 3130400.0 |
| 2002-06-18 18:00:00 | AAPL | Stock | 0.3107 | 0.3125 | 0.308 | 0.3089 | 9368800.0 |
| 2002-06-18 08:00:00 | MSFT | Stock | 27.7 | 27.9 | 27.55 | 27.675 | 71600.0 |
| 2002-06-18 08:30:00 | MSFT | Stock | 27.71 | 27.84 | 27.625 | 27.785 | 84600.0 |
| 2002-06-18 09:00:00 | MSFT | Stock | 27.775 | 27.84 | 27.7 | 27.77 | 232600.0 |
| 2002-06-18 09:30:00 | MSFT | Stock | 27.765 | 28.025 | 27.675 | 27.975 | 10014600.0 |
| 2002-06-18 10:00:00 | MSFT | Stock | 27.975 | 28.08 | 27.89 | 27.975 | 7763000.0 |
| 2002-06-18 10:30:00 | MSFT | Stock | 27.96 | 28.085 | 27.885 | 27.965 | 4955000.0 |
| 2002-06-18 11:00:00 | MSFT | Stock | 27.959 | 27.98 | 27.845 | 27.925 | 5034400.0 |
| 2002-06-18 11:30:00 | MSFT | Stock | 27.925 | 28.095 | 27.925 | 28.065 | 3734000.0 |
| 2002-06-18 12:00:00 | MSFT | Stock | 28.05 | 28.075 | 27.97 | 27.985 | 2429600.0 |
| 2002-06-18 12:30:00 | MSFT | Stock | 27.985 | 28.05 | 27.945 | 27.985 | 3689000.0 |
| 2002-06-18 13:00:00 | MSFT | Stock | 27.985 | 28.03 | 27.95 | 27.975 | 4817200.0 |
| 2002-06-18 13:30:00 | MSFT | Stock | 27.97 | 28.045 | 27.95 | 27.975 | 3584000.0 |
| 2002-06-18 14:00:00 | MSFT | Stock | 27.975 | 28.025 | 27.9 | 27.98 | 6476400.0 |
| 2002-06-18 14:30:00 | MSFT | Stock | 27.982 | 28.05 | 27.935 | 28.045 | 5056400.0 |
| 2002-06-18 15:00:00 | MSFT | Stock | 28.0435 | 28.145 | 27.99 | 28.06 | 6671600.0 |
| 2002-06-18 15:30:00 | MSFT | Stock | 28.06 | 28.075 | 27.88 | 28.0 | 5865000.0 |
| 2002-06-18 16:00:00 | MSFT | Stock | 28.0 | 28.525 | 27.94 | 28.295 | 4103200.0 |
| 2002-06-18 16:30:00 | MSFT | Stock | 28.295 | 28.295 | 27.9744 | 28.125 | 481800.0 |
| 2002-06-18 17:00:00 | MSFT | Stock | 28.125 | 28.18 | 27.96 | 27.96 | 201200.0 |
| 2002-06-18 17:30:00 | MSFT | Stock | 27.96 | 28.0144 | 27.755 | 27.775 | 403800.0 |
| 2002-06-18 18:00:00 | MSFT | Stock | 27.755 | 27.975 | 27.7 | 27.75 | 84400.0 |
| 2002-06-18 08:00:00 | NVDA | Stock | 0.2371 | 0.2398 | 0.2334 | 0.2334 | 912000.0 |
| 2002-06-18 08:30:00 | NVDA | Stock | 0.2354 | 0.2358 | 0.235 | 0.235 | 768000.0 |
| 2002-06-18 09:00:00 | NVDA | Stock | 0.235 | 0.2367 | 0.2337 | 0.2338 | 2004000.0 |
| 2002-06-18 09:30:00 | NVDA | Stock | 0.234 | 0.2361 | 0.2313 | 0.2342 | 151764000.0 |
| 2002-06-18 10:00:00 | NVDA | Stock | 0.234 | 0.2362 | 0.2312 | 0.234 | 155964000.0 |
| 2002-06-18 10:30:00 | NVDA | Stock | 0.234 | 0.2417 | 0.234 | 0.2409 | 119808000.0 |
| 2002-06-18 11:00:00 | NVDA | Stock | 0.241 | 0.2415 | 0.236 | 0.2373 | 126444000.0 |
| 2002-06-18 11:30:00 | NVDA | Stock | 0.2371 | 0.2404 | 0.2371 | 0.2391 | 44364000.0 |
> showing 50 of 31,783 rows — these rows as CSV