SocioAnalyticajoint top txs
    Updated 2025-02-03
    SELECT
    *
    FROM(
    SELECT
    direction,
    block_timestamp,
    user,
    chain,
    ROUND(tx_size,0) as tx_size_usd,
    chain_volume_prcnt as prcnt,
    bridge,
    integrator,
    tx_hash,
    incoming_tx_size_order as tx_size_order
    FROM $query('c654698c-7fe4-4cb5-94ba-42a7a84f63af')
    UNION
    SELECT
    direction,
    block_timestamp,
    user,
    chain,
    ROUND(tx_size,0) as tx_size,
    chain_volume_prcnt,
    bridge,
    integrator,
    tx_hash,
    outgoing_tx_size_order as tx_size_order
    FROM $query('d17f9842-fa52-4023-9cf4-2a7df3339707')
    )
    ORDER BY tx_size_order, chain, direction
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived