1 | datavortex | Flipside

datavortex1

Updated 2025-03-24

SELECT

tx_hash,

MAX(CASE WHEN event_name = 'Transfer' THEN decoded_log:_to END) AS destination_chain,

MAX(CASE WHEN event_name = 'Transfer' THEN decoded_log:_value END) AS transfer_value,

MAX(CASE WHEN event_name = 'Transfer' THEN contract_name END) AS bridged_token,

MAX(CASE WHEN event_name = 'CCIPSendRequested' THEN decoded_log:message.sender END) AS bridger,

MAX(CASE WHEN event_name = 'CCIPSendRequested' THEN decoded_log:message.feeToken END) AS fee_token

FROM

ronin.core.ez_decoded_event_logs

WHERE

(event_name = 'Transfer' AND decoded_log:_from = '0x46527571d5d1b68ee7eb60b18a32e6c60dceaf99')

OR event_name = 'CCIPSendRequested'

GROUP BY

tx_hash;

SELECT

tx_hash,

MAX(CASE WHEN event_name = 'Transfer' THEN decoded_log:_to END) AS destination_chain,

MAX(CASE WHEN event_name = 'Transfer' THEN decoded_log:_value END) AS transfer_value,

MAX(CASE WHEN event_name = 'Transfer' THEN contract_name END) AS bridged_token,

MAX(CASE WHEN event_name = 'CCIPSendRequested' THEN decoded_log:message:sender::STRING END) AS bridger,

MAX(CASE WHEN event_name = 'CCIPSendRequested' THEN decoded_log:message:feeToken::STRING END) AS fee_token

FROM

ronin.core.ez_decoded_event_logs

WHERE

-- tx_hash = '0xebda9deff01462f06871ad3809f35d2dcd683b41e1ab55ac37f9292b48c13df1'

decoded_log:_from = '0x46527571d5d1b68ee7eb60b18a32e6c60dceaf99'

AND event_name IN ('Transfer', 'CCIPSendRequested')

GROUP BY

tx_hash;

Last run: about 2 months ago

	TX_HASH	DESTINATION_CHAIN	TRANSFER_VALUE	BRIDGED_TOKEN	BRIDGER	FEE_TOKEN
1	0xe9f8ac2e08fc8213c0f0f1604a0c425d0e87e86f95be5c153a5a3a3843f136dc	0x261fe8a0c492a1ede8cf966aed16619c772198f5	578835502740140369	Wrapped Ronin	0x920c267ed50fd5e5e79d68130e39bceb2541a994	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
2	0xa988ff974e561011711947b7a803b6915601d312007eec425983a47ff19196e8	0x261fe8a0c492a1ede8cf966aed16619c772198f5	150485652253134659	Wrapped Ronin	0xeeb1c2ca81525c67bcd23fad4957c076ca6c5ce4	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
3	0x52ef3b3d7d59c1e636bfd66679c226e3cee516d53b9fbb075009b6552644bde1	0x261fe8a0c492a1ede8cf966aed16619c772198f5	177961967594318019	Wrapped Ronin	0x6d9be8ec198f0a72b4ef852cd216b670f1378253	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
4	0xf9a25cb9c6c2c1a53a68dbd6bcef06d214d56c9bc2cded2acaf108dcd1ab57ff	0x261fe8a0c492a1ede8cf966aed16619c772198f5	159037324482529922	Wrapped Ronin	0x920c267ed50fd5e5e79d68130e39bceb2541a994	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
5	0xea353b7b675b965c4df1a63354334355fd01b60f066db55b54e0957656a9610b	0x261fe8a0c492a1ede8cf966aed16619c772198f5	151912834924652857	Wrapped Ronin	0x920c267ed50fd5e5e79d68130e39bceb2541a994	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
6	0x600ca84b1009c8f2b8c2d318613f3e511532dbcc000ea0e9f11e99f7ee713a8c	0x261fe8a0c492a1ede8cf966aed16619c772198f5	247917297103366302	Wrapped Ronin	0x468201e260fead6c7553529355f522d14f0e569e	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
7	0x99c0725d78afc3fc73dc4d23152dc9292540b96a6ff383561f50abe76b9bc0e6	0x261fe8a0c492a1ede8cf966aed16619c772198f5	163539718353381579	Wrapped Ronin	0xa93c23f4488a2c0f97345787e19c143ef8aea240	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
8	0x355a92ecd76ee300e59e484d56d6476d9e4dc45ff9d6267244b5b90b6aa0cfdf	0x261fe8a0c492a1ede8cf966aed16619c772198f5	180645830895652952	Wrapped Ronin	0x920c267ed50fd5e5e79d68130e39bceb2541a994	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
9	0x5ce363ec1e57560352757268d1857b4625ba288e4e0391ed93e457131673e290	0x261fe8a0c492a1ede8cf966aed16619c772198f5	250052175700081956	Wrapped Ronin	0x920c267ed50fd5e5e79d68130e39bceb2541a994	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
10	0x868280a0d41995b850b103ba366bbc4ac5bcbead043e32779aa2ff0da045eed0	0x261fe8a0c492a1ede8cf966aed16619c772198f5	578835502740140369	Wrapped Ronin	0xf290353cd8d82adab6ced3ed1c8af443365e9f58	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
11	0x85a5ce82d35874745edb6002ed73d42ae7826f8ad0d30dd106b2afc84af207b3	0x261fe8a0c492a1ede8cf966aed16619c772198f5	156219021613991959	Wrapped Ronin	0x8de65bf80f4c13076f1463184a5a9841032601ab	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
12	0xcd53c109d3f679a88a787e615a3d677ae1751c4ca9b0deca41a01d2d0cdb102b	0x261fe8a0c492a1ede8cf966aed16619c772198f5	157023317542596606	Wrapped Ronin	0x7dc24671e6687cfb6eb3b774702987b42e55eda5	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
13	0xd320e99899362332d82b31337b0b75c7c62e3cc46b7f360ae11bf3c5753ef753	0x261fe8a0c492a1ede8cf966aed16619c772198f5	150651553549055576	Wrapped Ronin	0x920c267ed50fd5e5e79d68130e39bceb2541a994	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
14	0xb5503554e94156a87da4fda543cd7a56ddadc4129428d4655bd18a39d30d96a4	0x261fe8a0c492a1ede8cf966aed16619c772198f5	213851061391762838	Wrapped Ronin	0x920c267ed50fd5e5e79d68130e39bceb2541a994	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
15	0x00bdb24d4c6d812bfdd6b0be7dbaa4feb32d2a6afbc231284d41011ff832801b	0x261fe8a0c492a1ede8cf966aed16619c772198f5	221285329465662368	Wrapped Ronin	0x920c267ed50fd5e5e79d68130e39bceb2541a994	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
16	0x726d1a49226a86a64b20b1f7c101e19abcce0cfe47818ecbb38e3868233064c9	0x261fe8a0c492a1ede8cf966aed16619c772198f5	156151569458919615	Wrapped Ronin	0x072075b5903f4da7f65c84f8f5f8006c0690a109	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
17	0x9ac092e6a8a2c6ac0dfb8859305ed3560e1acf27040f06437a181bdee6ff0511	0x261fe8a0c492a1ede8cf966aed16619c772198f5	264341542081967509	Wrapped Ronin	0x2cd3e7906bd5b50f872cb6aeae163e1a473b0261	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
18	0x7d339f57afd215a5369bbc8f9a1db538ccdab0f59a9a41c5a968a6d222987a6f	0x261fe8a0c492a1ede8cf966aed16619c772198f5	141061939516715324	Wrapped Ronin	0x99ae854b8ca1d35498aa73738393236748d40084	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
19	0x0e0c279bd9afe7dfff7b57f10638502d139fc2e78ed358c0ef75c6d1b281b785	0x02b60267bceeafdc45005e0fa0dd783efebc9f1b	5292904705913092030	Wrapped Ronin	0x53156ba1b89462354248b0cceb94a269fbc5bce4	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4
20	0x8ff596b00bd94cf002ccfd272dcbf814d16b55538cf5a1ec2773745f624a793e	0x261fe8a0c492a1ede8cf966aed16619c772198f5	218651777049078023	Wrapped Ronin	0x9e8c42da29581d5a22dfd0e03a095bee3abca36f	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4

...

2535

592KB

flipside

flipside