ehsanstUntitled Query
    Updated 2022-12-12
    with tx1 as(select TX_ID,MIN(FROM_ASSET) as FROM_ASSET,MIN(TO_ASSET) as TO_ASSET,count(*)
    FROM thorchain.core.fact_swaps
    WHERE AFFILIATE_ADDRESS = 'te'
    group by TX_ID
    having(count(*))>=2),
    tx2 as(
    select TX_ID,sum(TO_AMOUNT) as AFF_Fee,sum(TO_AMOUNT*COALESCE(RUNE_USD, 1)) as AFF_Fee_USD,min(TO_ASSET) as rn
    FROM thorchain.core.fact_swaps
    WHERE NATIVE_TO_ADDRESS = 'te' and TO_ASSET='THOR.RUNE' and AFFILIATE_ADDRESS = 'te'
    group by TX_ID
    having(count(*))>=2)
    select tx1.TX_ID,tx1.FROM_ASSET,tx1.TO_ASSET,AFF_Fee,AFF_Fee_USD from tx1 join tx2 on tx1.TX_ID=tx2.TX_ID
    order by AFF_Fee_USD desc

    select * from thorchain.core.fact_swaps_events where tx_id='E0F91EAAD070AF56F0A87237096C574F81DDC50C44BD9A340C60014976323B11'

    select * from thorchain.core.fact_swaps where RUNE_USD is NULL limit 100

    select TO_AMOUNT*COALESCE(RUNE_USD, 1),* from thorchain.core.fact_swaps
    where TX_ID='B051DC776B4449A094511AE2082BBBBD278E3ACE121AD1B56A9C56E69EAA4A21'
    AND NATIVE_TO_ADDRESS = 'te' and TO_ASSET='THOR.RUNE'

    select * from thorchain.core.fact_swaps limit 100

    select TX_ID,MIN(FROM_ASSET) as FROM_ASSET,MIN(TO_ASSET) as TO_ASSET,count(*)
    FROM thorchain.core.fact_swaps
    WHERE AFFILIATE_ADDRESS = 'te'
    group by TX_ID
    having(count(*))<2


    select * from thorchain.core.fact_swaps_events where tx_id='72148219B62C2ED79F6E5AD1422C84F0A8F886801FCE0AE8E8C706AD2E3BD29A' limit 100

    SELECT fact_swaps.BLOCK_TIMESTAMP AS TIMESTAMP, fact_swaps.TX_ID, fact_swaps.FROM_ASSET, fact_swaps.TO_ASSET, fact_swaps.FROM_AMOUNT_USD AS SWAP_VALUE_USD, fact_swaps.AFFILIATE_ADDRESS, fact_swaps.AFFILIATE_FEE_BASIS_POINTS AS BASIS_POINTS, fact_swaps_events.MEMO
    FROM thorchain.core.fact_swaps
    Run a query to Download Data