flipside

    slow-coral copy copy
    Pine Analyticsslow-coral copy copy
    Updated 2025-03-08
    select
    from_address,
    count(Distinct tx_id) as transactions,
    sum(case when not FROM_AMOUNT_USD is null then FROM_AMOUNT_USD else to_AMOUNT_USD end) as swap_volume_Usd


    from maya.defi.fact_swaps
    where block_timestamp > current_date - 30
    group by 1
    order by 3 desc


    Last run: 11 days ago
    FROM_ADDRESS
    TRANSACTIONS
    SWAP_VOLUME_USD
    1
    		maya1364z3c8zldp3tnhf05p40m2trdlhhzqk5qfrm0455814694889.3833735
    2
    		maya1qefmyzkgkvu2kz57yv5x5r6k9tvr65v3u2dgvh200711618820.9635985
    3
    		0xd1f7112354055160d58fa1b1e7cfd15c0bfee46434709591092.8520272
    4
    		bc1qu8tkf2sv57ys49twv84mhfj063ue5pvnw4jmvt898979755.35203893
    5
    		maya1x5979k5wqgq58f4864glr7w2rtgyuqqm6l2zhx150208875116.61172977
    6
    		maya1qvlul0ujfrq27ja7uxrp8r7my9juegz0ul0lxc32638786856.42139643
    7
    		thor17hwqt302e5f2xm4h95ma8wuggqkvfzgvsnh5z944958585931.94166522
    8
    		thor1kua0els7fl2mgvaqe8x43k7csjj5tnjgq3c0rn21898424329.23114633
    9
    		maya17f9d0w3y2j9a6s83vz0xfssdmdwe5yzkk3j9kk40896153359.88909746
    10
    		maya1js9cp7g4h7l8lqsx8hk6q6h4tpw7npu7zjlgr239715854013.76015187
    11
    		thor1qvlul0ujfrq27ja7uxrp8r7my9juegz0ug3nsg25285466357.04171082
    12
    		maya1dmgdpkqngg3amua5hffjcharngzdp4wv3jrwyq38694735132.98274301
    13
    		bc1q47pfu4ymsdpjranzucmxcj4g5cqwnh52srnnr94564555994.98718349
    14
    		maya1quawafcnyqgr3wxp7qz6373shlzlmdsc39znl035254170791.38738293
    15
    		maya1aqqn36tf54tjj6qtr79ke5methxvvx8g6l38jv2812792708.08300927
    16
    		bc1qm5z2m9gm9rr7pdrax5wdlewz6zg9hnq5p7hhjh552782805.8350443
    17
    		thor17f9d0w3y2j9a6s83vz0xfssdmdwe5yzkkxvfqx20642752308.22334624
    18
    		bc1q7y9hl7a3gvtzxqzaunfaekkequz44eantfc8k6272706433.13968819
    19
    		maya1afa7l8atkqcl9c3k4jhv4v3yjg52me0dt4rc3m33022505173.12939893
    20
    		thor1quawafcnyqgr3wxp7qz6373shlzlmdsc3julfl19222268134.69799911
    ...
    1973
    124KB
    2s