0xHaM-dTotal Trades & Unique Traders Count
Updated 2023-02-07Copy Reference Fork
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
›
⌄
with tb1 as (
SELECT
BLOCK_TIMESTAMP,
'Gains Network' as platrofm,
tx_hash,
origin_from_address
FROM arbitrum.core.fact_event_logs
WHERE CONTRACT_ADDRESS in (lower('0x2f67a8d26f370b922b31b199c7946c3ed53c10c6'), lower('0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46'),
lower('0xcfa6ebd475d89db04cad5a756fff1cb2bc5be33c'), lower('0x6b8d3c08072a020ac065c467ce922e3a36d3f9d6'),
lower('0x04a5e3cf21B0080B72fAcDca634349A56982D497'), lower('0xAA379DD7Ec0bae467490e89bB2055A7e01231b8f'),
lower('0xf67Df2a4339eC1591615d94599081Dd037960d4b'), lower('0xc2d107e870927E3fb1127E6c1a33De5C863505b8'),
lower('0xcef1C791CDd8c3EA92D6AB32399119Fd30E1Ff21'), lower('0x6C612C804c84e3D20E3109c8efD06cD2d8b28F46'),
lower('0xcef1C791CDd8c3EA92D6AB32399119Fd30E1Ff21'), lower('0xd85E038593d7A098614721EaE955EC2022B9B91B'),
lower('0x990BA9Edd8a9615A23E4c452E63A80e519A4a23D'), lower('0x673cf5AB7b44Caac43C80dE5b99A37Ed5B3E4Cc6'),
lower('0x1759eD3BB9ecd661ebEcF4264f7677E09206ACE2'), lower('0x128889a9b82e5574012177055a35310d50c31a7d'))
UNION
SELECT
BLOCK_TIMESTAMP,
'GMX' as platrofm,
tx_hash,
origin_from_address
FROM arbitrum.core.fact_event_logs
WHERE contract_address = '0x489ee077994b6658eafa855c308275ead8097c4a'
)
SELECT
platrofm,
COUNT(DISTINCT tx_hash) as total_trade,
COUNT(DISTINCT origin_from_address) as total_trader
FROM tb1
GROUP by 1
order by 2 DESC
Run a query to Download Data