PREVIEW / stock_1hour / 2024-03-13
file: by_date/stock_1hour/2024/2024-03-13.parquet size: 1.4 MB rows: 60,194 symbols: 1,095
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-03-13 04:00:00 | AAPL | Stock | 173.31 | 173.31 | 172.85 | 173.08 | 4708.0 |
| 2024-03-13 05:00:00 | AAPL | Stock | 173.0 | 173.07 | 172.85 | 173.05 | 6072.0 |
| 2024-03-13 06:00:00 | AAPL | Stock | 173.08 | 173.23 | 173.07 | 173.23 | 4327.0 |
| 2024-03-13 07:00:00 | AAPL | Stock | 173.22 | 173.23 | 172.74 | 172.81 | 28814.0 |
| 2024-03-13 08:00:00 | AAPL | Stock | 173.2297 | 173.34 | 172.4101 | 173.06 | 105487.0 |
| 2024-03-13 09:00:00 | AAPL | Stock | 173.07 | 173.5 | 171.56 | 171.6653 | 5123654.0 |
| 2024-03-13 10:00:00 | AAPL | Stock | 171.67 | 171.7 | 170.76 | 171.04 | 7348721.0 |
| 2024-03-13 11:00:00 | AAPL | Stock | 171.035 | 171.21 | 170.865 | 171.0301 | 3952210.0 |
| 2024-03-13 12:00:00 | AAPL | Stock | 171.04 | 171.14 | 170.8527 | 171.015 | 3019206.0 |
| 2024-03-13 13:00:00 | AAPL | Stock | 171.015 | 171.53 | 171.01 | 171.5 | 3767490.0 |
| 2024-03-13 14:00:00 | AAPL | Stock | 171.4998 | 171.8 | 171.44 | 171.65 | 2899620.0 |
| 2024-03-13 15:00:00 | AAPL | Stock | 171.65 | 171.74 | 171.03 | 171.17 | 6869833.0 |
| 2024-03-13 16:00:00 | AAPL | Stock | 171.175 | 172.322 | 170.98 | 171.13 | 8046570.0 |
| 2024-03-13 17:00:00 | AAPL | Stock | 171.3 | 171.3 | 171.0206 | 171.0206 | 103387.0 |
| 2024-03-13 18:00:00 | AAPL | Stock | 171.11 | 171.4 | 171.11 | 171.2545 | 28144.0 |
| 2024-03-13 19:00:00 | AAPL | Stock | 171.27 | 171.58 | 171.21 | 171.5 | 16377.0 |
| 2024-03-13 04:00:00 | MSFT | Stock | 415.99 | 415.99 | 414.97 | 415.0 | 2382.0 |
| 2024-03-13 05:00:00 | MSFT | Stock | 415.0 | 415.0 | 414.81 | 414.99 | 2233.0 |
| 2024-03-13 06:00:00 | MSFT | Stock | 414.9 | 416.63 | 414.9 | 416.63 | 5230.0 |
| 2024-03-13 07:00:00 | MSFT | Stock | 416.55 | 418.86 | 416.55 | 417.75 | 37562.0 |
| 2024-03-13 08:00:00 | MSFT | Stock | 418.33 | 418.65 | 415.66 | 417.7 | 55342.0 |
| 2024-03-13 09:00:00 | MSFT | Stock | 417.75 | 418.61 | 412.0 | 412.2999 | 2077536.0 |
| 2024-03-13 10:00:00 | MSFT | Stock | 412.3 | 414.88 | 411.45 | 414.11 | 1659135.0 |
| 2024-03-13 11:00:00 | MSFT | Stock | 414.11 | 415.287 | 413.74 | 414.85 | 864346.0 |
| 2024-03-13 12:00:00 | MSFT | Stock | 414.86 | 415.53 | 414.46 | 415.1624 | 662276.0 |
| 2024-03-13 13:00:00 | MSFT | Stock | 415.145 | 416.1031 | 414.97 | 415.77 | 652828.0 |
| 2024-03-13 14:00:00 | MSFT | Stock | 415.77 | 416.63 | 415.4801 | 416.055 | 792520.0 |
| 2024-03-13 15:00:00 | MSFT | Stock | 416.0733 | 416.2 | 413.91 | 415.23 | 1525046.0 |
| 2024-03-13 16:00:00 | MSFT | Stock | 415.1 | 416.0 | 414.8 | 415.1 | 3222993.0 |
| 2024-03-13 17:00:00 | MSFT | Stock | 415.7502 | 415.97 | 415.1 | 415.9 | 7179.0 |
| 2024-03-13 18:00:00 | MSFT | Stock | 416.0 | 417.5 | 416.0 | 417.2535 | 10370.0 |
| 2024-03-13 19:00:00 | MSFT | Stock | 417.0 | 417.2 | 416.7 | 417.2 | 8415.0 |
| 2024-03-13 04:00:00 | NVDA | Stock | 93.6 | 93.634 | 92.058 | 92.7 | 1017330.0 |
| 2024-03-13 05:00:00 | NVDA | Stock | 92.601 | 92.92 | 92.545 | 92.775 | 259230.0 |
| 2024-03-13 06:00:00 | NVDA | Stock | 92.8 | 92.845 | 92.164 | 92.65 | 465230.0 |
| 2024-03-13 07:00:00 | NVDA | Stock | 92.64 | 93.167 | 92.6 | 92.819 | 1484930.0 |
| 2024-03-13 08:00:00 | NVDA | Stock | 92.863 | 93.8 | 90.476 | 90.995 | 8218020.0 |
| 2024-03-13 09:00:00 | NVDA | Stock | 90.98 | 91.4777 | 88.48 | 88.9485 | 90871930.0 |
| 2024-03-13 10:00:00 | NVDA | Stock | 88.949 | 90.048 | 88.435 | 89.432 | 82359960.0 |
| 2024-03-13 11:00:00 | NVDA | Stock | 89.437 | 89.882 | 88.619 | 89.309 | 49587100.0 |
| 2024-03-13 12:00:00 | NVDA | Stock | 89.3238 | 89.42 | 88.75 | 89.325 | 32586270.0 |
| 2024-03-13 13:00:00 | NVDA | Stock | 89.321 | 90.77 | 89.305 | 90.3368 | 53503200.0 |
| 2024-03-13 14:00:00 | NVDA | Stock | 90.327 | 90.877 | 89.83 | 90.5228 | 39648850.0 |
| 2024-03-13 15:00:00 | NVDA | Stock | 90.502 | 91.504 | 90.3138 | 90.926 | 67818010.0 |
| 2024-03-13 16:00:00 | NVDA | Stock | 90.925 | 91.2 | 90.358 | 90.616 | 20336870.0 |
| 2024-03-13 17:00:00 | NVDA | Stock | 90.64 | 90.888 | 89.822 | 90.115 | 1276910.0 |
| 2024-03-13 18:00:00 | NVDA | Stock | 90.08 | 90.574 | 90.08 | 90.39 | 871510.0 |
| 2024-03-13 19:00:00 | NVDA | Stock | 90.385 | 90.8 | 90.356 | 90.5 | 1143330.0 |
| 2024-03-13 04:00:00 | AMZN | Stock | 175.38 | 175.79 | 174.9 | 174.93 | 7201.0 |
| 2024-03-13 05:00:00 | AMZN | Stock | 175.0 | 175.11 | 174.95 | 175.1 | 5323.0 |
> showing 50 of 60,194 rows — these rows as CSV