-- forked from 0xAD5d421Ee9D918276de32F06Af845960847b26a5 / TxVolume - External @ https://flipsidecrypto.xyz/0xAD5d421Ee9D918276de32F06Af845960847b26a5/q/d-AP2wMGQYXB/txvolume---external

    SELECT
    blockchain,
    dt,
    fee_bps,
    token,
    amount,
    symbol,
    name,
    decimals,
    normalized_amount,
    normalized_fee_amount,
    price,
    amount_usd_value,
    fee_usd_value
    FROM
    (
    SELECT
    blockchain,
    dt,
    fee_bps,
    token,
    amount,
    symbol,
    name,
    ifnull(decimals, 18) as decimals,
    amount / pow(10, ifnull(decimals, 18)) as normalized_amount,
    normalized_amount * fee_bps / 10000 as normalized_fee_amount,
    price,
    normalized_amount * price as amount_usd_value,
    normalized_fee_amount * price as fee_usd_value
    FROM
    (
    SELECT
    'cross-chain' as blockchain,
    Run a query to Download Data