volume market share

SocioAnalyticavolume market share

Updated 2024-02-19

--wapal

select *

from aptos.core.fact_events

where tx_hash = '0x9f0accac71871045529380df3b8a048485b3b8cc612b2a3f98edbd9cf57f22a5'

-- Topaz

select *

from aptos.core.fact_events

where tx_hash = '0x454ffa0904d27ca5fd8ff166418273eab21702831c468319e63f117144dc6390'

0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2

-- BlueMove

select *

from aptos.core.fact_events

where tx_hash = '0xd70fd129c82b8dfc4ef72eaa602284f351304445db10a533eb3cad7cdeccbc85'

SELECT

date_trunc('d', block_timestamp) as date,

case when plaload_function = '0x584b50b999c78ade62f8359c91b5165ff390338d45f8e55969a04e65d76258c9::coin_listing::purchase' then 'Wapal'

when

SELECT DISTINCT source_chain

from axelar.defi.ez_bridge_satellite

select *

Last run: about 1 year ago

	BLOCK_NUMBER	BLOCK_TIMESTAMP	VERSION	TX_HASH	SUCCESS	TX_TYPE	SENDER	SIGNATURE	PAYLOAD	PAYLOAD_FUNCTION	CHANGES	EVENTS	GAS_UNIT_PRICE	GAS_USED	MAX_GAS_AMOUNT	EXPIRATION_TIMESTAMP_SECS	VM_STATUS	STATE_CHANGE_HASH	ACCUMULATOR_ROOT_HASH	EVENT_ROOT_HASH	FACT_TRANSACTIONS_ID	INSERTED_TIMESTAMP	MODIFIED_TIMESTAMP
1	147114174	2024-02-18 04:11:22.754	456393251	0x9f0accac71871045529380df3b8a048485b3b8cc612b2a3f98edbd9cf57f22a5	TRUE	user_transaction	0x9474421c7bcce2ee58c20081771eb5a0079fdb79833e015e1bf2589723c03f22	{"public_key":"0x68196c769821f8ddd2ae6023c82e07bdc488f74a2b5ae5b362a534f...	{"arguments":[{"inner":"0x2bbda3bc98f9496e9e4b5a927a1ef62604a2bd2b06081f...	0x584b50b999c78ade62f8359c91b5165ff390338d45f8e55969a04e65d76258c9::coin...	[{"address":"0x2bbda3bc98f9496e9e4b5a927a1ef62604a2bd2b06081f57ef6482cba...	[{"data":{"amount":"1969999"},"guid":{"account_address":"0x9474421c7bcce...	100	92	184	1708229572	Executed successfully	0x6576f28f0472147297c377f6afa15527cf4b70e5e7bb89bf91effb64d6c29a61	0x11b9df1fff0dc0f263ad5a4caac2c1da7f4f167dbaa3d0e107b8c7075a67f227	0x3a413722586c59ecc4bd79890ac0052df1b540bfad1e107833b268fb04480022	01fd790d292947aaf134053db99e3f10	2024-02-18 04:31:31.237	2024-02-18 06:31:06.857

13KB

flipside