PREVIEW / stock_1hour / 2024-09-03
file: by_date/stock_1hour/2024/2024-09-03.parquet size: 1.3 MB rows: 60,421 symbols: 843
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-03 04:00:00 | AAPL | Stock | 229.27 | 229.84 | 228.59 | 228.59 | 21807.0 |
| 2024-09-03 05:00:00 | AAPL | Stock | 228.57 | 228.68 | 227.8 | 228.47 | 16283.0 |
| 2024-09-03 06:00:00 | AAPL | Stock | 228.29 | 228.36 | 228.02 | 228.21 | 4732.0 |
| 2024-09-03 07:00:00 | AAPL | Stock | 228.14 | 228.48 | 227.57 | 227.84 | 36985.0 |
| 2024-09-03 08:00:00 | AAPL | Stock | 227.85 | 229.7 | 227.4297 | 228.06 | 107360.0 |
| 2024-09-03 09:00:00 | AAPL | Stock | 227.9207 | 229.0 | 225.3 | 226.16 | 5245999.0 |
| 2024-09-03 10:00:00 | AAPL | Stock | 226.19 | 226.48 | 223.51 | 223.645 | 4905446.0 |
| 2024-09-03 11:00:00 | AAPL | Stock | 223.65 | 224.67 | 223.27 | 223.54 | 3094347.0 |
| 2024-09-03 12:00:00 | AAPL | Stock | 223.55 | 224.32 | 223.34 | 223.71 | 2245287.0 |
| 2024-09-03 13:00:00 | AAPL | Stock | 223.72 | 224.15 | 223.18 | 223.21 | 1967720.0 |
| 2024-09-03 14:00:00 | AAPL | Stock | 223.24 | 223.3 | 221.82 | 221.935 | 3537184.0 |
| 2024-09-03 15:00:00 | AAPL | Stock | 221.945 | 222.8 | 221.17 | 222.76 | 6970839.0 |
| 2024-09-03 16:00:00 | AAPL | Stock | 222.77 | 222.77 | 221.71 | 222.0 | 9225649.0 |
| 2024-09-03 17:00:00 | AAPL | Stock | 222.0 | 222.77 | 221.03 | 221.21 | 309598.0 |
| 2024-09-03 18:00:00 | AAPL | Stock | 221.47 | 221.55 | 220.75 | 220.89 | 72508.0 |
| 2024-09-03 19:00:00 | AAPL | Stock | 220.9 | 220.9545 | 220.23 | 220.8519 | 73466.0 |
| 2024-09-03 04:00:00 | MSFT | Stock | 418.0 | 418.13 | 416.33 | 416.34 | 4203.0 |
| 2024-09-03 05:00:00 | MSFT | Stock | 415.8 | 416.84 | 414.21 | 415.79 | 9031.0 |
| 2024-09-03 06:00:00 | MSFT | Stock | 415.2 | 415.85 | 415.02 | 415.7 | 3522.0 |
| 2024-09-03 07:00:00 | MSFT | Stock | 415.83 | 416.58 | 415.39 | 416.5 | 6435.0 |
| 2024-09-03 08:00:00 | MSFT | Stock | 415.45 | 418.182 | 415.11 | 416.0725 | 19793.0 |
| 2024-09-03 09:00:00 | MSFT | Stock | 416.27 | 419.88 | 415.34 | 418.21 | 1442866.0 |
| 2024-09-03 10:00:00 | MSFT | Stock | 418.15 | 418.5 | 413.05 | 413.4 | 1447443.0 |
| 2024-09-03 11:00:00 | MSFT | Stock | 413.505 | 414.11 | 411.5101 | 411.6 | 858323.0 |
| 2024-09-03 12:00:00 | MSFT | Stock | 411.63 | 413.21 | 410.88 | 411.21 | 679437.0 |
| 2024-09-03 13:00:00 | MSFT | Stock | 411.22 | 412.03 | 410.855 | 410.97 | 515289.0 |
| 2024-09-03 14:00:00 | MSFT | Stock | 411.01 | 411.1 | 408.89 | 410.04 | 888718.0 |
| 2024-09-03 15:00:00 | MSFT | Stock | 410.02 | 410.565 | 407.03 | 409.54 | 2043782.0 |
| 2024-09-03 16:00:00 | MSFT | Stock | 409.485 | 410.0 | 408.0 | 409.01 | 5734633.0 |
| 2024-09-03 17:00:00 | MSFT | Stock | 409.0 | 409.44 | 408.8138 | 408.9006 | 50025.0 |
| 2024-09-03 18:00:00 | MSFT | Stock | 409.0 | 409.4 | 407.97 | 408.5 | 10390.0 |
| 2024-09-03 19:00:00 | MSFT | Stock | 408.6 | 408.88 | 407.7 | 408.4 | 5197.0 |
| 2024-09-03 04:00:00 | NVDA | Stock | 119.23 | 119.5 | 116.86 | 116.96 | 996265.0 |
| 2024-09-03 05:00:00 | NVDA | Stock | 116.92 | 117.2 | 116.48 | 116.66 | 864363.0 |
| 2024-09-03 06:00:00 | NVDA | Stock | 116.61 | 117.26 | 116.4 | 117.21 | 506184.0 |
| 2024-09-03 07:00:00 | NVDA | Stock | 117.25 | 117.4 | 116.52 | 116.98 | 1251599.0 |
| 2024-09-03 08:00:00 | NVDA | Stock | 116.96 | 119.39 | 116.5019 | 116.65 | 2706796.0 |
| 2024-09-03 09:00:00 | NVDA | Stock | 116.64 | 116.8 | 112.01 | 112.91 | 60594168.0 |
| 2024-09-03 10:00:00 | NVDA | Stock | 112.93 | 113.5258 | 109.61 | 109.765 | 81864661.0 |
| 2024-09-03 11:00:00 | NVDA | Stock | 109.77 | 111.68 | 109.395 | 110.36 | 47739626.0 |
| 2024-09-03 12:00:00 | NVDA | Stock | 110.3502 | 110.84 | 109.8 | 110.17 | 34425708.0 |
| 2024-09-03 13:00:00 | NVDA | Stock | 110.175 | 110.725 | 109.57 | 109.585 | 26333146.0 |
| 2024-09-03 14:00:00 | NVDA | Stock | 109.59 | 109.64 | 108.01 | 108.82 | 50219364.0 |
| 2024-09-03 15:00:00 | NVDA | Stock | 108.818 | 109.21 | 107.29 | 108.02 | 64042774.0 |
| 2024-09-03 16:00:00 | NVDA | Stock | 108.03 | 108.05 | 105.15 | 105.47 | 44224628.0 |
| 2024-09-03 17:00:00 | NVDA | Stock | 105.47 | 108.0 | 105.32 | 106.369 | 3205917.0 |
| 2024-09-03 18:00:00 | NVDA | Stock | 106.36 | 106.49 | 106.05 | 106.09 | 1390064.0 |
| 2024-09-03 19:00:00 | NVDA | Stock | 106.08 | 106.09 | 105.39 | 105.3916 | 1645561.0 |
| 2024-09-03 04:00:00 | AMZN | Stock | 178.5 | 178.52 | 177.8 | 177.8 | 20539.0 |
| 2024-09-03 05:00:00 | AMZN | Stock | 177.64 | 177.75 | 177.05 | 177.5 | 11602.0 |
> showing 50 of 60,421 rows — these rows as CSV