maybeyonaseuler_user_actions
    Updated 13 hours ago
    with
    pools as (
    select
    evault_token,
    -- creator,
    asset,
    dToken,
    symbol,
    decimals,
    price_token
    from $query('000efe94-c68d-423d-b74f-f81f2d08ae6a')
    ),
    logs as (
    select *,
    regexp_substr_all(substr(data,3), '.{64}') as data_array,
    from swell.core.fact_event_logs
    where topic_0 in (
    '0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7', -- Deposit
    '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef', -- Transfer
    '0xcbc04eca7e9da35cb1393a6135a199ca52e450d5e9251cbd99f7847d33a36750', -- Borrow
    '0xfbde797d201c681b91056529119e0b02407c7bb96a4a2c75c01fc9667232c8db', -- Withdraw
    '0x5c16de4f8b59bd9caf0f49a545f25819a895ed223294290b408242e72a594231', -- Repay
    '0x5e804d42ae3b860f881d11cb44a4bb1f2f0d5b3d081f5539a32d6f97b629d978', -- Interest Accrued
    '0x4e16b07cac5fe5604af487e07b1b62efc8bd47477b18839f4688d2cae957f965', -- Convert Fees
    '0x8246cc71ab01533b5bebc672a636df812f10637ad720797319d5741d5ebb3962', -- Liquidate
    '0x00'
    ) and contract_address in (select evault_token from pools)
    ),
    enhanced_logs as (
    select
    l.*,
    p.*
    from logs l
    join pools p
    on l.contract_address = p.evault_token
    ),
    Last run: about 13 hours agoAuto-refreshes every 12 hours
    BLOCK_TIMESTAMP
    BLOCK_NUMBER
    TX_HASH
    EVENT_INDEX
    VAULT
    ASSET
    SYMBOL
    USER
    AMOUNT
    AMOUNT_USD
    ACTION
    1
    2025-04-26 23:23:19.00065065480x037e10b1231c5764a1c39ce04563f39f01f12bfa391c17d71344dbde4f8fbf22180x10d0d11a8b693f4e3e33d09bbab7d4afc3c03ef30xa6cb988942610f6731e664379d15ffcfbf282b44weETH0xb3b535c41800b58fd8d52c3f312524500557e4680.2909459706562.477116604deposit
    2
    2025-04-26 23:23:19.00065065480x037e10b1231c5764a1c39ce04563f39f01f12bfa391c17d71344dbde4f8fbf2220x49c077b74292aa8f589d39034bf9c1ed1825a6080x4200000000000000000000000000000000000006WETH0xb3b535c41800b58fd8d52c3f312524500557e4680.3110743887564.329380738borrow
    3
    2025-04-26 23:21:41.00065064990xbafb6bad3243df1f47da35cebcfc01083d90f07de78bb37af591e758e082d46a50x10d0d11a8b693f4e3e33d09bbab7d4afc3c03ef30xa6cb988942610f6731e664379d15ffcfbf282b44weETH0xb3b535c41800b58fd8d52c3f312524500557e4680.02823454.58394518deposit
    4
    2025-04-26 20:51:41.00065019990x0d177d442e5819ceeeb267581c8f5e51e89e45a90bf0b5acd9396d52aebca48830x49c077b74292aa8f589d39034bf9c1ed1825a6080x4200000000000000000000000000000000000006WETH0xb3dbe27e6f3e594070c92b6461c9e0e6fff6a0470.0279598779150.544748895deposit
    5
    2025-04-26 20:48:17.00065018970xcd1fd7dfb77b1e263a96adcac3c1fc1d96681b9d8b3b2ccd3d135406a07ab09230x49c077b74292aa8f589d39034bf9c1ed1825a6080x4200000000000000000000000000000000000006WETH0xb3dbe27e6f3e594070c92b6461c9e0e6fff6a0470.0440431171579.619385455deposit
    6
    2025-04-26 20:45:25.00065018110x1a4cec69b1c5d6b6570ed82666dbf978f5d9a26be428fcee9846f0ed3ec98a7f30x49c077b74292aa8f589d39034bf9c1ed1825a6080x4200000000000000000000000000000000000006WETH0xb3dbe27e6f3e594070c92b6461c9e0e6fff6a0470.09166887308165.715321997deposit
    7
    2025-04-26 20:42:41.00065017290xa8b930e466dd7dd34611a2576886ce5b763185c73e09dea0bb5fc57270ca843a30x49c077b74292aa8f589d39034bf9c1ed1825a6080x4200000000000000000000000000000000000006WETH0xb3dbe27e6f3e594070c92b6461c9e0e6fff6a0470.1245171047225.097041191deposit
    8
    2025-04-26 20:41:11.00065016840x4a417d29c4f58cc068c8d42a35a417e8453a387e319ae30cb3844a48e7c7d17a20x10d0d11a8b693f4e3e33d09bbab7d4afc3c03ef30xa6cb988942610f6731e664379d15ffcfbf282b44weETH0xadcf6661dca24225d7984ee96b55e939fc6ddd130.4502471088867.302000708borrow
    9
    2025-04-26 20:40:45.00065016710xd19f8d78403eb931654f9277536baeae7a931cd816cb095c7682d97151de57f850x49c077b74292aa8f589d39034bf9c1ed1825a6080x4200000000000000000000000000000000000006WETH0xadcf6661dca24225d7984ee96b55e939fc6ddd130.5903.88deposit
    10
    2025-04-26 20:35:35.00065015160x9a1dac323577ceb8922a4691bee3f9c3b373c0b013c56f775859ad2eb637e9cf30x49c077b74292aa8f589d39034bf9c1ed1825a6080x4200000000000000000000000000000000000006WETH0xb3dbe27e6f3e594070c92b6461c9e0e6fff6a0470.1297213857234.505132252deposit
    11
    2025-04-26 20:25:41.00065012190xac5a0767be990877cd79412c97f19c3f7fb486c94ba6549efcadf46fc5cda83720x10d0d11a8b693f4e3e33d09bbab7d4afc3c03ef30xa6cb988942610f6731e664379d15ffcfbf282b44weETH0xadcf6661dca24225d7984ee96b55e939fc6ddd130.76016176521464.284404974borrow
    12
    2025-04-26 20:24:29.00065011830x4c095c01504c6aef7ff1694ca101eee2a4ea9d42078b39edae2feecde45d4db750x49c077b74292aa8f589d39034bf9c1ed1825a6080x4200000000000000000000000000000000000006WETH0xadcf6661dca24225d7984ee96b55e939fc6ddd1311807.76deposit
    13
    2025-04-26 19:49:33.00065001350x533e56560f2e4914be4e25f5e4a69557e2d0e8e494e4b4ade94b9f1c0fd2017b50x49c077b74292aa8f589d39034bf9c1ed1825a6080x4200000000000000000000000000000000000006WETH0x6c2693f5a936f37ed03cfa8465bf2d8beff19a0e1.1374118842053.44929353deposit
    14
    2025-04-26 19:40:59.00064998780xa6f7d5f15679f19fa7393a8caf646f8237bae04b144d2131a14639bef3cb6ca2130x46e3c018798d6de4517a3c98358e4bd8d334b79c0xc3eacf0612346366db554c991d7858716db09f58rsETH0x364f7fd945b8c76c3c77d6ac253f1fea3b65e00d2.685038.4804withdraw
    15
    2025-04-26 19:40:59.00064998780xa6f7d5f15679f19fa7393a8caf646f8237bae04b144d2131a14639bef3cb6ca290x49c077b74292aa8f589d39034bf9c1ed1825a6080x4200000000000000000000000000000000000006WETH0x364f7fd945b8c76c3c77d6ac253f1fea3b65e00d2.013628.7937repay
    16
    2025-04-26 19:40:59.00064998780xa6f7d5f15679f19fa7393a8caf646f8237bae04b144d2131a14639bef3cb6ca240x49c077b74292aa8f589d39034bf9c1ed1825a6080x4200000000000000000000000000000000000006WETH0x364f7fd945b8c76c3c77d6ac253f1fea3b65e00d2.0108642943630.354071203withdraw
    17
    2025-04-26 19:28:53.00064995150xe60463bfe6eefd46c7e04d45a5c83a8b0b8d07b504acacfe9b6516fac2653e6e100x49c077b74292aa8f589d39034bf9c1ed1825a6080x4200000000000000000000000000000000000006WETH0x6c2693f5a936f37ed03cfa8465bf2d8beff19a0f11805.37deposit
    18
    2025-04-26 18:26:45.00064976510xa3fdaeee8f02e254244fe4f5f7c2f255696134ff643c0768efa97aec0ee72332180x10d0d11a8b693f4e3e33d09bbab7d4afc3c03ef30xa6cb988942610f6731e664379d15ffcfbf282b44weETH0xb3b535c41800b58fd8d52c3f312524500557e4680.4052386212777.535394913deposit
    19
    2025-04-26 18:26:45.00064976510xa3fdaeee8f02e254244fe4f5f7c2f255696134ff643c0768efa97aec0ee7233220x49c077b74292aa8f589d39034bf9c1ed1825a6080x4200000000000000000000000000000000000006WETH0xb3b535c41800b58fd8d52c3f312524500557e4680.433231379779.812149918borrow
    20
    2025-04-26 18:24:29.00064975830x8d394d179f96a7a76939f483bf07cdd3ab9307fd95658635aca4d39afbf8909b50x10d0d11a8b693f4e3e33d09bbab7d4afc3c03ef30xa6cb988942610f6731e664379d15ffcfbf282b44weETH0xb3b535c41800b58fd8d52c3f312524500557e4680.04690189.98941771deposit
    ...
    4549
    1MB
    236s