solsurferchilly-tomato
    Updated 2025-01-22
    swell.core.fact_transactionsWITH tracked_tokens AS (
    -- Define all tokens to track
    SELECT * FROM (VALUES
    ('0x2826D136F5630adA89C1678b64A61620Aab77Aea', 'SWELL'),
    ('0x2416092f143378750bb29b79eD961ab195CcEea5', 'swETH'),
    ('0xda1F8EA667dc5600F5f654DF44b47F1639a83DD1', 'wSWELL'),
    ('0x939f1cC163fDc38a77571019eb4Ad1794873bf8c', 'rSWELL'),
    ('0xA6cB988942610f6731e664379D15fFcfBf282b44', 'swUSD'),
    ('0x5d3a1Ff2b6BAb83b63cd9AD0787074081a52ef34', 'SWETH_ETH_LP'),
    ('0x18d33689AE5d02649a859A1CF16c9f0563975258', 'rswETH'),
    ('0x09341022ea237a4DB1644DE7CCf8FA0e489D85B7', 'SWELL_ETH_LP'),
    ('0xc3eACf0612346366Db554C991D7858716db09f58', 'swUSDC'),
    ('0xFA3198ecF05303a6d96E57a45E6c815055D255b1', 'SWUSD_USDC_LP'),
    ('0x1783eB6B8966f7A2c3aA9B913DD53353B2C8c873', 'swBTC'),
    ('0x0b623F1130a1B0DC9e4497CA71E6250e3f006D51', 'govSWELL'),
    ('0xEa34479f7d95341E5fd49b89936366D6da710824', 'swFRAX'),
    ('0x218bAF6499658901942fFf9C1Fba25271F3a3d47', 'SWFRAX_FRAX_LP'),
    ('0x4200000000000000000000000000000000000006', 'WETH'),
    ('0x1cf7b5f266A0F39d6f9408B90340E3E71dF8BF7B', 'swMATIC'),
    ('0x211Cc4DD073734dA055fbF44a2b4667d5E5fE5d2', 'swBNB')
    ) as tokens(address, symbol)
    ),

    daily_transactions AS (
    SELECT
    DATE_TRUNC('day', t.block_timestamp) AS date,
    tt.symbol,
    COUNT(*) as num_transactions,
    COUNT(DISTINCT t.from_address) as unique_senders,
    COUNT(DISTINCT t.to_address) as unique_receivers,
    SUM(amount) as total_token_amount
    FROM ethereum.core.ez_token_transfers t
    JOIN tracked_tokens tt ON LOWER(t.contract_address) = LOWER(tt.address)
    GROUP BY 1, 2
    ),

    Last run: 22 days ago
    DATE
    SYMBOL
    NUM_TRANSACTIONS
    UNIQUE_SENDERS
    UNIQUE_RECEIVERS
    TOTAL_TOKEN_AMOUNT
    TXN_GROWTH_PCT
    TOTAL_TRANSACTIONS
    TOTAL_UNIQUE_SENDERS
    TOTAL_UNIQUE_RECEIVERS
    SEVEN_DAY_AVG_TXNS
    PCT_OF_DAILY_TOTAL
    1
    2025-01-22 00:00:00.000swETH62272.139342951-57.14285714362211.5100
    2
    2025-01-21 00:00:00.000swETH1422468.917849848133.333333333142214.75100
    3
    2025-01-20 00:00:00.000swETH622332.5093674185062219100
    4
    2025-01-19 00:00:00.000swETH4221.062385967-77.77777777842226100
    5
    2025-01-18 00:00:00.000swETH1822668.14197822850182231100
    6
    2025-01-17 00:00:00.000swETH122235.76592580920122235.25100
    7
    2025-01-16 00:00:00.000swETH1022200.950994579-54.545454545102238.25100
    8
    2025-01-15 00:00:00.000swETH2222954.803208178-31.25222243.75100
    9
    2025-01-14 00:00:00.000swETH3222798.61309647-33.333333333322251.5100
    10
    2025-01-13 00:00:00.000swETH4833217.157855691-22.580645161483352100
    11
    2025-01-12 00:00:00.000swETH62221119.32378761540.909090909622253.125100
    12
    2025-01-11 00:00:00.000swETH4422962.078956757-15.384615385442251.125100
    13
    2025-01-10 00:00:00.000swETH5222448.39081265644.444444444522250.75100
    14
    2025-01-09 00:00:00.000swETH3622998.491789072-33.333333333362247.5100
    15
    2025-01-08 00:00:00.000swETH54221724.461717911-35.714285714542247100
    16
    2025-01-07 00:00:00.000swETH844316.342003796133.333333333844346.5100
    17
    2025-01-06 00:00:00.000swETH36223835.59265535-36.842105263362242.25100
    18
    2025-01-05 00:00:00.000swETH5744464.49578931223.913043478574445.5100
    19
    2025-01-04 00:00:00.000swETH4622131.49098251612.195121951462245100
    20
    2025-01-03 00:00:00.000swETH41231436.83619095457.692307692412349.625100
    ...
    330
    28KB
    15s