0xaimanHow many Users Bridges from Ethereum to Polygon Monthly?
    Updated 2022-08-01
    with raw as ( select to_address as recipient, contract_address as tkn, block_timestamp as t
    from (
    select *
    from flipside_prod_db.polygon.udm_events
    where origin_address='0x0000000000000000000000000000000000000000' and event_name='transfer')
    WHERE contract_address=lower('0x7ceB23fD6bC0adD59E62ac25578270cFf1b9f619') or
    contract_address=lower('0x2791Bca1f2de4661ED88A30C99A7a9449Aa84174') or
    contract_address=lower('0x8505b9d2254A7Ae468c0E9dd10Ccea3A837aef5c') or
    contract_address=lower('0x313d009888329C9d1cf4f75CA3f32566335bd604') or
    contract_address=lower('0xDA537104D6A5edd53c6fBba9A898708E465260b6') or
    contract_address=lower('0xc2132D05D31c914a87C6611C10748AEb04B58e8F') or
    contract_address=lower('0x8f3Cf7ad23Cd3CaDbD9735AFf958023239c6A063') or
    contract_address=lower('0xdAb529f40E671A1D4bF91361c21bf9f0C9712ab7') or
    contract_address=lower('0xA1c57f48F0Deb89f569dFbE6E2B7f46D33606fD4') or
    contract_address=lower('0x1BFD67037B42Cf73acF2047067bd4F2C47D9BfD6') or
    contract_address=lower('0x71B821aa52a49F32EEd535fCA6Eb5aa130085978') or
    contract_address=lower('0x578360AdF0BbB2F10ec9cEC7EF89Ef495511ED5f') or
    contract_address=lower('0x556f501CF8a43216Df5bc9cC57Eb04D4FFAA9e6D') or
    contract_address=lower('0xeAb9Cfb094db203e6035c2e7268A86DEbeD5BD14') or
    contract_address=lower('0xeFfdCB49C2D0EF813764B709Ca3c6fe71f230E3e') or
    contract_address=lower('0x6EBEAC13f6403D19C95b6B75008B12fd21a93Aab') or
    contract_address=lower('0xA0c68C638235ee32657e8f720a23ceC1bFc77C77') or
    contract_address=lower('0xa5577d1cec2583058a6bd6d5deac44797c205701')),


    ba as (SELECT Recipient, t, tkn
    FROM raw
    --where l.label_type='token'
    )

    Select date_trunc('month',t) as month, count(recipient) as n_address
    from ba
    GROUP by 1 order by 1
    Run a query to Download Data