Updated 2023-07-07Copy Reference Fork
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
›
⌄
-- forked from @ https://flipsidecrypto.xyz/edit/queries/8423953b-3a07-46a9-af5a-0fb90849ae43
with
a as (
select
ORIGIN_FROM_ADDRESS as claimer ,
RAW_AMOUNT/pow(10,DECIMALS) as volume ,
AMOUNT_USD as USD ,
BLOCK_TIMESTAMP ,
TX_HASH ,
'Galexy' as Title
from ethereum.core.ez_token_transfers
where
ORIGIN_TO_ADDRESS ='0x92e130d5ed0f14199edfa050071116ca60e99aa5' and
CONTRACT_ADDRESS = '0x5faa989af96af85384b8a938c2ede4a7378d9875' and
ORIGIN_FUNCTION_SIGNATURE ='0x2e7ba6ef'
union
select
ORIGIN_FROM_ADDRESS as claimer ,
RAW_AMOUNT/pow(10,DECIMALS) as volume ,
AMOUNT_USD as USD ,
BLOCK_TIMESTAMP ,
TX_HASH ,
'Paraswap' as Title
from ethereum.core.ez_token_transfers
where
ORIGIN_TO_ADDRESS ='0x090e53c44e8a9b6b1bca800e881455b921aec420' and
CONTRACT_ADDRESS = '0xcafe001067cdef266afb7eb5a286dcfd277f3de5' and
ORIGIN_FUNCTION_SIGNATURE ='0x2e7ba6ef'
union
Run a query to Download Data