flipside

    Pharoah DEX Vol
    Trader JoePharoah DEX Vol
    Updated 2024-02-17
    -- Pharoah Exchange 0x88de50b233052e4fb783d4f6db78cc34fea3e9fc

    with
    pharaoh_lp as (
    select
    decoded_log:pool as pool_address,
    --decoded_log:fee as fee,
    case when pool_address='0xa71ba3939cd6c50c674866e321bc6bba1c977dd0' then 0.2*0.01
    when pool_address='0x66a5de11d1e1f20da825d974453f099c4bb13647' then 0.125*0.01
    when pool_address='0xa20c959b19f114e9c2d81547734cdc1110bd773d' then 0.1*0.01
    when pool_address='0x9011362efc771dcedd07ec2bd020eb9ff816c40f' then 0.0095*0.01
    end as fee,
    decoded_log:tickSpacing as tickspacing,
    decoded_log:token0 as token0,
    decoded_log:token1 as token1,
    t1.symbol as symbol0,
    t2.symbol as symbol1,
    concat(symbol0, '-', symbol1) as pool_name,
    t1.decimals as decimal0,
    t2.decimals as decimal1
    from
    avalanche.core.ez_decoded_event_logs
    left join
    avalanche.price.ez_asset_metadata t1 on token0=t1.token_address
    left join
    avalanche.price.ez_asset_metadata t2 on token1=t2.token_address
    where
    1=1
    --and tx_hash='0xd47cc59d11c9df94da8bc7082fb399fa9c8d4f31ce192e41fb3910bed033ad70'
    and contract_address='0xaaa32926fce6be95ea2c51cb4fcb60836d320c42'
    and pool_address in (
    '0xa20c959b19f114e9c2d81547734cdc1110bd773d' -- avax usdc
    ,'0x9011362efc771dcedd07ec2bd020eb9ff816c40f' -- savax avax
    ,'0x66a5de11d1e1f20da825d974453f099c4bb13647' -- weth avax
    ,'0xa71ba3939cd6c50c674866e321bc6bba1c977dd0' -- btc.b avax
    )
    Last run: over 1 year ago
    DAY
    TOKEN_AMOUNT
    POOL_ADDRESS
    TOKEN_ADDRESS
    POOL_NAME
    1
    		2023-12-15 00:00:00.000-3061.5690630xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    2
    		2023-12-15 00:00:00.00099.3772140xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    3
    		2023-12-15 00:00:00.000-3053.6215720xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    4
    		2023-12-15 00:00:00.000-3037.0890350xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    5
    		2023-12-15 00:00:00.000-3050.6229850xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    6
    		2023-12-15 00:00:00.000-3050.1358410xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    7
    		2023-12-15 00:00:00.000-3055.3718540xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    8
    		2023-12-15 00:00:00.000-191.2475390xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    9
    		2023-12-15 00:00:00.000-3050.7700870xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    10
    		2023-12-15 00:00:00.000-3038.1394540xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    11
    		2023-12-15 00:00:00.000-3038.1358860xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    12
    		2023-12-15 00:00:00.000-3044.803810xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    13
    		2023-12-15 00:00:00.000-3326.2129820xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    14
    		2023-12-15 00:00:00.000-3145.7970380xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    15
    		2023-12-15 00:00:00.000-3046.0533910xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    16
    		2023-12-15 00:00:00.000-3321.3303930xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    17
    		2023-12-15 00:00:00.000-3031.7212150xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    18
    		2023-12-15 00:00:00.000-3037.1144850xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    19
    		2023-12-15 00:00:00.000-3053.7156080xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    20
    		2023-12-15 00:00:00.000105.1611840xa20c959b19f114e9c2d81547734cdc1110bd773d0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6esAVAX-AVAX
    100
    14KB
    5s