flipside

    top routes copy
    BlockTrackertop routes copy
    Updated 5 days ago
    -- forked from top routes @ https://flipsidecrypto.xyz/studio/queries/2ed5ba9f-bcaf-4847-8d58-db48b1b0b40d

    -- 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,
    Last run: 5 days ago
    Affiliates
    TX_ID
    BLOCK_TIMESTAMP
    IN_ASSET
    OUT_ASSET
    ROUTE
    IN_AMOUNT
    OUT_AMOUNT
    IN_AMOUNT_USD
    OUT_AMOUNT_USD
    LIQUIDITY_FEE_RUNE
    LIQUIDITY_FEE_USD
    SLIP
    1
    		Trust Wallet189E...0FAC2025-05-21 19:26:27.573BTC.BTCETH.USDTBTC --> RUNE --> USDT13.51434940.4742741435572.848307141434136.24692153767.556527011449.1529687210.1009459722
    2
    		Trust WalletF428...05972025-05-08 09:16:02.837BTC.BTCETH.USDTBTC --> RUNE --> USDT11.091101536.0104951104927.579633681104042.01171899854.079370241116.7031840540.1010657354
    3
    		Trust WalletF279...D7C02025-05-06 20:41:34.266BTC.BTCETH.USDTBTC --> RUNE --> USDT8.478778786.62803472.636510387802715.7608846928284.7420906810137.2651789361.261681446
    4
    		Trust WalletEE4C...3B9D2025-05-12 21:28:25.912BTC.BTCBSC.BNBBTC --> RUNE --> BNB6.941073.029905708050.106331943707506.016015343374.35854326715.128247340.1009996667
    5
    		Trust Wallet404B...38612025-05-27 14:10:37.466BTC.BTCETH.USDTBTC --> RUNE --> USDT5.98801656967.839773660518.634412083660008.353931787338.49582995662.7303358870.1003348432
    6
    		Trust Wallet15CF...25792025-05-04 16:53:51.611BTC.BTCETH.WBTCBTC --> RUNE --> WBTC5.54555.519007530110.241939661529459.412887476671.58366666850.6868534310.1604735744
    7
    		Trust Wallet6803...2C6E2025-05-27 13:23:32.415BTC.BTCETH.USDTBTC --> RUNE --> USDT4.55500464.357322503106.039823357502705.276658133255.76569349503.8270161330.100143305
    8
    		Trust Wallet417F...98E52025-05-19 06:58:45.984ETH.USDTBTC.BTCUSDT --> RUNE --> BTC5000004.87504501476.360755526501085.483499941292.43776633500.8530529120.09987570544
    9
    		Trust Wallet953F...3A8E2025-05-09 19:37:16.549BTC.BTCETH.DAIBTC --> RUNE --> DAI3.691377763.89202381187.714730191380888.551716991784.983474311160.666301680.3044868071
    10
    		Trust Wallet6127...C8462025-05-07 08:36:20.308BSC.USDTETH.USDTUSDT --> RUNE --> USDT374490.30475373542.591558375083.389649905374793.851895049297.22798798375.8066647750.1001928305
    11
    		Trust Wallet4BA3...34E62025-05-25 18:22:17.750BTC.BTCETH.WBTCBTC --> RUNE --> WBTC3.3999823.389836365973.765869504365692.217193313196.42018384366.3561970080.1001044969
    12
    		Trust Wallet79E4...8D422025-05-05 19:48:35.481BTC.BTCETH.ETHBTC --> RUNE --> ETH3.4927181.010026330800.661189081330527.338116768262.52345807331.865907510.1003220206
    13
    		Trust WalletBC35...1F012025-05-31 17:16:34.019BTC.BTCETH.ETHBTC --> RUNE --> ETH3.0392124.852919318638.463907993318402.96226496188.2919216319.6031154760.1003027417
    14
    		Trust Wallet5924...A5A22025-06-02 08:15:51.296BTC.BTCETH.USDCBTC --> RUNE --> USDC2.9999315759.600974317322.898416721317098.690940855188.988793318.7409020210.1004468646
    15
    		Trust Wallet866E...FDA92025-06-02 08:10:04.337BTC.BTCETH.ETHBTC --> RUNE --> ETH2.999125.740223317126.522810986316872.788124194188.93822077318.7346954970.1005071076
    16
    		Trust Wallet0555...8F842025-06-01 13:48:48.217BTC.BTCETH.USDCBTC --> RUNE --> USDC3.01313362.473794314771.35357153314530.883229609193.48719186316.0132224690.1003945305
    17
    		Trust Wallet6100...35152025-05-15 17:34:58.594BTC.BTCETH.USDTBTC --> RUNE --> USDT3311167.826235312789.621106475312545.016189502159.8362223312.9041825450.1000366257
    18
    		Trust Wallet7D9E...395A2025-05-20 18:53:48.090BTC.BTCETH.USDTBTC --> RUNE --> USDT3316000.727267312655.873932599312415.840482972181.66133225312.3307949790.0998960266
    19
    		Trust WalletE240...25642025-06-01 10:50:12.090BTC.BTCETH.USDCBTC --> RUNE --> USDC2.99309816.052865311425.456153634311191.731503515191.2588742311.2227703720.09993491676
    20
    		Trust Wallet8846...37DD2025-05-13 02:47:41.202BTC.BTCETH.ETHBTC --> RUNE --> ETH2.995125.016562306184.936031606305939.817377051162.71500974308.1764188870.1006504183
    ...
    1000
    182KB
    15s