with GMT_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 ethereum.core.fact_transactions WHERE to_address = lower('0xe3c408bd53c31c085a1746af401a4042954ff740') GROUP BY 1 ), Illuvium_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 ethereum.core.fact_transactions WHERE to_address = lower('0x767fe9edc9e0df98e07454847909b5e959d7ca0e') GROUP BY 1 ), WilderWorld_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 ethereum.core.fact_transactions WHERE to_address = lower('0x2a3bff78b79a009976eea096a51a948a3dc00e34') GROUP BY 1 ), GuildOfGuardians_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 ethereum.core.fact_transactions WHERE to_address = lower('0x9ab7bb7fdc60f4357ecfef43986818a2a3569c62') GROUP BY 1 ), Splintershards_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 ethereum.core.fact_transactions WHERE to_address = lower('0x00813e3421e1367353bfe7615c7f7f133c89df74') GROUP BY 1 ), MyNeighborAlice_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 ethereum.core.fact_transactions WHERE to_address = lower('0xac51066d7bec65dc4589368da368b212745d63e8') GROUP BY 1 ), REVV_lifetime_ethereum 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 ethereum.core.fact_transactions WHERE to_address = lower('0x557b933a7c2c45672b610f8954a3deb39a51a8cae') GROUP BY 1 ), ForestNight_lifetime_ethereum 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 ethereum.core.fact_transactions WHERE to_address = lower('0x4455ef8b4b4a007a93daa12de63a47eeac700d9d') GROUP BY 1 ), GodsUnchained_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 ethereum.core.fact_transactions WHERE to_address = lower('0xccc8cb5229b0ac8069c51fd58367fd1e622afd97') GROUP BY 1 ), Cornacopius_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 ethereum.core.fact_transactions WHERE to_address = lower('0x42baf1f659d765c65ade5bb7e08eb2c680360d9d') GROUP BY 1 ), WagmiGames_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 ethereum.core.fact_transactions WHERE to_address = lower('0x3b604747ad1720c01ded0455728b62c0d2f100f0') GROUP BY 1 ), Astrafer_lifetime_ethereum 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 ethereum.core.fact_transactions WHERE to_address = lower('0x97bbbc5d96875fb78d2f14b7ff8d7a3a74106f17') GROUP BY 1 ), Senate_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 ethereum.core.fact_transactions WHERE to_address = lower('0x34be5b8c30ee4fde069dc878989686abe9884470') GROUP BY 1 ), Sidus_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 ethereum.core.fact_transactions WHERE to_address = lower('0x549020a9cb845220d66d3e9c6d9f9ef61c981102') GROUP BY 1 ), DarkFrontiers_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 ethereum.core.fact_transactions WHERE to_address = lower('0x12fc07081fab7de60987cad8e8dc407b606fb2f8') GROUP BY 1 ), Decentraland_lifetime_ethereum 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 ethereum.core.fact_transactions WHERE to_address = lower('0x0f5d2fb29fb7d3cfee444a200298f468908cc942') GROUP BY 1 ), Mars4_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 ethereum.core.fact_transactions WHERE to_address = lower('0x16cda4028e9e872a38acb903176719299beaed87') GROUP BY 1 ), CrazyDefenseHeros_lifetime_ethereum 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 ethereum.core.fact_transactions WHERE to_address = lower('0x1c9922314ed1415c95b9fd453c3818fd41867d0b') GROUP BY 1 ), HUSL_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 ethereum.core.fact_transactions WHERE to_address = lower('0xa2881f7f441267042f9778ffa0d4f834693426be') GROUP BY 1 ), AxieInfinity_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 ethereum.core.fact_transactions WHERE to_address = lower('0xbb0e17ef65f82ab018d8edd776e8dd940327b28b') GROUP BY 1 ), Gomining_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 ethereum.core.fact_transactions WHERE to_address = lower('0x7ddc52c4de30e94be3a6a0a2b259b2850f421989') GROUP BY 1 ), Fusionist_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 ethereum.core.fact_transactions WHERE to_address = lower('0xc27a719105a987b4c34116223cae8bd8f4b5def4') GROUP BY 1 ), AlienWorlds_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 ethereum.core.fact_transactions WHERE to_address = lower('0x888888848b652b3e3a0f34c96e00eec0f3a23f72') GROUP BY 1 ), Mythos_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 ethereum.core.fact_transactions WHERE to_address = lower('0xba41ddf06b7ffd89d1267b5a93bfef2424eb2003') GROUP BY 1 ), Morra_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 ethereum.core.fact_transactions WHERE to_address = lower('0xd9adfb67381d392c6e9671f64cdd9014bfcd74f2') GROUP BY 1 ), Xtremeverse_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 ethereum.core.fact_transactions WHERE to_address = lower('0x000000000503be77a5ed27bef2c19943a8b5ae73') 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 ethereum.core.fact_transactions WHERE to_address = lower('0x2e85ae1c47602f7927bcabc2ff99c40aa222ae15') GROUP BY 1 ) select 'GMT' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from GMT_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Illuvium' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from Illuvium_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Wilder World' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from WilderWorld_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Guild of Guardians' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from GuildOfGuardians_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Splintershards' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from Splintershards_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'My Neighbor Alice' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from MyNeighborAlice_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'REVV' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from REVV_lifetime_ethereum where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Forest Night' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from ForestNight_lifetime_ethereum where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Gods Unchained' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from GodsUnchained_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Cornacopius' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from Cornacopius_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Wagmi Games' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from WagmiGames_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Astrafer' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from Astrafer_lifetime_ethereum where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Senate' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from Senate_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Sidus' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from Sidus_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Dark Frontiers' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from DarkFrontiers_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Decentraland' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from Decentraland_lifetime_ethereum where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Mars4' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from Mars4_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Crazy Defense Heros' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from CrazyDefenseHeros_lifetime_ethereum where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'HUSL' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from HUSL_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Axie Infinity' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from AxieInfinity_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Gomining' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from Gomining_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Fusionist' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from Fusionist_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Alien Worlds' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from AlienWorlds_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Mythos' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from Mythos_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Morra' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from Morra_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Xtremeverse' as game, 'ethereum' as chain, avg(lifetime) avg_lifetime_days from Xtremeverse_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Katana Inu' as game, 'ethereum' 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
All Blockchain Games Token Transfers bsc ethereum polygon solana evm	evanden11	Apr 10, 2024
Average User Lifetime - Ethereum ethereum evm	evanden11	Apr 5, 2024
Ethereum Token Transfers by Game ethereum evm	evanden11	Apr 4, 2024

evanden11