PREVIEW / stock_1hour / 2003-11-21
file: by_date/stock_1hour/2003/2003-11-21.parquet size: 485 KB rows: 22,467 symbols: 1,661
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-21 08:00:00 | AAPL | Stock | 0.3639 | 0.3793 | 0.3636 | 0.3696 | 572936.0 |
| 2003-11-21 09:00:00 | AAPL | Stock | 0.3618 | 0.3679 | 0.36 | 0.3616 | 26650344.0 |
| 2003-11-21 10:00:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3545 | 0.3571 | 42157192.0 |
| 2003-11-21 11:00:00 | AAPL | Stock | 0.3573 | 0.3623 | 0.3571 | 0.36 | 46381832.0 |
| 2003-11-21 12:00:00 | AAPL | Stock | 0.3598 | 0.3611 | 0.3588 | 0.3611 | 19390392.0 |
| 2003-11-21 13:00:00 | AAPL | Stock | 0.3611 | 0.3666 | 0.3604 | 0.3627 | 36659672.0 |
| 2003-11-21 14:00:00 | AAPL | Stock | 0.3629 | 0.363 | 0.3593 | 0.3598 | 22606808.0 |
| 2003-11-21 15:00:00 | AAPL | Stock | 0.3598 | 0.3652 | 0.3586 | 0.3618 | 36125040.0 |
| 2003-11-21 16:00:00 | AAPL | Stock | 0.3618 | 0.3629 | 0.3616 | 0.3621 | 3152800.0 |
| 2003-11-21 17:00:00 | AAPL | Stock | 0.3625 | 0.3625 | 0.3622 | 0.3622 | 817040.0 |
| 2003-11-21 08:00:00 | MSFT | Stock | 25.23 | 25.37 | 25.21 | 25.27 | 146400.0 |
| 2003-11-21 09:00:00 | MSFT | Stock | 25.27 | 25.37 | 25.09 | 25.258 | 10010801.0 |
| 2003-11-21 10:00:00 | MSFT | Stock | 25.25 | 25.34 | 25.12 | 25.18 | 13970048.0 |
| 2003-11-21 11:00:00 | MSFT | Stock | 25.18 | 25.3 | 25.17 | 25.24 | 10078292.0 |
| 2003-11-21 12:00:00 | MSFT | Stock | 25.24 | 25.251 | 25.15 | 25.19 | 4955881.0 |
| 2003-11-21 13:00:00 | MSFT | Stock | 25.2 | 25.23 | 25.13 | 25.17 | 6070430.0 |
| 2003-11-21 14:00:00 | MSFT | Stock | 25.17 | 25.18 | 25.11 | 25.13 | 6872996.0 |
| 2003-11-21 15:00:00 | MSFT | Stock | 25.14 | 25.19 | 25.08 | 25.11 | 14742672.0 |
| 2003-11-21 16:00:00 | MSFT | Stock | 25.11 | 25.2 | 25.09 | 25.15 | 811322.0 |
| 2003-11-21 17:00:00 | MSFT | Stock | 25.15 | 25.15 | 25.1 | 25.13 | 109025.0 |
| 2003-11-21 18:00:00 | MSFT | Stock | 25.13 | 25.13 | 25.13 | 25.13 | 1900.0 |
| 2003-11-21 08:00:00 | NVDA | Stock | 0.164 | 0.1657 | 0.164 | 0.1653 | 4476240.0 |
| 2003-11-21 09:00:00 | NVDA | Stock | 0.1655 | 0.1664 | 0.1621 | 0.1631 | 110175240.0 |
| 2003-11-21 10:00:00 | NVDA | Stock | 0.1631 | 0.1646 | 0.1615 | 0.1623 | 124820760.0 |
| 2003-11-21 11:00:00 | NVDA | Stock | 0.1623 | 0.165 | 0.1623 | 0.1643 | 57275400.0 |
| 2003-11-21 12:00:00 | NVDA | Stock | 0.1644 | 0.1644 | 0.1634 | 0.1642 | 23446200.0 |
| 2003-11-21 13:00:00 | NVDA | Stock | 0.1642 | 0.1659 | 0.1634 | 0.1636 | 38029920.0 |
| 2003-11-21 14:00:00 | NVDA | Stock | 0.1636 | 0.1643 | 0.1627 | 0.1627 | 39470640.0 |
| 2003-11-21 15:00:00 | NVDA | Stock | 0.1627 | 0.1649 | 0.1627 | 0.1642 | 115811040.0 |
| 2003-11-21 16:00:00 | NVDA | Stock | 0.1644 | 0.1647 | 0.1636 | 0.1637 | 6758280.0 |
| 2003-11-21 17:00:00 | NVDA | Stock | 0.1647 | 0.1647 | 0.1638 | 0.164 | 727680.0 |
| 2003-11-21 08:00:00 | AMZN | Stock | 2.455 | 2.455 | 2.45 | 2.45 | 122320.0 |
| 2003-11-21 09:00:00 | AMZN | Stock | 2.4525 | 2.46 | 2.423 | 2.43 | 27059300.0 |
| 2003-11-21 10:00:00 | AMZN | Stock | 2.4285 | 2.4385 | 2.388 | 2.4065 | 49675020.0 |
| 2003-11-21 11:00:00 | AMZN | Stock | 2.407 | 2.4265 | 2.4055 | 2.411 | 24350440.0 |
| 2003-11-21 12:00:00 | AMZN | Stock | 2.4105 | 2.42 | 2.4075 | 2.42 | 10247140.0 |
| 2003-11-21 13:00:00 | AMZN | Stock | 2.42 | 2.4415 | 2.4195 | 2.428 | 16008640.0 |
| 2003-11-21 14:00:00 | AMZN | Stock | 2.428 | 2.428 | 2.397 | 2.4015 | 16658140.0 |
| 2003-11-21 15:00:00 | AMZN | Stock | 2.401 | 2.429 | 2.4001 | 2.4285 | 33868080.0 |
| 2003-11-21 16:00:00 | AMZN | Stock | 2.4275 | 2.433 | 2.425 | 2.429 | 1018320.0 |
| 2003-11-21 17:00:00 | AMZN | Stock | 2.4275 | 2.429 | 2.424 | 2.426 | 281700.0 |
| 2003-11-21 09:00:00 | CL | Stock | 25.975 | 25.98 | 25.81 | 25.865 | 363200.0 |
| 2003-11-21 10:00:00 | CL | Stock | 25.865 | 25.91 | 25.765 | 25.835 | 422600.0 |
| 2003-11-21 11:00:00 | CL | Stock | 25.83 | 26.0 | 25.83 | 25.955 | 227600.0 |
| 2003-11-21 12:00:00 | CL | Stock | 25.95 | 25.975 | 25.815 | 25.835 | 349600.0 |
| 2003-11-21 13:00:00 | CL | Stock | 25.835 | 25.935 | 25.81 | 25.89 | 763400.0 |
| 2003-11-21 14:00:00 | CL | Stock | 25.895 | 25.94 | 25.89 | 25.9 | 229800.0 |
| 2003-11-21 15:00:00 | CL | Stock | 25.905 | 25.975 | 25.845 | 25.925 | 544800.0 |
| 2003-11-21 16:00:00 | CL | Stock | 25.925 | 25.935 | 25.925 | 25.935 | 139000.0 |
| 2003-11-21 18:00:00 | CL | Stock | 25.935 | 25.935 | 25.935 | 25.935 | 200.0 |
> showing 50 of 22,467 rows — these rows as CSV