Total Number of Holders | |
|---|---|
1 | 52874 |
Eman-RazTotal Number of Holders
Updated 2 days ago
999
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 final_table2 as (
with final_table1 as (
with swell_chain as (
with transactions as (
with table1 as (with tab1 as (SELECT
block_timestamp, tx_hash, origin_from_address,
lower(PARSE_JSON(full_decoded_log):"address"::STRING) AS contract_address,
PARSE_JSON(full_decoded_log):"data"[0]:"value"::STRING AS from_address,
PARSE_JSON(full_decoded_log):"data"[1]:"value"::STRING AS to_address,
(PARSE_JSON(full_decoded_log):"data"[2]:"value"::NUMBER)/pow(10,18) AS amount
from swell.core.ez_decoded_event_logs
where tx_succeeded='TRUE' and event_name='Transfer')
select block_timestamp::date as date, from_address as address, -amount as amount
from tab1
where contract_address=lower('0x2826D136F5630adA89C1678b64A61620Aab77Aea')),
table2 as (with tab1 as (SELECT
block_timestamp, tx_hash, origin_from_address,
lower(PARSE_JSON(full_decoded_log):"address"::STRING) AS contract_address,
PARSE_JSON(full_decoded_log):"data"[0]:"value"::STRING AS from_address,
PARSE_JSON(full_decoded_log):"data"[1]:"value"::STRING AS to_address,
(PARSE_JSON(full_decoded_log):"data"[2]:"value"::NUMBER)/pow(10,18) AS amount
from swell.core.ez_decoded_event_logs
where tx_succeeded='TRUE' and event_name='Transfer')
select block_timestamp::date as date, to_address as address, amount
from tab1
where contract_address=lower('0x2826D136F5630adA89C1678b64A61620Aab77Aea'))
select * from table1 union all
select * from table2),
date_list as (
select
block_timestamp :: date as date
Last run: 1 day ago
1
9B
19s