PREVIEW / stock_1hour / 2003-05-22
file: by_date/stock_1hour/2003/2003-05-22.parquet size: 436 KB rows: 21,414 symbols: 1,573
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-22 08:00:00 | AAPL | Stock | 0.3188 | 0.3188 | 0.3188 | 0.3188 | 5600.0 |
| 2003-05-22 09:00:00 | AAPL | Stock | 0.3188 | 0.3213 | 0.3168 | 0.3198 | 15659840.0 |
| 2003-05-22 10:00:00 | AAPL | Stock | 0.3196 | 0.3277 | 0.3189 | 0.3268 | 42904904.0 |
| 2003-05-22 11:00:00 | AAPL | Stock | 0.3264 | 0.3286 | 0.3252 | 0.3259 | 22107680.0 |
| 2003-05-22 12:00:00 | AAPL | Stock | 0.3259 | 0.3277 | 0.3252 | 0.3264 | 12864432.0 |
| 2003-05-22 13:00:00 | AAPL | Stock | 0.3263 | 0.3268 | 0.3252 | 0.3268 | 9174872.0 |
| 2003-05-22 14:00:00 | AAPL | Stock | 0.3268 | 0.3277 | 0.3252 | 0.3257 | 16168600.0 |
| 2003-05-22 15:00:00 | AAPL | Stock | 0.3259 | 0.3271 | 0.3239 | 0.3257 | 29557640.0 |
| 2003-05-22 16:00:00 | AAPL | Stock | 0.3257 | 0.3266 | 0.3239 | 0.3257 | 2682736.0 |
| 2003-05-22 17:00:00 | AAPL | Stock | 0.3257 | 0.3257 | 0.3257 | 0.3257 | 1019200.0 |
| 2003-05-22 08:00:00 | MSFT | Stock | 24.035 | 24.201 | 23.55 | 24.2 | 168070.0 |
| 2003-05-22 09:00:00 | MSFT | Stock | 24.171 | 24.26 | 24.08 | 24.15 | 10438912.0 |
| 2003-05-22 10:00:00 | MSFT | Stock | 24.15 | 24.17 | 24.049 | 24.09 | 17368962.0 |
| 2003-05-22 11:00:00 | MSFT | Stock | 24.09 | 24.27 | 24.05 | 24.17 | 10264473.0 |
| 2003-05-22 12:00:00 | MSFT | Stock | 24.17 | 24.24 | 24.14 | 24.15 | 6345452.0 |
| 2003-05-22 13:00:00 | MSFT | Stock | 24.15 | 24.19 | 24.1 | 24.15 | 5370593.0 |
| 2003-05-22 14:00:00 | MSFT | Stock | 24.1516 | 24.163 | 24.04 | 24.11 | 11224562.0 |
| 2003-05-22 15:00:00 | MSFT | Stock | 24.12 | 24.171 | 24.07 | 24.16 | 14966196.0 |
| 2003-05-22 16:00:00 | MSFT | Stock | 24.17 | 24.2 | 24.1 | 24.14 | 1196702.0 |
| 2003-05-22 17:00:00 | MSFT | Stock | 24.14 | 24.19 | 24.14 | 24.19 | 165775.0 |
| 2003-05-22 18:00:00 | MSFT | Stock | 24.2 | 24.21 | 24.16 | 24.19 | 7100.0 |
| 2003-05-22 08:00:00 | NVDA | Stock | 0.1748 | 0.1748 | 0.1733 | 0.1733 | 1478040.0 |
| 2003-05-22 09:00:00 | NVDA | Stock | 0.1733 | 0.1746 | 0.1711 | 0.1712 | 98384400.0 |
| 2003-05-22 10:00:00 | NVDA | Stock | 0.1712 | 0.176 | 0.1704 | 0.1752 | 168621480.0 |
| 2003-05-22 11:00:00 | NVDA | Stock | 0.1752 | 0.1764 | 0.1737 | 0.1745 | 107146440.0 |
| 2003-05-22 12:00:00 | NVDA | Stock | 0.1746 | 0.1754 | 0.1737 | 0.1738 | 57278040.0 |
| 2003-05-22 13:00:00 | NVDA | Stock | 0.1739 | 0.174 | 0.1727 | 0.1732 | 61316520.0 |
| 2003-05-22 14:00:00 | NVDA | Stock | 0.1732 | 0.1737 | 0.1722 | 0.173 | 47938200.0 |
| 2003-05-22 15:00:00 | NVDA | Stock | 0.173 | 0.1758 | 0.1726 | 0.1747 | 180775080.0 |
| 2003-05-22 16:00:00 | NVDA | Stock | 0.1747 | 0.1754 | 0.1742 | 0.1746 | 12984600.0 |
| 2003-05-22 17:00:00 | NVDA | Stock | 0.1748 | 0.1751 | 0.1748 | 0.175 | 744000.0 |
| 2003-05-22 18:00:00 | NVDA | Stock | 0.1748 | 0.1748 | 0.1745 | 0.1745 | 164400.0 |
| 2003-05-22 08:00:00 | AMZN | Stock | 1.5815 | 1.5875 | 1.575 | 1.5775 | 336000.0 |
| 2003-05-22 09:00:00 | AMZN | Stock | 1.578 | 1.6055 | 1.5645 | 1.6005 | 20485680.0 |
| 2003-05-22 10:00:00 | AMZN | Stock | 1.6005 | 1.625 | 1.5965 | 1.6175 | 30343900.0 |
| 2003-05-22 11:00:00 | AMZN | Stock | 1.618 | 1.6205 | 1.6095 | 1.614 | 11571840.0 |
| 2003-05-22 12:00:00 | AMZN | Stock | 1.614 | 1.632 | 1.613 | 1.6275 | 9526920.0 |
| 2003-05-22 13:00:00 | AMZN | Stock | 1.6275 | 1.6325 | 1.6245 | 1.6315 | 8291140.0 |
| 2003-05-22 14:00:00 | AMZN | Stock | 1.6315 | 1.6485 | 1.627 | 1.6425 | 15709600.0 |
| 2003-05-22 15:00:00 | AMZN | Stock | 1.6425 | 1.665 | 1.64 | 1.6505 | 43762480.0 |
| 2003-05-22 16:00:00 | AMZN | Stock | 1.65 | 1.655 | 1.649 | 1.65 | 1253000.0 |
| 2003-05-22 17:00:00 | AMZN | Stock | 1.651 | 1.652 | 1.65 | 1.65 | 391900.0 |
| 2003-05-22 18:00:00 | AMZN | Stock | 1.652 | 1.652 | 1.652 | 1.652 | 34000.0 |
| 2003-05-22 09:00:00 | CL | Stock | 29.3 | 29.375 | 29.25 | 29.295 | 235800.0 |
| 2003-05-22 10:00:00 | CL | Stock | 29.29 | 29.555 | 29.29 | 29.425 | 361400.0 |
| 2003-05-22 11:00:00 | CL | Stock | 29.4 | 29.48 | 29.285 | 29.445 | 283400.0 |
| 2003-05-22 12:00:00 | CL | Stock | 29.435 | 29.49 | 29.38 | 29.39 | 222000.0 |
| 2003-05-22 13:00:00 | CL | Stock | 29.385 | 29.45 | 29.33 | 29.43 | 196000.0 |
| 2003-05-22 14:00:00 | CL | Stock | 29.42 | 29.475 | 29.375 | 29.45 | 307400.0 |
| 2003-05-22 15:00:00 | CL | Stock | 29.45 | 29.51 | 29.415 | 29.44 | 541800.0 |
> showing 50 of 21,414 rows — these rows as CSV