fidamMounthly Inflow
Updated 2024-12-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH playformIn AS (
SELECT
DATE_TRUNC('day', m.block_timestamp) AS date,
l.project_name AS AddressName,
SUM(m.AMOUNT_USD) AS Amountusd
FROM bsc.core.ez_token_transfers m
JOIN bsc.core.dim_labels l
ON m.from_address = l.address
WHERE m.contract_address = '0x947950bcc74888a40ffa2593c5798f11fc9124c4'
AND block_timestamp >= '2024-01-01'
AND block_timestamp <= '2024-12-31'
GROUP BY date, AddressName
)
SELECT Date,
AddressName,
Amountusd
FROM playformIn
ORDER BY date desc
QueryRunArchived: QueryRun has been archived