PREVIEW / stock_1hour / 2003-10-09
file: by_date/stock_1hour/2003/2003-10-09.parquet size: 479 KB rows: 22,070 symbols: 1,651
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-10-09 08:00:00 | AAPL | Stock | 0.4107 | 0.4189 | 0.4107 | 0.4166 | 128800.0 |
| 2003-10-09 09:00:00 | AAPL | Stock | 0.4163 | 0.4196 | 0.407 | 0.4123 | 52876264.0 |
| 2003-10-09 10:00:00 | AAPL | Stock | 0.4122 | 0.4171 | 0.4105 | 0.4118 | 53052608.0 |
| 2003-10-09 11:00:00 | AAPL | Stock | 0.4116 | 0.4171 | 0.4104 | 0.4146 | 38093328.0 |
| 2003-10-09 12:00:00 | AAPL | Stock | 0.4146 | 0.4173 | 0.4141 | 0.4171 | 21088872.0 |
| 2003-10-09 13:00:00 | AAPL | Stock | 0.4171 | 0.4227 | 0.4159 | 0.4198 | 35862792.0 |
| 2003-10-09 14:00:00 | AAPL | Stock | 0.4204 | 0.4218 | 0.4155 | 0.4173 | 56288904.0 |
| 2003-10-09 15:00:00 | AAPL | Stock | 0.417 | 0.4188 | 0.4148 | 0.4188 | 42211456.0 |
| 2003-10-09 16:00:00 | AAPL | Stock | 0.4188 | 0.4189 | 0.4146 | 0.4188 | 1136072.0 |
| 2003-10-09 17:00:00 | AAPL | Stock | 0.4188 | 0.4188 | 0.4188 | 0.4188 | 33600.0 |
| 2003-10-09 08:00:00 | MSFT | Stock | 28.89 | 29.15 | 28.75 | 29.13 | 207683.0 |
| 2003-10-09 09:00:00 | MSFT | Stock | 29.14 | 29.27 | 28.95 | 29.08 | 8170943.0 |
| 2003-10-09 10:00:00 | MSFT | Stock | 29.09 | 29.19 | 28.99 | 29.18 | 7034076.0 |
| 2003-10-09 11:00:00 | MSFT | Stock | 29.18 | 29.29 | 29.14 | 29.26 | 9543029.0 |
| 2003-10-09 12:00:00 | MSFT | Stock | 29.27 | 29.3496 | 29.23 | 29.28 | 5123872.0 |
| 2003-10-09 13:00:00 | MSFT | Stock | 29.28 | 29.29 | 29.15 | 29.22 | 5144093.0 |
| 2003-10-09 14:00:00 | MSFT | Stock | 29.22 | 29.25 | 28.89 | 28.94 | 7936952.0 |
| 2003-10-09 15:00:00 | MSFT | Stock | 28.94 | 28.98 | 28.8 | 28.89 | 9512087.0 |
| 2003-10-09 16:00:00 | MSFT | Stock | 28.9 | 29.1179 | 28.85 | 28.94 | 627848.0 |
| 2003-10-09 17:00:00 | MSFT | Stock | 28.94 | 28.99 | 28.91 | 28.99 | 80400.0 |
| 2003-10-09 18:00:00 | MSFT | Stock | 28.98 | 29.0 | 28.95 | 29.0 | 12900.0 |
| 2003-10-09 08:00:00 | NVDA | Stock | 0.1363 | 0.1373 | 0.136 | 0.1372 | 1286040.0 |
| 2003-10-09 09:00:00 | NVDA | Stock | 0.1372 | 0.1379 | 0.1359 | 0.1371 | 138230880.0 |
| 2003-10-09 10:00:00 | NVDA | Stock | 0.1371 | 0.1412 | 0.1362 | 0.1412 | 176235720.0 |
| 2003-10-09 11:00:00 | NVDA | Stock | 0.1412 | 0.1423 | 0.1403 | 0.1409 | 135563160.0 |
| 2003-10-09 12:00:00 | NVDA | Stock | 0.1409 | 0.1415 | 0.1407 | 0.1412 | 52635360.0 |
| 2003-10-09 13:00:00 | NVDA | Stock | 0.1412 | 0.1413 | 0.1397 | 0.1401 | 43282920.0 |
| 2003-10-09 14:00:00 | NVDA | Stock | 0.1402 | 0.1404 | 0.1373 | 0.1377 | 101256120.0 |
| 2003-10-09 15:00:00 | NVDA | Stock | 0.1376 | 0.1382 | 0.1366 | 0.1373 | 102937800.0 |
| 2003-10-09 16:00:00 | NVDA | Stock | 0.1373 | 0.1376 | 0.1362 | 0.1369 | 3312360.0 |
| 2003-10-09 17:00:00 | NVDA | Stock | 0.1369 | 0.1376 | 0.1369 | 0.1375 | 96000.0 |
| 2003-10-09 18:00:00 | NVDA | Stock | 0.1375 | 0.1375 | 0.1375 | 0.1375 | 72000.0 |
| 2003-10-09 08:00:00 | AMZN | Stock | 2.829 | 2.8595 | 2.805 | 2.8575 | 2127320.0 |
| 2003-10-09 09:00:00 | AMZN | Stock | 2.8575 | 2.9165 | 2.82 | 2.897 | 86051040.0 |
| 2003-10-09 10:00:00 | AMZN | Stock | 2.8975 | 2.922 | 2.886 | 2.9205 | 63147460.0 |
| 2003-10-09 11:00:00 | AMZN | Stock | 2.921 | 2.935 | 2.9125 | 2.928 | 41434800.0 |
| 2003-10-09 12:00:00 | AMZN | Stock | 2.929 | 2.939 | 2.9245 | 2.926 | 23731200.0 |
| 2003-10-09 13:00:00 | AMZN | Stock | 2.926 | 2.955 | 2.9205 | 2.944 | 38027420.0 |
| 2003-10-09 14:00:00 | AMZN | Stock | 2.945 | 2.9475 | 2.89 | 2.9015 | 57661560.0 |
| 2003-10-09 15:00:00 | AMZN | Stock | 2.901 | 2.9125 | 2.884 | 2.8945 | 63418020.0 |
| 2003-10-09 16:00:00 | AMZN | Stock | 2.894 | 2.9025 | 2.8925 | 2.898 | 2377860.0 |
| 2003-10-09 17:00:00 | AMZN | Stock | 2.901 | 2.9085 | 2.8921 | 2.905 | 234000.0 |
| 2003-10-09 18:00:00 | AMZN | Stock | 2.9085 | 2.91 | 2.9075 | 2.9075 | 24000.0 |
| 2003-10-09 09:00:00 | CL | Stock | 29.0 | 29.115 | 28.98 | 28.99 | 297200.0 |
| 2003-10-09 10:00:00 | CL | Stock | 28.985 | 29.045 | 28.89 | 29.035 | 526600.0 |
| 2003-10-09 11:00:00 | CL | Stock | 29.045 | 29.125 | 28.935 | 28.97 | 299600.0 |
| 2003-10-09 12:00:00 | CL | Stock | 28.97 | 29.0 | 28.885 | 28.915 | 310600.0 |
| 2003-10-09 13:00:00 | CL | Stock | 28.905 | 28.945 | 28.825 | 28.865 | 262800.0 |
| 2003-10-09 14:00:00 | CL | Stock | 28.875 | 28.9 | 28.575 | 28.74 | 478000.0 |
| 2003-10-09 15:00:00 | CL | Stock | 28.72 | 28.85 | 28.66 | 28.81 | 602000.0 |
> showing 50 of 22,070 rows — these rows as CSV