SocioCryptoExpressed vs. regular transactions over time
    Updated 2023-10-26
    -- forked from Expressed vs. regular transactions by chain @ https://flipsidecrypto.xyz/edit/queries/b6a881a3-c81f-4ceb-b509-c5c71009896d

    with base_m as(
    SELECT
    a.date,
    coalesce(expressed_txs,0)as n_express,
    coalesce(n_txs,0) as txs
    FROM (
    SELECT
    date_trunc('week', block_timestamp) as date,
    count(DISTINCT tx_hash) as n_txs
    FROM base.core.fact_token_transfers
    WHERE origin_from_address = '0xd36aac0c9676e984d72823fb662ce94d3ab5e551'
    AND origin_to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'
    GROUP BY 1 ) a
    LEFT JOIN (
    SELECT
    date_trunc('week', block_timestamp) as date,
    count(DISTINCT tx_hash) as expressed_txs
    FROM base.core.fact_token_transfers
    WHERE origin_from_address = '0xe743a49f04f2f77eb2d3b753ae3ad599de8cea84'
    AND origin_to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'
    GROUP BY 1
    ) b ON a.date = b.date
    )
    ,
    arbitrum_m as (
    SELECT
    a.date,
    coalesce(expressed_txs,0)as n_express,
    coalesce(n_txs,0) as txs
    FROM (
    SELECT
    date_trunc('week', block_timestamp) as date,
    count(DISTINCT tx_hash) as n_txs
    FROM arbitrum.core.ez_token_transfers
    Run a query to Download Data