SocioAnalyticalp actors [4 pools]
Updated 2024-04-01
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 rel_contracts as (
select * from
( values ( 'terra1afkvgc0mxfqakqlaqpxdgy58n79x4r239q3tucxmrsqvqk7ce3ksnctxfu', 'Astroport LUNA-WBTC Pair'),
('terra16n04evd52r67acm3t8dy2369msuzkapdjmg9rzr6ankmmmj6054s8q5zlc', 'Astroport LUNA-WETH Pair'),
('terra13cw46g72kwtgln0540j9cqa79ham5k86jlx34e2pqukww6v0v3yseakged','Astroport LUNA-USDC.axl Pair'),
--('terra1jd04eztujfgt4z0uyw7lkm0gujs0gpxs6pd5gv8ltt5xccmq3v8sppm7wg' ,'Astroport SOLID - USDC.axl Pair'),
('terra1tm20pwpzwyyvyadu4v488hrg59nhu9v2l8v7k67nhccam4aagczsg0pzzr','Astroport Astro-USDC.axl Pair')
--('terra1cr8dg06sh343hh4xzn3gxd3ayetsjtet7q5gp4kfrewul2kql8sqvhaey4','Astroport ampLUNA-LUNA Pair'),
--('terra1ygn5h8v8rm0v8y57j3mtu3mjr2ywu9utj6jch6e0ys2fc2pkyddqekwrew','Astroport axlUSDT-axlUSDC Pair'),
--('terra1mpj7j25fw5a0q5vfasvsvdp6xytaqxh006lh6f5zpwxvadem9hwsy6m508','Astroport LUNA-LunaX Pair')
) as a (contract_address,pool_name)
)
,
add_txns as (
SELECT
DISTINCT tx_id,
block_timestamp
FROM
terra.core.fact_msg_attributes_standard a
JOIN rel_contracts b
ON a.attribute_value = b.contract_address
WHERE
msg_type = 'execute'
AND attribute_key = '_contract_address'
INTERSECT
SELECT
tx_id,
block_timestamp
FROM
terra.core.fact_msg_attributes_standard
WHERE
msg_type = 'wasm'
AND attribute_key = 'action'
AND attribute_value IN ('provide_liquidity','mint')
)
QueryRunArchived: QueryRun has been archived