-- forked from PLR: Token Holders @ https://flipsidecrypto.xyz/edit/queries/a4786a02-e91d-4e4b-a8dc-9081ba80292d with holders as ( select user_address, current_bal, token_name, symbol, contract_address from ethereum.core.ez_current_balances where -- token_name = 'PILLAR' -- and symbol = 'PLR' -- and contract_address = '0xe3818504c1b32bf1557b16c238b2e01fd3149c17' -- AND last_activity_block_timestamp :: date >= date_trunc('month', current_date) - interval '1 month' -- AND last_activity_block_timestamp :: date < date_trunc('month', current_date) and current_bal >= 10000 order by current_bal desc ), transactions as ( select from_address, to_address, block_timestamp, 'arbitrum' as chain from arbitrum.core.fact_transactions WHERE block_timestamp :: date >= date_trunc('month', current_date) - interval '1 month' AND block_timestamp :: date < date_trunc('month', current_date) UNION select from_address, to_address, block_timestamp, 'eth' as chain from ethereum.core.fact_transactions WHERE block_timestamp :: date >= date_trunc('month', current_date) - interval '1 month' AND block_timestamp :: date < date_trunc('month', current_date) UNION select from_address, to_address, block_timestamp, 'avax' as chain from avalanche.core.fact_transactions WHERE block_timestamp :: date >= date_trunc('month', current_date) - interval '1 month' AND block_timestamp :: date < date_trunc('month', current_date) UNION select from_address, to_address, block_timestamp, 'base' as chain from base.core.fact_transactions WHERE block_timestamp :: date >= date_trunc('month', current_date) - interval '1 month' AND block_timestamp :: date < date_trunc('month', current_date) UNION select from_address, to_address, block_timestamp, 'blast' as chain from blast.core.fact_transactions WHERE block_timestamp :: date >= date_trunc('month', current_date) - interval '1 month' AND block_timestamp :: date < date_trunc('month', current_date) UNION select from_address, to_address, block_timestamp, 'bsc' as chain from bsc.core.fact_transactions WHERE block_timestamp :: date >= date_trunc('month', current_date) - interval '1 month' AND block_timestamp :: date < date_trunc('month', current_date) UNION select from_address, to_address, block_timestamp, 'gnosis' as chain from gnosis.core.fact_transactions WHERE block_timestamp :: date >= date_trunc('month', current_date) - interval '1 month' AND block_timestamp :: date < date_trunc('month', current_date) UNION select from_address, to_address, block_timestamp, 'optimism' as chain from optimism.core.fact_transactions WHERE block_timestamp :: date >= date_trunc('month', current_date) - interval '1 month' AND block_timestamp :: date < date_trunc('month', current_date) UNION select from_address, to_address, block_timestamp, 'polygon' as chain from polygon.core.fact_transactions WHERE block_timestamp :: date >= date_trunc('month', current_date) - interval '1 month' AND block_timestamp :: date < date_trunc('month', current_date) ), address_count_by_chain as ( SELECT count(DISTINCT(h.user_address)) as address_count, tx.chain, --DATE_TRUNC('month', tx.block_timestamp) as month from holders h join transactions t on h.user_address = t.from_address join transactions tx on h.user_address = tx.to_address group by tx.chain --DATE_TRUNC('month', tx.block_timestamp) -- order by -- month desc ) SELECT * FROM address_count_by_chain -- UNION -- ALL -- SELECT -- 'Total', -- SUM(address_count) -- FROM -- address_count_by_chain;

Query	Creator	Created
Getting Started ethereum nft evm	djde	May 18, 2024
Query EIGEN holders copy gnosis bsc arbitrum base ethereum	djde	May 20, 2024
PLR: Token Holders ethereum evm balances	djde	May 18, 2024
PLR: Token Holders >10000 (Ethereum) Who Have Made a Transaction (Any EVM) in Past Month gnosis bsc arbitrum base ethereum	djde	May 20, 2024

djde