USD_AMOUNT | |
|---|---|
1 | 1301390722.98833 |
freemartianTotal Tokens Deposited
Updated 2024-01-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 0xf6326fb3: deposit ٍETH
-- 0x0a553dcb: deposit USDT
-- 0x3265aead: deposit stETH
-- 0xf688bcfb: deposit USDC
-- 0x365833e1: deposit DAI
WITH datas AS (
SELECT
SUM(amount_usd) AS usd_amount
FROM ethereum.core.ez_eth_transfers
WHERE eth_to_address = lower('0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d')
AND origin_function_signature = '0xf6326fb3'
AND block_timestamp::date >= '2023-11-20'
AND block_timestamp < CURRENT_TIMESTAMP() - INTERVAL '2 HOUR'
AND eth_from_address <> '0x0000000000000000000000000000000000000000'
UNION
SELECT
SUM(amount_usd) AS usd_amount
FROM ethereum.core.ez_token_transfers t
WHERE to_address = lower('0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d')
AND block_timestamp::date >= '2023-11-20'
AND block_timestamp < CURRENT_TIMESTAMP() - INTERVAL '2 HOUR'
AND origin_function_signature IN ('0x0a553dcb','0x3265aead','0xf688bcfb','0x365833e1')
AND from_address <> '0x0000000000000000000000000000000000000000'
)
SELECT
sum(usd_amount) AS usd_amount
FROM datas
Last run: about 1 year agoAuto-refreshes every 3 hours
1
20B
16s