PREVIEW / stock_1hour / 2003-11-12
file: by_date/stock_1hour/2003/2003-11-12.parquet size: 496 KB rows: 23,454 symbols: 1,665
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-12 08:00:00 | AAPL | Stock | 0.3846 | 0.3854 | 0.3846 | 0.3854 | 1248800.0 |
| 2003-11-12 09:00:00 | AAPL | Stock | 0.3848 | 0.392 | 0.3836 | 0.3905 | 29095024.0 |
| 2003-11-12 10:00:00 | AAPL | Stock | 0.3907 | 0.3961 | 0.3905 | 0.3934 | 41692112.0 |
| 2003-11-12 11:00:00 | AAPL | Stock | 0.3932 | 0.3966 | 0.3929 | 0.3966 | 20303080.0 |
| 2003-11-12 12:00:00 | AAPL | Stock | 0.3966 | 0.3991 | 0.3957 | 0.3989 | 26744704.0 |
| 2003-11-12 13:00:00 | AAPL | Stock | 0.3989 | 0.4025 | 0.3988 | 0.4002 | 30927008.0 |
| 2003-11-12 14:00:00 | AAPL | Stock | 0.4004 | 0.4057 | 0.3991 | 0.4054 | 40650960.0 |
| 2003-11-12 15:00:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.3984 | 0.4011 | 68485760.0 |
| 2003-11-12 16:00:00 | AAPL | Stock | 0.4004 | 0.4033 | 0.3984 | 0.4032 | 3931872.0 |
| 2003-11-12 17:00:00 | AAPL | Stock | 0.3988 | 0.4018 | 0.3962 | 0.3988 | 1248632.0 |
| 2003-11-12 18:00:00 | AAPL | Stock | 0.3988 | 0.3988 | 0.3988 | 0.3988 | 78400.0 |
| 2003-11-12 08:00:00 | MSFT | Stock | 25.86 | 25.9 | 25.81 | 25.85 | 50207.0 |
| 2003-11-12 09:00:00 | MSFT | Stock | 25.87 | 25.89 | 25.67 | 25.78 | 7314214.0 |
| 2003-11-12 10:00:00 | MSFT | Stock | 25.78 | 25.791 | 25.61 | 25.63 | 9471030.0 |
| 2003-11-12 11:00:00 | MSFT | Stock | 25.62 | 25.77 | 25.6 | 25.74 | 10248111.0 |
| 2003-11-12 12:00:00 | MSFT | Stock | 25.74 | 25.83 | 25.68 | 25.74 | 5677886.0 |
| 2003-11-12 13:00:00 | MSFT | Stock | 25.74 | 26.0 | 25.74 | 25.96 | 9985615.0 |
| 2003-11-12 14:00:00 | MSFT | Stock | 25.95 | 26.14 | 25.9 | 26.101 | 14368198.0 |
| 2003-11-12 15:00:00 | MSFT | Stock | 26.1 | 26.11 | 25.92 | 25.98 | 12074073.0 |
| 2003-11-12 16:00:00 | MSFT | Stock | 25.99 | 26.06 | 25.9 | 26.01 | 785992.0 |
| 2003-11-12 17:00:00 | MSFT | Stock | 26.01 | 26.02 | 25.8156 | 25.98 | 401249.0 |
| 2003-11-12 18:00:00 | MSFT | Stock | 25.99 | 26.0 | 25.98 | 26.0 | 6310.0 |
| 2003-11-12 08:00:00 | NVDA | Stock | 0.1764 | 0.1764 | 0.1763 | 0.1763 | 120000.0 |
| 2003-11-12 09:00:00 | NVDA | Stock | 0.176 | 0.179 | 0.1748 | 0.1784 | 101202240.0 |
| 2003-11-12 10:00:00 | NVDA | Stock | 0.1784 | 0.1787 | 0.1776 | 0.1777 | 75242520.0 |
| 2003-11-12 11:00:00 | NVDA | Stock | 0.1777 | 0.1787 | 0.1776 | 0.1782 | 81213840.0 |
| 2003-11-12 12:00:00 | NVDA | Stock | 0.1782 | 0.1787 | 0.1779 | 0.1782 | 34637640.0 |
| 2003-11-12 13:00:00 | NVDA | Stock | 0.1782 | 0.1784 | 0.1775 | 0.1777 | 61655280.0 |
| 2003-11-12 14:00:00 | NVDA | Stock | 0.1777 | 0.1787 | 0.1777 | 0.1787 | 49216440.0 |
| 2003-11-12 15:00:00 | NVDA | Stock | 0.1787 | 0.1792 | 0.1764 | 0.1783 | 154032000.0 |
| 2003-11-12 16:00:00 | NVDA | Stock | 0.1786 | 0.1792 | 0.1774 | 0.1792 | 13497360.0 |
| 2003-11-12 17:00:00 | NVDA | Stock | 0.1792 | 0.1812 | 0.1775 | 0.1786 | 2484480.0 |
| 2003-11-12 18:00:00 | NVDA | Stock | 0.1808 | 0.1816 | 0.1808 | 0.1816 | 954600.0 |
| 2003-11-12 08:00:00 | AMZN | Stock | 2.6265 | 2.6755 | 2.6245 | 2.6255 | 82000.0 |
| 2003-11-12 09:00:00 | AMZN | Stock | 2.6255 | 2.6475 | 2.611 | 2.6135 | 24976080.0 |
| 2003-11-12 10:00:00 | AMZN | Stock | 2.614 | 2.6375 | 2.612 | 2.627 | 18578440.0 |
| 2003-11-12 11:00:00 | AMZN | Stock | 2.627 | 2.634 | 2.6055 | 2.6255 | 15685540.0 |
| 2003-11-12 12:00:00 | AMZN | Stock | 2.6255 | 2.6375 | 2.6204 | 2.6285 | 11343640.0 |
| 2003-11-12 13:00:00 | AMZN | Stock | 2.6282 | 2.662 | 2.628 | 2.6565 | 21896280.0 |
| 2003-11-12 14:00:00 | AMZN | Stock | 2.6565 | 2.678 | 2.6565 | 2.6725 | 23027840.0 |
| 2003-11-12 15:00:00 | AMZN | Stock | 2.6725 | 2.7145 | 2.6675 | 2.714 | 49510140.0 |
| 2003-11-12 16:00:00 | AMZN | Stock | 2.714 | 2.7225 | 2.705 | 2.7225 | 2502080.0 |
| 2003-11-12 17:00:00 | AMZN | Stock | 2.722 | 2.7225 | 2.6574 | 2.7195 | 125240.0 |
| 2003-11-12 09:00:00 | CL | Stock | 26.125 | 26.255 | 26.075 | 26.23 | 454800.0 |
| 2003-11-12 10:00:00 | CL | Stock | 26.23 | 26.275 | 26.175 | 26.175 | 1100400.0 |
| 2003-11-12 11:00:00 | CL | Stock | 26.175 | 26.25 | 26.145 | 26.21 | 1018200.0 |
| 2003-11-12 12:00:00 | CL | Stock | 26.22 | 26.23 | 26.195 | 26.215 | 418400.0 |
| 2003-11-12 13:00:00 | CL | Stock | 26.22 | 26.285 | 26.195 | 26.26 | 411200.0 |
| 2003-11-12 14:00:00 | CL | Stock | 26.26 | 26.42 | 26.26 | 26.42 | 430600.0 |
| 2003-11-12 15:00:00 | CL | Stock | 26.415 | 26.465 | 26.325 | 26.355 | 1268000.0 |
> showing 50 of 23,454 rows — these rows as CSV