freemartianUntitled Query
Updated 2022-11-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with ftx_source as (
select
DISTINCT to_address as receiver
from ethereum.core.ez_token_transfers a join ethereum.core.dim_labels b on a.from_address = b.address
where label in ('alameda research','ftx')
AND block_timestamp::date >= '2022-11-08')
select
*
from axelar.core.fact_msg_attributes a inner join ftx_source f on a.ATTRIBUTE_VALUE = f.receiver
where ATTRIBUTE_KEY = 'destinationAddress'
AND block_timestamp::date >= '2022-11-08'
-- select *
-- from axelar.core.fact_msg_attributes
-- where tx_id = '9A1C61F2EE2DF3AAC8A7BBB810647D1C26D92820D3590B6A57300BDA72E29556'
Run a query to Download Data