PREVIEW / stock_30min / 2005-04-14
file: by_date/stock_30min/2005/2005-04-14.parquet size: 835 KB rows: 44,575 symbols: 1,960
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-04-14 05:30:00 | AAPL | Stock | 1.4518 | 1.4518 | 1.4518 | 1.4518 | 179200.0 |
| 2005-04-14 06:30:00 | AAPL | Stock | 1.4482 | 1.4482 | 1.4482 | 1.4482 | 56000.0 |
| 2005-04-14 07:30:00 | AAPL | Stock | 1.4286 | 1.4429 | 1.4261 | 1.4286 | 545580.0 |
| 2005-04-14 08:00:00 | AAPL | Stock | 1.4286 | 1.4429 | 1.4161 | 1.4239 | 31238088.0 |
| 2005-04-14 08:30:00 | AAPL | Stock | 1.4239 | 1.4268 | 1.3839 | 1.3868 | 47973828.0 |
| 2005-04-14 09:00:00 | AAPL | Stock | 1.3868 | 1.3879 | 1.3643 | 1.3857 | 82180448.0 |
| 2005-04-14 09:30:00 | AAPL | Stock | 1.3861 | 1.4129 | 1.3596 | 1.4036 | 570751328.0 |
| 2005-04-14 10:00:00 | AAPL | Stock | 1.4032 | 1.4279 | 1.3729 | 1.3836 | 252721084.0 |
| 2005-04-14 10:30:00 | AAPL | Stock | 1.3839 | 1.3971 | 1.375 | 1.3939 | 146704992.0 |
| 2005-04-14 11:00:00 | AAPL | Stock | 1.394 | 1.3968 | 1.3857 | 1.3918 | 100645692.0 |
| 2005-04-14 11:30:00 | AAPL | Stock | 1.3919 | 1.3921 | 1.3782 | 1.3786 | 86159304.0 |
| 2005-04-14 12:00:00 | AAPL | Stock | 1.3786 | 1.3857 | 1.3571 | 1.3571 | 159886496.0 |
| 2005-04-14 12:30:00 | AAPL | Stock | 1.3571 | 1.3671 | 1.3518 | 1.3539 | 138952296.0 |
| 2005-04-14 13:00:00 | AAPL | Stock | 1.3539 | 1.3589 | 1.3314 | 1.3329 | 203038360.0 |
| 2005-04-14 13:30:00 | AAPL | Stock | 1.3325 | 1.3389 | 1.3157 | 1.3182 | 211146964.0 |
| 2005-04-14 14:00:00 | AAPL | Stock | 1.3189 | 1.3414 | 1.3168 | 1.3336 | 193160436.0 |
| 2005-04-14 14:30:00 | AAPL | Stock | 1.3336 | 1.3454 | 1.3296 | 1.3425 | 135553740.0 |
| 2005-04-14 15:00:00 | AAPL | Stock | 1.3425 | 1.3471 | 1.3196 | 1.3432 | 145933284.0 |
| 2005-04-14 15:30:00 | AAPL | Stock | 1.3436 | 1.3489 | 1.3282 | 1.3314 | 208926116.0 |
| 2005-04-14 16:00:00 | AAPL | Stock | 1.3307 | 1.4087 | 1.3204 | 1.3214 | 13986420.0 |
| 2005-04-14 16:30:00 | AAPL | Stock | 1.3207 | 1.3214 | 1.3089 | 1.3118 | 3908688.0 |
| 2005-04-14 17:00:00 | AAPL | Stock | 1.3136 | 1.3314 | 1.3118 | 1.3161 | 1608124.0 |
| 2005-04-14 17:30:00 | AAPL | Stock | 1.3143 | 1.3164 | 1.3086 | 1.3164 | 740180.0 |
| 2005-04-14 18:00:00 | AAPL | Stock | 1.3125 | 1.3161 | 1.3036 | 1.3071 | 1118460.0 |
| 2005-04-14 08:00:00 | MSFT | Stock | 25.01 | 25.03 | 25.01 | 25.02 | 8100.0 |
| 2005-04-14 08:30:00 | MSFT | Stock | 25.01 | 25.03 | 25.01 | 25.03 | 7967.0 |
| 2005-04-14 09:00:00 | MSFT | Stock | 25.03 | 25.09 | 25.0 | 25.0 | 122462.0 |
| 2005-04-14 09:30:00 | MSFT | Stock | 25.01 | 25.11 | 25.0 | 25.07 | 6469566.0 |
| 2005-04-14 10:00:00 | MSFT | Stock | 25.07 | 25.08 | 24.83 | 24.91 | 7230310.0 |
| 2005-04-14 10:30:00 | MSFT | Stock | 24.9 | 24.97 | 24.84 | 24.94 | 5102333.0 |
| 2005-04-14 11:00:00 | MSFT | Stock | 24.94 | 25.07 | 24.91 | 25.03 | 5761791.0 |
| 2005-04-14 11:30:00 | MSFT | Stock | 25.03 | 25.08 | 24.96 | 24.96 | 3481349.0 |
| 2005-04-14 12:00:00 | MSFT | Stock | 24.96 | 25.03 | 24.93 | 25.03 | 3141484.0 |
| 2005-04-14 12:30:00 | MSFT | Stock | 25.03 | 25.09 | 25.02 | 25.05 | 2983161.0 |
| 2005-04-14 13:00:00 | MSFT | Stock | 25.05 | 25.08 | 24.95 | 25.0 | 3126559.0 |
| 2005-04-14 13:30:00 | MSFT | Stock | 24.999 | 25.04 | 24.93 | 25.02 | 4332972.0 |
| 2005-04-14 14:00:00 | MSFT | Stock | 25.01 | 25.05 | 24.98 | 25.01 | 5913293.0 |
| 2005-04-14 14:30:00 | MSFT | Stock | 25.0 | 25.01 | 24.95 | 24.98 | 4040583.0 |
| 2005-04-14 15:00:00 | MSFT | Stock | 24.98 | 25.01 | 24.94 | 24.98 | 5489375.0 |
| 2005-04-14 15:30:00 | MSFT | Stock | 24.98 | 25.14 | 24.83 | 24.85 | 6841453.0 |
| 2005-04-14 16:00:00 | MSFT | Stock | 24.86 | 24.87 | 24.63 | 24.68 | 645173.0 |
| 2005-04-14 16:30:00 | MSFT | Stock | 24.68 | 24.84 | 24.55 | 24.55 | 78048.0 |
| 2005-04-14 17:00:00 | MSFT | Stock | 24.55 | 24.84 | 24.54 | 24.56 | 521800.0 |
| 2005-04-14 17:30:00 | MSFT | Stock | 24.56 | 24.858 | 24.56 | 24.6 | 7299.0 |
| 2005-04-14 18:00:00 | MSFT | Stock | 24.6 | 24.6 | 24.57 | 24.6 | 6292.0 |
| 2005-04-14 08:30:00 | NVDA | Stock | 0.1872 | 0.1873 | 0.1872 | 0.1873 | 42000.0 |
| 2005-04-14 09:00:00 | NVDA | Stock | 0.1869 | 0.1869 | 0.1854 | 0.1854 | 240000.0 |
| 2005-04-14 09:30:00 | NVDA | Stock | 0.1862 | 0.1872 | 0.1847 | 0.1862 | 40033680.0 |
| 2005-04-14 10:00:00 | NVDA | Stock | 0.186 | 0.1867 | 0.1846 | 0.1848 | 39587160.0 |
| 2005-04-14 10:30:00 | NVDA | Stock | 0.1848 | 0.1867 | 0.184 | 0.1863 | 37581600.0 |
> showing 50 of 44,575 rows — these rows as CSV