PREVIEW / stock_1hour / 2024-09-05
file: by_date/stock_1hour/2024/2024-09-05.parquet size: 1.3 MB rows: 57,688 symbols: 841
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-05 04:00:00 | AAPL | Stock | 220.2 | 220.5 | 220.12 | 220.49 | 9916.0 |
| 2024-09-05 05:00:00 | AAPL | Stock | 220.44 | 220.44 | 219.89 | 220.1 | 5665.0 |
| 2024-09-05 06:00:00 | AAPL | Stock | 220.17 | 221.37 | 219.95 | 221.2 | 28744.0 |
| 2024-09-05 07:00:00 | AAPL | Stock | 221.1 | 221.39 | 220.39 | 220.44 | 23945.0 |
| 2024-09-05 08:00:00 | AAPL | Stock | 221.2 | 221.39 | 219.15 | 220.36 | 166132.0 |
| 2024-09-05 09:00:00 | AAPL | Stock | 220.29 | 224.92 | 220.2595 | 224.71 | 5342793.0 |
| 2024-09-05 10:00:00 | AAPL | Stock | 224.71 | 225.48 | 223.63 | 223.7 | 4274321.0 |
| 2024-09-05 11:00:00 | AAPL | Stock | 223.7 | 223.87 | 221.88 | 221.97 | 3051249.0 |
| 2024-09-05 12:00:00 | AAPL | Stock | 221.98 | 223.15 | 221.9562 | 222.825 | 1894069.0 |
| 2024-09-05 13:00:00 | AAPL | Stock | 222.835 | 223.74 | 222.34 | 223.61 | 1876370.0 |
| 2024-09-05 14:00:00 | AAPL | Stock | 223.63 | 223.9 | 223.17 | 223.32 | 1806300.0 |
| 2024-09-05 15:00:00 | AAPL | Stock | 223.33 | 223.4 | 221.8101 | 222.38 | 3554290.0 |
| 2024-09-05 16:00:00 | AAPL | Stock | 222.38 | 222.79 | 221.62 | 222.37 | 3879797.0 |
| 2024-09-05 17:00:00 | AAPL | Stock | 222.3106 | 222.5 | 222.1931 | 222.35 | 29235.0 |
| 2024-09-05 18:00:00 | AAPL | Stock | 222.35 | 222.49 | 222.032 | 222.3219 | 20680.0 |
| 2024-09-05 19:00:00 | AAPL | Stock | 222.41 | 222.41 | 222.15 | 222.21 | 23049.0 |
| 2024-09-05 04:00:00 | MSFT | Stock | 409.19 | 409.5 | 408.18 | 408.18 | 2282.0 |
| 2024-09-05 05:00:00 | MSFT | Stock | 408.0 | 408.0 | 406.49 | 407.3 | 2308.0 |
| 2024-09-05 06:00:00 | MSFT | Stock | 407.8 | 407.9 | 407.26 | 407.9 | 2747.0 |
| 2024-09-05 07:00:00 | MSFT | Stock | 408.0 | 408.1 | 406.6 | 406.67 | 4892.0 |
| 2024-09-05 08:00:00 | MSFT | Stock | 408.0 | 408.3 | 405.72 | 406.9 | 29386.0 |
| 2024-09-05 09:00:00 | MSFT | Stock | 406.9 | 413.0883 | 405.25 | 411.45 | 1175627.0 |
| 2024-09-05 10:00:00 | MSFT | Stock | 411.43 | 413.1 | 409.31 | 409.43 | 1274113.0 |
| 2024-09-05 11:00:00 | MSFT | Stock | 409.4412 | 410.06 | 406.84 | 407.05 | 909681.0 |
| 2024-09-05 12:00:00 | MSFT | Stock | 406.98 | 407.75 | 406.13 | 407.05 | 668674.0 |
| 2024-09-05 13:00:00 | MSFT | Stock | 407.02 | 409.19 | 406.24 | 409.19 | 627470.0 |
| 2024-09-05 14:00:00 | MSFT | Stock | 409.23 | 409.415 | 407.71 | 407.8198 | 601964.0 |
| 2024-09-05 15:00:00 | MSFT | Stock | 407.81 | 408.65 | 406.29 | 408.4 | 1415355.0 |
| 2024-09-05 16:00:00 | MSFT | Stock | 408.39 | 408.39 | 406.85 | 407.39 | 2018758.0 |
| 2024-09-05 17:00:00 | MSFT | Stock | 406.903 | 408.39 | 406.903 | 407.75 | 18778.0 |
| 2024-09-05 18:00:00 | MSFT | Stock | 407.97 | 408.26 | 407.0324 | 407.6137 | 4255.0 |
| 2024-09-05 19:00:00 | MSFT | Stock | 407.32 | 408.24 | 407.13 | 408.19 | 6134.0 |
| 2024-09-05 04:00:00 | NVDA | Stock | 107.16 | 107.66 | 107.03 | 107.19 | 466125.0 |
| 2024-09-05 05:00:00 | NVDA | Stock | 107.2 | 107.21 | 106.11 | 106.73 | 371722.0 |
| 2024-09-05 06:00:00 | NVDA | Stock | 106.73 | 106.94 | 106.42 | 106.66 | 288257.0 |
| 2024-09-05 07:00:00 | NVDA | Stock | 106.66 | 107.06 | 106.12 | 106.28 | 977858.0 |
| 2024-09-05 08:00:00 | NVDA | Stock | 106.71 | 107.6036 | 104.16 | 105.323 | 5809392.0 |
| 2024-09-05 09:00:00 | NVDA | Stock | 105.35 | 108.99 | 104.76 | 108.86 | 52541846.0 |
| 2024-09-05 10:00:00 | NVDA | Stock | 108.88 | 109.65 | 107.65 | 107.68 | 54625650.0 |
| 2024-09-05 11:00:00 | NVDA | Stock | 107.69 | 107.83 | 106.07 | 106.335 | 39847424.0 |
| 2024-09-05 12:00:00 | NVDA | Stock | 106.34 | 107.7051 | 106.285 | 106.94 | 25929273.0 |
| 2024-09-05 13:00:00 | NVDA | Stock | 106.94 | 107.6 | 106.29 | 107.565 | 19597465.0 |
| 2024-09-05 14:00:00 | NVDA | Stock | 107.57 | 107.75 | 106.76 | 107.215 | 20715477.0 |
| 2024-09-05 15:00:00 | NVDA | Stock | 107.23 | 107.4 | 106.37 | 107.24 | 26123728.0 |
| 2024-09-05 16:00:00 | NVDA | Stock | 107.24 | 107.61 | 106.05 | 106.55 | 13884778.0 |
| 2024-09-05 17:00:00 | NVDA | Stock | 106.52 | 107.21 | 106.35 | 106.58 | 717829.0 |
| 2024-09-05 18:00:00 | NVDA | Stock | 106.59 | 106.74 | 106.4 | 106.44 | 433332.0 |
| 2024-09-05 19:00:00 | NVDA | Stock | 106.44 | 106.44 | 106.14 | 106.35 | 660563.0 |
| 2024-09-05 04:00:00 | AMZN | Stock | 173.71 | 173.8 | 173.32 | 173.47 | 9959.0 |
| 2024-09-05 05:00:00 | AMZN | Stock | 173.45 | 173.45 | 172.58 | 173.0 | 13917.0 |
> showing 50 of 57,688 rows — these rows as CSV