0xaimanUntitled Query
Updated 2022-06-30
99
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
›
⌄
select *
from (with mint as (select * --block_timestamp,event_name, tx_id
from ethereum.udm_events
where --tx_id='0xe6056e12140b369316d6c122c7e3215ea538b4cd37665cb454acf3c1a4094155' and
event_name='MintShort' and
contract_address='0x64187ae08781b09368e6253f9e94951243a493d5'),
t1 as (
select tx_id, symbol,amount,amount_usd
from ethereum.udm_events
where to_address='0x64187ae08781b09368e6253f9e94951243a493d5'
--where tx_id='0xe6056e12140b369316d6c122c7e3215ea538b4cd37665cb454acf3c1a4094155'
),
t2 as (
select tx_id, amount
from ethereum.udm_events
where from_address='0x0000000000000000000000000000000000000000' and contract_address='0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b'
--where tx_id='0xe6056e12140b369316d6c122c7e3215ea538b4cd37665cb454acf3c1a4094155'
)
select * --block_timestamp, mint.tx_id,event_name,t1.symbol, t1.amount as colateral_amount,t1.amount_usd as collateral_valuation, t2.amount as osqth_minted
from mint inner join t1 on mint.tx_id=mint.tx_id inner join t2 on t2.tx_id=mint.tx_id
--where mint.tx_id='0x6e765fec43e83768007c3969772c5b27a0613df9abaf0e4d91c4076562d3d0f4'
)
--group by 1
limit 1000
Run a query to Download Data