flipside

    euler deposits incomplte
    permaryeuler deposits incomplte
    Updated 2025-05-08
    /* SELECT
    tx_hash,
    event_name,
    decoded_log:shares::int AS amount,
    contract_address,
    topic_0,
    case
    when contract_address = lower('0x39de0f00189306062d79edec6dca5bb6bfd108f9') then 'USDC'
    when contract_address = lower('0xa446938b0204aa4055cdfed68ddf0e0d1bab3e9e') then 'USDT'
    when contract_address = lower('0x2137568666f12fc5a026f5430ae7194f1c1362ab') then 'AUSD'
    when contract_address = lower('0x6072a6d18446278bb5a43eb747de8f61e34cb77f') then 'BTC.b'
    ELSE 'Other'
    END AS token_name
    FROM avalanche.core.ez_decoded_event_logs
    WHERE origin_to_address = lower('0xddcbe30A761Edd2e19bba930A977475265F36Fa1')
    AND event_name = 'Deposit'
    --'Supply'

    --0xddcbe30A761Edd2e19bba930A977475265F36Fa1 */

    select distinct
    e.tx_hash,
    t.block_timestamp,
    t.origin_function_signature,
    e.event_name,
    e.topic_0,
    t.amount_precise,
    t.amount,
    t.amount_usd,
    t.symbol,
    t.decimals
    from avalanche.core.ez_decoded_event_logs e
    join avalanche.core.ez_token_transfers t
    on e.contract_address =t.contract_address
    and e.tx_hash =t.tx_hash
    WHERE e.origin_to_address = lower('0xddcbe30A761Edd2e19bba930A977475265F36Fa1')
    Last run: about 1 month ago
    TX_HASH
    EVENT_NAME
    AMOUNT
    CONTRACT_ADDRESS
    TOPIC_0
    1
    		0x64ad8d3ee079834d80d3088499f9ef2e295d1a6336a8ec8b453dae26e4e5548bDeposit2997422597470x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    2
    		0xb401dc7a61659a5140e02fbf299370ec93d32300d2d31332bf81d5109a7dcc70Deposit359466450770x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    3
    		0x19a0566241cf867c242367367d323d395a4f0de85d42e5c2f72e4c672d497f98Deposit857867486450x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    4
    		0x2248635eaa3f671282d24c8347248b1ba689ff16f701d3f8c4d25cfd1b134910Deposit2524439966740x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    5
    		0xb6445456341d900db05a53639f34f54dffdecbf00278288445f0a239d1443b6dDeposit9888174250x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    6
    		0xdb1f8bb8c870b5c52cb0fda2bd9c57950bba8c923c9a6ec5c2c19df8b36cc4e0Deposit99892451880x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    7
    		0x96e10346f64b6f44487bb627db4254e1623bc6e01efd63bcaca3e5bd29d79804Deposit104631436690x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    8
    		0x7326bf5adb57bd4fceb9bc283f9364dc091b19d29e1ff4a0958e22641b94248cDeposit99898060510x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    9
    		0x91f2aa996acc8ff1dd0e7a4a77f6c8342839c7e49f2f33276c65520003f10ea8Deposit118909991760x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    10
    		0xb9a7cb9f15acfdec74670d840e1c007cecd6325a66c51fb7fc4011f43360ced3Deposit1553790880x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    11
    		0x80f3ddacd9ef435f19bc3eb416f7822c9a88c45069de5c15705eb7bc56c069adDeposit117855907540x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    12
    		0x61c14c21ecde7f874883e6340f09958ca78da8a29b8c666b75439c3bdcd9438dDeposit319694372870x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    13
    		0x04686b9f4952903b3b465a43818d9383555f6c2e19fadf596e325d9ad6582303Deposit8490071260x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    14
    		0xb0ce84230fbdc723fd8aebc270e23d4ec47535e3b3f066ad8189975663fec54fDeposit70109826050x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    15
    		0xca0d8cfaf78a3512e235f6ba92bab7d38064da4e9052dc65c83b618f12612904Deposit19627910960x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    16
    		0xa62f2cae5a7537e218642819072872c9d62f218693cc2de771d6b4707840e9d2Deposit1998280615800x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    17
    		0x13c51f9da6dbb8367b12d281c7da3396b8365ebef6d7b324f45ddde0e5af93d4Deposit999034770x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    18
    		0xee3424e2cd844d3c77bd0092f805577ad5bf1982e1a7f95bae073f7187cfd07aDeposit475484750x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    19
    		0x61eebd9bdf20eef0dc2e4c94abfa5dab0f582a855656684c4f1911d763013d8bDeposit1067061533770x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    20
    		0x1774e035b4c340ccfa6ade07d6b1e9ef6eed9b15bbf67c0f454073394a15ccfcDeposit399551412730x39de0f00189306062d79edec6dca5bb6bfd108f90xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7
    ...
    7615
    2MB
    20s