flipside

    Gains Network vs GMX copy copy
    Pine AnalyticsGains Network vs GMX copy copy
    Updated 2024-02-12
    -- forked from Gains Network vs GMX copy @ https://flipsidecrypto.xyz/edit/queries/428c8ed1-d2c0-4241-a066-a9cdb91c2512

    with tab1 as (
    select
    tx_hash as txs,
    From_Address as ofa
    from arbitrum.core.fact_transactions
    where to_address in (lower('0x2c7e82641f03Fa077F88833213210A86027f15dc'), lower('0x48B07695c41AaC54CC35F56AF25573dd19235c6f'), lower('0x2FE799d81FDfCC441093eaB52Af788d4Cc6Ff650'))
    and status = 'SUCCESS'
    )


    SELECT --*
    from_address as user,
    'GNS' as protocol,
    'Arbitrum' as chain,
    'V7 Perp' as Trade_type,
    count(*) as events
    FROM arbitrum.core.ez_token_transfers
    WHERE tx_hash in (SELECT txs from tab1)
    and to_address in (lower('0xcFa6ebD475d89dB04cAd5A756fff1cb2BC5bE33c'), lower('0xFe54a9A1C2C276cf37C56CeeE30737FDc6dA4d27'), lower('0x3B09fCa4cC6b140fDd364f28db830ccE01Fd60fD'))

    AND AMOUNT_USD > 1000
    GROUP BY 1,2,3,4
    --LIMIT 100


    Last run: about 1 year ago
    USER
    PROTOCOL
    CHAIN
    TRADE_TYPE
    EVENTS
    1
    		0x9cc6d132fedd90bad0b9fd58e6581d744eff20ccGNSArbitrumV7 Perp83
    2
    		0x74b40cad7ecebc056701020c8421329a1d643fceGNSArbitrumV7 Perp8
    3
    		0xda6fc9aa2952f0136eb8ad205674f562c5d9434aGNSArbitrumV7 Perp25
    4
    		0x5de953d5b76f349d19d8a956793ff4cabab86d07GNSArbitrumV7 Perp2
    5
    		0x088f3d32e5cbcb9c1c256f864423db7862085b12GNSArbitrumV7 Perp21
    6
    		0x1dab3ce0c753c6176d19471e3026a32f629cac79GNSArbitrumV7 Perp39
    7
    		0x6b83e40fbdcda0e170c1e3da42066c3f7e870c62GNSArbitrumV7 Perp10
    8
    		0xfa6fb5e1da1f7158e4950f6475b1e88ea538a859GNSArbitrumV7 Perp9
    9
    		0x013fcc5914bf709bb89d4fee0bd2dc39372ef6a3GNSArbitrumV7 Perp1
    10
    		0xc80858827b37155af2775e743f34894098e91b86GNSArbitrumV7 Perp21
    11
    		0xd923a27095fb2bc24e3a19603837f5e94484de83GNSArbitrumV7 Perp7
    12
    		0x6f2aec8325755ed76e0ce3899ff99744bf7b47b9GNSArbitrumV7 Perp1
    13
    		0x7bdc57a20bea89f99ca021f1cfc8d9ed772d5415GNSArbitrumV7 Perp7
    14
    		0xe7c48f807eab7a33eba7bc9f6eadfd7d67d4ebb5GNSArbitrumV7 Perp1
    15
    		0xf709c420f9504df0c832e1849429575511e316d7GNSArbitrumV7 Perp3
    16
    		0x80e736628cb39a20e2a3e2f44d3a81c892977b0eGNSArbitrumV7 Perp6
    17
    		0xd316afafc944adebad70f801839892b94448ea2aGNSArbitrumV7 Perp2
    18
    		0x4166ae566a373297a160fe6b7b13b90e9b350101GNSArbitrumV7 Perp1
    19
    		0xb6d844d84b2955d6ad07a198504db8686677b2e6GNSArbitrumV7 Perp4
    20
    		0x6de2e7fa3fb84a24fc1853ad5bf90065d2f85cf0GNSArbitrumV7 Perp3
    ...
    1446
    108KB
    22s