No Data to Display
rezarwzDistribution of LXPs
Updated 2025-01-20
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
35
36
›
⌄
with all_lxp as (
SELECT
value:r as row_number,
value:c as "# of wallets",
value:dis as lxp_range
FROM
(
select
chainbase_utils.post(
'/v1/dw/query',
{ 'query': '
with all_lxp as (
select
to_address as ua,
value/pow(10,18) as lxp
from
linea.token_transfers
WHERE contract_address="0xd83af4fbd77f3ab65c3b1dc4b38d7e67aecf599a")
,all_dis as (
select
lxp,
count(ua) as c
from all_lxp
group by
lxp)
select
case
when 500>=lxp then "LXP=<500"
when lxp between 501 and 800 then "LXP=<800"
when lxp between 801 and 1000 then "LXP=<1000"
when lxp between 1001 and 1300 then "LXP=<1300"
when lxp between 1301 and 1500 then "LXP=<1500"
when lxp between 1501 and 1800 then "LXP=<1800"
when lxp between 1801 and 2000 then "LXP<2000"
when lxp>= 2000 then "LXP>=2000"
end as dis,
Last run: 3 months ago
0
2B
2s