Home

Welcome to the indexer wiki!

Useful queries

Keeping track of useful SQL queries to get some data out of the indexer.

Active accounts

Number of distinct accounts that made transactions (outside of minting and topping up)

SELECT count(distinct from_addr) as unique_accounts, count(*) as transactions, SUM(value::integer/1000000)  as total_transactions
FROM t_transfers_137_0x5491a3d35f148a44f0af4d718b9636a6e55ebc2d
WHERE from_addr != '0x0000000000000000000000000000000000000000'
  AND to_addr != '0x0000000000000000000000000000000000000000'
  AND from_addr != '0x5736A617711d11f92A9f6C32f9f8d01F88b832BA' -- @topup

Number of people who topped up

SELECT count(distinct to_addr) as unique_toppers, count(*) as transactions, SUM(value::integer/1000000)  as total_transactions
FROM t_transfers_137_0x5491a3d35f148a44f0af4d718b9636a6e55ebc2d
WHERE from_addr = '0x5736A617711d11f92A9f6C32f9f8d01F88b832BA' -- @topup

Customers of an account

SELECT count(distinct from_addr) as unique_customers, count(*) as transactions, SUM(value::integer/1000000)  as total_transactions
FROM t_transfers_137_0x5491a3d35f148a44f0af4d718b9636a6e55ebc2d
WHERE to_addr = '0x34C4360bd268a9d615Bc3382f35792e03C026Ca7' -- @cryptobar

SELECT count(distinct from_addr) as unique_donors, count(*) as transactions, SUM(value::integer/1000000)  as total_transactions
FROM t_transfers_137_0x5491a3d35f148a44f0af4d718b9636a6e55ebc2d
WHERE to_addr = '0x6C2Df884CA32903bB6354Dcc9FF1d37Fc3F9066e' -- @pizza