PREVIEW / stock_1hour / 2003-12-23
file: by_date/stock_1hour/2003/2003-12-23.parquet size: 504 KB rows: 23,185 symbols: 1,704
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-23 08:00:00 | AAPL | Stock | 0.3538 | 0.3543 | 0.352 | 0.3543 | 1437520.0 |
| 2003-12-23 09:00:00 | AAPL | Stock | 0.3538 | 0.3563 | 0.353 | 0.3539 | 26467616.0 |
| 2003-12-23 10:00:00 | AAPL | Stock | 0.3541 | 0.3548 | 0.35 | 0.3519 | 56056392.0 |
| 2003-12-23 11:00:00 | AAPL | Stock | 0.352 | 0.3529 | 0.3516 | 0.3521 | 42282016.0 |
| 2003-12-23 12:00:00 | AAPL | Stock | 0.3521 | 0.3546 | 0.3518 | 0.3539 | 48842752.0 |
| 2003-12-23 13:00:00 | AAPL | Stock | 0.3539 | 0.3541 | 0.3518 | 0.3538 | 22247624.0 |
| 2003-12-23 14:00:00 | AAPL | Stock | 0.3538 | 0.3559 | 0.3529 | 0.3541 | 33704776.0 |
| 2003-12-23 15:00:00 | AAPL | Stock | 0.3546 | 0.3554 | 0.3518 | 0.355 | 62881168.0 |
| 2003-12-23 16:00:00 | AAPL | Stock | 0.3532 | 0.3561 | 0.3514 | 0.3526 | 5830720.0 |
| 2003-12-23 17:00:00 | AAPL | Stock | 0.3538 | 0.3538 | 0.3521 | 0.3527 | 431200.0 |
| 2003-12-23 18:00:00 | AAPL | Stock | 0.3538 | 0.3538 | 0.3538 | 0.3538 | 12768.0 |
| 2003-12-23 08:00:00 | MSFT | Stock | 27.2 | 27.21 | 27.11 | 27.21 | 128200.0 |
| 2003-12-23 09:00:00 | MSFT | Stock | 27.21 | 27.25 | 27.1 | 27.14 | 4416963.0 |
| 2003-12-23 10:00:00 | MSFT | Stock | 27.15 | 27.311 | 27.14 | 27.23 | 5811124.0 |
| 2003-12-23 11:00:00 | MSFT | Stock | 27.23 | 27.28 | 27.15 | 27.18 | 4727469.0 |
| 2003-12-23 12:00:00 | MSFT | Stock | 27.18 | 27.23 | 27.06 | 27.17 | 4813702.0 |
| 2003-12-23 13:00:00 | MSFT | Stock | 27.17 | 27.2 | 27.13 | 27.16 | 4132837.0 |
| 2003-12-23 14:00:00 | MSFT | Stock | 27.16 | 27.2 | 27.01 | 27.07 | 5745307.0 |
| 2003-12-23 15:00:00 | MSFT | Stock | 27.06 | 27.17 | 27.03 | 27.17 | 6483026.0 |
| 2003-12-23 16:00:00 | MSFT | Stock | 27.13 | 27.18 | 27.06 | 27.15 | 616858.0 |
| 2003-12-23 17:00:00 | MSFT | Stock | 27.16 | 27.3 | 27.11 | 27.12 | 1268768.0 |
| 2003-12-23 18:00:00 | MSFT | Stock | 27.15 | 27.17 | 27.15 | 27.17 | 3453.0 |
| 2003-12-23 08:00:00 | NVDA | Stock | 0.1758 | 0.1758 | 0.1753 | 0.1758 | 328800.0 |
| 2003-12-23 09:00:00 | NVDA | Stock | 0.1759 | 0.1792 | 0.175 | 0.1782 | 101462880.0 |
| 2003-12-23 10:00:00 | NVDA | Stock | 0.1783 | 0.1817 | 0.1783 | 0.181 | 138590640.0 |
| 2003-12-23 11:00:00 | NVDA | Stock | 0.181 | 0.1847 | 0.1804 | 0.183 | 114938880.0 |
| 2003-12-23 12:00:00 | NVDA | Stock | 0.1828 | 0.1833 | 0.181 | 0.1824 | 59960400.0 |
| 2003-12-23 13:00:00 | NVDA | Stock | 0.1824 | 0.1833 | 0.1822 | 0.1828 | 43509600.0 |
| 2003-12-23 14:00:00 | NVDA | Stock | 0.1828 | 0.1835 | 0.182 | 0.1823 | 83691000.0 |
| 2003-12-23 15:00:00 | NVDA | Stock | 0.1823 | 0.1834 | 0.1822 | 0.1832 | 113732040.0 |
| 2003-12-23 16:00:00 | NVDA | Stock | 0.1832 | 0.1833 | 0.1825 | 0.1826 | 6065640.0 |
| 2003-12-23 17:00:00 | NVDA | Stock | 0.1832 | 0.1832 | 0.1829 | 0.1832 | 996000.0 |
| 2003-12-23 18:00:00 | NVDA | Stock | 0.183 | 0.1832 | 0.183 | 0.1831 | 168000.0 |
| 2003-12-23 08:00:00 | AMZN | Stock | 2.496 | 2.505 | 2.496 | 2.496 | 128000.0 |
| 2003-12-23 09:00:00 | AMZN | Stock | 2.496 | 2.525 | 2.4885 | 2.5225 | 20973220.0 |
| 2003-12-23 10:00:00 | AMZN | Stock | 2.523 | 2.5975 | 2.5225 | 2.582 | 64121580.0 |
| 2003-12-23 11:00:00 | AMZN | Stock | 2.582 | 2.6295 | 2.5805 | 2.6155 | 36872340.0 |
| 2003-12-23 12:00:00 | AMZN | Stock | 2.6161 | 2.631 | 2.6135 | 2.623 | 24119440.0 |
| 2003-12-23 13:00:00 | AMZN | Stock | 2.6225 | 2.6262 | 2.6075 | 2.6205 | 15262100.0 |
| 2003-12-23 14:00:00 | AMZN | Stock | 2.6205 | 2.6295 | 2.5865 | 2.596 | 25185560.0 |
| 2003-12-23 15:00:00 | AMZN | Stock | 2.596 | 2.6255 | 2.5935 | 2.616 | 29771780.0 |
| 2003-12-23 16:00:00 | AMZN | Stock | 2.616 | 2.6245 | 2.592 | 2.614 | 936240.0 |
| 2003-12-23 17:00:00 | AMZN | Stock | 2.6155 | 2.624 | 2.61 | 2.624 | 350280.0 |
| 2003-12-23 09:00:00 | CL | Stock | 24.65 | 24.6728 | 24.52 | 24.53 | 567600.0 |
| 2003-12-23 10:00:00 | CL | Stock | 24.525 | 24.64 | 24.51 | 24.58 | 982000.0 |
| 2003-12-23 11:00:00 | CL | Stock | 24.58 | 24.645 | 24.56 | 24.615 | 1032000.0 |
| 2003-12-23 12:00:00 | CL | Stock | 24.6 | 24.64 | 24.58 | 24.595 | 853000.0 |
| 2003-12-23 13:00:00 | CL | Stock | 24.605 | 24.675 | 24.595 | 24.675 | 747800.0 |
| 2003-12-23 14:00:00 | CL | Stock | 24.675 | 24.715 | 24.55 | 24.62 | 704800.0 |
| 2003-12-23 15:00:00 | CL | Stock | 24.63 | 24.7 | 24.605 | 24.67 | 973400.0 |
> showing 50 of 23,185 rows — these rows as CSV