PREVIEW / stock_1hour / 2003-11-19
file: by_date/stock_1hour/2003/2003-11-19.parquet size: 476 KB rows: 22,435 symbols: 1,671
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-19 09:00:00 | AAPL | Stock | 0.3643 | 0.3675 | 0.3618 | 0.3625 | 18733568.0 |
| 2003-11-19 10:00:00 | AAPL | Stock | 0.3625 | 0.3668 | 0.3621 | 0.3663 | 49710360.0 |
| 2003-11-19 11:00:00 | AAPL | Stock | 0.3661 | 0.3688 | 0.3655 | 0.3659 | 43425088.0 |
| 2003-11-19 12:00:00 | AAPL | Stock | 0.3659 | 0.3668 | 0.3636 | 0.3643 | 51777040.0 |
| 2003-11-19 13:00:00 | AAPL | Stock | 0.3641 | 0.3679 | 0.3641 | 0.3643 | 27336232.0 |
| 2003-11-19 14:00:00 | AAPL | Stock | 0.3641 | 0.3666 | 0.3639 | 0.365 | 25253816.0 |
| 2003-11-19 15:00:00 | AAPL | Stock | 0.365 | 0.3657 | 0.362 | 0.3632 | 83822536.0 |
| 2003-11-19 16:00:00 | AAPL | Stock | 0.365 | 0.3654 | 0.3609 | 0.3652 | 4112808.0 |
| 2003-11-19 17:00:00 | AAPL | Stock | 0.3657 | 0.3657 | 0.3657 | 0.3657 | 44800.0 |
| 2003-11-19 08:00:00 | MSFT | Stock | 25.18 | 25.33 | 25.18 | 25.32 | 43220.0 |
| 2003-11-19 09:00:00 | MSFT | Stock | 25.32 | 25.37 | 25.17 | 25.36 | 8996487.0 |
| 2003-11-19 10:00:00 | MSFT | Stock | 25.36 | 25.54 | 25.33 | 25.35 | 15912004.0 |
| 2003-11-19 11:00:00 | MSFT | Stock | 25.34 | 25.38 | 25.26 | 25.32 | 7955861.0 |
| 2003-11-19 12:00:00 | MSFT | Stock | 25.31 | 25.36 | 25.3 | 25.33 | 4421523.0 |
| 2003-11-19 13:00:00 | MSFT | Stock | 25.35 | 25.38 | 25.25 | 25.3 | 5368238.0 |
| 2003-11-19 14:00:00 | MSFT | Stock | 25.29 | 25.49 | 25.29 | 25.38 | 11295069.0 |
| 2003-11-19 15:00:00 | MSFT | Stock | 25.38 | 25.41 | 25.23 | 25.35 | 14750062.0 |
| 2003-11-19 16:00:00 | MSFT | Stock | 25.35 | 25.39 | 25.29 | 25.35 | 570254.0 |
| 2003-11-19 17:00:00 | MSFT | Stock | 25.35 | 25.4 | 25.279 | 25.36 | 31422.0 |
| 2003-11-19 18:00:00 | MSFT | Stock | 25.39 | 25.4 | 25.39 | 25.4 | 2900.0 |
| 2003-11-19 08:00:00 | NVDA | Stock | 0.1648 | 0.1658 | 0.1648 | 0.1653 | 312000.0 |
| 2003-11-19 09:00:00 | NVDA | Stock | 0.1651 | 0.1667 | 0.1644 | 0.1661 | 109722720.0 |
| 2003-11-19 10:00:00 | NVDA | Stock | 0.1662 | 0.1674 | 0.1657 | 0.1666 | 137178480.0 |
| 2003-11-19 11:00:00 | NVDA | Stock | 0.1665 | 0.1667 | 0.1661 | 0.1664 | 36193320.0 |
| 2003-11-19 12:00:00 | NVDA | Stock | 0.1663 | 0.1667 | 0.166 | 0.1666 | 24965640.0 |
| 2003-11-19 13:00:00 | NVDA | Stock | 0.1667 | 0.1667 | 0.1662 | 0.1666 | 33142800.0 |
| 2003-11-19 14:00:00 | NVDA | Stock | 0.1667 | 0.1692 | 0.1666 | 0.1683 | 57849720.0 |
| 2003-11-19 15:00:00 | NVDA | Stock | 0.1683 | 0.1692 | 0.1678 | 0.1689 | 108100440.0 |
| 2003-11-19 16:00:00 | NVDA | Stock | 0.1688 | 0.1737 | 0.1682 | 0.1686 | 2727240.0 |
| 2003-11-19 17:00:00 | NVDA | Stock | 0.1687 | 0.1687 | 0.1687 | 0.1687 | 48000.0 |
| 2003-11-19 18:00:00 | NVDA | Stock | 0.1684 | 0.1684 | 0.1684 | 0.1684 | 12000.0 |
| 2003-11-19 08:00:00 | AMZN | Stock | 2.4125 | 2.4405 | 2.41 | 2.44 | 490000.0 |
| 2003-11-19 09:00:00 | AMZN | Stock | 2.44 | 2.443 | 2.3835 | 2.4005 | 40832500.0 |
| 2003-11-19 10:00:00 | AMZN | Stock | 2.3995 | 2.475 | 2.3955 | 2.457 | 81673920.0 |
| 2003-11-19 11:00:00 | AMZN | Stock | 2.458 | 2.4895 | 2.443 | 2.458 | 29139660.0 |
| 2003-11-19 12:00:00 | AMZN | Stock | 2.458 | 2.4765 | 2.4565 | 2.4715 | 19411300.0 |
| 2003-11-19 13:00:00 | AMZN | Stock | 2.4714 | 2.4775 | 2.4505 | 2.4575 | 22346820.0 |
| 2003-11-19 14:00:00 | AMZN | Stock | 2.4585 | 2.4815 | 2.455 | 2.471 | 22080900.0 |
| 2003-11-19 15:00:00 | AMZN | Stock | 2.47 | 2.4925 | 2.468 | 2.475 | 31592460.0 |
| 2003-11-19 16:00:00 | AMZN | Stock | 2.4805 | 2.4805 | 2.4725 | 2.4761 | 3237260.0 |
| 2003-11-19 17:00:00 | AMZN | Stock | 2.476 | 2.4815 | 2.463 | 2.4815 | 458040.0 |
| 2003-11-19 09:00:00 | CL | Stock | 25.675 | 25.78 | 25.65 | 25.77 | 298400.0 |
| 2003-11-19 10:00:00 | CL | Stock | 25.775 | 25.975 | 25.725 | 25.755 | 3940800.0 |
| 2003-11-19 11:00:00 | CL | Stock | 25.75 | 25.815 | 25.705 | 25.79 | 804400.0 |
| 2003-11-19 12:00:00 | CL | Stock | 25.79 | 25.9 | 25.76 | 25.855 | 295600.0 |
| 2003-11-19 13:00:00 | CL | Stock | 25.875 | 25.975 | 25.82 | 25.965 | 283600.0 |
| 2003-11-19 14:00:00 | CL | Stock | 25.965 | 26.024 | 25.875 | 25.93 | 326600.0 |
| 2003-11-19 15:00:00 | CL | Stock | 25.945 | 25.97 | 25.835 | 25.85 | 455000.0 |
| 2003-11-19 16:00:00 | CL | Stock | 25.85 | 25.85 | 25.85 | 25.85 | 81800.0 |
| 2003-11-19 17:00:00 | CL | Stock | 25.675 | 25.87 | 25.675 | 25.87 | 95600.0 |
> showing 50 of 22,435 rows — these rows as CSV