NuveveCryptoArchived[BSC] Average Gas Fee Since Feb 2023
    Updated 2023-05-06
    with squid as (
    select
    concat('Squid') as bridge,
    avg(tx_fee) as avg_bsc
    from bsc.core.fact_transactions
    where to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'
    and block_timestamp >= '2023-02-06'
    ),

    stargate as (
    select
    concat('Stargate') as bridge,
    avg(tx_fee) as avg_bsc
    from bsc.core.fact_transactions
    where to_address = '0x4a364f8c717caad9a442737eb7b8a55cc6cf18d8'
    and block_timestamp >= '2023-02-06'
    ),

    lifi as (
    select
    concat('Lifi') as bridge,
    avg(tx_fee) as avg_bsc
    from bsc.core.fact_transactions
    where to_address = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
    and block_timestamp >= '2023-02-06'
    ),

    bungee as (
    select
    concat('Bungee') as bridge,
    avg(tx_fee) as avg_bsc
    from bsc.core.fact_transactions
    where block_timestamp >= '2023-02-06'
    and to_address = '0x3a23f943181408eac424116af7b7790c94cb97a5'
    or to_address = '0xc30141b657f4216252dc59af2e7cdb9d8792e1b0'
    ),
    Run a query to Download Data