kiacryptototal info
Updated 2022-09-23
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
›
⌄
with lido as (
select
count(distinct origin_from_address) as lido_stakers,
count(distinct tx_hash) as lido_tx_count,
sum(raw_amount/1e18) as lido_amount_in_matic
from polygon.core.fact_token_transfers
where contract_address = '0x3a58a54c066fdc0f2d55fc9c89f0415c92ebf3c4' and from_address = '0x0000000000000000000000000000000000000000'
),
claystack as (
select
count(distinct origin_from_address) as claystack_stakers,
count(distinct tx_hash) as claystack_tx_count,
sum(raw_amount/1e18) as claystack_amount_in_matic
from polygon.core.fact_token_transfers
where contract_address = '0x7ed6390f38d554b8518ef30b925b46972e768af8' and from_address = '0x0000000000000000000000000000000000000000'
),
ankr as (
select
count(distinct origin_from_address) as ankr_stakers,
count(distinct tx_hash) as ankr_tx_count,
sum(raw_amount/1e18) as ankr_amount_in_matic
from polygon.core.fact_token_transfers
where contract_address = '0x03a97594aa5ece130e2e956fc0ced2fea8ed8989' and from_address = '0x0000000000000000000000000000000000000000'
),
stader as (
select
count(distinct origin_from_address) as stader_stakers,
count(distinct tx_hash) as stader_tx_count,
sum(raw_amount/1e18) as stader_amount_in_matic
from polygon.core.fact_token_transfers
where contract_address = '0x3ad736904e9e65189c3000c7dd2c8ac8bb7cd4e3' and from_address = '0x0000000000000000000000000000000000000000'
)
select *
from lido, claystack, ankr, stader
Run a query to Download Data