SELECT

DECODED_LOG:pool::STRING AS pool_address

FROM polygon.core.ez_decoded_event_logs

WHERE contract_address = LOWER('0x411b0fAcC3489691f28ad58c47006AF5E3Ab3A28')

AND event_name = 'Pool'

),

fees_from_logs AS (

SELECT

tx_hash,

contract_address,

DECODED_LOG:fee * 1e-6 AS fee

FROM polygon.core.ez_decoded_event_logs

WHERE contract_address IN (SELECT pool_address FROM pool_addresses)

AND event_name = 'Fee'

),

combined_swaps_and_fees AS (

SELECT

date_trunc('day', ds.block_timestamp) AS date,

ds.tx_hash,

ds.amount_in_usd,

fl.fee

FROM polygon.core.ez_dex_swaps ds

LEFT JOIN fees_from_logs fl ON ds.tx_hash = fl.tx_hash

and ds.contract_address = fl.contract_address

WHERE ds.platform LIKE '%quickswap-v3%'

),

dex_volume AS (

SELECT

date_trunc('day', date) as date,

sum(volume) as volume_usd

FROM external.defillama.fact_dex_volume

WHERE chain = 'polygon' AND protocol = 'quickswap v3'

GROUP BY 1

),

llama_fees as (