nitsTrueFreeze Claims made
Updated 2022-08-21
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT count(DISTINCT origin_from_address) as claimed_addresses,
claimed_addresses/230000*100 as percent_claimed_addresses
, sum(amt) as total_amt,
total_amt/42000000*100 as percent_amt
from
(SELECT tx_hash,origin_from_address, event_inputs:value/pow(10,18) as amt from
ethereum.core.fact_event_logs
where contract_address = '0x55b1e2d8b13e7acad03353fad58fc3fa065c5822' and origin_function_signature = '0x2e7ba6ef' and tx_hash != '0x67d34fcac1e7ca9c1c7e17535ff55645d136df7d80812f3d480f1a4a99985cdc'
GROUP by 1,2 ,3 )
limit 100
Run a query to Download Data