mo115bebop
Updated 2023-05-24
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 tx as (with wallets as (select FROM_ADDRESS as wallet
from polygon.core.ez_token_transfers
WHERE TO_ADDRESS = '0xaf0b0000f0210d0f421f0009c72406703b50506b'
and BLOCK_TIMESTAMP >= '2023-05-18'),
a as (with txs as (select FROM_ADDRESS,SUBSTRING(TX_HASH, -1, 2) as lt
from polygon.core.ez_token_transfers
WHERE TO_ADDRESS = '0xaf0b0000f0210d0f421f0009c72406703b50506b'
and BLOCK_TIMESTAMP >= '2023-05-18')
select FROM_ADDRESS as wallet,
case when lt='a' then 'yes' else null end as a
--case when lt='b' then 'yes' else null end as b,
--case when lt='c' then 'yes' else null end as c,
--case when lt='d' then 'yes' else null end as d,
--case when lt='e' then 'yes' else null end as e,
--case when lt='f' then 'yes' else null end as f,
--case when lt='0' then 'yes' else null end as "0",
--case when lt='1' then 'yes' else null end as "1",
--case when lt='2' then 'yes' else null end as "2",
--case when lt='3' then 'yes' else null end as "3",
--case when lt='4' then 'yes' else null end as "4",
--case when lt='5' then 'yes' else null end as "5",
--case when lt='6' then 'yes' else null end as "6",
--case when lt='7' then 'yes' else null end as "7",
--case when lt='8' then 'yes' else null end as "8",
--case when lt='9' then 'yes' else null end as "9"
from txs
group by 1,2),
b as (with txs as (select FROM_ADDRESS,SUBSTRING(TX_HASH, -1, 2) as lt
from polygon.core.ez_token_transfers
WHERE TO_ADDRESS = '0xaf0b0000f0210d0f421f0009c72406703b50506b'
and BLOCK_TIMESTAMP >= '2023-05-18')
select FROM_ADDRESS as wallet,
case when lt='b' then 'yes' else null end as b
from txs
group by 1,2),
c as (with txs as (select FROM_ADDRESS,SUBSTRING(TX_HASH, -1, 2) as lt
Run a query to Download Data