with ThetanArena_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0x9fd87aefe02441b123c3c32466cd9db4c578618f') GROUP BY 1 ), RealFevr_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0x82030cdbd9e4b7c5bb0b811a61da6360d69449cc') GROUP BY 1 ), MonstaInfinite_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0x9573c88aE3e37508f87649f87c4dd5373C9F31e0') GROUP BY 1 ), MyDefiPet_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0xfb62ae373aca027177d1c18ee0862817f9080d08') GROUP BY 1 ), Elemon_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0xe3233fdb23f1c27ab37bd66a19a1f1762fcf5f3f') GROUP BY 1 ), FaraLand_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0xf4ed363144981d3a65f42e7d0dc54ff9eef559a1') GROUP BY 1 ), Wizardia_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0xfa40d8fc324bcdd6bbae0e086de886c571c225d4') GROUP BY 1 ), GunstarMetaverse_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0x7edc0ec89f987ecd85617b891c44fe462a325869') GROUP BY 1 ), Warena_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0xa9d75cc3405f0450955050c520843f99aff8749d') GROUP BY 1 ), FOTAFightOfTheAges_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0x0a4e1bdfa75292a98c15870aef24bd94bffe0bd4') GROUP BY 1 ), ArsenalFanToken_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0x4568ca00299819998501914690d6010ae48a59ba') GROUP BY 1 ), KabyKABY_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0x02a40c048ee2607b5f5606e445cfc3633fb20b58') GROUP BY 1 ), KabyKGT_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0xa4e208c627f3adc60165c2a9fe79d73f4e8dd760') GROUP BY 1 ), MyMasterWar_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0xf3147987a00d35eecc10c731269003ca093740ca') GROUP BY 1 ), Starship_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0x52419258e3fa44deac7e670eadd4c892b480a805') GROUP BY 1 ), Eldarune_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0xab2ed911bdbea001fd3b29adbc35d8a76e68aae4') GROUP BY 1 ), DreamsQuest_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0x54523d5fb56803bac758e8b10b321748a77ae9e9') GROUP BY 1 ), Cryptopolis_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0xea395dfafed39924988b475f2ca7f4c72655203a') GROUP BY 1 ), Defina_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0x426c72701833fddbdfc06c944737c6031645c708') GROUP BY 1 ), Genopets_lifetime as ( SELECT distinct from_address as user, (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , min(block_timestamp::date) as first_tx FROM bsc.core.fact_transactions WHERE to_address = lower('0x9df465460938f9ebdf51c38cc87d72184471f8f0') GROUP BY 1 ) --, -- Katanainu_lifetime as ( -- SELECT -- distinct from_address as user, -- (max(block_timestamp::date) - min(block_timestamp::date)) AS lifetime , -- min(block_timestamp::date) as first_tx -- FROM bsc.core.fact_transactions -- WHERE -- to_address = lower('0x6d6ba21e4c4b29ca7bfa1c344ba1e35b8dae7205') -- GROUP BY 1 -- ) select 'Thetan Arena' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from ThetanArena_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'RealFevr' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from RealFevr_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Monsta Infinite' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from MonstaInfinite_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'My Defi Pet' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from MyDefiPet_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Elemon' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from Elemon_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Fara Land' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from FaraLand_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Wizardia' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from Wizardia_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Gunstar Metaverse' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from GunstarMetaverse_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Warena' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from Warena_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'FOTA Fight of the Ages' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from FOTAFightOfTheAges_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Arsenal Fan Token' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from ArsenalFanToken_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Kaby - KABY' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from KabyKABY_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Kaby - KGT' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from KabyKGT_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'My Master War' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from MyMasterWar_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Starship' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from Starship_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Eldarune' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from Eldarune_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Dreams Quest' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from DreamsQuest_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Cryptopolis' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from Cryptopolis_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Defina' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from Defina_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Genopets' as game, 'bsc' as chain, avg(lifetime) avg_lifetime_days from Genopets_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users -- union -- select -- 'Katana Inu' as game, -- 'bsc' as chain, -- avg(lifetime) avg_lifetime_days -- from Katanainu_lifetime -- where first_tx < CURRENT_DATE()-7 -- to exclude new users order by avg_lifetime_days desc

Query	Creator	Created
Binance Token Transfers by Game bsc evm binance	evanden11	Apr 4, 2024
All Blockchain Games Token Transfers bsc ethereum polygon solana evm	evanden11	Apr 10, 2024
Average User Lifetime - Binance bsc evm binance	evanden11	Apr 5, 2024

evanden11