PREVIEW / stock_1hour / 2002-11-22
file: by_date/stock_1hour/2002/2002-11-22.parquet size: 419 KB rows: 19,582 symbols: 1,502
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 |
|---|---|---|---|---|---|---|---|
| 2002-11-22 08:00:00 | AAPL | Stock | 0.2913 | 0.2913 | 0.2902 | 0.2902 | 123200.0 |
| 2002-11-22 09:00:00 | AAPL | Stock | 0.2911 | 0.2912 | 0.2861 | 0.2893 | 24652712.0 |
| 2002-11-22 10:00:00 | AAPL | Stock | 0.2893 | 0.2896 | 0.2839 | 0.2843 | 34355720.0 |
| 2002-11-22 11:00:00 | AAPL | Stock | 0.2845 | 0.2879 | 0.2845 | 0.2866 | 17202920.0 |
| 2002-11-22 12:00:00 | AAPL | Stock | 0.2863 | 0.2886 | 0.2854 | 0.2879 | 14777112.0 |
| 2002-11-22 13:00:00 | AAPL | Stock | 0.2879 | 0.288 | 0.2852 | 0.2863 | 15354920.0 |
| 2002-11-22 14:00:00 | AAPL | Stock | 0.2861 | 0.2886 | 0.2857 | 0.2857 | 24758160.0 |
| 2002-11-22 15:00:00 | AAPL | Stock | 0.2855 | 0.2879 | 0.2841 | 0.2859 | 37449944.0 |
| 2002-11-22 16:00:00 | AAPL | Stock | 0.2859 | 0.2871 | 0.2852 | 0.2859 | 8758400.0 |
| 2002-11-22 17:00:00 | AAPL | Stock | 0.2859 | 0.2859 | 0.2859 | 0.2859 | 224000.0 |
| 2002-11-22 08:00:00 | MSFT | Stock | 28.72 | 28.905 | 28.65 | 28.7 | 75314.0 |
| 2002-11-22 09:00:00 | MSFT | Stock | 28.7005 | 28.905 | 28.68 | 28.82 | 8053608.0 |
| 2002-11-22 10:00:00 | MSFT | Stock | 28.82 | 28.98 | 28.5485 | 28.575 | 12702008.0 |
| 2002-11-22 11:00:00 | MSFT | Stock | 28.58 | 28.79 | 28.57 | 28.67 | 8943240.0 |
| 2002-11-22 12:00:00 | MSFT | Stock | 28.67 | 28.895 | 28.648 | 28.87 | 5510130.0 |
| 2002-11-22 13:00:00 | MSFT | Stock | 28.87 | 28.945 | 28.815 | 28.925 | 3764968.0 |
| 2002-11-22 14:00:00 | MSFT | Stock | 28.921 | 29.135 | 28.915 | 29.085 | 13191718.0 |
| 2002-11-22 15:00:00 | MSFT | Stock | 29.085 | 29.15 | 28.875 | 29.11 | 14221882.0 |
| 2002-11-22 16:00:00 | MSFT | Stock | 29.1 | 29.1395 | 29.007 | 29.1395 | 1397156.0 |
| 2002-11-22 17:00:00 | MSFT | Stock | 29.115 | 29.165 | 29.11 | 29.125 | 41960.0 |
| 2002-11-22 18:00:00 | MSFT | Stock | 29.15 | 29.15 | 29.125 | 29.13 | 5800.0 |
| 2002-11-22 08:00:00 | NVDA | Stock | 0.1291 | 0.13 | 0.1156 | 0.1267 | 16405200.0 |
| 2002-11-22 09:00:00 | NVDA | Stock | 0.1263 | 0.134 | 0.125 | 0.1299 | 253659240.0 |
| 2002-11-22 10:00:00 | NVDA | Stock | 0.1299 | 0.1329 | 0.1292 | 0.1303 | 280201440.0 |
| 2002-11-22 11:00:00 | NVDA | Stock | 0.1303 | 0.1322 | 0.1302 | 0.1305 | 104188800.0 |
| 2002-11-22 12:00:00 | NVDA | Stock | 0.1304 | 0.132 | 0.1304 | 0.1312 | 65992800.0 |
| 2002-11-22 13:00:00 | NVDA | Stock | 0.1312 | 0.1321 | 0.1304 | 0.1312 | 67178160.0 |
| 2002-11-22 14:00:00 | NVDA | Stock | 0.1314 | 0.1337 | 0.131 | 0.1318 | 125802720.0 |
| 2002-11-22 15:00:00 | NVDA | Stock | 0.1317 | 0.1324 | 0.13 | 0.131 | 222439800.0 |
| 2002-11-22 16:00:00 | NVDA | Stock | 0.131 | 0.1317 | 0.1304 | 0.1304 | 9516960.0 |
| 2002-11-22 17:00:00 | NVDA | Stock | 0.1304 | 0.131 | 0.1302 | 0.1304 | 1624680.0 |
| 2002-11-22 18:00:00 | NVDA | Stock | 0.1302 | 0.1302 | 0.1302 | 0.1302 | 541320.0 |
| 2002-11-22 08:00:00 | AMZN | Stock | 1.1595 | 1.1695 | 1.159 | 1.16 | 571000.0 |
| 2002-11-22 09:00:00 | AMZN | Stock | 1.16 | 1.1995 | 1.155 | 1.198 | 32224380.0 |
| 2002-11-22 10:00:00 | AMZN | Stock | 1.198 | 1.1985 | 1.1795 | 1.1815 | 38986720.0 |
| 2002-11-22 11:00:00 | AMZN | Stock | 1.1815 | 1.1847 | 1.175 | 1.1795 | 21505500.0 |
| 2002-11-22 12:00:00 | AMZN | Stock | 1.1795 | 1.1925 | 1.177 | 1.1905 | 20010500.0 |
| 2002-11-22 13:00:00 | AMZN | Stock | 1.1905 | 1.2075 | 1.187 | 1.205 | 30741240.0 |
| 2002-11-22 14:00:00 | AMZN | Stock | 1.2055 | 1.214 | 1.1984 | 1.203 | 34290700.0 |
| 2002-11-22 15:00:00 | AMZN | Stock | 1.2025 | 1.209 | 1.1945 | 1.199 | 38828300.0 |
| 2002-11-22 16:00:00 | AMZN | Stock | 1.1995 | 1.203 | 1.1975 | 1.2 | 2447340.0 |
| 2002-11-22 17:00:00 | AMZN | Stock | 1.206 | 1.206 | 1.1985 | 1.2 | 176000.0 |
| 2002-11-22 18:00:00 | AMZN | Stock | 1.2 | 1.2 | 1.2 | 1.2 | 12000.0 |
| 2002-11-22 09:00:00 | CL | Stock | 26.225 | 26.225 | 25.875 | 25.905 | 672200.0 |
| 2002-11-22 10:00:00 | CL | Stock | 25.905 | 26.145 | 25.84 | 26.125 | 884000.0 |
| 2002-11-22 11:00:00 | CL | Stock | 26.14 | 26.325 | 26.075 | 26.08 | 949000.0 |
| 2002-11-22 12:00:00 | CL | Stock | 26.08 | 26.295 | 26.08 | 26.235 | 705400.0 |
| 2002-11-22 13:00:00 | CL | Stock | 26.235 | 26.235 | 26.0 | 26.05 | 748000.0 |
| 2002-11-22 14:00:00 | CL | Stock | 26.045 | 26.075 | 25.9 | 25.93 | 592000.0 |
| 2002-11-22 15:00:00 | CL | Stock | 25.93 | 25.995 | 25.75 | 25.775 | 1624200.0 |
> showing 50 of 19,582 rows — these rows as CSV