PREVIEW / stock_1hour / 2003-03-12
file: by_date/stock_1hour/2003/2003-03-12.parquet size: 404 KB rows: 20,547 symbols: 1,542
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-03-12 08:00:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2536 | 0.2536 | 44800.0 |
| 2003-03-12 09:00:00 | AAPL | Stock | 0.2536 | 0.2569 | 0.2511 | 0.2552 | 22276520.0 |
| 2003-03-12 10:00:00 | AAPL | Stock | 0.2552 | 0.2559 | 0.2536 | 0.2538 | 34534864.0 |
| 2003-03-12 11:00:00 | AAPL | Stock | 0.2536 | 0.2546 | 0.2523 | 0.2525 | 12828312.0 |
| 2003-03-12 12:00:00 | AAPL | Stock | 0.2527 | 0.2543 | 0.2518 | 0.253 | 35518616.0 |
| 2003-03-12 13:00:00 | AAPL | Stock | 0.2529 | 0.2536 | 0.2516 | 0.2536 | 22260784.0 |
| 2003-03-12 14:00:00 | AAPL | Stock | 0.2536 | 0.2557 | 0.2529 | 0.2554 | 19319440.0 |
| 2003-03-12 15:00:00 | AAPL | Stock | 0.2554 | 0.257 | 0.2538 | 0.2541 | 44787120.0 |
| 2003-03-12 16:00:00 | AAPL | Stock | 0.2541 | 0.2568 | 0.2539 | 0.2539 | 7106400.0 |
| 2003-03-12 17:00:00 | AAPL | Stock | 0.2548 | 0.2548 | 0.2548 | 0.2548 | 5600.0 |
| 2003-03-12 18:00:00 | AAPL | Stock | 0.2548 | 0.2548 | 0.2548 | 0.2548 | 56000.0 |
| 2003-03-12 08:00:00 | MSFT | Stock | 22.75 | 23.5 | 22.0 | 22.84 | 633489.0 |
| 2003-03-12 09:00:00 | MSFT | Stock | 22.82 | 23.14 | 22.7 | 22.99 | 10068253.0 |
| 2003-03-12 10:00:00 | MSFT | Stock | 22.99 | 23.01 | 22.83 | 22.89 | 8101734.0 |
| 2003-03-12 11:00:00 | MSFT | Stock | 22.89 | 23.0 | 22.7 | 22.73 | 7111790.0 |
| 2003-03-12 12:00:00 | MSFT | Stock | 22.73 | 22.751 | 22.57 | 22.68 | 5272145.0 |
| 2003-03-12 13:00:00 | MSFT | Stock | 22.68 | 22.82 | 22.55 | 22.82 | 5859552.0 |
| 2003-03-12 14:00:00 | MSFT | Stock | 22.81 | 23.18 | 22.75 | 23.158 | 11707523.0 |
| 2003-03-12 15:00:00 | MSFT | Stock | 23.159 | 23.42 | 23.02 | 23.4 | 15356247.0 |
| 2003-03-12 16:00:00 | MSFT | Stock | 23.4 | 23.44 | 23.35 | 23.44 | 2959323.0 |
| 2003-03-12 17:00:00 | MSFT | Stock | 23.44 | 23.46 | 23.3916 | 23.44 | 84000.0 |
| 2003-03-12 18:00:00 | MSFT | Stock | 23.44 | 23.44 | 23.41 | 23.41 | 9836.0 |
| 2003-03-12 08:00:00 | NVDA | Stock | 0.1012 | 0.1027 | 0.1012 | 0.1021 | 1524000.0 |
| 2003-03-12 09:00:00 | NVDA | Stock | 0.1021 | 0.1035 | 0.1018 | 0.103 | 52914120.0 |
| 2003-03-12 10:00:00 | NVDA | Stock | 0.103 | 0.1032 | 0.1025 | 0.1026 | 49078080.0 |
| 2003-03-12 11:00:00 | NVDA | Stock | 0.1026 | 0.1032 | 0.1021 | 0.1024 | 64985760.0 |
| 2003-03-12 12:00:00 | NVDA | Stock | 0.1024 | 0.1031 | 0.1018 | 0.1024 | 44226120.0 |
| 2003-03-12 13:00:00 | NVDA | Stock | 0.1025 | 0.1033 | 0.1021 | 0.1032 | 37330800.0 |
| 2003-03-12 14:00:00 | NVDA | Stock | 0.1032 | 0.1038 | 0.1025 | 0.1037 | 52487520.0 |
| 2003-03-12 15:00:00 | NVDA | Stock | 0.1037 | 0.105 | 0.1033 | 0.1047 | 126740520.0 |
| 2003-03-12 16:00:00 | NVDA | Stock | 0.1048 | 0.105 | 0.1045 | 0.1049 | 6799680.0 |
| 2003-03-12 17:00:00 | NVDA | Stock | 0.105 | 0.105 | 0.105 | 0.105 | 120000.0 |
| 2003-03-12 08:00:00 | AMZN | Stock | 1.139 | 1.139 | 1.131 | 1.1325 | 197520.0 |
| 2003-03-12 09:00:00 | AMZN | Stock | 1.1325 | 1.145 | 1.1245 | 1.1365 | 14153960.0 |
| 2003-03-12 10:00:00 | AMZN | Stock | 1.1365 | 1.146 | 1.136 | 1.1405 | 11797300.0 |
| 2003-03-12 11:00:00 | AMZN | Stock | 1.1405 | 1.144 | 1.1385 | 1.1395 | 8644000.0 |
| 2003-03-12 12:00:00 | AMZN | Stock | 1.14 | 1.145 | 1.1365 | 1.1425 | 11674380.0 |
| 2003-03-12 13:00:00 | AMZN | Stock | 1.1425 | 1.1475 | 1.1388 | 1.1475 | 8334960.0 |
| 2003-03-12 14:00:00 | AMZN | Stock | 1.1475 | 1.1495 | 1.1405 | 1.148 | 13069040.0 |
| 2003-03-12 15:00:00 | AMZN | Stock | 1.148 | 1.169 | 1.1475 | 1.1675 | 27894980.0 |
| 2003-03-12 16:00:00 | AMZN | Stock | 1.1675 | 1.178 | 1.15 | 1.168 | 3365700.0 |
| 2003-03-12 17:00:00 | AMZN | Stock | 1.17 | 1.17 | 1.1675 | 1.1675 | 122000.0 |
| 2003-03-12 18:00:00 | AMZN | Stock | 1.1715 | 1.1715 | 1.1715 | 1.1715 | 6000.0 |
| 2003-03-12 09:00:00 | CL | Stock | 24.8 | 25.04 | 24.775 | 24.935 | 332600.0 |
| 2003-03-12 10:00:00 | CL | Stock | 24.945 | 25.205 | 24.86 | 25.18 | 571000.0 |
| 2003-03-12 11:00:00 | CL | Stock | 25.18 | 25.255 | 25.12 | 25.165 | 506400.0 |
| 2003-03-12 12:00:00 | CL | Stock | 25.16 | 25.2 | 25.08 | 25.15 | 579400.0 |
| 2003-03-12 13:00:00 | CL | Stock | 25.145 | 25.255 | 25.125 | 25.225 | 610800.0 |
| 2003-03-12 14:00:00 | CL | Stock | 25.225 | 25.36 | 25.125 | 25.36 | 644400.0 |
| 2003-03-12 15:00:00 | CL | Stock | 25.355 | 25.515 | 25.325 | 25.505 | 1112800.0 |
> showing 50 of 20,547 rows — these rows as CSV