PREVIEW / stock_1hour / 2003-11-25
file: by_date/stock_1hour/2003/2003-11-25.parquet size: 507 KB rows: 23,657 symbols: 1,686
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-11-25 08:00:00 | AAPL | Stock | 0.3786 | 0.3786 | 0.3786 | 0.3786 | 28000.0 |
| 2003-11-25 09:00:00 | AAPL | Stock | 0.378 | 0.3793 | 0.3732 | 0.3763 | 18573800.0 |
| 2003-11-25 10:00:00 | AAPL | Stock | 0.3763 | 0.3789 | 0.3741 | 0.375 | 39039560.0 |
| 2003-11-25 11:00:00 | AAPL | Stock | 0.375 | 0.3757 | 0.3743 | 0.3754 | 17742536.0 |
| 2003-11-25 12:00:00 | AAPL | Stock | 0.375 | 0.3766 | 0.3746 | 0.3748 | 21365456.0 |
| 2003-11-25 13:00:00 | AAPL | Stock | 0.3748 | 0.3748 | 0.3723 | 0.373 | 16468368.0 |
| 2003-11-25 14:00:00 | AAPL | Stock | 0.3732 | 0.3743 | 0.3725 | 0.3741 | 27134016.0 |
| 2003-11-25 15:00:00 | AAPL | Stock | 0.3741 | 0.3766 | 0.3681 | 0.3696 | 74381944.0 |
| 2003-11-25 16:00:00 | AAPL | Stock | 0.3702 | 0.3705 | 0.3688 | 0.3696 | 8301160.0 |
| 2003-11-25 17:00:00 | AAPL | Stock | 0.3696 | 0.3742 | 0.3696 | 0.372 | 2833600.0 |
| 2003-11-25 08:00:00 | MSFT | Stock | 25.77 | 25.94 | 25.77 | 25.82 | 81085.0 |
| 2003-11-25 09:00:00 | MSFT | Stock | 25.82 | 25.91 | 25.73 | 25.87 | 12447788.0 |
| 2003-11-25 10:00:00 | MSFT | Stock | 25.87 | 25.95 | 25.68 | 25.75 | 14069611.0 |
| 2003-11-25 11:00:00 | MSFT | Stock | 25.76 | 25.78 | 25.53 | 25.55 | 10373731.0 |
| 2003-11-25 12:00:00 | MSFT | Stock | 25.55 | 25.61 | 25.53 | 25.56 | 5481677.0 |
| 2003-11-25 13:00:00 | MSFT | Stock | 25.56 | 25.56 | 25.43 | 25.471 | 7295973.0 |
| 2003-11-25 14:00:00 | MSFT | Stock | 25.48 | 25.61 | 25.45 | 25.61 | 12092637.0 |
| 2003-11-25 15:00:00 | MSFT | Stock | 25.6 | 25.66 | 25.4 | 25.4 | 14708499.0 |
| 2003-11-25 16:00:00 | MSFT | Stock | 25.42 | 25.47 | 25.38 | 25.45 | 1590796.0 |
| 2003-11-25 17:00:00 | MSFT | Stock | 25.45 | 25.5966 | 25.41 | 25.45 | 337641.0 |
| 2003-11-25 18:00:00 | MSFT | Stock | 25.47 | 25.48 | 25.46 | 25.48 | 2050.0 |
| 2003-11-25 08:00:00 | NVDA | Stock | 0.175 | 0.1754 | 0.175 | 0.1754 | 426000.0 |
| 2003-11-25 09:00:00 | NVDA | Stock | 0.1758 | 0.1778 | 0.1733 | 0.1778 | 129566520.0 |
| 2003-11-25 10:00:00 | NVDA | Stock | 0.1777 | 0.1785 | 0.1754 | 0.1767 | 128218440.0 |
| 2003-11-25 11:00:00 | NVDA | Stock | 0.1767 | 0.177 | 0.1757 | 0.1762 | 74351880.0 |
| 2003-11-25 12:00:00 | NVDA | Stock | 0.1762 | 0.1779 | 0.1759 | 0.1776 | 105552720.0 |
| 2003-11-25 13:00:00 | NVDA | Stock | 0.1776 | 0.1785 | 0.1769 | 0.1772 | 59579640.0 |
| 2003-11-25 14:00:00 | NVDA | Stock | 0.1772 | 0.1788 | 0.1772 | 0.1787 | 59216040.0 |
| 2003-11-25 15:00:00 | NVDA | Stock | 0.1787 | 0.1791 | 0.1762 | 0.1769 | 125962320.0 |
| 2003-11-25 16:00:00 | NVDA | Stock | 0.1772 | 0.1777 | 0.1767 | 0.1767 | 5116200.0 |
| 2003-11-25 17:00:00 | NVDA | Stock | 0.1767 | 0.1769 | 0.1766 | 0.1767 | 1696200.0 |
| 2003-11-25 18:00:00 | NVDA | Stock | 0.1767 | 0.1767 | 0.1767 | 0.1767 | 120000.0 |
| 2003-11-25 08:00:00 | AMZN | Stock | 2.572 | 2.5875 | 2.568 | 2.5725 | 322000.0 |
| 2003-11-25 09:00:00 | AMZN | Stock | 2.5715 | 2.635 | 2.5635 | 2.624 | 43198300.0 |
| 2003-11-25 10:00:00 | AMZN | Stock | 2.6245 | 2.6445 | 2.62 | 2.643 | 56878120.0 |
| 2003-11-25 11:00:00 | AMZN | Stock | 2.644 | 2.665 | 2.639 | 2.6475 | 40841720.0 |
| 2003-11-25 12:00:00 | AMZN | Stock | 2.6475 | 2.6555 | 2.6425 | 2.6505 | 16530000.0 |
| 2003-11-25 13:00:00 | AMZN | Stock | 2.651 | 2.653 | 2.6355 | 2.6425 | 15221060.0 |
| 2003-11-25 14:00:00 | AMZN | Stock | 2.6415 | 2.649 | 2.626 | 2.6485 | 17537120.0 |
| 2003-11-25 15:00:00 | AMZN | Stock | 2.6485 | 2.655 | 2.6165 | 2.625 | 36264180.0 |
| 2003-11-25 16:00:00 | AMZN | Stock | 2.625 | 2.6275 | 2.61 | 2.6175 | 5979980.0 |
| 2003-11-25 17:00:00 | AMZN | Stock | 2.6165 | 2.6342 | 2.6155 | 2.6225 | 1451760.0 |
| 2003-11-25 18:00:00 | AMZN | Stock | 2.6215 | 2.624 | 2.6215 | 2.624 | 69580.0 |
| 2003-11-25 09:00:00 | CL | Stock | 26.225 | 26.3 | 26.15 | 26.265 | 236600.0 |
| 2003-11-25 10:00:00 | CL | Stock | 26.265 | 26.47 | 26.255 | 26.41 | 511200.0 |
| 2003-11-25 11:00:00 | CL | Stock | 26.405 | 26.42 | 26.26 | 26.33 | 866800.0 |
| 2003-11-25 12:00:00 | CL | Stock | 26.305 | 26.35 | 26.265 | 26.3 | 555000.0 |
| 2003-11-25 13:00:00 | CL | Stock | 26.29 | 26.305 | 26.23 | 26.24 | 327000.0 |
| 2003-11-25 14:00:00 | CL | Stock | 26.24 | 26.29 | 26.21 | 26.24 | 641400.0 |
| 2003-11-25 15:00:00 | CL | Stock | 26.24 | 26.275 | 26.16 | 26.2 | 1227800.0 |
> showing 50 of 23,657 rows — these rows as CSV