flipside

    User Stable Coin Bridge on Orbiter
    freemartianUser Stable Coin Bridge on Orbiter
    Updated 2025-01-17

    WITH from_ethereum AS (
    SELECT
    (CASE
    WHEN RIGHT (raw_amount,4) = 9001 THEN 'ethereum'
    WHEN RIGHT (raw_amount,4) = 9002 THEN 'arbitrum'
    WHEN RIGHT (raw_amount,4) = 9003 THEN 'zksync_lite'
    WHEN RIGHT (raw_amount,4) = 9004 THEN 'starknet'
    WHEN RIGHT (raw_amount,4) = 9006 THEN 'polygon'
    WHEN RIGHT (raw_amount,4) = 9007 THEN 'optimism'
    WHEN RIGHT (raw_amount,4) = 9008 THEN 'immutablex'
    WHEN RIGHT (raw_amount,4) = 9009 THEN 'loopring'
    WHEN RIGHT (raw_amount,4) = 9010 THEN 'metis'
    WHEN RIGHT (raw_amount,4) = 9011 THEN 'dydx'
    WHEN RIGHT (raw_amount,4) = 9012 THEN 'zkspace'
    WHEN RIGHT (raw_amount,4) = 9013 THEN 'boba'
    WHEN RIGHT (raw_amount,4) = 9014 THEN 'zksync_era'
    WHEN RIGHT (raw_amount,4) = 9015 THEN 'bsc'
    WHEN RIGHT (raw_amount,4) = 9016 THEN 'arbitrum_nova'
    WHEN RIGHT (raw_amount,4) = 9017 THEN 'zkevm'
    WHEN RIGHT (raw_amount,4) = 9021 THEN 'base'
    WHEN RIGHT (raw_amount,4) = 9023 THEN 'linea'
    WHEN RIGHT (raw_amount,4) = 9024 THEN 'mantle'
    WHEN RIGHT (raw_amount,4) = 9030 THEN 'zora'
    else 'others'
    end
    ) AS destination,
    block_timestamp,
    from_address,
    to_address,
    tx_hash AS transactions,
    raw_amount/pow(10,6) AS amount_usd
    FROM ethereum.core.fact_token_transfers
    WHERE to_address IN ('0x41d3d33156ae7c62c094aae2995003ae63f587b3','0xd7aa9ba6caac7b0436c91396f22ca5a7f31664fc','0x095D2918B03b2e86D68551DCF11302121fb626c9')
    AND destination <> 'others'

    Last run: 2 months ago
    DESTINATION
    BLOCK_TIMESTAMP
    FROM_ADDRESS
    TO_ADDRESS
    TRANSACTIONS
    AMOUNT_USD
    FROM_NETWORK
    1
    		arbitrum_nova2023-04-12 07:30:32.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30x6521e06ba5a4c4bd0e353e82c71e64dc1d23c9f891c81ea0d9cc1e5fb62913105001.009016Arbitrum
    2
    		polygon2023-04-07 07:51:39.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30x80b77bb63b094ce79c23e3860f12f8ff0146237a0041bd5e87b0cbf74a6453c45441.519006Optimism
    3
    		arbitrum_nova2023-11-06 08:21:23.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30x689b9e1825faeb812658bac844a20992ec130910d1ed1885be758af4032720d99.569016Base
    4
    		polygon2023-04-07 05:33:50.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30xb7606b384e75e6fa3722964f024702d25a66cd294e9919b22eb331bbb14237dc5447.339006Arbitrum
    5
    		optimism2023-04-06 06:36:26.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30x6964a96cedcb6e4d76aa20ee1deb12a6070e58214efecc9b1cbc3ddc51384c515471.019007Arbitrum
    6
    		optimism2023-11-09 10:43:20.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30xafd660893dcc0628b9a623923e31f65a8deabaabd6491e4fcdf21daf03871da52099.989007Arbitrum
    7
    		arbitrum2023-04-08 15:22:30.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30x85a05a857866ab4264d7b0baf33255ed3ea451dc0b856b698eaf6ed9f6cab2283838.369002Optimism
    8
    		arbitrum2023-04-18 15:29:59.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30x0aab8dbbf4745a433c8679e6fb69cdb73d2035f90355fcd6f2da175e1a382a2a5536.159002Optimism
    9
    		arbitrum2023-04-06 15:11:25.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30x8549c95a7da31d6b565ad3bf82ad2357c7d3c0eb9f7351d82fbf23264c37c1e55461.559002Optimism
    10
    		optimism2023-04-10 10:17:28.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30x7f95a9733486c93f92b2dd233583766355170bba0e70eb98102ddd01474a81115616.939007Arbitrum
    11
    		arbitrum_nova2023-04-12 06:00:55.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30x3afea89a0a512453e47af78155488c8e7a39e40d55a61c71a086e0fc459af5b22001.009016Optimism
    12
    		bsc2023-12-16 06:46:15.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30x258a78aa00287619ec5409c484fec80346448c39bebd1bb2112cc98fea6948241130.599015Optimism
    13
    		optimism2024-01-08 19:39:58.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30xdde1a6e84ca155e9c30471b3f970ac69e1f8f77c05abbc331a72d3bc896afe811637.019007Arbitrum
    14
    		base2023-11-06 08:19:39.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30xc3b95c620acfdb8d8724a9f199101e7a696d4bf13eee355a89b9c1ac1ba701b510.989021Optimism
    15
    		arbitrum2023-09-28 06:48:33.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30x5ac779782982f81302529057393dde22fef1a9f969d2702fdd9a0335a4b378d6699.989002Optimism
    16
    		arbitrum2023-11-25 11:02:07.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30x355d26a61fb8df031bde41de792bcf30082417941c71047f583c9109f629fca21508.799002Optimism
    17
    		arbitrum2023-08-10 06:24:27.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30x365a7a7fdbf0b1bebe4c2eeac9afa4bd3076c370401c7d773ab8ceb23d13cedd703.809002Optimism
    18
    		arbitrum2023-04-04 09:32:53.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30x2189613beb66d625b4910e698ce468ca64b0edb5d8b5d4f025f646a515ce0324400.939002Optimism
    19
    		polygon2023-04-05 08:43:44.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30x3048ee1bccba13986bf82e82411c454d294f2ea871cd5d6f1a367c3b5cb523645476.909006Arbitrum
    20
    		arbitrum_nova2023-05-23 03:44:49.0000x0a0ae914771ec0a5851049864ccc27b1baa8cd430x41d3d33156ae7c62c094aae2995003ae63f587b30xec91d4d4f43d0affdbdbeb6727a943661063743e4b0fa122307a940b80b835591050.589016Optimism
    33
    7KB
    33s