with Affyn_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 polygon.core.fact_transactions WHERE to_address = lower('0x3b56a704c01d650147ade2b8cee594066b3f9421') GROUP BY 1 ), REVV_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 polygon.core.fact_transactions WHERE to_address = lower('0x70c006878a5a50ed185ac4c87d837633923de296') GROUP BY 1 ), DOSE_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 polygon.core.fact_transactions WHERE to_address = lower('0x81382e9693de2afc33f69b70a6c12ca9b3a73f47') GROUP BY 1 ), MarsToken_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 polygon.core.fact_transactions WHERE to_address = lower('0x411bc96881a62572ff33c9d8ce60df99e3d96cd8') GROUP BY 1 ), ForestNight_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 polygon.core.fact_transactions WHERE to_address = lower('0x4455ef8b4b4a007a93daa12de63a47eeac700d9d') GROUP BY 1 ), Astrafer_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 polygon.core.fact_transactions WHERE to_address = lower('0xdfce1e99a31c4597a3f8a8945cbfa9037655e335') GROUP BY 1 ), RebelBots_RBL_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 polygon.core.fact_transactions WHERE to_address = lower('0xe26cda27c13f4f87cffc2f437c5900b27ebbb5bb') GROUP BY 1 ), RebelBots_XOIL_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 polygon.core.fact_transactions WHERE to_address = lower('0xa7aac53f7c860b1f9d610147341c57579c51403e') GROUP BY 1 ), CrazyDefenseHeros_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 polygon.core.fact_transactions WHERE to_address = lower('0x2bc07124d8dac638e290f401046ad584546bc47b') GROUP BY 1 ), Onerare_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 polygon.core.fact_transactions WHERE to_address = lower('0xff2382bd52efacef02cc895bcbfc4618608aa56f') GROUP BY 1 ), PlanetIX_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 polygon.core.fact_transactions WHERE to_address = lower('0xe06bd4f5aac8d0aa337d13ec88db6defc6eaeefe') GROUP BY 1 ), Decentraland_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 polygon.core.fact_transactions WHERE to_address = lower('0xa1c57f48f0deb89f569dfbe6e2b7f46d33606fd4') GROUP BY 1 ), Vulcanforged_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 polygon.core.fact_transactions WHERE to_address = lower('0x430ef9263e76dae63c84292c3409d61c598e9682') GROUP BY 1 ) select 'Affyn' as game, 'polygon' as chain, avg(lifetime) avg_lifetime_days from Affyn_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'REVV' as game, 'polygon' as chain, avg(lifetime) avg_lifetime_days from REVV_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'DOSE' as game, 'polygon' as chain, avg(lifetime) avg_lifetime_days from DOSE_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'MarsToken' as game, 'polygon' as chain, avg(lifetime) avg_lifetime_days from MarsToken_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'ForestNight' as game, 'polygon' as chain, avg(lifetime) avg_lifetime_days from ForestNight_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Astrafer' as game, 'polygon' as chain, avg(lifetime) avg_lifetime_days from Astrafer_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Rebel Bots (RBLS)' as game, 'polygon' as chain, avg(lifetime) avg_lifetime_days from RebelBots_RBL_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Rebel Bots (XOIL)' as game, 'polygon' as chain, avg(lifetime) avg_lifetime_days from RebelBots_XOIL_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Crazy Defense Heros' as game, 'polygon' as chain, avg(lifetime) avg_lifetime_days from CrazyDefenseHeros_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Onerare' as game, 'polygon' as chain, avg(lifetime) avg_lifetime_days from Onerare_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'PlanetIX' as game, 'polygon' as chain, avg(lifetime) avg_lifetime_days from PlanetIX_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Decentraland' as game, 'polygon' as chain, avg(lifetime) avg_lifetime_days from Decentraland_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users union select 'Vulcan Forged' as game, 'polygon' as chain, avg(lifetime) avg_lifetime_days from Vulcanforged_lifetime where first_tx < CURRENT_DATE()-7 -- to exclude new users order by avg_lifetime_days desc

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

evanden11