flipside

    mover
    freemartianmover
    Updated 2024-02-05
    WITH prices AS(
    SELECT symbol, hour, avg(price) as price
    FROM crosschain.price.ez_hourly_token_prices
    WHERE blockchain = 'ethereum'
    group by 1,2
    )


    SELECT
    block_number,
    block_timestamp,
    version,
    tx_hash,
    -- payload:function data structure is as follows ==> bridge_address::function::event_name
    payload,
    split_part(payload:function,'::',1) AS bridge_address,
    split_part(payload:function,'::',2) AS function,
    split_part(payload:function,'::',3) AS event_name,
    (CASE
    WHEN split_part(payload:function,'::',1) = '0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1' THEN 'mover' -- mover bridge address
    ELSE 'Others'
    END) AS platform,
    sender,
    payload:arguments[1] AS destination_chain_receiver,
    split_part(payload:type_arguments[1],'::',3) AS destination_chain,
    payload:arguments[2] AS destination_chain_id,
    payload:type_arguments[0] AS token_address,
    tokens.symbol AS token_symbol,
    name AS token_name,
    payload:arguments[0] AS amount_unadj,
    payload:arguments[0] /pow(10,decimals) AS amount,
    (payload:arguments[0] /pow(10,decimals)) * price AS amount_usd,
    fact_transactions_id,
    tr.inserted_timestamp,
    tr.modified_timestamp

    Last run: about 1 year ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    VERSION
    TX_HASH
    PAYLOAD
    BRIDGE_ADDRESS
    FUNCTION
    EVENT_NAME
    PLATFORM
    SENDER
    DESTINATION_CHAIN_RECEIVER
    DESTINATION_CHAIN
    DESTINATION_CHAIN_ID
    TOKEN_ADDRESS
    TOKEN_SYMBOL
    TOKEN_NAME
    AMOUNT_UNADJ
    AMOUNT
    AMOUNT_USD
    FACT_TRANSACTIONS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    101166345
    		2023-10-09 00:47:11.6602899204360x57fac257835a407e737a65abd43377a7dee6613822ce9a1b1c2d9c037efe7959
    {"arguments":["500000","0x0c424f635899336d44859d0931f5d8d6cfedc6cd1c373f...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0xfe6a0fc43b98fd330c9c6771fa10cceb8a397ad598120330428ace28f8e4928d
    0x0c424f635899336d44859d0931f5d8d6cfedc6cd1c373f2114823fa4678a18f4
    		Sui
    11
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT
    		USDTTether USD
    500000
    		0.50.5005df2bf2d491db7b7bd11f529b783f0ef52023-12-01 13:13:07.5582023-12-01 13:13:07.558
    2
    126045852
    		2023-12-20 07:19:36.7223668265160xc336c6588443bc6c000797777a150bf7f92b7db89e0720b91ebf99991244f7b9
    {"arguments":["1000000","0xe2cbAd3bEC5449BbBde75e52ca7053c5477f0d2a","13...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0xd44f78c25d2d9c58a5fd36ab7d8c77cb918423251fcf0b0d586e1a09bfd98333
    0xe2cbAd3bEC5449BbBde75e52ca7053c5477f0d2a
    		Polygon
    137
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC
    		USDCUSD Coin
    1000000
    		10.99939754bff364be60091ffccd7bffdc2d309762023-12-20 07:31:56.1392023-12-20 09:31:53.176
    3
    89535197
    		2023-09-07 00:44:41.2152534134360xd50144e459e8c09c018daf3e3bd17739b8983c78dc655826d7695ce3fb373483
    {"arguments":["102614000","0x43810DA8DA5F1272CEe2A9d5Ae45268D4F90550c","...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0x813b7383339dc0b286ab2a8b46f4e326cd159dfe8936f6ead4e3f32c13798041
    0x43810DA8DA5F1272CEe2A9d5Ae45268D4F90550c
    		Optimism
    10
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC
    		USDCUSD Coin
    102614000
    		102.614102.6140d34418c059f2aa2aff5f7b44f9b7bdc2023-12-01 13:13:07.5582023-12-01 13:13:07.558
    4
    140835418
    		2024-02-01 16:37:58.8394306435930xca1375c444fb7514cdc390940db8f559c3d5db03a95c48992d5973c6c0224b2b
    {"arguments":["10000","0x3296611f7D13451FAe42c892E6CC5d802E0a5e62","137"...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0xd0a330352a2b2e8d0fbf5642ace5c01c612b42fd83581c710c1947072505d624
    0x3296611f7D13451FAe42c892E6CC5d802E0a5e62
    		Polygon
    137
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC
    		USDCUSD Coin
    10000
    		0.010.010006175785a71fbd864700bace12e4b80751ec62024-02-01 17:11:33.8242024-02-01 19:11:58.627
    5
    128175575
    		2023-12-27 12:42:15.6963817409250x0d61d262726f6d5557debb15a85c5d90ec0c4d0ae410c6ea9cda85ca0bf7ffc4
    {"arguments":["103663000","0xC136559f0d1706848d90f64CE1CD2ECC1518C3Ba","...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0x2267e5239cca5ff6ed32025bc1b4580c5e04e3e9fc104feb473c038576f4f2c1
    0xC136559f0d1706848d90f64CE1CD2ECC1518C3Ba
    		Optimism
    10
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC
    		USDCUSD Coin
    103663000
    		103.663103.9221575123d658b46b593ab4c3a75f7d942db942023-12-27 13:11:48.1582023-12-27 15:11:57.496
    6
    97258381
    		2023-09-28 08:17:31.2992779500170xc04dd2ce6838d9ce1a9535bd584b1a3d41528bc7c2266da492acaf7579febe05
    {"arguments":["142990","0x85FeFeDA8c397E493304e9fAbb3f8FEEFEf069bb","137...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0xc62212a46a40799ae04c1fa5d455963e7adfea199f8af92c876ca570a4c90437
    0x85FeFeDA8c397E493304e9fAbb3f8FEEFEf069bb
    		Polygon
    137
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT
    		USDTTether USD
    142990
    		0.142990.142915359222e81e87ffc9cfefe59a197a5abd6b752023-12-01 13:13:07.5582023-12-01 13:13:07.558
    7
    96577966
    		2023-09-26 09:48:34.0472758332030xcc4d341da1db9875b7a5ffc6ee1b9887a9d41b7d2fde5c988cd65c7a5cf74ed9
    {"arguments":["268960","0x6212a26178cAB886822DA2f39698BFe0eCAa7677","137...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0x3faeb28bf6e7707ed08f3e09b3b97237f05336e551d368fb7f0cca1d823501a9
    0x6212a26178cAB886822DA2f39698BFe0eCAa7677
    		Polygon
    137
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT
    		USDTTether USD
    268960
    		0.268960.26936344b4aa6802dea594df524f43fdcca104992023-12-01 13:13:07.5582023-12-01 13:13:07.558
    8
    96573350
    		2023-09-26 09:30:15.9202758173340xe86db9a8808ad8c0009a04ddf6cd55396044802f74e8995784342b151e09a53e
    {"arguments":["203571","0xab2A7e05B64C625fFa8B7a12335FDf66c82F3d45","137...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0xb62e19cf18b6b201d54ffbb25983f63fb5244e0f394873d23895d0a0b3cb5b30
    0xab2A7e05B64C625fFa8B7a12335FDf66c82F3d45
    		Polygon
    137
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT
    		USDTTether USD
    203571
    		0.2035710.20387635654acc25af945deba634ce0eba30f9668a2023-12-01 13:13:07.5582023-12-01 13:13:07.558
    9
    89614674
    		2023-09-07 05:48:53.1432536531260x0449c2da86766200756ed4693b57666d766a3b6ab8d29c22a644957d91c124a7
    {"arguments":["7863770","0x75276BF30A094383706F8C521045b1B7BBAbDc21","56...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0x66c19253f0cd55166a9a7884ce7df1c0844b46a4a1996d95470f60e528a8b375
    0x75276BF30A094383706F8C521045b1B7BBAbDc21
    		BNB
    56
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT
    		USDTTether USD
    7863770
    		7.863777.852556264d8cb5715616679966fa5dff91d1949002023-12-01 13:13:07.5582023-12-01 13:13:07.558
    10
    105662823
    		2023-10-22 06:21:11.8333065163680xbbcaa0a3680b0adf8c398e8021df97b47eb173f4fe543decedc37066ad00344d
    {"arguments":["70002800","0x6bBfa2849c5E6C67751e722B9682402A8F0F74a9","4...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0x73e1ed2d1d88857c28e608267d68b9643df6848c80d08dd166a7f9ee39eb0f14
    0x6bBfa2849c5E6C67751e722B9682402A8F0F74a9
    		Arbitrum
    42161
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT
    		USDTTether USD
    70002800
    		70.002870.2117233576bd424cf6fd6b965bf8c2fb79cdb3cc62023-12-01 13:13:07.5582023-12-01 13:13:07.558
    11
    91775297
    		2023-09-13 02:56:01.2042605553350x9cc6395593b6117af9322be3b282cda62dbbcf2529a56198590cd68da1ce8b93
    {"arguments":["33000000","0x43810DA8DA5F1272CEe2A9d5Ae45268D4F90550c","1...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0x813b7383339dc0b286ab2a8b46f4e326cd159dfe8936f6ead4e3f32c13798041
    0x43810DA8DA5F1272CEe2A9d5Ae45268D4F90550c
    		Polygon
    137
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC
    		USDCUSD Coin
    33000000
    		3332.98746964cb269a56d24b2689024442fcbac502023-12-01 13:13:07.5582023-12-01 13:13:07.558
    12
    120174912
    		2023-12-02 23:08:15.4283488131360xf91622dbfa93905910e78cf032fb05826ab728ecdbf00186ee8282df815f3241
    {"arguments":["99846400","0x25CC275CFE3Cce1700E816e00d4CD1f60872038A","1...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0x1afa676881b208fc4e837b9e162680aeeeead8d47aec2d3a56bb9fe39d693284
    0x25CC275CFE3Cce1700E816e00d4CD1f60872038A
    		Polygon
    137
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC
    		USDCUSD Coin
    99846400
    		99.8464100.2457856979156c5a69888c3f0619fe7866ff2212023-12-02 23:31:53.7632023-12-03 01:31:41.797
    13
    97600497
    		2023-09-29 07:03:49.4662790066150x27238bdac0f3144ca3d53a5bf8648201d66530973d738a1041bc0be9c4a6428f
    {"arguments":["200000","0x8A5a67B54ec0E16FAA3d4A56fFD4DAf6994f4255","137...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0x7792aeeeec29f692215b5fe501b46c8141f25795a71114797100304d7a773ef4
    0x8A5a67B54ec0E16FAA3d4A56fFD4DAf6994f4255
    		Polygon
    137
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT
    		USDTTether USD
    200000
    		0.20.19978669ffab9689681b1d5432822165095e4ba2023-12-01 13:13:07.5582023-12-01 13:13:07.558
    14
    114004531
    		2023-11-15 14:23:54.1003312413010xec7ad8230ac727776f427bf37bcbf582c1d4f8dfeb532ab8777a8039f9f8f496
    {"arguments":["87912900","0x0c07aEF2f354082ccAE93F9a4217Da05b0Fd96f5","4...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0x9049ac14152419f08f73b2a387a78b6769613088e522e0e92f38759773d1ac6e
    0x0c07aEF2f354082ccAE93F9a4217Da05b0Fd96f5
    		Arbitrum
    42161
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT
    		USDTTether USD
    87912900
    		87.912987.480368532032eb7bbab7be86b2a662bbc9083fa0d2023-12-01 13:13:07.5582023-12-01 13:13:07.558
    15
    91773647
    		2023-09-13 02:49:28.6872605503000xe09d671af1d3502508dce8286fe1887d6750d821d40890bda1d39fc6d5b95aae
    {"arguments":["135497000","0x43810DA8DA5F1272CEe2A9d5Ae45268D4F90550c","...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0x813b7383339dc0b286ab2a8b46f4e326cd159dfe8936f6ead4e3f32c13798041
    0x43810DA8DA5F1272CEe2A9d5Ae45268D4F90550c
    		BNB
    56
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC
    		USDCUSD Coin
    135497000
    		135.497135.445511148f7e4eb91eaf3a2db5f0019010a4563c2023-12-01 13:13:07.5582023-12-01 13:13:07.558
    16
    109795177
    		2023-11-03 16:36:37.0423190502060x2e4d56d75231021f1417bd829b666099cb2e5a0a9dd0ee5e14da1108300b8d90
    {"arguments":["51365600","0x67F08A674fa559445125d10B02378dC7AE6A44cB","3...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0xfdaeb488a6c89848af4795987e0d0a5ca0221d27a3d8ae8b85a33b8d0758771
    0x67F08A674fa559445125d10B02378dC7AE6A44cB
    		ZkSync
    324
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC
    		USDCUSD Coin
    51365600
    		51.365651.395802686054f1e2bcb5c40bbcb4488f65ee0b92023-12-01 13:13:07.5582023-12-01 13:13:07.558
    17
    104974653
    		2023-10-20 07:05:52.2063043102690x913deba2d0afb9d45084942abf5b31399b81e23a138f9b53b204cecf8923a6ab
    {"arguments":["53660","0xb6373e60348f70E9d5B6BB07E70f9Bb79eFddfe4","137"...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0x30f08c676c5305d7fcc8a33e206838170064793026397ab03e6ee48f466e48b5
    0xb6373e60348f70E9d5B6BB07E70f9Bb79eFddfe4
    		Polygon
    137
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT
    		USDTTether USD
    53660
    		0.053660.0539283ea77cbc0bd03645c44fb22dce768e4c12023-12-01 13:13:07.5582023-12-01 13:13:07.558
    18
    113562021
    		2023-11-14 09:03:55.1673299557660xf356edb9c37a6ee735d5bdcbef860d5026493fbbf2c180ee2129014295073bc6
    {"arguments":["7284250","0x83c83C4cf33c3d927afb64b9878007899BC0AbB1","42...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0x85ad61083c4bd48d5fe8379ccc9353c9e2cce7757b05f626247cd64083fb6253
    0x83c83C4cf33c3d927afb64b9878007899BC0AbB1
    		Arbitrum
    42161
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT
    		USDTTether USD
    7284250
    		7.284257.309744875c247b6aeb68b6d1c55615199d715da552023-12-01 13:13:07.5582023-12-01 13:13:07.558
    19
    108186616
    		2023-10-30 00:09:29.4273143943740x1da949c5c503d3193444c2bcf6db6f6535d7f94121058e26d59e965b388a85c9
    {"arguments":["683120","0x3241Ec0D2e161bf52378e839f30E37eB64DbB135","324...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0x6be3b6cbc20d6a9a24e1f568b731aad4cd5654afa9801bccdc8beea80ebb4e22
    0x3241Ec0D2e161bf52378e839f30E37eB64DbB135
    		ZkSync
    324
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT
    		USDTTether USD
    683120
    		0.683120.68346156d8d650d80d21509a3ba60ab3a1f8f2a22023-12-01 13:13:07.5582023-12-01 13:13:07.558
    20
    107781866
    		2023-10-28 19:43:21.5733132573940x3c9fb4ea084dd860e689e3aec68e8d496eb107dd27b5fe9b2b8f5ec50e9ff74d
    {"arguments":["19704800","0x34B208048EAbceBb6960e43f8cA5875390AE3CC5","4...
    		0xb3db6a8618db6e0eb9f2a3c98f693a7e622f986377c3153e6dd602ca74984ef1bridgeswap_outmover0xbe605cbbb2f7d03012deaf7428bc0e93b39b5d92bc5138df5e839d2288e83933
    0x34B208048EAbceBb6960e43f8cA5875390AE3CC5
    		Arbitrum
    42161
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC
    		USDCUSD Coin
    19704800
    		19.704819.70406107ebb7c7e7fb6e8ca199baa4f53df861ff2023-12-01 13:13:07.5582023-12-01 13:13:07.558
    ...
    384
    359KB
    76s