tkvresearchaccused-olive
Updated 2025-01-20
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 full_data as (
select *
from(values
('ECY31gWwxy4s2VnMkYhmqDkrV75KrwR2yTtsnrnSpump', 'BARRON'),
('FUAfBo2jgks6gB4Z4LfZkqSZgzNucisEHqnNebaRxM1P', 'MELANIA'),
('FZ5Jt1qefwdBLESjJAjRewJCPSfN6ocqMSc3RoqMpump', 'IVANKA'),
('YHJGAU32z4r83KGvjrsq1cGrTkQGgsj16GU2zY6pump', 'ERIC TRUMP'),
('Gn8bRZvr1m25rQtYF9mYrfKWaiRmgmzTfQWdebG4pump', 'TRUMP JR')
) l(address,token)
),
--base,arb,bsc,eth,sol,polygon,blast
-- evm_tab as
-- (select date(block_timestamp) as datetime,
-- symbol,
-- to_address as user,
-- amount as amt
-- from arbitrum.core.ez_token_transfers
-- where contract_address in (select lower(address) from full_data)
-- union all
-- select date(block_timestamp) as datetime,
-- symbol,
-- from_address,
-- -amount
-- from arbitrum.core.ez_token_transfers
-- where contract_address in (select lower(address) from full_data)
-- union all
-- select date(block_timestamp) as datetime,
-- symbol,
-- to_address as user,
-- amount as amt
-- from base.core.ez_token_transfers
-- where contract_address in (select lower(address) from full_data)
-- union all
-- select date(block_timestamp) as datetime,
-- symbol,
QueryRunArchived: QueryRun has been archived