PREVIEW / stock_1hour / 2003-12-10
file: by_date/stock_1hour/2003/2003-12-10.parquet size: 501 KB rows: 23,279 symbols: 1,687
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-12-10 08:00:00 | AAPL | Stock | 0.3657 | 0.3657 | 0.3657 | 0.3657 | 106400.0 |
| 2003-12-10 09:00:00 | AAPL | Stock | 0.3666 | 0.368 | 0.3645 | 0.3661 | 11703048.0 |
| 2003-12-10 10:00:00 | AAPL | Stock | 0.3661 | 0.367 | 0.3573 | 0.3577 | 37960440.0 |
| 2003-12-10 11:00:00 | AAPL | Stock | 0.3577 | 0.3629 | 0.3564 | 0.3625 | 34790392.0 |
| 2003-12-10 12:00:00 | AAPL | Stock | 0.3627 | 0.3636 | 0.3614 | 0.3629 | 14505288.0 |
| 2003-12-10 13:00:00 | AAPL | Stock | 0.363 | 0.3671 | 0.3613 | 0.3668 | 21331912.0 |
| 2003-12-10 14:00:00 | AAPL | Stock | 0.367 | 0.367 | 0.362 | 0.3627 | 51996000.0 |
| 2003-12-10 15:00:00 | AAPL | Stock | 0.3629 | 0.3668 | 0.362 | 0.3641 | 55646304.0 |
| 2003-12-10 16:00:00 | AAPL | Stock | 0.3641 | 0.3652 | 0.3636 | 0.3641 | 6391000.0 |
| 2003-12-10 17:00:00 | AAPL | Stock | 0.3643 | 0.3643 | 0.3639 | 0.3639 | 33096.0 |
| 2003-12-10 18:00:00 | AAPL | Stock | 0.3643 | 0.3643 | 0.3641 | 0.3643 | 84000.0 |
| 2003-12-10 08:00:00 | MSFT | Stock | 26.96 | 26.99 | 26.4 | 26.55 | 181545.0 |
| 2003-12-10 09:00:00 | MSFT | Stock | 26.55 | 26.6 | 26.42 | 26.53 | 12891324.0 |
| 2003-12-10 10:00:00 | MSFT | Stock | 26.52 | 26.57 | 26.41 | 26.44 | 14793198.0 |
| 2003-12-10 11:00:00 | MSFT | Stock | 26.44 | 26.58 | 26.38 | 26.56 | 13163741.0 |
| 2003-12-10 12:00:00 | MSFT | Stock | 26.56 | 26.58 | 26.49 | 26.55 | 7434716.0 |
| 2003-12-10 13:00:00 | MSFT | Stock | 26.55 | 26.56 | 26.42 | 26.54 | 8064769.0 |
| 2003-12-10 14:00:00 | MSFT | Stock | 26.53 | 26.554 | 26.43 | 26.46 | 8055995.0 |
| 2003-12-10 15:00:00 | MSFT | Stock | 26.46 | 26.6 | 26.43 | 26.6 | 13966948.0 |
| 2003-12-10 16:00:00 | MSFT | Stock | 26.6 | 26.67 | 26.5 | 26.63 | 1178517.0 |
| 2003-12-10 17:00:00 | MSFT | Stock | 26.63 | 26.65 | 26.59 | 26.65 | 12987.0 |
| 2003-12-10 18:00:00 | MSFT | Stock | 26.63 | 26.63 | 26.4146 | 26.63 | 8627.0 |
| 2003-12-10 08:00:00 | NVDA | Stock | 0.1631 | 0.1674 | 0.1626 | 0.1634 | 1170720.0 |
| 2003-12-10 09:00:00 | NVDA | Stock | 0.1636 | 0.1649 | 0.1625 | 0.1649 | 45515520.0 |
| 2003-12-10 10:00:00 | NVDA | Stock | 0.1649 | 0.1665 | 0.1634 | 0.1635 | 105905040.0 |
| 2003-12-10 11:00:00 | NVDA | Stock | 0.1635 | 0.1668 | 0.1632 | 0.1666 | 73185600.0 |
| 2003-12-10 12:00:00 | NVDA | Stock | 0.1667 | 0.1671 | 0.1656 | 0.166 | 48623760.0 |
| 2003-12-10 13:00:00 | NVDA | Stock | 0.1658 | 0.1667 | 0.1647 | 0.1665 | 50799480.0 |
| 2003-12-10 14:00:00 | NVDA | Stock | 0.1665 | 0.1668 | 0.1636 | 0.1646 | 95120880.0 |
| 2003-12-10 15:00:00 | NVDA | Stock | 0.1646 | 0.1667 | 0.1629 | 0.1658 | 106313760.0 |
| 2003-12-10 16:00:00 | NVDA | Stock | 0.1662 | 0.1665 | 0.1658 | 0.1658 | 28969920.0 |
| 2003-12-10 17:00:00 | NVDA | Stock | 0.1657 | 0.1657 | 0.1654 | 0.1654 | 120000.0 |
| 2003-12-10 08:00:00 | AMZN | Stock | 2.4655 | 2.4655 | 2.4625 | 2.4645 | 60000.0 |
| 2003-12-10 09:00:00 | AMZN | Stock | 2.467 | 2.4945 | 2.465 | 2.494 | 26898420.0 |
| 2003-12-10 10:00:00 | AMZN | Stock | 2.491 | 2.5085 | 2.485 | 2.4875 | 30728020.0 |
| 2003-12-10 11:00:00 | AMZN | Stock | 2.4875 | 2.5 | 2.4825 | 2.4995 | 16177660.0 |
| 2003-12-10 12:00:00 | AMZN | Stock | 2.4995 | 2.502 | 2.4355 | 2.4355 | 16686320.0 |
| 2003-12-10 13:00:00 | AMZN | Stock | 2.436 | 2.4655 | 2.4165 | 2.461 | 41698520.0 |
| 2003-12-10 14:00:00 | AMZN | Stock | 2.4615 | 2.462 | 2.4155 | 2.425 | 22606780.0 |
| 2003-12-10 15:00:00 | AMZN | Stock | 2.425 | 2.478 | 2.4235 | 2.46 | 25897100.0 |
| 2003-12-10 16:00:00 | AMZN | Stock | 2.4605 | 2.4725 | 2.428 | 2.4725 | 2232360.0 |
| 2003-12-10 17:00:00 | AMZN | Stock | 2.4659 | 2.4659 | 2.4605 | 2.465 | 84320.0 |
| 2003-12-10 18:00:00 | AMZN | Stock | 2.465 | 2.4675 | 2.464 | 2.464 | 34000.0 |
| 2003-12-10 09:00:00 | CL | Stock | 26.47 | 26.5 | 26.365 | 26.365 | 359200.0 |
| 2003-12-10 10:00:00 | CL | Stock | 26.37 | 26.405 | 26.3 | 26.3 | 856400.0 |
| 2003-12-10 11:00:00 | CL | Stock | 26.305 | 26.375 | 26.265 | 26.36 | 851400.0 |
| 2003-12-10 12:00:00 | CL | Stock | 26.355 | 26.425 | 26.32 | 26.39 | 288200.0 |
| 2003-12-10 13:00:00 | CL | Stock | 26.39 | 26.4 | 26.335 | 26.395 | 502800.0 |
| 2003-12-10 14:00:00 | CL | Stock | 26.39 | 26.395 | 26.255 | 26.265 | 869600.0 |
| 2003-12-10 15:00:00 | CL | Stock | 26.265 | 26.35 | 26.175 | 26.305 | 802200.0 |
> showing 50 of 23,279 rows — these rows as CSV