flipside

    ShapeShift THORChain Explorer copy
    ShapeShiftShapeShift THORChain Explorer copy
    Updated 2025-06-02
    with table_1 as (select min(block_timestamp) as day,
    from_address,
    native_to_address,
    affiliate_fee_basis_points,
    tx_id,
    split(from_asset, '-')[0] as from_assets,
    case
    when from_assets ilike '%/%' then split(from_assets, '/')[1]
    else split(from_assets, '.')[1]
    end as from_asset_names,
    split(to_asset, '-')[0] as to_assets,
    case
    when to_assets ilike '%/%' then split(to_assets, '/')[1]
    else split(to_assets, '.')[1]
    end as to_asset_names,
    concat(from_asset_names, ' -> ', to_asset_names) as assets,
    case when assets ilike '%RUNE' then 2
    else 1
    end as numbering,
    sum(from_amount_usd/rune_usd) as rune_volume,
    sum(from_amount_usd) as usd_volume
    from thorchain.defi.fact_swaps
    where affiliate_address = 'ss'
    group by 2,3,4,5,6,7,8),

    table_2 as (select day,
    tx_id,
    from_address,
    native_to_address,
    affiliate_fee_basis_points,
    array_agg(distinct assets) within group (order by assets asc) as swap_direction,
    sum(rune_volume) as swap_volume_rune,
    sum(usd_volume) as swap_volume_usd
    from table_1
    group by 1,2,3,4,5),

    Last run: 15 days ago
    TX Date Time
    Transaction ID
    From Address
    From Token Amount
    From USD Amount
    Swap Path
    To Token Amount
    To USD Amount
    To Address
    Fee BPS
    Affiliate Fee RUNE
    Affiliate Fee USD
    Streaming (Y/N)
    1
    		2025-06-02 17:18:30.564https://runescan.io/tx/674BAA5C1458C4B25615CE44F6E70D804CA79EA90E99A23D338FA8E3498B730Bthor1z92egyt24g3wz6saugv4yu9k4avew2hn9yzad90.000071080.18ETH -> RUNE0.0129240732.89thor122h9hlrugzdny9ct95z6g7afvpzu34s73uklju000N
    2
    		2025-06-02 17:18:24.435https://runescan.io/tx/674BAA5C1458C4B25615CE44F6E70D804CA79EA90E99A23D338FA8E3498B730Bthor1z92egyt24g3wz6saugv4yu9k4avew2hn9yzad90.110071080.36RUNE -> ETH0.0129240732.890xd54f6558E6DeF83e4383fA7981BC3a110797204E550.110.1809556797N
    3
    		2025-06-02 14:59:35.209https://runescan.io/tx/EC493670E9BC89AD1DAB1CEF134522B97C4FED0A887A5E9BBD84A11DE6297678thor13hz4cuh4k3pljyjwsxray647hdr9dt69exhq440.00506837528.75BTC -> RUNE0.9215209896022.31thor122h9hlrugzdny9ct95z6g7afvpzu34s73uklju000Y
    4
    		2025-06-02 14:55:24.730https://runescan.io/tx/EC493670E9BC89AD1DAB1CEF134522B97C4FED0A887A5E9BBD84A11DE6297678thor13hz4cuh4k3pljyjwsxray647hdr9dt69exhq44321.370068371057.26RUNE -> BTC0.9215209896022.31bc1qrmxwtpdcdpl5ltznd0ufsw0rjhrgyy0g6qre2n55321.365528.512708801Y
    5
    		2025-06-02 14:34:01.071https://runescan.io/tx/485D2681A3499B7062C204131252757CB55DC34A2BBE752FDAC9270DC635206Athor1gzje2g2qz433uu4djgcpk807jrmap0dz3rctkn817.22914316210.02USDC -> RUNE283.998802283.97thor122h9hlrugzdny9ct95z6g7afvpzu34s73uklju000N
    6
    		2025-06-02 14:33:55.106https://runescan.io/tx/485D2681A3499B7062C204131252757CB55DC34A2BBE752FDAC9270DC635206Athor1gzje2g2qz433uu4djgcpk807jrmap0dz3rctkn817.22914316210.02TCY -> RUNE -> USDC283.998802283.970x4E25231dc14cA60FDfaF97582eBBd4e21cBFbB0C550.8214461421.354532222N
    7
    		2025-06-02 13:21:16.715https://runescan.io/tx/2D2C3B567EAB1699B5E22BD1600FE5F0D1CC2AAC184A5113A2853AAD5740F7E70xa4a5689f688c0c4c9483497947af46fbd250aa9510001000.67USDT -> RUNE -> TGT33117.897140521000.030xa4a5689f688C0c4C9483497947aF46fBD250aa95000Y
    8
    		2025-06-02 13:04:06.752https://runescan.io/tx/40B8F899797DD4FEC5B06751A666CD196500B3D8B7ADC0FEA12048A04D8FAD6Cthor1py3feajx27qnm8ek73pavmgy2m7r6ecn6ztlhj10000.000183242569.85BTC -> RUNE0.033316623471.23thor122h9hlrugzdny9ct95z6g7afvpzu34s73uklju000Y
    9
    		2025-06-02 13:03:11.563https://runescan.io/tx/40B8F899797DD4FEC5B06751A666CD196500B3D8B7ADC0FEA12048A04D8FAD6Cthor1py3feajx27qnm8ek73pavmgy2m7r6ecn6ztlhj10000.000183242569.85TCY -> RUNE -> BTC0.033316623471.23bc1qwqzw74d0r5cjyfrjtcqltxtpe48dg6spzglnc65510.04777820816.565107354Y
    10
    		2025-06-02 11:03:21.403https://runescan.io/tx/4B8DE37C4FB66D278CEC1905CBAB94A2990ED1761145F70AC2A2C13992A71489bc1qqdx34pktxdh86md2mh7hqqh09e39h64wf6f2q511.461956692094.59USDT -> RUNE2080.3557622082.14thor122h9hlrugzdny9ct95z6g7afvpzu34s73uklju000N
    11
    		2025-06-02 11:02:19.956https://runescan.io/tx/4B8DE37C4FB66D278CEC1905CBAB94A2990ED1761145F70AC2A2C13992A71489bc1qqdx34pktxdh86md2mh7hqqh09e39h64wf6f2q511.461956692094.59BTC -> RUNE -> USDT2080.3557622082.140x7a5Bef1a296580580920aEe61b737236395e8E58557.0484004111.454935066N
    12
    		2025-06-02 05:28:58.032https://runescan.io/tx/98D17EF876122F17D588E7024BA52C24E5509162C4C2734185AE33A94658718Fcosmos14cdzhp88m6h42a5ddgldxrpstrqu23epcjqc4m32.00187667138.27BCH -> RUNE0.34121251137.42thor122h9hlrugzdny9ct95z6g7afvpzu34s73uklju000N
    13
    		2025-06-02 05:28:52.091https://runescan.io/tx/98D17EF876122F17D588E7024BA52C24E5509162C4C2734185AE33A94658718Fcosmos14cdzhp88m6h42a5ddgldxrpstrqu23epcjqc4m32.00187667138.27ATOM -> RUNE -> BCH0.34121251137.42qrjzsty8t66ccah0mzqjh0ay8ffd6v5gpclgmxyhm5550.45065593370.7562393659N
    14
    		2025-06-02 01:52:47.742https://runescan.io/tx/2ADD3EB6996E5BB702132F330D449E2ED73F720D6B096F3649222790117DC93A0x94e518796b40accea034bf74b02bfb654716d8e910657.9816636610539.16TCY -> RUNE29377.399029147707.91thor122h9hlrugzdny9ct95z6g7afvpzu34s73uklju000Y
    15
    		2025-06-02 01:39:25.680https://runescan.io/tx/2ADD3EB6996E5BB702132F330D449E2ED73F720D6B096F3649222790117DC93A0x94e518796b40accea034bf74b02bfb654716d8e910657.9816636610539.16USDC -> RUNE -> TCY29377.399029147707.91thor1clm0ehgt8d04z4n5pka05jjrqk3a2emsgcz7605533.89089089357.717055075Y
    16
    		2025-06-01 23:41:36.203https://runescan.io/tx/070C2F901FCEBF19A8F80DAE5CA90957D0FCDF5A1AB1FECD28BDD4DDD59B24F1bc1q6u49s93pvft2g9rnf379m77m4862h5qk002ph50.0005806450.21ETH -> RUNE0.0196482549.88thor122h9hlrugzdny9ct95z6g7afvpzu34s73uklju000N
    17
    		2025-06-01 23:41:30.001https://runescan.io/tx/070C2F901FCEBF19A8F80DAE5CA90957D0FCDF5A1AB1FECD28BDD4DDD59B24F1bc1q6u49s93pvft2g9rnf379m77m4862h5qk002ph50.0005806450.21BTC -> RUNE -> ETH0.0196482549.880x141D9959cAe3853b035000490C03991eB70Fc4aC550.16005484490.2745502058N
    18
    		2025-06-01 22:15:19.588https://runescan.io/tx/7411D1C4AD1797BEE11949F25B9219A768737D3BA4AD00C056B185703EF921CCbc1q2x3rmh04eph6ymfr5c474x8zuxeyvqu44agnns0.31671023252.12ATOM -> RUNE57.152086250.62thor122h9hlrugzdny9ct95z6g7afvpzu34s73uklju000N
    19
    		2025-06-01 22:15:13.626https://runescan.io/tx/7411D1C4AD1797BEE11949F25B9219A768737D3BA4AD00C056B185703EF921CCbc1q2x3rmh04eph6ymfr5c474x8zuxeyvqu44agnns0.31671023252.12BTC -> RUNE -> ATOM57.152086250.62cosmos1dzj5zlxchely94sah3gje4rnxetajjjv6lzfa5550.80134418231.378747185N
    20
    		2025-06-01 21:22:14.060https://runescan.io/tx/466DA707D9182C76B783F835420825FED3922A8725A5088D819535C7E7CB80E6thor1hj3ts525ehk9e64thckl89lc5pfw6g0p6kh6uc14937.953933.06TCY -> RUNE3096.5942120895311.57thor1hj3ts525ehk9e64thckl89lc5pfw6g0p6kh6uc5512.61114309121.631843447Y
    ...
    2500
    677KB
    19s