PREVIEW / stock_1hour / 2003-05-09
file: by_date/stock_1hour/2003/2003-05-09.parquet size: 418 KB rows: 20,687 symbols: 1,583
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-09 08:00:00 | AAPL | Stock | 0.322 | 0.3268 | 0.3216 | 0.3268 | 1013600.0 |
| 2003-05-09 09:00:00 | AAPL | Stock | 0.3268 | 0.3286 | 0.3239 | 0.3266 | 122485608.0 |
| 2003-05-09 10:00:00 | AAPL | Stock | 0.3266 | 0.3271 | 0.3232 | 0.3245 | 85549296.0 |
| 2003-05-09 11:00:00 | AAPL | Stock | 0.3245 | 0.325 | 0.3193 | 0.3214 | 79268224.0 |
| 2003-05-09 12:00:00 | AAPL | Stock | 0.3214 | 0.3245 | 0.3214 | 0.3232 | 48945232.0 |
| 2003-05-09 13:00:00 | AAPL | Stock | 0.3232 | 0.3259 | 0.3223 | 0.325 | 40557664.0 |
| 2003-05-09 14:00:00 | AAPL | Stock | 0.3254 | 0.3261 | 0.3232 | 0.3246 | 31946656.0 |
| 2003-05-09 15:00:00 | AAPL | Stock | 0.3246 | 0.3268 | 0.3243 | 0.3259 | 71508248.0 |
| 2003-05-09 16:00:00 | AAPL | Stock | 0.3259 | 0.3268 | 0.3252 | 0.3264 | 1785840.0 |
| 2003-05-09 17:00:00 | AAPL | Stock | 0.3259 | 0.3263 | 0.3257 | 0.3257 | 313600.0 |
| 2003-05-09 18:00:00 | AAPL | Stock | 0.3257 | 0.3257 | 0.3257 | 0.3257 | 5600.0 |
| 2003-05-09 08:00:00 | MSFT | Stock | 25.96 | 25.98 | 25.9 | 25.95 | 80895.0 |
| 2003-05-09 09:00:00 | MSFT | Stock | 25.95 | 26.33 | 25.861 | 26.24 | 9232951.0 |
| 2003-05-09 10:00:00 | MSFT | Stock | 26.24 | 26.32 | 26.14 | 26.31 | 9049734.0 |
| 2003-05-09 11:00:00 | MSFT | Stock | 26.32 | 26.38 | 26.28 | 26.35 | 6129924.0 |
| 2003-05-09 12:00:00 | MSFT | Stock | 26.35 | 26.5 | 26.34 | 26.41 | 5477284.0 |
| 2003-05-09 13:00:00 | MSFT | Stock | 26.41 | 26.42 | 26.25 | 26.29 | 4401380.0 |
| 2003-05-09 14:00:00 | MSFT | Stock | 26.29 | 26.36 | 26.13 | 26.26 | 5384999.0 |
| 2003-05-09 15:00:00 | MSFT | Stock | 26.27 | 26.36 | 26.16 | 26.34 | 6231149.0 |
| 2003-05-09 16:00:00 | MSFT | Stock | 26.36 | 26.48 | 26.225 | 26.28 | 763681.0 |
| 2003-05-09 17:00:00 | MSFT | Stock | 26.28 | 26.36 | 26.27 | 26.32 | 55378.0 |
| 2003-05-09 18:00:00 | MSFT | Stock | 26.29 | 26.34 | 26.24 | 26.28 | 8450.0 |
| 2003-05-09 08:00:00 | NVDA | Stock | 0.1498 | 0.1585 | 0.1483 | 0.156 | 218286960.0 |
| 2003-05-09 09:00:00 | NVDA | Stock | 0.1561 | 0.1607 | 0.1542 | 0.1592 | 1498927920.0 |
| 2003-05-09 10:00:00 | NVDA | Stock | 0.1592 | 0.1616 | 0.1576 | 0.1614 | 991426440.0 |
| 2003-05-09 11:00:00 | NVDA | Stock | 0.1614 | 0.1682 | 0.1608 | 0.1674 | 1248423360.0 |
| 2003-05-09 12:00:00 | NVDA | Stock | 0.1675 | 0.1712 | 0.1661 | 0.167 | 1132439640.0 |
| 2003-05-09 13:00:00 | NVDA | Stock | 0.1669 | 0.1679 | 0.1662 | 0.1667 | 360446040.0 |
| 2003-05-09 14:00:00 | NVDA | Stock | 0.1667 | 0.1707 | 0.1661 | 0.1701 | 564903120.0 |
| 2003-05-09 15:00:00 | NVDA | Stock | 0.1703 | 0.1794 | 0.1695 | 0.1782 | 1706272320.0 |
| 2003-05-09 16:00:00 | NVDA | Stock | 0.1782 | 0.1817 | 0.1757 | 0.1795 | 165792240.0 |
| 2003-05-09 17:00:00 | NVDA | Stock | 0.1794 | 0.1808 | 0.178 | 0.1802 | 26506560.0 |
| 2003-05-09 18:00:00 | NVDA | Stock | 0.1802 | 0.1803 | 0.1792 | 0.1799 | 4855680.0 |
| 2003-05-09 08:00:00 | AMZN | Stock | 1.5225 | 1.5276 | 1.522 | 1.5275 | 140100.0 |
| 2003-05-09 09:00:00 | AMZN | Stock | 1.5275 | 1.54 | 1.517 | 1.531 | 13747360.0 |
| 2003-05-09 10:00:00 | AMZN | Stock | 1.5301 | 1.532 | 1.51 | 1.5295 | 25675020.0 |
| 2003-05-09 11:00:00 | AMZN | Stock | 1.5295 | 1.537 | 1.523 | 1.5295 | 18216840.0 |
| 2003-05-09 12:00:00 | AMZN | Stock | 1.5295 | 1.5445 | 1.5275 | 1.5425 | 13112020.0 |
| 2003-05-09 13:00:00 | AMZN | Stock | 1.5425 | 1.547 | 1.54 | 1.542 | 8133500.0 |
| 2003-05-09 14:00:00 | AMZN | Stock | 1.5415 | 1.5445 | 1.535 | 1.541 | 11090580.0 |
| 2003-05-09 15:00:00 | AMZN | Stock | 1.5415 | 1.5495 | 1.54 | 1.5485 | 12688040.0 |
| 2003-05-09 16:00:00 | AMZN | Stock | 1.5485 | 1.55 | 1.548 | 1.5485 | 652000.0 |
| 2003-05-09 17:00:00 | AMZN | Stock | 1.549 | 1.55 | 1.545 | 1.545 | 586500.0 |
| 2003-05-09 09:00:00 | CL | Stock | 28.53 | 28.59 | 28.5 | 28.505 | 295200.0 |
| 2003-05-09 10:00:00 | CL | Stock | 28.5 | 28.62 | 28.415 | 28.62 | 571600.0 |
| 2003-05-09 11:00:00 | CL | Stock | 28.62 | 28.7 | 28.62 | 28.645 | 253400.0 |
| 2003-05-09 12:00:00 | CL | Stock | 28.65 | 28.735 | 28.61 | 28.685 | 244200.0 |
| 2003-05-09 13:00:00 | CL | Stock | 28.685 | 28.7 | 28.635 | 28.665 | 171800.0 |
| 2003-05-09 14:00:00 | CL | Stock | 28.68 | 28.7 | 28.58 | 28.7 | 280200.0 |
| 2003-05-09 15:00:00 | CL | Stock | 28.7 | 28.7 | 28.615 | 28.685 | 372000.0 |
> showing 50 of 20,687 rows — these rows as CSV