flipside

    2-top routes [last 30d]
    BlockTracker2-top routes [last 30d]
    Updated 2025-05-22
    -- forked from top routes [last 30d] @ https://flipsidecrypto.xyz/studio/queries/4701dfba-bf6d-483d-92dd-f0c1be32d0e6

    with data as (
    select
    block_timestamp,
    tx_id,
    case when contains(in_asset,'-') then split(in_asset,'-')[0] else in_asset end as in_asset,
    case when contains(out_asset,'-') then split(out_asset,'-')[0] else out_asset end as out_asset,
    in_e8 / 1e8 as in_amount,
    out_e8 / 1e8 as out_amount
    from thorchain.defi.fact_streamling_swap_details_events
    )
    ,
    amount_usd as (
    select
    a.tx_id,
    sum(from_amount_usd) / count(distinct pool_name) as in_amount_usd,
    sum(to_amount_usd) / count(DISTINCT pool_name) as out_amount_usd,
    sum(LIQ_FEE_RUNE) as liquidity_fee_rune,
    sum(LIQ_FEE_RUNE_USD) as liquidity_fee_usd
    from thorchain.defi.fact_swaps a
    join data b using(tx_id)
    group by 1
    )
    ,
    main as (
    select
    block_timestamp,
    tx_id,
    in_asset,
    case when contains(in_asset,'/') then split(in_asset,'/')[1]
    when contains(in_asset,'~') then split(in_asset,'~')[1]
    when contains(in_asset,'.') then split(in_asset,'.')[1]
    end as in_symbol,
    out_asset,
    case when contains(out_asset,'/') then split(out_asset,'/')[1]
    Last run: 22 days ago
    Affiliates
    TX_ID
    IN_ASSET
    OUT_ASSET
    ROUTE
    IN_AMOUNT
    OUT_AMOUNT
    IN_AMOUNT_USD
    OUT_AMOUNT_USD
    LIQUIDITY_FEE_RUNE
    LIQUIDITY_FEE_USD
    SLIP
    BLOCK_TIMESTAMP
    1
    		ThorwalletC2D29ADF1F7E4D28225613E43F7F7EC3977C3EB85DAE7021D085BDBF2FDCB50CBTC.BTCETH.ETHBTC --> RUNE --> ETH208.3329598869.67060622489482.783119722470907.342151311573.3065149822355.5766696940.09940458342025-05-22 01:23:59.306
    2
    		ThorswapD140654E7EDE777F55ACA08CBEE9F2D319835CBA526C70D81C2150A160AC6979BTC.BTCETH.ETHBTC --> RUNE --> ETH203.38569.39745322314459.288087622292332.914657912396.7170916124815.1516985120.1112066012025-05-22 05:41:42.609
    3
    		Thorwallet8B202FF8FCAEB40D83F2DDBA4FEA09A09C749249AE772492E0225EDF91B59EB0BTC.BTCETH.ETHBTC --> RUNE --> ETH188.258066.43035420196804.129258220170456.551354210534.3204432120119.2670382330.099616092282025-05-21 23:08:37.175
    4
    		Unknown AffiliatesAACD04AFDF5C6C2E73499722F66F2BF307433D2A5634080F4226409C496D60D0BTC.BTCETH.ETHBTC --> RUNE --> ETH44.9991883.5313274738561.889717394734605.189823632666.722313924750.1228626280.10024397642025-05-19 23:24:36.826
    5
    		ThorswapAACD04AFDF5C6C2E73499722F66F2BF307433D2A5634080F4226409C496D60D0BTC.BTCETH.ETHBTC --> RUNE --> ETH44.9991883.5313274738561.889717394734605.189823632666.722313924750.1228626280.10024397642025-05-19 23:24:36.826
    6
    		Unknown Affiliates65D4CC61536800440F7882B4740C974B4BEE0AF8C97B22372927F2B58F63E69CBTC.BTCETH.ETHBTC --> RUNE --> ETH39.991660.3994654311517.09768344302317.766923052250.189684814371.1158310360.10138231472025-05-22 01:26:23.967
    7
    		Thorswap65D4CC61536800440F7882B4740C974B4BEE0AF8C97B22372927F2B58F63E69CBTC.BTCETH.ETHBTC --> RUNE --> ETH39.991660.3994654311517.09768344302317.766923052250.189684814371.1158310360.10138231472025-05-22 01:26:23.967
    8
    		Unknown Affiliates784133EF2531CE543CF91838AE65F5EFFFC03F4B9F3CCDF9315F00014907DC2CBTC.BTCETH.ETHBTC --> RUNE --> ETH351449.384813765267.541342583762132.02096692053.031225733757.3625824320.099790055852025-05-21 06:21:12.678
    9
    		Thorswap784133EF2531CE543CF91838AE65F5EFFFC03F4B9F3CCDF9315F00014907DC2CBTC.BTCETH.ETHBTC --> RUNE --> ETH351449.384813765267.541342583762132.02096692053.031225733757.3625824320.099790055852025-05-21 06:21:12.678
    10
    		Thorswap81E5EE911E15ECD4365C5B158FAFD7256C0A25A03C90488B5E6EAA11A40653C4BTC.BTCETH.ETHBTC --> RUNE --> ETH351444.1673953720444.828723963717312.382725132061.971673563720.8784897110.10001165622025-05-20 06:04:55.117
    11
    		Unknown Affiliates81E5EE911E15ECD4365C5B158FAFD7256C0A25A03C90488B5E6EAA11A40653C4BTC.BTCETH.ETHBTC --> RUNE --> ETH351444.1673953720444.828723963717312.382725132061.971673563720.8784897110.10001165622025-05-20 06:04:55.117
    12
    		Unknown AffiliatesD0A736FB48E14F4EE7C99C2EC662BDD7660E33BDFAA623B0CE75A238CA6E3457BTC.BTCETH.ETHBTC --> RUNE --> ETH39.991686.6430153371452.376523623368626.859612572375.376892583373.6049704490.10006384772025-05-21 00:38:01.903
    13
    		ThorswapD0A736FB48E14F4EE7C99C2EC662BDD7660E33BDFAA623B0CE75A238CA6E3457BTC.BTCETH.ETHBTC --> RUNE --> ETH39.991686.6430153371452.376523623368626.859612572375.376892583373.6049704490.10006384772025-05-21 00:38:01.903
    14
    		Unknown AffiliatesB87210493EF9BCD02F019851A74DFEB3ACA88FF9F9C5BC54085D7FA69F1BFFF1BTC.BTCETH.ETHBTC --> RUNE --> ETH251077.5484162615718.728331042613504.506038631422.590854772617.5228910280.10006897392025-05-19 02:11:31.596
    15
    		ThorswapB87210493EF9BCD02F019851A74DFEB3ACA88FF9F9C5BC54085D7FA69F1BFFF1BTC.BTCETH.ETHBTC --> RUNE --> ETH251077.5484162615718.728331042613504.506038631422.590854772617.5228910280.10006897392025-05-19 02:11:31.596
    16
    		Unknown AffiliatesF1574675C7EFDBC0D5AEFF4B025A3A0E5D2EB4CFE184A5D2C2A54887C291EE86BTC.BTCETH.ETHBTC --> RUNE --> ETH24.991030.2729922589441.28021082587258.281383581483.142352422589.7295047960.10001113082025-05-17 05:25:31.178
    17
    		ThorswapF1574675C7EFDBC0D5AEFF4B025A3A0E5D2EB4CFE184A5D2C2A54887C291EE86BTC.BTCETH.ETHBTC --> RUNE --> ETH24.991030.2729922589441.28021082587258.281383581483.142352422589.7295047960.10001113082025-05-17 05:25:31.178
    18
    		ThorswapF68422585AF7DECDEA45BB4ECD2C0C07ADEEA92204420F709DE2DB60D3689EA5BTC.BTCETH.ETHBTC --> RUNE --> ETH24.898181298.5095562331618.913885312328501.032810522845.275489373734.2176315970.1601555732025-04-23 07:16:47.153
    19
    		Unknown AffiliatesF68422585AF7DECDEA45BB4ECD2C0C07ADEEA92204420F709DE2DB60D3689EA5BTC.BTCETH.ETHBTC --> RUNE --> ETH24.898181298.5095562331618.913885312328501.032810522845.275489373734.2176315970.1601555732025-04-23 07:16:47.153
    20
    		ThorswapA5E4852A7ACE2A38ABC9DFEC7F821CBA0A19D691A4FEF50BF84CF9757BCDAE1ABTC.BTCETH.ETHBTC --> RUNE --> ETH20.91997837.7273582176809.817245792174999.64902921144.126612322179.6098095110.10012862822025-05-16 05:57:44.812
    ...
    1000
    241KB
    5s