JhanlycnStarSharks Weekly TX & Fees
Updated 2023-10-13
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
›
⌄
SELECT
DATE_TRUNC('WEEK', BLOCK_TIMESTAMP) AS Week,
COUNT(DISTINCT TX_HASH) AS Unique_Txs,
SUM(COALESCE(TX_FEE, 0)) AS Weekly_TxFee,
SUM(SUM(COALESCE(TX_FEE, 0))) OVER (
ORDER BY
DATE_TRUNC('WEEK', BLOCK_TIMESTAMP)
) AS Total_TxFee
FROM
bsc.core.fact_transactions
WHERE
TO_ADDRESS IN (
'0x991d90f89d81759945324935b672219d969a3675',
'0x03961ae0a61f64ac7a68734e97544512ed4233a6',
'0x7dcd78308500dca51265ec72bf6e7ea83f15d1d7',
'0x2df5471b6e25b9dcad2d6169876a9e6a4f5ae882',
'0xaa0e36850b6325b6964e9bac25626a8554519500',
'0xc3028fbc1742a16a5d69de1b334cbce28f5d7eb3',
'0x94019518f82762bb94280211d19d4ac025d98583',
'0x26193c7fa4354ae49ec53ea2cebc513dc39a10aa',
'0x416f1d70c1c22608814d9f36c492efb3ba8cad4c',
'0x0e3089db5f6a9f0a6550818d1dc274da9f73d4c8',
'0x9731825340473c74c96538eb45aaf812d6961ea2',
'0x1f7acc330fe462a9468aa47ecdb543787577e1e7',
'0xf8de3211d8652d665647e3dc6e0338713eaf7ebd',
'0x0b432c2a14be6c120e61f3f8c8dbfc8f52939291',
'0xa60d55bfc0b8bbad58c5bb4a4637b2f6026a0c82',
'0xdb3eccc59affbf022da2a28650f9d55d133fbce1',
'0xe9e092e46a75d192d9d7d3942f11f116fd2f7ca9',
'0xe14ad9b7d0056f14cd8a22c0d0bef247711ae8f0',
'0x61b9e6716f9a5c933f08e0262041a50f766416d4'
)
GROUP BY
Week
ORDER BY
Week;
Run a query to Download Data