PREVIEW / stock_1hour / 2003-05-12
file: by_date/stock_1hour/2003/2003-05-12.parquet size: 423 KB rows: 20,409 symbols: 1,580
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-12 08:00:00 | AAPL | Stock | 0.3232 | 0.3241 | 0.3232 | 0.3241 | 112000.0 |
| 2003-05-12 09:00:00 | AAPL | Stock | 0.3236 | 0.3302 | 0.3234 | 0.3277 | 69436864.0 |
| 2003-05-12 10:00:00 | AAPL | Stock | 0.3273 | 0.333 | 0.3264 | 0.3327 | 95006296.0 |
| 2003-05-12 11:00:00 | AAPL | Stock | 0.3329 | 0.333 | 0.33 | 0.3313 | 49762160.0 |
| 2003-05-12 12:00:00 | AAPL | Stock | 0.3313 | 0.3321 | 0.3296 | 0.3305 | 29741376.0 |
| 2003-05-12 13:00:00 | AAPL | Stock | 0.3307 | 0.3341 | 0.3305 | 0.333 | 64047872.0 |
| 2003-05-12 14:00:00 | AAPL | Stock | 0.333 | 0.3346 | 0.3316 | 0.3339 | 36121848.0 |
| 2003-05-12 15:00:00 | AAPL | Stock | 0.3339 | 0.3343 | 0.3314 | 0.3314 | 32664800.0 |
| 2003-05-12 16:00:00 | AAPL | Stock | 0.3316 | 0.3329 | 0.3311 | 0.332 | 1663200.0 |
| 2003-05-12 17:00:00 | AAPL | Stock | 0.332 | 0.332 | 0.3313 | 0.3313 | 72800.0 |
| 2003-05-12 18:00:00 | AAPL | Stock | 0.3313 | 0.3313 | 0.3313 | 0.3313 | 5600.0 |
| 2003-05-12 08:00:00 | MSFT | Stock | 26.3 | 26.37 | 26.21 | 26.25 | 146900.0 |
| 2003-05-12 09:00:00 | MSFT | Stock | 26.26 | 26.38 | 25.31 | 26.13 | 7445908.0 |
| 2003-05-12 10:00:00 | MSFT | Stock | 26.13 | 26.36 | 26.1 | 26.31 | 8111710.0 |
| 2003-05-12 11:00:00 | MSFT | Stock | 26.31 | 26.45 | 26.2 | 26.39 | 6591295.0 |
| 2003-05-12 12:00:00 | MSFT | Stock | 26.4 | 26.43 | 26.3 | 26.32 | 4455930.0 |
| 2003-05-12 13:00:00 | MSFT | Stock | 26.33 | 26.36 | 26.06 | 26.17 | 9218821.0 |
| 2003-05-12 14:00:00 | MSFT | Stock | 26.16 | 26.255 | 26.11 | 26.24 | 5284222.0 |
| 2003-05-12 15:00:00 | MSFT | Stock | 26.24 | 26.25 | 26.13 | 26.2 | 7193346.0 |
| 2003-05-12 16:00:00 | MSFT | Stock | 26.2 | 26.23 | 26.15 | 26.18 | 459526.0 |
| 2003-05-12 17:00:00 | MSFT | Stock | 26.15 | 26.2 | 26.15 | 26.18 | 9250.0 |
| 2003-05-12 18:00:00 | MSFT | Stock | 26.2 | 26.2 | 26.16 | 26.16 | 7586.0 |
| 2003-05-12 08:00:00 | NVDA | Stock | 0.1782 | 0.1867 | 0.1758 | 0.1822 | 78305400.0 |
| 2003-05-12 09:00:00 | NVDA | Stock | 0.1815 | 0.1833 | 0.1739 | 0.1761 | 791294040.0 |
| 2003-05-12 10:00:00 | NVDA | Stock | 0.1761 | 0.179 | 0.1754 | 0.1767 | 517382880.0 |
| 2003-05-12 11:00:00 | NVDA | Stock | 0.1767 | 0.1771 | 0.175 | 0.1757 | 302075400.0 |
| 2003-05-12 12:00:00 | NVDA | Stock | 0.1757 | 0.1759 | 0.1721 | 0.1742 | 371172600.0 |
| 2003-05-12 13:00:00 | NVDA | Stock | 0.1742 | 0.1748 | 0.1717 | 0.1728 | 180117240.0 |
| 2003-05-12 14:00:00 | NVDA | Stock | 0.173 | 0.175 | 0.1722 | 0.174 | 219906120.0 |
| 2003-05-12 15:00:00 | NVDA | Stock | 0.174 | 0.1758 | 0.1729 | 0.1732 | 308888280.0 |
| 2003-05-12 16:00:00 | NVDA | Stock | 0.1733 | 0.1737 | 0.173 | 0.1735 | 18131280.0 |
| 2003-05-12 17:00:00 | NVDA | Stock | 0.1735 | 0.174 | 0.1732 | 0.1736 | 3007080.0 |
| 2003-05-12 18:00:00 | NVDA | Stock | 0.1737 | 0.1737 | 0.1734 | 0.1734 | 684000.0 |
| 2003-05-12 08:00:00 | AMZN | Stock | 1.5495 | 1.5525 | 1.5445 | 1.5445 | 179400.0 |
| 2003-05-12 09:00:00 | AMZN | Stock | 1.5445 | 1.55 | 1.5335 | 1.5455 | 14693080.0 |
| 2003-05-12 10:00:00 | AMZN | Stock | 1.5455 | 1.579 | 1.5435 | 1.576 | 37317500.0 |
| 2003-05-12 11:00:00 | AMZN | Stock | 1.5755 | 1.5845 | 1.57 | 1.5844 | 21544420.0 |
| 2003-05-12 12:00:00 | AMZN | Stock | 1.5845 | 1.589 | 1.5755 | 1.5765 | 17041580.0 |
| 2003-05-12 13:00:00 | AMZN | Stock | 1.5775 | 1.583 | 1.5725 | 1.5775 | 9052640.0 |
| 2003-05-12 14:00:00 | AMZN | Stock | 1.5775 | 1.5875 | 1.573 | 1.585 | 13808100.0 |
| 2003-05-12 15:00:00 | AMZN | Stock | 1.5855 | 1.59 | 1.579 | 1.5835 | 19252180.0 |
| 2003-05-12 16:00:00 | AMZN | Stock | 1.584 | 1.587 | 1.582 | 1.583 | 509320.0 |
| 2003-05-12 17:00:00 | AMZN | Stock | 1.5845 | 1.587 | 1.5845 | 1.585 | 219000.0 |
| 2003-05-12 18:00:00 | AMZN | Stock | 1.585 | 1.5875 | 1.584 | 1.584 | 58000.0 |
| 2003-05-12 09:00:00 | CL | Stock | 28.665 | 28.71 | 28.535 | 28.665 | 309200.0 |
| 2003-05-12 10:00:00 | CL | Stock | 28.71 | 28.745 | 28.625 | 28.67 | 496600.0 |
| 2003-05-12 11:00:00 | CL | Stock | 28.675 | 28.825 | 28.66 | 28.825 | 357800.0 |
| 2003-05-12 12:00:00 | CL | Stock | 28.83 | 28.945 | 28.79 | 28.945 | 422600.0 |
| 2003-05-12 13:00:00 | CL | Stock | 28.945 | 28.965 | 28.905 | 28.925 | 346800.0 |
| 2003-05-12 14:00:00 | CL | Stock | 28.925 | 29.08 | 28.92 | 29.055 | 571400.0 |
> showing 50 of 20,409 rows — these rows as CSV