PREVIEW / stock_1hour / 2024-11-06
file: by_date/stock_1hour/2024/2024-11-06.parquet size: 1.5 MB rows: 65,994 symbols: 717
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-11-06 04:00:00 | AAPL | Stock | 226.9 | 226.9 | 223.66 | 224.49 | 67646.0 |
| 2024-11-06 05:00:00 | AAPL | Stock | 224.31 | 224.31 | 223.31 | 223.31 | 69704.0 |
| 2024-11-06 06:00:00 | AAPL | Stock | 223.49 | 223.6 | 222.41 | 223.0 | 75839.0 |
| 2024-11-06 07:00:00 | AAPL | Stock | 223.0 | 224.6 | 223.0 | 224.0 | 176377.0 |
| 2024-11-06 08:00:00 | AAPL | Stock | 224.05 | 228.78 | 222.892 | 223.95 | 349405.0 |
| 2024-11-06 09:00:00 | AAPL | Stock | 223.81 | 225.64 | 221.19 | 224.45 | 7751765.0 |
| 2024-11-06 10:00:00 | AAPL | Stock | 224.48 | 226.065 | 223.94 | 224.21 | 5221984.0 |
| 2024-11-06 11:00:00 | AAPL | Stock | 224.205 | 225.185 | 223.69 | 224.67 | 3322206.0 |
| 2024-11-06 12:00:00 | AAPL | Stock | 224.665 | 224.68 | 223.965 | 224.35 | 2812852.0 |
| 2024-11-06 13:00:00 | AAPL | Stock | 224.35 | 224.56 | 223.845 | 223.915 | 2017360.0 |
| 2024-11-06 14:00:00 | AAPL | Stock | 223.92 | 224.09 | 223.26 | 223.4101 | 2483984.0 |
| 2024-11-06 15:00:00 | AAPL | Stock | 223.42 | 224.225 | 222.5 | 222.7 | 5570924.0 |
| 2024-11-06 16:00:00 | AAPL | Stock | 222.71 | 223.41 | 222.36 | 223.17 | 9224109.0 |
| 2024-11-06 17:00:00 | AAPL | Stock | 223.08 | 223.5 | 222.72 | 222.76 | 59333.0 |
| 2024-11-06 18:00:00 | AAPL | Stock | 222.81 | 222.88 | 222.5 | 222.65 | 34050.0 |
| 2024-11-06 19:00:00 | AAPL | Stock | 222.65 | 222.8125 | 222.4 | 222.4699 | 23419.0 |
| 2024-11-06 04:00:00 | MSFT | Stock | 415.58 | 417.28 | 415.0 | 417.28 | 26252.0 |
| 2024-11-06 05:00:00 | MSFT | Stock | 417.5 | 417.69 | 416.45 | 416.96 | 19153.0 |
| 2024-11-06 06:00:00 | MSFT | Stock | 416.96 | 417.15 | 415.0 | 415.0 | 17368.0 |
| 2024-11-06 07:00:00 | MSFT | Stock | 415.11 | 418.4 | 415.0 | 417.52 | 52743.0 |
| 2024-11-06 08:00:00 | MSFT | Stock | 415.3 | 418.79 | 411.8 | 416.46 | 128268.0 |
| 2024-11-06 09:00:00 | MSFT | Stock | 416.39 | 417.98 | 410.52 | 417.5 | 3574440.0 |
| 2024-11-06 10:00:00 | MSFT | Stock | 417.54 | 420.39 | 416.15 | 416.2899 | 2512267.0 |
| 2024-11-06 11:00:00 | MSFT | Stock | 416.25 | 417.49 | 415.26 | 416.09 | 1448829.0 |
| 2024-11-06 12:00:00 | MSFT | Stock | 416.08 | 416.88 | 414.78 | 416.09 | 975695.0 |
| 2024-11-06 13:00:00 | MSFT | Stock | 416.11 | 418.73 | 416.07 | 418.28 | 996163.0 |
| 2024-11-06 14:00:00 | MSFT | Stock | 418.31 | 419.6599 | 417.96 | 419.561 | 872977.0 |
| 2024-11-06 15:00:00 | MSFT | Stock | 419.56 | 420.45 | 418.93 | 420.21 | 2111622.0 |
| 2024-11-06 16:00:00 | MSFT | Stock | 420.18 | 420.5 | 419.03 | 420.5 | 4995186.0 |
| 2024-11-06 17:00:00 | MSFT | Stock | 420.55 | 420.9 | 420.1041 | 420.1041 | 134402.0 |
| 2024-11-06 18:00:00 | MSFT | Stock | 420.18 | 420.18 | 419.7 | 419.9 | 9707.0 |
| 2024-11-06 19:00:00 | MSFT | Stock | 419.9855 | 419.9855 | 419.4416 | 419.5 | 3262.0 |
| 2024-11-06 04:00:00 | NVDA | Stock | 142.12 | 142.39 | 141.03 | 142.38 | 812947.0 |
| 2024-11-06 05:00:00 | NVDA | Stock | 142.4 | 142.49 | 141.9 | 142.22 | 509191.0 |
| 2024-11-06 06:00:00 | NVDA | Stock | 142.2 | 142.33 | 140.17 | 140.23 | 739592.0 |
| 2024-11-06 07:00:00 | NVDA | Stock | 140.23 | 141.5 | 140.23 | 141.19 | 1655887.0 |
| 2024-11-06 08:00:00 | NVDA | Stock | 140.6 | 142.4796 | 140.45 | 142.1801 | 3771393.0 |
| 2024-11-06 09:00:00 | NVDA | Stock | 142.18 | 144.63 | 141.76 | 142.87 | 43069154.0 |
| 2024-11-06 10:00:00 | NVDA | Stock | 142.8706 | 144.31 | 142.87 | 143.88 | 30155118.0 |
| 2024-11-06 11:00:00 | NVDA | Stock | 143.9 | 144.44 | 143.5 | 144.42 | 15500935.0 |
| 2024-11-06 12:00:00 | NVDA | Stock | 144.42 | 145.49 | 144.3 | 145.479 | 26910965.0 |
| 2024-11-06 13:00:00 | NVDA | Stock | 145.48 | 146.335 | 145.385 | 145.92 | 22778532.0 |
| 2024-11-06 14:00:00 | NVDA | Stock | 145.9102 | 146.47 | 145.42 | 146.4084 | 16338278.0 |
| 2024-11-06 15:00:00 | NVDA | Stock | 146.4 | 146.49 | 145.32 | 145.62 | 24603435.0 |
| 2024-11-06 16:00:00 | NVDA | Stock | 145.61 | 145.75 | 145.0805 | 145.5 | 21063847.0 |
| 2024-11-06 17:00:00 | NVDA | Stock | 145.49 | 145.87 | 145.24 | 145.54 | 1276141.0 |
| 2024-11-06 18:00:00 | NVDA | Stock | 145.54 | 145.9 | 145.515 | 145.67 | 330215.0 |
| 2024-11-06 19:00:00 | NVDA | Stock | 145.66 | 145.75 | 145.3 | 145.3 | 384323.0 |
| 2024-11-06 04:00:00 | AMZN | Stock | 201.17 | 202.0 | 200.42 | 201.08 | 70556.0 |
| 2024-11-06 05:00:00 | AMZN | Stock | 201.08 | 201.27 | 199.6 | 199.85 | 69512.0 |
> showing 50 of 65,994 rows — these rows as CSV