PREVIEW / stock_1hour / 2024-03-04
file: by_date/stock_1hour/2024/2024-03-04.parquet size: 1.4 MB rows: 62,466 symbols: 1,141
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-04 04:00:00 | AAPL | Stock | 179.93 | 179.93 | 178.49 | 178.6 | 22245.0 |
| 2024-03-04 05:00:00 | AAPL | Stock | 178.56 | 178.62 | 178.47 | 178.62 | 13541.0 |
| 2024-03-04 06:00:00 | AAPL | Stock | 178.5 | 178.5 | 178.19 | 178.48 | 13657.0 |
| 2024-03-04 07:00:00 | AAPL | Stock | 178.47 | 178.54 | 176.7 | 176.7 | 194994.0 |
| 2024-03-04 08:00:00 | AAPL | Stock | 178.36 | 179.42 | 176.63 | 176.81 | 586164.0 |
| 2024-03-04 09:00:00 | AAPL | Stock | 176.8 | 177.59 | 174.62 | 174.97 | 11787386.0 |
| 2024-03-04 10:00:00 | AAPL | Stock | 174.96 | 175.0 | 173.9 | 174.83 | 11734027.0 |
| 2024-03-04 11:00:00 | AAPL | Stock | 174.835 | 175.02 | 174.1 | 174.1201 | 7067896.0 |
| 2024-03-04 12:00:00 | AAPL | Stock | 174.1112 | 174.7 | 174.01 | 174.05 | 5787993.0 |
| 2024-03-04 13:00:00 | AAPL | Stock | 174.05 | 174.505 | 173.79 | 174.205 | 6357588.0 |
| 2024-03-04 14:00:00 | AAPL | Stock | 174.2 | 175.645 | 173.98 | 175.325 | 6575693.0 |
| 2024-03-04 15:00:00 | AAPL | Stock | 175.325 | 175.5 | 174.95 | 175.09 | 8429898.0 |
| 2024-03-04 16:00:00 | AAPL | Stock | 175.05 | 175.2 | 174.9 | 174.97 | 5676786.0 |
| 2024-03-04 17:00:00 | AAPL | Stock | 174.97 | 175.1 | 174.91 | 174.92 | 142181.0 |
| 2024-03-04 18:00:00 | AAPL | Stock | 174.95 | 174.95 | 174.61 | 174.61 | 42704.0 |
| 2024-03-04 19:00:00 | AAPL | Stock | 174.67 | 174.67 | 174.5 | 174.6 | 32618.0 |
| 2024-03-04 04:00:00 | MSFT | Stock | 414.6 | 415.3 | 414.53 | 414.61 | 5625.0 |
| 2024-03-04 05:00:00 | MSFT | Stock | 414.66 | 414.66 | 414.44 | 414.44 | 1920.0 |
| 2024-03-04 06:00:00 | MSFT | Stock | 413.85 | 413.85 | 413.0 | 413.78 | 3861.0 |
| 2024-03-04 07:00:00 | MSFT | Stock | 414.19 | 414.24 | 413.5 | 413.5 | 10982.0 |
| 2024-03-04 08:00:00 | MSFT | Stock | 414.05 | 416.538 | 413.43 | 413.6699 | 43732.0 |
| 2024-03-04 09:00:00 | MSFT | Stock | 413.6 | 416.25 | 412.0 | 416.11 | 2272057.0 |
| 2024-03-04 10:00:00 | MSFT | Stock | 416.13 | 417.35 | 414.28 | 415.89 | 1792447.0 |
| 2024-03-04 11:00:00 | MSFT | Stock | 415.9 | 416.12 | 414.9 | 416.05 | 890633.0 |
| 2024-03-04 12:00:00 | MSFT | Stock | 416.065 | 416.55 | 415.6564 | 415.93 | 737033.0 |
| 2024-03-04 13:00:00 | MSFT | Stock | 415.93 | 416.05 | 414.9 | 415.6199 | 648192.0 |
| 2024-03-04 14:00:00 | MSFT | Stock | 415.6 | 415.66 | 414.58 | 415.14 | 878668.0 |
| 2024-03-04 15:00:00 | MSFT | Stock | 415.15 | 415.81 | 414.58 | 414.86 | 1460757.0 |
| 2024-03-04 16:00:00 | MSFT | Stock | 414.77 | 414.92 | 414.09 | 414.3762 | 2454057.0 |
| 2024-03-04 17:00:00 | MSFT | Stock | 414.08 | 414.49 | 414.0224 | 414.49 | 2450.0 |
| 2024-03-04 18:00:00 | MSFT | Stock | 414.3 | 414.35 | 413.75 | 413.75 | 2597.0 |
| 2024-03-04 19:00:00 | MSFT | Stock | 413.8 | 414.1 | 413.5 | 413.6 | 5381.0 |
| 2024-03-04 04:00:00 | NVDA | Stock | 83.212 | 83.749 | 83.035 | 83.2 | 567280.0 |
| 2024-03-04 05:00:00 | NVDA | Stock | 83.179 | 83.35 | 83.162 | 83.305 | 174630.0 |
| 2024-03-04 06:00:00 | NVDA | Stock | 83.35 | 83.45 | 83.194 | 83.4 | 160430.0 |
| 2024-03-04 07:00:00 | NVDA | Stock | 83.406 | 84.155 | 83.35 | 84.052 | 2271210.0 |
| 2024-03-04 08:00:00 | NVDA | Stock | 83.498 | 84.398 | 83.201 | 84.2 | 4866660.0 |
| 2024-03-04 09:00:00 | NVDA | Stock | 84.212 | 85.386 | 83.719 | 84.495 | 81553360.0 |
| 2024-03-04 10:00:00 | NVDA | Stock | 84.498 | 85.545 | 84.229 | 85.36 | 61737010.0 |
| 2024-03-04 11:00:00 | NVDA | Stock | 85.36 | 85.494 | 84.911 | 85.333 | 33528710.0 |
| 2024-03-04 12:00:00 | NVDA | Stock | 85.3571 | 86.695 | 85.242 | 86.574 | 45297500.0 |
| 2024-03-04 13:00:00 | NVDA | Stock | 86.5819 | 87.045 | 86.267 | 86.95 | 45247480.0 |
| 2024-03-04 14:00:00 | NVDA | Stock | 86.9507 | 87.695 | 86.714 | 87.204 | 52864070.0 |
| 2024-03-04 15:00:00 | NVDA | Stock | 87.214 | 87.282 | 84.7999 | 85.251 | 82550080.0 |
| 2024-03-04 16:00:00 | NVDA | Stock | 85.237 | 85.777 | 84.6 | 85.5 | 18955640.0 |
| 2024-03-04 17:00:00 | NVDA | Stock | 85.49 | 85.78 | 85.237 | 85.74 | 1650250.0 |
| 2024-03-04 18:00:00 | NVDA | Stock | 85.74 | 86.174 | 85.74 | 85.91 | 1619750.0 |
| 2024-03-04 19:00:00 | NVDA | Stock | 85.949 | 86.0 | 85.755 | 85.795 | 897660.0 |
| 2024-03-04 04:00:00 | AMZN | Stock | 178.63 | 178.8 | 178.41 | 178.47 | 7831.0 |
| 2024-03-04 05:00:00 | AMZN | Stock | 178.34 | 178.43 | 178.26 | 178.41 | 1762.0 |
> showing 50 of 62,466 rows — these rows as CSV