PREVIEW / stock_1hour / 2003-05-06
file: by_date/stock_1hour/2003/2003-05-06.parquet size: 443 KB rows: 21,660 symbols: 1,584
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-05-06 08:00:00 | AAPL | Stock | 0.2866 | 0.2929 | 0.2821 | 0.2866 | 2682400.0 |
| 2003-05-06 09:00:00 | AAPL | Stock | 0.2866 | 0.2982 | 0.2866 | 0.2939 | 175170408.0 |
| 2003-05-06 10:00:00 | AAPL | Stock | 0.2939 | 0.2961 | 0.2911 | 0.2955 | 135608928.0 |
| 2003-05-06 11:00:00 | AAPL | Stock | 0.2955 | 0.2998 | 0.2939 | 0.2993 | 98096656.0 |
| 2003-05-06 12:00:00 | AAPL | Stock | 0.2991 | 0.3048 | 0.298 | 0.3045 | 99616776.0 |
| 2003-05-06 13:00:00 | AAPL | Stock | 0.3048 | 0.3064 | 0.3025 | 0.3043 | 79400160.0 |
| 2003-05-06 14:00:00 | AAPL | Stock | 0.3043 | 0.3196 | 0.3041 | 0.3152 | 338366448.0 |
| 2003-05-06 15:00:00 | AAPL | Stock | 0.3152 | 0.3155 | 0.3113 | 0.3125 | 322277368.0 |
| 2003-05-06 16:00:00 | AAPL | Stock | 0.3125 | 0.3143 | 0.3053 | 0.3116 | 43012256.0 |
| 2003-05-06 17:00:00 | AAPL | Stock | 0.3116 | 0.3134 | 0.3107 | 0.3116 | 431088.0 |
| 2003-05-06 18:00:00 | AAPL | Stock | 0.3114 | 0.313 | 0.3114 | 0.3116 | 95088.0 |
| 2003-05-06 08:00:00 | MSFT | Stock | 25.91 | 26.0 | 25.875 | 25.94 | 43901.0 |
| 2003-05-06 09:00:00 | MSFT | Stock | 25.92 | 26.16 | 25.82 | 26.04 | 5339213.0 |
| 2003-05-06 10:00:00 | MSFT | Stock | 26.04 | 26.24 | 26.02 | 26.19 | 6508525.0 |
| 2003-05-06 11:00:00 | MSFT | Stock | 26.2 | 26.33 | 26.16 | 26.329 | 4530447.0 |
| 2003-05-06 12:00:00 | MSFT | Stock | 26.32 | 26.42 | 26.29 | 26.38 | 5126941.0 |
| 2003-05-06 13:00:00 | MSFT | Stock | 26.38 | 26.49 | 26.31 | 26.36 | 4830516.0 |
| 2003-05-06 14:00:00 | MSFT | Stock | 26.36 | 26.501 | 26.19 | 26.24 | 10863015.0 |
| 2003-05-06 15:00:00 | MSFT | Stock | 26.242 | 26.39 | 26.08 | 26.37 | 8423063.0 |
| 2003-05-06 16:00:00 | MSFT | Stock | 26.38 | 26.49 | 26.2615 | 26.4 | 566962.0 |
| 2003-05-06 17:00:00 | MSFT | Stock | 26.409 | 26.45 | 26.25 | 26.32 | 216146.0 |
| 2003-05-06 18:00:00 | MSFT | Stock | 26.33 | 26.37 | 26.33 | 26.362 | 9900.0 |
| 2003-05-06 08:00:00 | NVDA | Stock | 0.1358 | 0.1373 | 0.1358 | 0.1358 | 2220000.0 |
| 2003-05-06 09:00:00 | NVDA | Stock | 0.1364 | 0.1367 | 0.1337 | 0.1356 | 143642760.0 |
| 2003-05-06 10:00:00 | NVDA | Stock | 0.1355 | 0.1365 | 0.1339 | 0.1344 | 147021600.0 |
| 2003-05-06 11:00:00 | NVDA | Stock | 0.1344 | 0.1377 | 0.1343 | 0.1377 | 159309960.0 |
| 2003-05-06 12:00:00 | NVDA | Stock | 0.1378 | 0.1387 | 0.1374 | 0.1381 | 98648040.0 |
| 2003-05-06 13:00:00 | NVDA | Stock | 0.1381 | 0.1394 | 0.1375 | 0.1389 | 93180840.0 |
| 2003-05-06 14:00:00 | NVDA | Stock | 0.1389 | 0.1392 | 0.1362 | 0.1367 | 107646600.0 |
| 2003-05-06 15:00:00 | NVDA | Stock | 0.1368 | 0.1375 | 0.1351 | 0.136 | 188519640.0 |
| 2003-05-06 16:00:00 | NVDA | Stock | 0.1359 | 0.1372 | 0.1355 | 0.1362 | 2472000.0 |
| 2003-05-06 17:00:00 | NVDA | Stock | 0.1362 | 0.1362 | 0.135 | 0.135 | 1379400.0 |
| 2003-05-06 18:00:00 | NVDA | Stock | 0.135 | 0.1354 | 0.1347 | 0.1352 | 960000.0 |
| 2003-05-06 08:00:00 | AMZN | Stock | 1.497 | 1.5 | 1.4905 | 1.4926 | 90000.0 |
| 2003-05-06 09:00:00 | AMZN | Stock | 1.4926 | 1.515 | 1.4895 | 1.51 | 31501320.0 |
| 2003-05-06 10:00:00 | AMZN | Stock | 1.51 | 1.518 | 1.507 | 1.5125 | 28072900.0 |
| 2003-05-06 11:00:00 | AMZN | Stock | 1.5125 | 1.522 | 1.5115 | 1.5215 | 17940360.0 |
| 2003-05-06 12:00:00 | AMZN | Stock | 1.521 | 1.5375 | 1.5195 | 1.536 | 31927100.0 |
| 2003-05-06 13:00:00 | AMZN | Stock | 1.5356 | 1.5356 | 1.526 | 1.529 | 20638940.0 |
| 2003-05-06 14:00:00 | AMZN | Stock | 1.5295 | 1.559 | 1.525 | 1.541 | 55811560.0 |
| 2003-05-06 15:00:00 | AMZN | Stock | 1.541 | 1.5521 | 1.5295 | 1.544 | 54064260.0 |
| 2003-05-06 16:00:00 | AMZN | Stock | 1.544 | 1.5474 | 1.54 | 1.546 | 1452000.0 |
| 2003-05-06 17:00:00 | AMZN | Stock | 1.545 | 1.548 | 1.5405 | 1.5425 | 397780.0 |
| 2003-05-06 18:00:00 | AMZN | Stock | 1.542 | 1.545 | 1.542 | 1.544 | 68000.0 |
| 2003-05-06 09:00:00 | CL | Stock | 28.75 | 28.81 | 28.6 | 28.6 | 423400.0 |
| 2003-05-06 10:00:00 | CL | Stock | 28.585 | 28.68 | 28.5 | 28.6 | 795600.0 |
| 2003-05-06 11:00:00 | CL | Stock | 28.595 | 28.6 | 28.5 | 28.575 | 414000.0 |
| 2003-05-06 12:00:00 | CL | Stock | 28.585 | 28.65 | 28.56 | 28.645 | 472000.0 |
| 2003-05-06 13:00:00 | CL | Stock | 28.65 | 28.685 | 28.625 | 28.64 | 250000.0 |
| 2003-05-06 14:00:00 | CL | Stock | 28.64 | 28.815 | 28.625 | 28.725 | 674800.0 |
> showing 50 of 21,660 rows — these rows as CSV