freemartianUser activity
    Updated 2024-02-19
    SELECT
    eth_from_address AS wallet,
    block_timestamp,
    tx_hash,
    'ETH' AS symbol,
    amount,
    amount_usd
    FROM ethereum.core.ez_eth_transfers
    WHERE eth_to_address = lower('0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d')
    AND eth_from_address <> '0x0000000000000000000000000000000000000000'
    AND amount_usd IS NOT NULL
    AND eth_from_address = lower('{{wallet_address}}')
    AND origin_function_signature = '0xf6326fb3'

    UNION

    SELECT
    from_address AS wallet,
    block_timestamp,
    tx_hash,
    symbol,
    amount,
    amount_usd
    FROM ethereum.core.ez_token_transfers
    WHERE to_address = lower('0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d')
    AND origin_function_signature IN ('0x0a553dcb','0x3265aead','0xf688bcfb','0x365833e1')
    AND from_address <> '0x0000000000000000000000000000000000000000'
    AND amount_usd IS NOT NULL
    AND from_address = lower('{{wallet_address}}')
    Last run: over 1 year agoAuto-refreshes every 3 hours
    WALLET
    BLOCK_TIMESTAMP
    TX_HASH
    SYMBOL
    AMOUNT
    AMOUNT_USD
    1
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72024-02-01 03:41:35.0000x41ba1cf0472558c842d658ea15414f1f0019dace145ba1ec94232f416d7908ceDAI1998.2492339861993.421463837
    2
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72024-02-01 06:15:35.0000x00fa4aff74cd369a3cdbd515a2e3a528a7b8469ae3b36792f1c04535d1e8d470DAI11981.70602278611955.621848775
    3
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72023-12-02 03:43:23.0000x8628665527c883dbe444b8c949f34f85879c2140dbce902695d4b12f92294943DAI7636.6104824937627.477096356
    4
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72024-01-24 12:50:35.0000xa04029005b6ec9d7c094e1ad2b2380d1790a4dbbcd73ceb232bd86475e69fcf2DAI1978.6743623871978.875235238
    5
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72024-01-26 11:31:47.0000xbc05160f2d90a1a0a78d207ff207099045f9b0357c3fe4c4462eda4035d13e24DAI599.471187842599.218810472
    6
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72024-01-24 12:07:35.0000x50ac30be836b118b4ed796e40105e12a8acb74090df48c8d40c0b559ab1bb19fDAI49.95371002749.958781273
    7
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72023-12-05 11:08:47.0000x9477a8638175bd493c19626eae88de5a6cf905934aa6fe19f7f46ffadeb451bcDAI4999.8005101624982.166213762
    8
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72024-01-23 07:33:35.0000x23cde4f9bf8ad3f07389455fbe147991c8558a82e76ca7f4288d29c5f785a95cDAI1000.003725907997.981718373
    9
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72023-11-30 11:09:35.0000x90bad00b1c61a16f461a8465dc8e049a7f4f39968a65c3524ea0b880662623efDAI8160.1385519718135.764218116
    10
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72023-11-21 06:59:23.0000x070091331e5551fe588f92a5db93c90e4e28f8a747b5ecaceb66f306e190f3b9DAI2101.1110177952101.111017795
    11
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72023-12-09 20:18:35.0000x8f21a7cc04efe8ee4fe57a664c6741f89931a70bd050723d77bc1f144ebcb7d7DAI10002.17730949983.303200818
    12
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72023-12-06 04:14:47.0000xa38956cb04f2d63530e10b3e823fd7bff7cdd3c723afaf07070214dbf5e4dcc1DAI10000.39709372610020.397887914
    13
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72023-11-24 12:24:59.0000x99bf3c6cd35a9cb271d261265ee50eb3697dff8a582f12fcf0e3d49887e9ac4dDAI92.17167661492.166515
    14
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72023-12-19 02:21:23.0000xe1974bad2ecf0062e65b3e55a622969abfcb16f3a1ac0c93e30364a64c2056d8DAI1486.1529220521483.213311572
    15
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72024-02-03 02:10:23.0000x75b03ffde05ec833b46f6975ff3b0e7a05a7c0ee2537a2299e4f127d9dc5c52bDAI2993.3626926472991.390066632
    16
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72024-01-08 22:36:59.0000x5df1da698bc41987054fab9f84965e85d8f02d977417b59a4f6217edd5d8ae84DAI6003.1926796296015.199064988
    17
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72024-02-04 05:29:47.0000xd3bcddbe5ea20c926e772cff026da8ad253ab5d703d6d7d173e0e01b9d2bea34DAI52.96650061552.945208082
    18
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72024-01-21 11:31:47.0000x82e27ac858be7f9be56413866aca5881c9e15eb3ab01a276d60a301c608fbe6fDAI2997.423404332995.097403768
    19
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72024-01-16 20:46:47.0000x90c7534f8e2cb9d37692e133169097a46f33d7cafc0d915748a4f41c75c5c376DAI1998.9993416881996.610537475
    20
    0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c72023-11-21 03:46:47.0000xe980df7a7630b1b01b593d96c09dbbaf446be2c1ff2135d338f3beac8c8b759cDAI6002.9279117996002.927911799
    ...
    4029
    697KB
    52s