Moebridges 1
    Updated 2025-07-13
    with prc as (
    select hour::date as date,
    token_address,
    avg(price) as avg_price
    from crosschain.price.ez_prices_hourly
    group by 1,2
    )
    , sq_base as (
    select
    t1.* , amount*avg_price as amount_usd
    from axelar.defi.ez_bridge_squid t1
    left join prc on t1.BLOCK_TIMESTAMP::date=prc.date
    and t1.token_address=prc.token_address
    where BLOCK_TIMESTAMP>= current_date - 180
    order by 1 desc
    )
    ,
    st_base as (
    select
    t1.* , amount*avg_price as amount_usd
    from axelar.defi.ez_bridge_satellite t1
    left join prc on t1.BLOCK_TIMESTAMP::date=prc.date
    and t1.token_address=prc.token_address
    where BLOCK_TIMESTAMP>= current_date - 180
    order by 1 desc
    )
    SELECT
    date_trunc(week, BLOCK_TIMESTAMP) as date,
    'Squid' as tool,
    count(DISTINCT tx_hash) as no_txn,
    count(DISTINCT SENDER) as no_sender,
    sum(amount_usd) as volume_usd,
    avg(amount_usd) as avg_USD_Volume,
    median(amount_usd) as median_volume_usd,
    avg(avg_USD_Volume) OVER (ORDER BY date ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as MA_7_Days_volume,
    sum(no_sender) over (order by date) as cum_buyers,
    Last run: 16 days agoAuto-refreshes every 24 hours
    DATE
    TOOL
    NO_TXN
    NO_SENDER
    VOLUME_USD
    AVG_USD_VOLUME
    MEDIAN_VOLUME_USD
    MA_7_DAYS_VOLUME
    CUM_BUYERS
    CUM_SALE
    CUM_VOLUME
    1
    2025-01-13 00:00:00.000Squid11678692916403751.43138461411.561090387122.5014419711411.56109038769291167816403751.4313846
    2
    2025-05-12 00:00:00.000Squid6295377114613661.4392632343.81097662680.9445164222057.94527311498221161562288495273.601336
    3
    2025-05-19 00:00:00.000Squid7301457315493859.63525022127.6928914129.0501683372077.647043718102794168863303989133.236586
    4
    2025-07-07 00:00:00.000Squid559132909813821.057140091775.93576857456.9405148811704.631528758128514209401369084546.097761
    5
    2025-03-31 00:00:00.000Squid9723610420666243.46078732129.66235168924.470244881918.62356937175661123013209922313.358857
    6
    2025-04-07 00:00:00.000Satellite27148571067.8955640462693.71648851434.3560607064393.97891606644402025710928.7691554
    7
    2025-04-21 00:00:00.000Satellite14721963723.9327102876883.742376502630.9658519134377.090569074698438627678300.4397004
    8
    2025-04-14 00:00:00.000Squid642339799997330.940905661560.13279352519.2894275592035.04042516384362137363234291411.601443
    9
    2025-06-16 00:00:00.000Squid644941126503439.099426351015.36910217425.5528129141811.407446037119145194190341492803.558149
    10
    2025-06-23 00:00:00.000Squid495131989877114.285984462014.09345146535.4574560371867.125525417122343199141351369917.844133
    11
    2025-02-03 00:00:00.000Satellite372691883387.015890786898.853538061989.24341143712930.43596391260152415102582.8374392
    12
    2025-05-19 00:00:00.000Satellite370353015127.208604858398.6830323252513.9735287296000.540778607843534734403142.7466424
    13
    2025-04-28 00:00:00.000Squid567834218853329.068693781568.34881642135.1182818662000.38121025691245148951258628972.307321
    14
    2025-06-30 00:00:00.000Satellite15822516945.393883723946.148044914999.7671112867481.1806607181134692554688190.7474945
    15
    2025-06-30 00:00:00.000Squid466928817900807.196487691700.56117014453.4872640331775.615929764125224203810359270725.040621
    16
    2025-01-27 00:00:00.000Satellite505768660692.830613723793.1121720161286.20786641614940.963439192191115213219195.8215484
    17
    2025-02-10 00:00:00.000Satellite253403806875.9940969920802.601060639799.95073333314504.868983256300177718909458.8315362
    18
    2025-04-14 00:00:00.000Satellite219331003647.737834715282.35651492416.941534214047.580540445677423926714576.5069901
    19
    2025-02-10 00:00:00.000Squid12403782118289857.92259661487.706029168101.185431741539.724593323339095729987320569.9582539
    20
    2025-02-24 00:00:00.000Squid8969509518163920.97438932042.037209038109.932873481528.8406758094879880875119421285.755803
    52
    7KB
    44s