flipside

    DeFi Adoption Post-Pectra
    cryptodatadiveDeFi Adoption Post-Pectra
    Updated 2025-05-10
    WITH transactions AS (
    SELECT
    DATE_TRUNC('day', t.block_timestamp) AS day,
    CASE
    WHEN LOWER(t.to_address) = LOWER('0x1F98431c8aD98523631AE4a59f267346ea31F984') THEN 'Uniswap V3'
    WHEN LOWER(t.to_address) = LOWER('0x7d2768dE32b0b80b7a3454c06BdAc94A69DDc7A9') THEN 'Aave V2'
    WHEN LOWER(t.to_address) = LOWER('0x6B175474E89094C44Da98b954EedeAC495271d0F') THEN 'MakerDAO (Dai)'
    WHEN LOWER(t.to_address) = LOWER('0x3d9819210A31b4961b30EF54bE2aeD79B9c9Cd3B') THEN 'Compound'
    WHEN LOWER(t.to_address) = LOWER('0xbEbc44782C7dB0a1A60Cb6fe97d0b483032FF1C7') THEN 'Curve 3Pool'
    ELSE 'Other'
    END AS protocol,
    COUNT(*) AS tx_count,
    SUM(t.value / 1e18) AS tx_volume_eth
    FROM ethereum.core.fact_transactions t
    WHERE t.block_timestamp BETWEEN DATE '2025-05-01' AND DATE '2025-05-09'
    AND LOWER(t.to_address) IN (
    LOWER('0x1F98431c8aD98523631AE4a59f267346ea31F984'), -- Uniswap V3
    LOWER('0x7d2768dE32b0b80b7a3454c06BdAc94A69DDc7A9'), -- Aave V2
    LOWER('0x6B175474E89094C44Da98b954EedeAC495271d0F'), -- MakerDAO (Dai)
    LOWER('0x3d9819210A31b4961b30EF54bE2aeD79B9c9Cd3B'), -- Compound
    LOWER('0xbEbc44782C7dB0a1A60Cb6fe97d0b483032FF1C7') -- Curve 3Pool
    )
    GROUP BY 1, 2
    ),
    tagged AS (
    SELECT
    day,
    protocol,
    tx_count,
    tx_volume_eth,
    CASE
    WHEN day < DATE '2025-05-07' THEN 'Before Pectra'
    ELSE 'After Pectra'
    END AS upgrade_period
    FROM transactions
    )
    Last run: about 1 month ago
    DAY
    PROTOCOL
    UPGRADE_PERIOD
    TOTAL_TX_VOLUME
    1
    		2025-05-01 00:00:00.000Aave V2Before Pectra0
    2
    		2025-05-01 00:00:00.000CompoundBefore Pectra0
    3
    		2025-05-01 00:00:00.000Curve 3PoolBefore Pectra0
    4
    		2025-05-01 00:00:00.000MakerDAO (Dai)Before Pectra0
    5
    		2025-05-02 00:00:00.000Aave V2Before Pectra0
    6
    		2025-05-02 00:00:00.000CompoundBefore Pectra0
    7
    		2025-05-02 00:00:00.000Curve 3PoolBefore Pectra0
    8
    		2025-05-02 00:00:00.000MakerDAO (Dai)Before Pectra0
    9
    		2025-05-03 00:00:00.000Aave V2Before Pectra0
    10
    		2025-05-03 00:00:00.000CompoundBefore Pectra0
    11
    		2025-05-03 00:00:00.000Curve 3PoolBefore Pectra0
    12
    		2025-05-03 00:00:00.000MakerDAO (Dai)Before Pectra0
    13
    		2025-05-03 00:00:00.000Uniswap V3Before Pectra0
    14
    		2025-05-04 00:00:00.000Aave V2Before Pectra0
    15
    		2025-05-04 00:00:00.000CompoundBefore Pectra0
    16
    		2025-05-04 00:00:00.000Curve 3PoolBefore Pectra0
    17
    		2025-05-04 00:00:00.000MakerDAO (Dai)Before Pectra0
    18
    		2025-05-05 00:00:00.000Aave V2Before Pectra0
    19
    		2025-05-05 00:00:00.000CompoundBefore Pectra0
    20
    		2025-05-05 00:00:00.000Curve 3PoolBefore Pectra0
    34
    2KB
    2s