0xaimanHow many Users Bridges from Ethereum to Polygon Monthly?
Updated 2022-08-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
›
⌄
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