I did a print out of the combined total of all utxos where is_spent = false and I got back
20009210.72379106 ...
which is close, but higher than the total supply in circulation (around 19.82m)
I'm hoping the difference has something to do with a certain script type not strigger the is_spent variable I track... I'm also aware that the node maintains a current list of all utxos, so maybe my best bet is to do a comparison of utxo ID fields?
Curious if anything stands out to anyone on this: Here is a print out of amounts summed by script_type...
script_type | ct | total_amount
-----------------------+----------+------------------
pubkeyhash | 52505234 | 6812722.99744588
witness_v0_keyhash | 49812368 | 5950961.07712848
scripthash | 14085469 | 4212919.07096102
pubkey | 45304 | 1720781.42621185
witness_v0_scripthash | 1589794 | 1161322.78037109
witness_v1_taproot | 58752893 | 147776.69085131
nonstandard | 187875 | 2627.60490072
multisig | 1872416 | 57.31497578
nulldata | 143801 | 41.75518261
witness_unknown | 199 | 0.00576232
Not worth doing more dust accounting until I get this table synced with the current chain...