freemartianTotal General Infos
Updated 2023-12-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- forked from General infos @ https://flipsidecrypto.xyz/edit/queries/28821d1c-df68-4166-a13f-7ace27bf957c
SELECT
COUNT(tx_hash) AS tx_count,
COUNT(DISTINCT from_address) AS depositor_count,
SUM(tx_fee) AS fee_paid
FROM ethereum.core.fact_transactions
WHERE to_address = lower('0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d')
AND origin_function_signature IN ('0xf6326fb3','0x0a553dcb','0x3265aead','0xf688bcfb','0x365833e1')
AND block_timestamp::date >= '2023-11-20'
AND from_address <> '0x0000000000000000000000000000000000000000'
QueryRunArchived: QueryRun has been archived