PREVIEW / stock_1hour / 2024-08-07
file: by_date/stock_1hour/2024/2024-08-07.parquet size: 1.3 MB rows: 59,439 symbols: 879
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-08-07 04:00:00 | AAPL | Stock | 208.3 | 208.85 | 207.12 | 208.33 | 38722.0 |
| 2024-08-07 05:00:00 | AAPL | Stock | 208.31 | 209.39 | 208.31 | 208.44 | 26269.0 |
| 2024-08-07 06:00:00 | AAPL | Stock | 208.5 | 209.27 | 208.24 | 209.27 | 18550.0 |
| 2024-08-07 07:00:00 | AAPL | Stock | 208.91 | 209.35 | 207.8 | 207.95 | 88511.0 |
| 2024-08-07 08:00:00 | AAPL | Stock | 208.8 | 209.3 | 207.6 | 208.0799 | 126035.0 |
| 2024-08-07 09:00:00 | AAPL | Stock | 208.03 | 212.43 | 206.32 | 212.4 | 6487261.0 |
| 2024-08-07 10:00:00 | AAPL | Stock | 212.43 | 213.47 | 210.81 | 213.15 | 6502951.0 |
| 2024-08-07 11:00:00 | AAPL | Stock | 213.18 | 213.64 | 211.96 | 212.5799 | 4450174.0 |
| 2024-08-07 12:00:00 | AAPL | Stock | 212.5799 | 212.97 | 211.18 | 211.555 | 3345254.0 |
| 2024-08-07 13:00:00 | AAPL | Stock | 211.54 | 211.85 | 210.35 | 210.93 | 3849652.0 |
| 2024-08-07 14:00:00 | AAPL | Stock | 210.9 | 211.28 | 208.89 | 208.94 | 4469862.0 |
| 2024-08-07 15:00:00 | AAPL | Stock | 208.945 | 210.99 | 208.48 | 209.86 | 6610217.0 |
| 2024-08-07 16:00:00 | AAPL | Stock | 209.87 | 209.93 | 208.71 | 208.71 | 6633558.0 |
| 2024-08-07 17:00:00 | AAPL | Stock | 208.63 | 209.82 | 208.09 | 208.39 | 52437.0 |
| 2024-08-07 18:00:00 | AAPL | Stock | 208.39 | 209.34 | 208.3584 | 208.9 | 45268.0 |
| 2024-08-07 19:00:00 | AAPL | Stock | 208.71 | 209.0 | 207.63 | 208.25 | 47283.0 |
| 2024-08-07 04:00:00 | MSFT | Stock | 401.47 | 404.62 | 401.47 | 404.62 | 10306.0 |
| 2024-08-07 05:00:00 | MSFT | Stock | 404.75 | 406.6 | 404.36 | 405.65 | 10647.0 |
| 2024-08-07 06:00:00 | MSFT | Stock | 405.92 | 407.09 | 405.92 | 407.0 | 8755.0 |
| 2024-08-07 07:00:00 | MSFT | Stock | 406.61 | 407.2 | 406.07 | 406.15 | 23139.0 |
| 2024-08-07 08:00:00 | MSFT | Stock | 406.58 | 409.48 | 401.93 | 408.35 | 62061.0 |
| 2024-08-07 09:00:00 | MSFT | Stock | 408.05 | 409.39 | 406.93 | 408.9184 | 1565203.0 |
| 2024-08-07 10:00:00 | MSFT | Stock | 408.93 | 410.08 | 407.43 | 408.43 | 1421916.0 |
| 2024-08-07 11:00:00 | MSFT | Stock | 408.445 | 408.67 | 404.65 | 405.71 | 1114887.0 |
| 2024-08-07 12:00:00 | MSFT | Stock | 405.74 | 405.77 | 401.31 | 401.88 | 1106442.0 |
| 2024-08-07 13:00:00 | MSFT | Stock | 401.87 | 402.38 | 399.88 | 400.318 | 1454271.0 |
| 2024-08-07 14:00:00 | MSFT | Stock | 400.29 | 400.625 | 398.26 | 398.85 | 1319289.0 |
| 2024-08-07 15:00:00 | MSFT | Stock | 398.84 | 401.05 | 397.47 | 398.34 | 2002755.0 |
| 2024-08-07 16:00:00 | MSFT | Stock | 398.4 | 398.45 | 395.19 | 395.96 | 2764735.0 |
| 2024-08-07 17:00:00 | MSFT | Stock | 395.9615 | 398.43 | 395.3343 | 396.8 | 8748.0 |
| 2024-08-07 18:00:00 | MSFT | Stock | 396.0433 | 397.7627 | 396.0433 | 397.19 | 4573.0 |
| 2024-08-07 19:00:00 | MSFT | Stock | 397.19 | 397.19 | 393.88 | 394.07 | 16664.0 |
| 2024-08-07 04:00:00 | NVDA | Stock | 104.3 | 106.13 | 103.16 | 105.72 | 1501187.0 |
| 2024-08-07 05:00:00 | NVDA | Stock | 105.78 | 105.79 | 105.05 | 105.71 | 547640.0 |
| 2024-08-07 06:00:00 | NVDA | Stock | 105.75 | 106.12 | 105.26 | 105.95 | 509047.0 |
| 2024-08-07 07:00:00 | NVDA | Stock | 105.91 | 107.12 | 105.78 | 106.27 | 2028380.0 |
| 2024-08-07 08:00:00 | NVDA | Stock | 106.1 | 107.1196 | 104.11 | 106.9 | 3737289.0 |
| 2024-08-07 09:00:00 | NVDA | Stock | 106.9 | 108.8 | 105.72 | 106.44 | 51922092.0 |
| 2024-08-07 10:00:00 | NVDA | Stock | 106.445 | 107.06 | 104.29 | 105.445 | 53121964.0 |
| 2024-08-07 11:00:00 | NVDA | Stock | 105.445 | 106.18 | 103.51 | 104.1581 | 36484379.0 |
| 2024-08-07 12:00:00 | NVDA | Stock | 104.16 | 104.3 | 102.57 | 103.005 | 33875880.0 |
| 2024-08-07 13:00:00 | NVDA | Stock | 102.97 | 103.24 | 100.75 | 101.0303 | 37301624.0 |
| 2024-08-07 14:00:00 | NVDA | Stock | 101.0379 | 101.4 | 99.26 | 99.7607 | 50868907.0 |
| 2024-08-07 15:00:00 | NVDA | Stock | 99.76 | 101.39 | 98.69 | 98.75 | 57060078.0 |
| 2024-08-07 16:00:00 | NVDA | Stock | 98.75 | 99.4494 | 98.01 | 98.1 | 23954977.0 |
| 2024-08-07 17:00:00 | NVDA | Stock | 98.1 | 98.91 | 97.4 | 98.0 | 2795253.0 |
| 2024-08-07 18:00:00 | NVDA | Stock | 98.02 | 98.66 | 97.94 | 98.53 | 1083537.0 |
| 2024-08-07 19:00:00 | NVDA | Stock | 98.55 | 98.61 | 97.15 | 97.65 | 1609564.0 |
| 2024-08-07 04:00:00 | AMZN | Stock | 164.11 | 164.5 | 163.16 | 164.5 | 29014.0 |
| 2024-08-07 05:00:00 | AMZN | Stock | 164.69 | 164.9 | 164.33 | 164.89 | 21309.0 |
> showing 50 of 59,439 rows — these rows as CSV