flipside

    weekly
    datavortexweekly
    Updated 2025-05-04
    WITH sender_transactions as (
    select
    tx_hash,
    block_timestamp,
    old_owner_id as sender_address,
    amount_raw as sent_amount,
    token_id as sent_token
    from near.defi.fact_intents
    where log_event = 'mt_transfer'
    and RECEIPT_SUCCEEDED = TRUE
    qualify row_number() over (partition by tx_hash, log_index order by log_event_index desc) = 1
    ),
    swap_details as (
    select
    tx_hash,
    block_timestamp,
    sender_address,
    sent_amount,
    split(sent_token, ':')[1] :: string as input_token
    from sender_transactions
    ),
    token_metadata as (
    select *
    from $query('64f376d0-8a1f-4ccf-8516-cae9c8067b49')
    ),
    adjusted_swaps as (
    select
    s.tx_hash,
    s.block_timestamp,
    s.sender_address,
    s.input_token,
    t.symbol as input_symbol,
    t.chain as source_chain,
    s.sent_amount / pow(10, t.decimal) as adjusted_input
    from swap_details s,
    lateral (select * from token_metadata where token = s.input_token) t
    Last run: 22 days ago
    WEEK_START
    SWAP_COUNT
    UNIQUE_SENDERS
    TOTAL_INPUT_USD
    CUMULATIVE_SWAPS
    CUMULATIVE_SENDERS
    CUMULATIVE_USD
    1
    		2025-04-28 00:00:00.0001219613182039258.36235004852641155020574218.4586847
    2
    		2025-04-21 00:00:00.0001598021661003268.56162748730681046118534960.0963346
    3
    		2025-04-14 00:00:00.0002448756391305581.7529130457088850617531691.5347071
    4
    		2025-04-07 00:00:00.00060978591243854.5983176132601306816226109.7817941
    5
    		2025-03-31 00:00:00.0002662541766356.36850913126504238314982255.1834765
    6
    		2025-03-24 00:00:00.0002495480500364.08170270223842200814215898.8149674
    7
    		2025-03-17 00:00:00.0001506356433680.58813325921347163513715534.7332647
    8
    		2025-03-10 00:00:00.0001268273943891.87885351319841138413281854.1451314
    9
    		2025-03-03 00:00:00.00015532311802142.1679721518573121412337962.2662779
    10
    		2025-02-24 00:00:00.00020882012450480.2937762217020107510535820.0983057
    11
    		2025-02-17 00:00:00.00010081641284186.23552074149329738085339.80452952
    12
    		2025-02-10 00:00:00.000987183947562.1100741139249016801153.56900877
    13
    		2025-02-03 00:00:00.00010021761097380.57371771129377915853591.45893467
    14
    		2025-01-27 00:00:00.000583114330339.012573351119356694756210.88521697
    15
    		2025-01-20 00:00:00.00016641601604836.90622042113526164425871.87264362
    16
    		2025-01-13 00:00:00.0001162176549491.0820805296885362821034.96642319
    17
    		2025-01-06 00:00:00.00049694239413.57534395685264272271543.88434268
    18
    		2024-12-30 00:00:00.000408113258279.07768642380303752032130.30899872
    19
    		2024-12-23 00:00:00.000499116354769.88152503776222991773851.2313123
    20
    		2024-12-16 00:00:00.000651139382391.38582571232091419081.34978726
    26
    2KB
    5s