Web3 Voice🎙
wallet v4 r2, а теперь попробуй по сиду в например в tonkeeper или tonhub востановить адрес
select count(*)
from (
select address, count(*) as count
from events
where blockchain = 'ton'
and address <> 'the-void'
and toStartOfMonth(time) = '2023-01-01'
group by address
having count > 5
)
SELECT
COUNT(DISTINCT account) as MAW
FROM
(
SELECT
w.address as account,
COUNT(*) as message_count
FROM
redoubt.messages t
JOIN redoubt.wallets w ON w.address = t.source
WHERE
t.tx_time >= '2023-01-01' :: timestamp WITH time zone
AND t.tx_time < '2023-02-01' :: timestamp WITH time zone
GROUP BY
w.address
HAVING
COUNT(*) > 5
) as subquery;
можно заметить что размер резултата по данным 3xpl получается в среднем в 7 раз больше чем redoubt
2020-05 74
2020-06 70
2020-07 137
2020-08 176
2020-09 438
2020-10 1223
2020-11 1554
2020-12 4616
2021-01 2977
2021-02 4188
2021-03 3336
2021-04 4659
2021-05 5115
2021-06 6316
2021-07 9573
2021-08 7471
2021-09 9248
2021-10 8065
2021-11 9373
2021-12 10845
2022-01 10446
2022-02 17258
2022-03 15049
2022-04 21586
2022-05 23184
2022-06 22797
2022-07 38691
2022-08 18013
2022-09 18307
2022-10 16689
2022-11 18913
2022-12 68880
2023-01 160883
2023-02 81863
2023-03 12980
2023-04 9304
2023-05 8398
2023-06 9363
2023-07 9558
select count(*)
from events
where blockchain = 'ton'
and address <> 'the-void'
and time < '2023-08-01'
370645662
name : KWT (KWT)
rootAddress : 0:5664d5169a3ebe98746df1fb482dc49dfd5b5bc5b6d21a05a8054bfcce84da9e
totalSupply : 0.000
tokenStandard: Tip3
--------------
Owner : 0:93c649a74df7641d486b88a5636385a2b9b106e67e8fe26521e7ac84e2719c72
EVER : 917.28
QUBE : 92.12
....... USD 35.64
WETH : .1.00
.... USD 1 642.61
WBTC : .0.13
.... USD 3 410.70
TIP-3 SUM = 5 088.95 USD
--------------