Cheers for your reply. One way of thinking about the question is I don't really care about defining a financial transaction vs something else. The data will do that by itself. In the example above, someone is "sending" 20,000 sats and spending 14,700 sats to do so - i.e. a fee of about 75% of the amount they are sending, it's clearly not a financial transaction anyway!

So what I am looking for is something like - for each block, every single transaction will have an amount sent and a fee rate paid to send it. From that we could work out a fee perecentage for every single transaction. By looking at the average (or other metrics) of all of those, I think it would start to get interesting. Perhaps it's difficult to pick up those numbers in practice.

I know people sometimes talk about total value sent over the network, so it's clearly aggregated at times from data. Interestingly though, I don't think you could look at total value sent per block and use that in combination with total fees in a block, as if a whale comes along and sends 1,000 BTC in on a transaction in one block and not the next, that would obviously distort the data.

I'll keep looking!

I suppose my goal is just to understand if fees are going to remain in the triple figures /vbyte, or will come back down to cheaper levels in the coming weeks/months. If they are coming back down, I'll simply wait.

Let's say I want to move 0.1 btc. I think what I'm trying to say is that if the blocks are full of others moving 1 btc at 100 sats/vbyte, then the data would show that the effective % fee they are paying is something like the following (I know the level will depend on data and UTXOs, but let's assume it's pretty simple and the overall fee is just 12x the rate for now in terms of working out a fee) -

12,000 sats fee Effective rate to move 1 btc 12,000 / 100,000,000 = 0.012%

Now my % rate for a similar transaction but only 0.1btc would be the same in absolute terms, but ten times that in relative terms. Long term, I'm simply going to have to pay more in relative terms to move bitcoin around to compete with those moving around larger amounts of bitcoin. In this sense, the fee rates are sustainable and it's an open market of competition.

Compare this to those spending 14,700 sats to move 20,000 sats. Now they may have an economic reason (in their mind) to carry that out, but it doesn't seem sustainable if Bitcoin 10x's in future. Whereas the person moving 1 btc will still be able to pay 100 sats/vbyte and maintain the fee in bitcoin denominated terms, as will I.

I hope that makes sense - finding it slightly hard to articulate!