PREVIEW / stock_1hour / 2003-05-15
file: by_date/stock_1hour/2003/2003-05-15.parquet size: 434 KB rows: 21,529 symbols: 1,577
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 |
|---|---|---|---|---|---|---|---|
| 2003-05-15 08:00:00 | AAPL | Stock | 0.3314 | 0.3314 | 0.3314 | 0.3314 | 106400.0 |
| 2003-05-15 09:00:00 | AAPL | Stock | 0.3321 | 0.3359 | 0.3305 | 0.3359 | 39618656.0 |
| 2003-05-15 10:00:00 | AAPL | Stock | 0.3359 | 0.3366 | 0.3298 | 0.332 | 53299568.0 |
| 2003-05-15 11:00:00 | AAPL | Stock | 0.332 | 0.333 | 0.3304 | 0.3318 | 34095712.0 |
| 2003-05-15 12:00:00 | AAPL | Stock | 0.3316 | 0.3325 | 0.3302 | 0.3321 | 37889320.0 |
| 2003-05-15 13:00:00 | AAPL | Stock | 0.3321 | 0.333 | 0.3314 | 0.3329 | 14406784.0 |
| 2003-05-15 14:00:00 | AAPL | Stock | 0.3327 | 0.3334 | 0.3314 | 0.3329 | 23955624.0 |
| 2003-05-15 15:00:00 | AAPL | Stock | 0.3332 | 0.3348 | 0.3319 | 0.3348 | 29370768.0 |
| 2003-05-15 16:00:00 | AAPL | Stock | 0.3343 | 0.3348 | 0.3313 | 0.3332 | 2357152.0 |
| 2003-05-15 17:00:00 | AAPL | Stock | 0.3321 | 0.3321 | 0.3313 | 0.332 | 296800.0 |
| 2003-05-15 18:00:00 | AAPL | Stock | 0.3345 | 0.3345 | 0.3345 | 0.3345 | 868000.0 |
| 2003-05-15 08:00:00 | MSFT | Stock | 25.6 | 25.8 | 25.6 | 25.73 | 83866.0 |
| 2003-05-15 09:00:00 | MSFT | Stock | 25.73 | 25.99 | 25.71 | 25.98 | 7232445.0 |
| 2003-05-15 10:00:00 | MSFT | Stock | 25.96 | 26.0 | 25.65 | 25.72 | 10542056.0 |
| 2003-05-15 11:00:00 | MSFT | Stock | 25.73 | 25.731 | 25.65 | 25.6901 | 4414622.0 |
| 2003-05-15 12:00:00 | MSFT | Stock | 25.69 | 25.73 | 25.59 | 25.7 | 3908052.0 |
| 2003-05-15 13:00:00 | MSFT | Stock | 25.7 | 25.8 | 25.69 | 25.78 | 2465117.0 |
| 2003-05-15 14:00:00 | MSFT | Stock | 25.79 | 25.8 | 25.64 | 25.74 | 3097069.0 |
| 2003-05-15 15:00:00 | MSFT | Stock | 25.75 | 25.81 | 25.67 | 25.8 | 4780262.0 |
| 2003-05-15 16:00:00 | MSFT | Stock | 25.81 | 25.83 | 25.69 | 25.7 | 505577.0 |
| 2003-05-15 17:00:00 | MSFT | Stock | 25.7 | 25.81 | 25.65 | 25.69 | 44000.0 |
| 2003-05-15 18:00:00 | MSFT | Stock | 25.81 | 25.81 | 25.69 | 25.7 | 116672.0 |
| 2003-05-15 08:00:00 | NVDA | Stock | 0.1687 | 0.1708 | 0.1679 | 0.1704 | 763200.0 |
| 2003-05-15 09:00:00 | NVDA | Stock | 0.1708 | 0.1751 | 0.1708 | 0.175 | 215915040.0 |
| 2003-05-15 10:00:00 | NVDA | Stock | 0.1751 | 0.1754 | 0.1723 | 0.1737 | 237266040.0 |
| 2003-05-15 11:00:00 | NVDA | Stock | 0.1735 | 0.1737 | 0.1726 | 0.1732 | 76706400.0 |
| 2003-05-15 12:00:00 | NVDA | Stock | 0.1732 | 0.174 | 0.1725 | 0.1738 | 70100520.0 |
| 2003-05-15 13:00:00 | NVDA | Stock | 0.1738 | 0.1747 | 0.1734 | 0.1745 | 70133400.0 |
| 2003-05-15 14:00:00 | NVDA | Stock | 0.1745 | 0.1758 | 0.1742 | 0.1752 | 146576640.0 |
| 2003-05-15 15:00:00 | NVDA | Stock | 0.1753 | 0.1757 | 0.1747 | 0.1755 | 130105560.0 |
| 2003-05-15 16:00:00 | NVDA | Stock | 0.1755 | 0.1755 | 0.1745 | 0.1746 | 8851560.0 |
| 2003-05-15 17:00:00 | NVDA | Stock | 0.1747 | 0.1754 | 0.1747 | 0.175 | 738000.0 |
| 2003-05-15 18:00:00 | NVDA | Stock | 0.1754 | 0.1755 | 0.1747 | 0.1748 | 876000.0 |
| 2003-05-15 08:00:00 | AMZN | Stock | 1.6424 | 1.6424 | 1.631 | 1.631 | 193000.0 |
| 2003-05-15 09:00:00 | AMZN | Stock | 1.632 | 1.639 | 1.6195 | 1.6275 | 17394540.0 |
| 2003-05-15 10:00:00 | AMZN | Stock | 1.6276 | 1.634 | 1.61 | 1.62 | 24356280.0 |
| 2003-05-15 11:00:00 | AMZN | Stock | 1.62 | 1.625 | 1.613 | 1.62 | 9501320.0 |
| 2003-05-15 12:00:00 | AMZN | Stock | 1.619 | 1.622 | 1.6115 | 1.62 | 7961220.0 |
| 2003-05-15 13:00:00 | AMZN | Stock | 1.6195 | 1.625 | 1.617 | 1.625 | 7660620.0 |
| 2003-05-15 14:00:00 | AMZN | Stock | 1.6245 | 1.6275 | 1.618 | 1.6245 | 6817560.0 |
| 2003-05-15 15:00:00 | AMZN | Stock | 1.6245 | 1.6335 | 1.62 | 1.631 | 14779120.0 |
| 2003-05-15 16:00:00 | AMZN | Stock | 1.631 | 1.6335 | 1.6225 | 1.6325 | 787800.0 |
| 2003-05-15 17:00:00 | AMZN | Stock | 1.6295 | 1.6335 | 1.6295 | 1.6335 | 90000.0 |
| 2003-05-15 18:00:00 | AMZN | Stock | 1.6315 | 1.6315 | 1.63 | 1.63 | 156000.0 |
| 2003-05-15 09:00:00 | CL | Stock | 28.885 | 28.95 | 28.8 | 28.92 | 470400.0 |
| 2003-05-15 10:00:00 | CL | Stock | 28.92 | 29.065 | 28.92 | 29.025 | 774800.0 |
| 2003-05-15 11:00:00 | CL | Stock | 29.015 | 29.125 | 29.0 | 29.05 | 324800.0 |
| 2003-05-15 12:00:00 | CL | Stock | 29.045 | 29.1 | 28.99 | 29.08 | 342800.0 |
| 2003-05-15 13:00:00 | CL | Stock | 29.09 | 29.175 | 29.035 | 29.175 | 260800.0 |
| 2003-05-15 14:00:00 | CL | Stock | 29.175 | 29.255 | 29.165 | 29.195 | 282400.0 |
> showing 50 of 21,529 rows — these rows as CSV