hbd1994Swaps Daily Overview
Updated 2023-08-30
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 main as (
with pairs as (
with registers as (
select
distinct tx_id as id,
date(block_timestamp) as date0
from sei.core.fact_msg_attributes
where MSG_TYPE = 'wasm'
and ATTRIBUTE_KEY = 'action'
and ATTRIBUTE_VALUE = 'register'),
factories as (
select
distinct tx_id as tx,
date(block_timestamp) as date1
from sei.core.fact_msg_attributes
inner join registers on tx_id = id and block_timestamp::date = date0
where MSG_TYPE = 'wasm'
and ATTRIBUTE_KEY = '_contract_address'
and ATTRIBUTE_VALUE = 'sei1xr3rq8yvd7qplsw5yx90ftsr2zdhg4e9z60h5duusgxpv72hud3shh3qfl')
select
date(block_timestamp) as "Date of Creation",
tx_id as "Transaction hash",
ATTRIBUTE_VALUE as "Pool Address",
case
when ATTRIBUTE_VALUE = 'sei1dv6y7jkkksw4evvrm7x4d2dpm9334rp5xrfar7jh8p38f82y3xus25psnj' then 'USDCet - WETH'
when ATTRIBUTE_VALUE = 'sei1ehrlfpqnq35c7wknhrg2pupx44xcvac0un602wk68jgvx093uxwsyjtsey' then 'SEI - sey'
when ATTRIBUTE_VALUE = 'sei15jumtkmss2d8hvg7ywk9law2c5t0u57jtv8hu4a0dce8e5whfwaqg7q3er' then 'ASTRO - axlUSDC'
when ATTRIBUTE_VALUE = 'sei10jj0ucwl3fdwrxdqecmk7auamgpfgcvvkyar67ykyvyxxwum0tpsh06w9x' then 'fac...SEI - SEI'
when ATTRIBUTE_VALUE = 'sei1ea3s0kacfle84pf7ncw7k7ldl8t56qnvgxnk274cghmja9xmvypqg5elst' then 'MUSK - SEI'
when ATTRIBUTE_VALUE = 'sei1p6mgf33c79u72gr27xa660vynkq3g2flfn48jy6quq3vy4wzag4qh264w2' then 'axlUSDC - USDCar'
when ATTRIBUTE_VALUE = 'sei1a94tfxh0lgnsx20wsfv2ur737g2yejx8tt4e6uf6k5cc5jg77f0q0ekwar' then 'USDCar - USDCet'
when ATTRIBUTE_VALUE = 'sei1eq7n2naz680klrvhlna8lxhmn9zxwzcdzjvynzfrq4fgsulhaupqzdpsd5' then 'fac...llo- SEI'
when ATTRIBUTE_VALUE = 'sei1jc4gk0ua02kvrpggat77r25226h6hg5rrfwlywu7zclkdscjwlhqep7nwm' then 'SEI - USDCso'