flipside

    Daily Number of Swappers
    SniperDaily Number of Swappers
    Updated 9 days ago
    select
    BLOCK_TIMESTAMP::date as date,
    case when TOKEN_in = lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7') then 'SELL'
    when TOKEN_out = lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7') then 'BUY' end as type,
    count(DISTINCT ORIGIN_FROM_ADDRESS) as users,
    count(DISTINCT TX_HASH) as transactions,
    count(*) as swap,
    sum(AMOUNT_IN) as volume_avax,
    sum(AMOUNT_IN_USD) as volume_usd,
    avg(AMOUNT_IN_USD) as avg_volume_usd,
    avg(volume_usd) over (order by date rows between 1 preceding and 0 following) as "Moving Average 7D",
    avg(volume_usd) over (order by date rows between 2 preceding and 0 following) as "Moving Average 14D",
    avg(volume_usd) over (order by date rows between 4 preceding and 0 following) as "Moving Average 30D",
    sum(users) over (order by date asc) as cumulative_users
    from avalanche.defi.ez_dex_swaps
    where
    AMOUNT_IN_USD is NOT NULL
    and
    TOKEN_in = lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7') OR
    TOKEN_out = lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7')
    group by 1,2


    Last run: 9 days ago
    DATE
    TYPE
    USERS
    TRANSACTIONS
    SWAP
    VOLUME_AVAX
    VOLUME_USD
    AVG_VOLUME_USD
    Moving Average 7D
    Moving Average 14D
    Moving Average 30D
    CUMULATIVE_USERS
    1
    		2025-01-15 00:00:00.000BUY1015377956832652304.684542232509644.73448.7117343112509644.732509644.732509644.731015
    2
    		2025-01-16 00:00:00.000BUY693306471252060171.286020622122763.94309.5310498692316204.3352316204.3352316204.3351709
    3
    		2025-01-16 00:00:00.000SELL11102122763.942316204.3352316204.3351709
    4
    		2025-01-17 00:00:00.000BUY550166842551407519.053163371383338.1334.3011358141383338.11753051.022005248.923333332259
    5
    		2025-01-18 00:00:00.000BUY428192841591864015.789549921135784.84289.0773326551259561.471259561.471787882.90252687
    6
    		2025-01-19 00:00:00.000BUY348121922691347753.6852494830566.53386.849804378983175.6851116563.156666671368113.35253035
    7
    		2025-01-20 00:00:00.000SELL10219636418463113.6145543174390.01479.093434066502478.27485453.053333333881019.873389
    8
    		2025-01-20 00:00:00.000BUY2529811554782481.737545775451402.62297.562702703312896.315000001805917.996666667795096.423389
    9
    		2025-01-21 00:00:00.000BUY31211851893739445.003680451394190.09208.235652404422796.355000001339994.24597266.8183911
    10
    		2025-01-21 00:00:00.000SELL21043592031317908.3526851345650.65375.707228261369920.370000001304743.583333333439239.983911
    11
    		2025-01-22 00:00:00.000BUY233253942791097524.70315483554923.07129.685223183450286.860000001431587.936666667384111.2884354
    12
    		2025-01-22 00:00:00.000SELL210418149835511976.0345159492730.71328.92570761523826.890000001464434.81447779.4284354
    13
    		2025-01-23 00:00:00.000SELL277682185037875513.2236588469054.12253.542767568480892.415000001505569.3451309.7284974
    14
    		2025-01-23 00:00:00.000BUY343141931401742543.14197311037860.7335.877249191753457.410000001666548.51580043.854974
    15
    		2025-01-24 00:00:00.000BUY7854396102587497935.675423525147950.17501.8473552353092905.4353515245.71540503.7546500
    16
    		2025-01-24 00:00:00.000SELL74140889374156132148.1665774359926.23465.108409434753938.21955613.683333332301504.3866500
    17
    		2025-01-25 00:00:00.000SELL4194587737545716182.61217711858396.77251.9860027123109161.53788757.723333332574637.5987550
    18
    		2025-01-25 00:00:00.000BUY631235757142824056.857686352111454.77369.5877419921984925.773039267.236666672903117.7287550
    19
    		2025-01-26 00:00:00.000BUY629335464972745944.802745562472711.2380.5927658922292082.9852147520.913333333190087.8288632
    20
    		2025-01-26 00:00:00.000SELL4534031621735468704.01186571786186.63287.306840922129448.9152123450.866666672517735.128632
    ...
    178
    24KB
    3s