Query editor
with swap_in as (select dt, from_address, to_address, amount_swap, evt_tx_hash, contract_address, swap_orderfrom (select date_trunc('day', evt_block_time::date) as dt,"from" as from_address, "to" as to_address, "value"/1e18 as amount_swap,evt_tx_hash, contract_address,row_number() over (partition by evt_tx_hash order by value desc) as swap_orderfrom bep20."BEP20_evt_Transfer"where evt_tx_hash in (select tx_hashfrom bsc.logswhere topic1 = '\xff3715fa8f2d4d791dd7a610a545050b8c6fe3a62b0f6c38f2f96a00598fe483'and contract_address = '\x20a304a7d126758dfe6b243d0fc515f83bca8431')) awhere swap_order <= 2),price as (select avg(price) as price, date_trunc('day', minute) as dt_price, symbol, contract_addressfrom prices."usd"where contract_address in (select contract_address from swap_in)and minute::date >= '2022-12-01'group by 2,3,4),final as (select dt, token0_address, token0_price,token1_address, token1_price,coalesce(i.from_address, o.from_address) as seller,coalesce(i.to_address, o.to_address) as buyer,amount_swap_in, amount_swap_out, i.evt_tx_hashfrom (select dt, from_address, to_address, i.contract_address as token0_address, price as token0_price,amount_swap as amount_swap_in, evt_tx_hashfrom swap_in ileft join price p oni.contract_address = p.contract_addressand i.dt = p.dt_pricewhere swap_order = 1) ijoin (select from_address, to_address, i.contract_address as token1_address, price as token1_price,amount_swap as amount_swap_out, evt_tx_hashfrom swap_in ileft join price p oni.contract_address = p.contract_addressand i.dt = p.dt_pricewhere swap_order = 2) o oni.evt_tx_hash = o.evt_tx_hash),thena_price as (select avg(amount_swap_out * token1_price / amount_swap_in ) as thena_price,dtfrom finalwhere token0_address = '\xf4c8e32eadec4bfe97e0f595add0f4450a863a11'group by 2),