PREVIEW / stock_30min / 2002-01-16
file: by_date/stock_30min/2002/2002-01-16.parquet size: 593 KB rows: 30,534 symbols: 1,352
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-01-16 08:00:00 | AAPL | Stock | 0.3786 | 0.3786 | 0.375 | 0.375 | 173600.0 |
| 2002-01-16 08:30:00 | AAPL | Stock | 0.3804 | 0.3875 | 0.3804 | 0.3804 | 140000.0 |
| 2002-01-16 09:00:00 | AAPL | Stock | 0.3816 | 0.3839 | 0.3814 | 0.3823 | 89600.0 |
| 2002-01-16 09:30:00 | AAPL | Stock | 0.3823 | 0.3823 | 0.3755 | 0.3757 | 63190400.0 |
| 2002-01-16 10:00:00 | AAPL | Stock | 0.3755 | 0.3794 | 0.3746 | 0.3773 | 38012800.0 |
| 2002-01-16 10:30:00 | AAPL | Stock | 0.3771 | 0.3777 | 0.375 | 0.3757 | 26605600.0 |
| 2002-01-16 11:00:00 | AAPL | Stock | 0.3757 | 0.3764 | 0.3684 | 0.37 | 74726400.0 |
| 2002-01-16 11:30:00 | AAPL | Stock | 0.37 | 0.3727 | 0.37 | 0.372 | 14817600.0 |
| 2002-01-16 12:00:00 | AAPL | Stock | 0.372 | 0.3725 | 0.3704 | 0.3721 | 17466400.0 |
| 2002-01-16 12:30:00 | AAPL | Stock | 0.3721 | 0.3761 | 0.3705 | 0.3746 | 26135200.0 |
| 2002-01-16 13:00:00 | AAPL | Stock | 0.3746 | 0.3777 | 0.3738 | 0.3746 | 24656800.0 |
| 2002-01-16 13:30:00 | AAPL | Stock | 0.3748 | 0.3782 | 0.3736 | 0.3746 | 15075200.0 |
| 2002-01-16 14:00:00 | AAPL | Stock | 0.3746 | 0.3761 | 0.3741 | 0.3745 | 14666400.0 |
| 2002-01-16 14:30:00 | AAPL | Stock | 0.3745 | 0.3757 | 0.3743 | 0.3757 | 16195200.0 |
| 2002-01-16 15:00:00 | AAPL | Stock | 0.375 | 0.3766 | 0.3743 | 0.375 | 42515200.0 |
| 2002-01-16 15:30:00 | AAPL | Stock | 0.375 | 0.375 | 0.3661 | 0.3711 | 93413600.0 |
| 2002-01-16 16:00:00 | AAPL | Stock | 0.3736 | 0.3743 | 0.37 | 0.3732 | 34008800.0 |
| 2002-01-16 16:30:00 | AAPL | Stock | 0.3721 | 0.3929 | 0.3679 | 0.3848 | 9968000.0 |
| 2002-01-16 17:00:00 | AAPL | Stock | 0.3857 | 0.3929 | 0.3711 | 0.3929 | 1976800.0 |
| 2002-01-16 17:30:00 | AAPL | Stock | 0.3911 | 0.3929 | 0.3839 | 0.3893 | 9055200.0 |
| 2002-01-16 18:00:00 | AAPL | Stock | 0.3889 | 0.3889 | 0.3877 | 0.3882 | 302400.0 |
| 2002-01-16 08:00:00 | MSFT | Stock | 34.425 | 34.7725 | 34.375 | 34.4 | 178400.0 |
| 2002-01-16 08:30:00 | MSFT | Stock | 34.375 | 34.775 | 34.375 | 34.575 | 61200.0 |
| 2002-01-16 09:00:00 | MSFT | Stock | 34.545 | 34.77 | 34.42 | 34.425 | 235400.0 |
| 2002-01-16 09:30:00 | MSFT | Stock | 34.425 | 34.8805 | 34.415 | 34.82 | 6642200.0 |
| 2002-01-16 10:00:00 | MSFT | Stock | 34.825 | 34.92 | 34.685 | 34.785 | 6959200.0 |
| 2002-01-16 10:30:00 | MSFT | Stock | 34.785 | 34.785 | 34.515 | 34.58 | 4798000.0 |
| 2002-01-16 11:00:00 | MSFT | Stock | 34.58 | 34.585 | 34.355 | 34.45 | 4728200.0 |
| 2002-01-16 11:30:00 | MSFT | Stock | 34.45 | 34.465 | 34.355 | 34.395 | 2580200.0 |
| 2002-01-16 12:00:00 | MSFT | Stock | 34.395 | 34.425 | 34.075 | 34.19 | 3425400.0 |
| 2002-01-16 12:30:00 | MSFT | Stock | 34.18 | 34.305 | 34.135 | 34.275 | 2525400.0 |
| 2002-01-16 13:00:00 | MSFT | Stock | 34.275 | 34.28 | 34.08 | 34.115 | 2107600.0 |
| 2002-01-16 13:30:00 | MSFT | Stock | 34.115 | 34.185 | 34.005 | 34.045 | 2621400.0 |
| 2002-01-16 14:00:00 | MSFT | Stock | 34.04 | 34.25 | 33.975 | 34.21 | 3776800.0 |
| 2002-01-16 14:30:00 | MSFT | Stock | 34.2 | 34.325 | 34.17 | 34.22 | 3427400.0 |
| 2002-01-16 15:00:00 | MSFT | Stock | 34.2345 | 34.395 | 34.21 | 34.275 | 3171200.0 |
| 2002-01-16 15:30:00 | MSFT | Stock | 34.275 | 34.285 | 33.93 | 33.93 | 6670200.0 |
| 2002-01-16 16:00:00 | MSFT | Stock | 33.93 | 34.3992 | 33.815 | 33.95 | 1852000.0 |
| 2002-01-16 16:30:00 | MSFT | Stock | 33.91 | 34.3968 | 33.91 | 33.975 | 162600.0 |
| 2002-01-16 17:00:00 | MSFT | Stock | 33.95 | 34.1495 | 33.935 | 34.1495 | 276600.0 |
| 2002-01-16 17:30:00 | MSFT | Stock | 34.125 | 34.125 | 34.045 | 34.125 | 8800.0 |
| 2002-01-16 18:00:00 | MSFT | Stock | 34.105 | 34.125 | 34.05 | 34.125 | 3600.0 |
| 2002-01-16 08:00:00 | NVDA | Stock | 0.527 | 0.5347 | 0.527 | 0.5347 | 324000.0 |
| 2002-01-16 08:30:00 | NVDA | Stock | 0.5367 | 0.5445 | 0.5333 | 0.535 | 3492000.0 |
| 2002-01-16 09:00:00 | NVDA | Stock | 0.5354 | 0.5442 | 0.5337 | 0.5375 | 8088000.0 |
| 2002-01-16 09:30:00 | NVDA | Stock | 0.5371 | 0.5401 | 0.5282 | 0.5341 | 150732000.0 |
| 2002-01-16 10:00:00 | NVDA | Stock | 0.534 | 0.5354 | 0.5237 | 0.5239 | 139560000.0 |
| 2002-01-16 10:30:00 | NVDA | Stock | 0.5239 | 0.5287 | 0.5217 | 0.5264 | 87540000.0 |
| 2002-01-16 11:00:00 | NVDA | Stock | 0.5268 | 0.5287 | 0.5244 | 0.5277 | 79308000.0 |
| 2002-01-16 11:30:00 | NVDA | Stock | 0.5277 | 0.5325 | 0.525 | 0.5317 | 63588000.0 |
> showing 50 of 30,534 rows — these rows as CSV