flipside

    04 - A Report of Gas Station Usage
    hbd199404 - A Report of Gas Station Usage
    Updated 2025-01-19
    ----------------------------------------------------- Adding Tokens and Symbols -----------------------------------------------------

    WITH tokens AS (
    select
    token_address as token,
    name,
    symbol,
    uri
    FROM $query('b227b22d-94d7-49d7-951a-309cb1755c73')),

    ----------------------------------------------------- Pool Creations -----------------------------------------------------

    pools as (
    select
    BLOCK_TIMESTAMP as creation_date,
    INSTRUCTION:accounts[1] as tokenMintA,
    b.symbol as tokenMintA_symbol,
    INSTRUCTION:accounts[2] as tokenMintB,
    c.symbol as tokenMintB_symbol,
    tokenMintB_symbol || ' - ' || tokenMintA_symbol as pool_name,
    INSTRUCTION:accounts[5] as pool_funder,
    INSTRUCTION:accounts[6] as pool_address,
    INSTRUCTION:accounts[7] as tokenVaultA,
    INSTRUCTION:accounts[8] as tokenVaultB,
    case
    when INSTRUCTION:accounts[9] = '9ZhzuqjANw7T8Q8KWErXELrx9ZMArUdXAUmoJ9qBGuUS' then '0.01' when INSTRUCTION:accounts[9] = 'BWhUdrPPor8gxya47efretmwTtkCpFQxDiK8eRDV4ibE' then '0.02'
    when INSTRUCTION:accounts[9] = '9uqkUhxV5Gu3yMKSQ9Baavj3ky8MkVDp925XNfCng1dy' then '0.05' when INSTRUCTION:accounts[9] = 'ELt2ABgf4BpXZhKLcxKCg3QJb7WGtcz9ACGcHc6pFvaG' then '0.1'
    when INSTRUCTION:accounts[9] = '2G1aYAbxbwHLUV74HZ1gFdj6eftPiwKx9yRsSsMeCXSq' then '0.15' when INSTRUCTION:accounts[9] = 'DT3cBTV8RMkNRLGV4S7Xj7QbbxrZvPG3kPYq2YnstEnn' then '0.3'
    when INSTRUCTION:accounts[9] = 'Cu433u9MsEH57ZFJC4Pw9DT97PSgeVF4EY1YoLfUwRze' then '0.65' when INSTRUCTION:accounts[9] = '7wAquQD66tK61wzM45uG8S3cHTKho1gknydE8qzDnV18' then '1'
    when INSTRUCTION:accounts[9] = '8ESd9eMrLUGveZGSKg2Fw9wKGD5oWzy41RAPfeZQNUrQ' then '1' when INSTRUCTION:accounts[9] = 'Hb1U1qAm1ZQYR4rJgDhGusPGUzkW4yjF3Ak7J9fZ8VHG' then '2'
    end as fee_percent
    from eclipse.core.fact_events a
    left join tokens b on b.TOKEN = a.INSTRUCTION:accounts[1]
    left join tokens c on c.TOKEN = a.INSTRUCTION:accounts[2]
    where substr(replace(substr(utils.udf_base58_to_hex(INSTRUCTION:data),3,1000), ''),0,16) = 'cf2d57f21b3fcc43'
    order by 1, INDEX),
    Last run: 3 months ago
    Date and Time
    Visitor Address
    Deal Object
    Deal USD Volume
    Base Currency / Amount
    Quote Currency / Amount
    ETH Balance Before Deal
    1
    		2024-11-06 23:14:47.000
    4uRLbJ4Vdit9STSfYMBjpxbcrjWxQQSzyxF4TB5UYTSm
    		USDC ---> ETH0.1513886815USDC - 0.15ETH - 5.6215e-050.007671948
    2
    		2024-11-06 23:17:47.000
    4uRLbJ4Vdit9STSfYMBjpxbcrjWxQQSzyxF4TB5UYTSm
    		SOL ---> ETH0.1238632218SOL - 0.000653594ETH - 4.5994e-050.007728163
    3
    		2024-11-06 23:23:03.000
    4uRLbJ4Vdit9STSfYMBjpxbcrjWxQQSzyxF4TB5UYTSm
    		SOL ---> ETH0.2104576015SOL - 0.001111111ETH - 7.8149e-050.007774157
    4
    		2024-11-07 00:38:18.000
    8Uk6Kb3UM423qLoUfBGeqRmErsstheYYWJN1Lc5tzmuD
    		USDC ---> ETH5.033139392USDC - 5ETH - 0.0018428780.025100527
    5
    		2024-11-07 01:32:13.000
    4JP2MzcnNmiSVrKytcRwmogfL5YHyQhe8qnoeEzrzfXc
    		USDC ---> ETH10.030564288USDC - 10ETH - 0.0036853770.087968662
    6
    		2024-11-07 01:53:45.000
    4JP2MzcnNmiSVrKytcRwmogfL5YHyQhe8qnoeEzrzfXc
    		USDC ---> ETH9.987982979USDC - 10ETH - 0.0036697320.091654039
    7
    		2024-11-07 01:54:07.000
    4JP2MzcnNmiSVrKytcRwmogfL5YHyQhe8qnoeEzrzfXc
    		USDC ---> ETH9.986613954USDC - 10ETH - 0.0036692290.095323771
    8
    		2024-11-07 01:58:21.000
    4JP2MzcnNmiSVrKytcRwmogfL5YHyQhe8qnoeEzrzfXc
    		USDC ---> ETH9.985244929USDC - 10ETH - 0.0036687260.049556425
    9
    		2024-11-07 02:05:43.000
    4uRLbJ4Vdit9STSfYMBjpxbcrjWxQQSzyxF4TB5UYTSm
    		USDC ---> ETH0.1490752965USDC - 0.15ETH - 5.5027e-050.007852306
    10
    		2024-11-07 02:05:51.000
    4uRLbJ4Vdit9STSfYMBjpxbcrjWxQQSzyxF4TB5UYTSm
    		USDC ---> ETH0.1490725874USDC - 0.15ETH - 5.5026e-050.007907333
    11
    		2024-11-07 02:06:05.000
    4uRLbJ4Vdit9STSfYMBjpxbcrjWxQQSzyxF4TB5UYTSm
    		USDC ---> ETH0.1490725874USDC - 0.15ETH - 5.5026e-050.007962359
    12
    		2024-11-07 02:06:50.000
    4uRLbJ4Vdit9STSfYMBjpxbcrjWxQQSzyxF4TB5UYTSm
    		USDC ---> ETH0.1490725874USDC - 0.15ETH - 5.5026e-050.008017385
    13
    		2024-11-07 02:09:03.000
    4uRLbJ4Vdit9STSfYMBjpxbcrjWxQQSzyxF4TB5UYTSm
    		USDC ---> ETH0.1490725874USDC - 0.15ETH - 5.5026e-050.008072411
    14
    		2024-11-07 02:45:24.000
    DJuqvhPnmh16wzJsrCmiCxpiNxTodyiZN7CDKSDVZGF3
    		USDC ---> ETH3.945679879USDC - 4ETH - 0.0014564380.038245268
    15
    		2024-11-07 04:22:43.000
    4uRLbJ4Vdit9STSfYMBjpxbcrjWxQQSzyxF4TB5UYTSm
    		tETH ---> ETH0.5085218799tETH - 0.000175438ETH - 0.0001783430.008036809
    16
    		2024-11-07 04:23:09.000
    4uRLbJ4Vdit9STSfYMBjpxbcrjWxQQSzyxF4TB5UYTSm
    		tETH ---> ETH0.5085446909tETH - 0.000175438ETH - 0.0001783510.008215152
    17
    		2024-11-07 04:24:46.000
    4uRLbJ4Vdit9STSfYMBjpxbcrjWxQQSzyxF4TB5UYTSm
    		tETH ---> ETH0.152571106tETH - 5.2631e-05ETH - 5.3508e-050.008393503
    18
    		2024-11-07 04:25:25.000
    4uRLbJ4Vdit9STSfYMBjpxbcrjWxQQSzyxF4TB5UYTSm
    		SOL ---> ETH0.1594229481SOL - 0.000833333ETH - 5.5911e-050.008447011
    19
    		2024-11-07 04:31:46.000
    4uRLbJ4Vdit9STSfYMBjpxbcrjWxQQSzyxF4TB5UYTSm
    		tETH ---> ETH0.1525768087tETH - 5.2631e-05ETH - 5.351e-050.008502922
    20
    		2024-11-07 04:31:46.000
    4uRLbJ4Vdit9STSfYMBjpxbcrjWxQQSzyxF4TB5UYTSm
    		SOL ---> ETH0.1593202988SOL - 0.000833333ETH - 5.5875e-050.008556432
    ...
    18558
    3MB
    174s