PREVIEW / stock_1hour / 2003-12-19
file: by_date/stock_1hour/2003/2003-12-19.parquet size: 504 KB rows: 23,700 symbols: 1,702
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-19 08:00:00 | AAPL | Stock | 0.3579 | 0.358 | 0.3579 | 0.3579 | 722400.0 |
| 2003-12-19 09:00:00 | AAPL | Stock | 0.3589 | 0.3646 | 0.3546 | 0.3584 | 73660104.0 |
| 2003-12-19 10:00:00 | AAPL | Stock | 0.3586 | 0.3609 | 0.3559 | 0.3588 | 37971696.0 |
| 2003-12-19 11:00:00 | AAPL | Stock | 0.3588 | 0.3598 | 0.3559 | 0.3579 | 22402128.0 |
| 2003-12-19 12:00:00 | AAPL | Stock | 0.3575 | 0.3575 | 0.3546 | 0.3552 | 24576720.0 |
| 2003-12-19 13:00:00 | AAPL | Stock | 0.3552 | 0.3561 | 0.3545 | 0.3557 | 32877656.0 |
| 2003-12-19 14:00:00 | AAPL | Stock | 0.3557 | 0.3561 | 0.3536 | 0.3538 | 42822360.0 |
| 2003-12-19 15:00:00 | AAPL | Stock | 0.3538 | 0.3543 | 0.3509 | 0.3509 | 119944720.0 |
| 2003-12-19 16:00:00 | AAPL | Stock | 0.3518 | 0.362 | 0.3504 | 0.3513 | 12316808.0 |
| 2003-12-19 17:00:00 | AAPL | Stock | 0.3513 | 0.3596 | 0.3513 | 0.3514 | 1998584.0 |
| 2003-12-19 18:00:00 | AAPL | Stock | 0.3513 | 0.3513 | 0.3513 | 0.3513 | 28000.0 |
| 2003-12-19 08:00:00 | MSFT | Stock | 27.42 | 27.45 | 27.25 | 27.44 | 107509.0 |
| 2003-12-19 09:00:00 | MSFT | Stock | 27.43 | 27.52 | 27.35 | 27.39 | 16718348.0 |
| 2003-12-19 10:00:00 | MSFT | Stock | 27.39 | 27.505 | 27.38 | 27.46 | 7594384.0 |
| 2003-12-19 11:00:00 | MSFT | Stock | 27.46 | 27.49 | 27.2 | 27.39 | 11484614.0 |
| 2003-12-19 12:00:00 | MSFT | Stock | 27.39 | 27.43 | 27.21 | 27.27 | 8449587.0 |
| 2003-12-19 13:00:00 | MSFT | Stock | 27.27 | 27.29 | 27.22 | 27.271 | 4287912.0 |
| 2003-12-19 14:00:00 | MSFT | Stock | 27.27 | 27.32 | 27.19 | 27.3 | 4031560.0 |
| 2003-12-19 15:00:00 | MSFT | Stock | 27.3 | 27.39 | 27.29 | 27.36 | 8188454.0 |
| 2003-12-19 16:00:00 | MSFT | Stock | 27.37 | 27.44 | 27.28 | 27.365 | 2794037.0 |
| 2003-12-19 17:00:00 | MSFT | Stock | 27.3625 | 27.38 | 27.28 | 27.36 | 441914.0 |
| 2003-12-19 18:00:00 | MSFT | Stock | 27.35 | 27.35 | 27.28 | 27.31 | 1204.0 |
| 2003-12-19 08:00:00 | NVDA | Stock | 0.1753 | 0.1785 | 0.175 | 0.1762 | 3120000.0 |
| 2003-12-19 09:00:00 | NVDA | Stock | 0.1762 | 0.1792 | 0.1742 | 0.1778 | 187041120.0 |
| 2003-12-19 10:00:00 | NVDA | Stock | 0.1778 | 0.18 | 0.1772 | 0.1792 | 142226880.0 |
| 2003-12-19 11:00:00 | NVDA | Stock | 0.1792 | 0.1796 | 0.1784 | 0.179 | 105901200.0 |
| 2003-12-19 12:00:00 | NVDA | Stock | 0.179 | 0.1791 | 0.1753 | 0.1767 | 93425280.0 |
| 2003-12-19 13:00:00 | NVDA | Stock | 0.1766 | 0.1767 | 0.1753 | 0.1759 | 48232080.0 |
| 2003-12-19 14:00:00 | NVDA | Stock | 0.176 | 0.176 | 0.1737 | 0.175 | 78927720.0 |
| 2003-12-19 15:00:00 | NVDA | Stock | 0.1748 | 0.1777 | 0.1747 | 0.1754 | 126238920.0 |
| 2003-12-19 16:00:00 | NVDA | Stock | 0.1755 | 0.1762 | 0.1745 | 0.1747 | 28226040.0 |
| 2003-12-19 17:00:00 | NVDA | Stock | 0.1746 | 0.1756 | 0.1746 | 0.1748 | 2478480.0 |
| 2003-12-19 18:00:00 | NVDA | Stock | 0.1743 | 0.1744 | 0.1743 | 0.1744 | 344880.0 |
| 2003-12-19 08:00:00 | AMZN | Stock | 2.44 | 2.44 | 2.4335 | 2.435 | 120000.0 |
| 2003-12-19 09:00:00 | AMZN | Stock | 2.435 | 2.4475 | 2.413 | 2.4205 | 24331220.0 |
| 2003-12-19 10:00:00 | AMZN | Stock | 2.42 | 2.4295 | 2.4155 | 2.423 | 22192400.0 |
| 2003-12-19 11:00:00 | AMZN | Stock | 2.423 | 2.4325 | 2.417 | 2.424 | 19406340.0 |
| 2003-12-19 12:00:00 | AMZN | Stock | 2.424 | 2.4275 | 2.4195 | 2.4235 | 14021040.0 |
| 2003-12-19 13:00:00 | AMZN | Stock | 2.4235 | 2.4265 | 2.4185 | 2.423 | 6935520.0 |
| 2003-12-19 14:00:00 | AMZN | Stock | 2.423 | 2.428 | 2.42 | 2.426 | 7217040.0 |
| 2003-12-19 15:00:00 | AMZN | Stock | 2.426 | 2.4705 | 2.4245 | 2.4615 | 52634760.0 |
| 2003-12-19 16:00:00 | AMZN | Stock | 2.4615 | 2.463 | 2.459 | 2.4625 | 2317840.0 |
| 2003-12-19 17:00:00 | AMZN | Stock | 2.4626 | 2.4635 | 2.4595 | 2.4615 | 463660.0 |
| 2003-12-19 18:00:00 | AMZN | Stock | 2.46 | 2.46 | 2.46 | 2.46 | 18000.0 |
| 2003-12-19 08:00:00 | CL | Stock | 25.1 | 25.155 | 25.1 | 25.155 | 2400.0 |
| 2003-12-19 09:00:00 | CL | Stock | 25.15 | 25.15 | 24.5 | 24.525 | 3948600.0 |
| 2003-12-19 10:00:00 | CL | Stock | 24.52 | 24.685 | 24.415 | 24.625 | 3654400.0 |
| 2003-12-19 11:00:00 | CL | Stock | 24.62 | 24.62 | 24.3 | 24.365 | 3532000.0 |
| 2003-12-19 12:00:00 | CL | Stock | 24.37 | 24.45 | 24.28 | 24.33 | 2188200.0 |
| 2003-12-19 13:00:00 | CL | Stock | 24.335 | 24.395 | 24.31 | 24.365 | 1840000.0 |
> showing 50 of 23,700 rows — these rows as CSV