flipside

    received the most # last quarter
    arctic-night-foxreceived the most # last quarter
    Updated 2022-08-10
    SELECT
    ADDRESS_NAME,
    COUNT(DISTINCT TX_HASH) as count_transaction
    FROM
    ethereum.core.fact_transactions
    INNER JOIN
    ethereum.core.dim_labels
    ON
    ethereum.core.fact_transactions.TO_ADDRESS = ethereum.core.dim_labels.ADDRESS
    WHERE
    ethereum.core.dim_labels.ADDRESS IN(lower('0x8589427373D6D84E98730D7795D8f6f8731FDA16')
    ,lower('0x722122dF12D4e14e13Ac3b6895a86e84145b6967')
    ,lower('0xDD4c48C0B24039969fC16D1cdF626eaB821d3384')
    ,lower('0xd90e2f925DA726b50C4Ed8D0Fb90Ad053324F31b')
    ,lower('0xd96f2B1c14Db8458374d9Aca76E26c3D18364307')
    ,lower('0x4736dCf1b7A3d580672CcE6E7c65cd5cc9cFBa9D')
    ,lower('0xD4B88Df4D29F5CedD6857912842cff3b20C8Cfa3')
    ,lower('0x910Cbd523D972eb0a6f4cAe4618aD62622b39DbF')
    ,lower('0xA160cdAB225685dA1d56aa342Ad8841c3b53f291')
    ,lower('0xFD8610d20aA15b7B2E3Be39B396a1bC3516c7144')
    ,lower('0xF60dD140cFf0706bAE9Cd734Ac3ae76AD9eBC32A')
    ,lower('0x22aaA7720ddd5388A3c0A3333430953C68f1849b')
    ,lower('0xBA214C1c1928a32Bffe790263E38B4Af9bFCD659')
    ,lower('0xb1C8094B234DcE6e03f10a5b673c1d8C69739A00')
    ,lower('0x527653eA119F3E6a1F5BD18fbF4714081D7B31ce')
    ,lower('0x58E8dCC13BE9780fC42E8723D8EaD4CF46943dF2')
    ,lower('0xD691F27f38B395864Ea86CfC7253969B409c362d')
    ,lower('0xaEaaC358560e11f52454D997AAFF2c5731B6f8a6')
    ,lower('0x1356c899D8C9467C7f71C195612F8A395aBf2f0a')
    ,lower('0xA60C772958a3eD56c1F15dD055bA37AC8e523a0D')
    ,lower('0x169AD27A470D064DEDE56a2D3ff727986b15D52B')
    ,lower('0x0836222F2B2B24A3F36f98668Ed8F0B38D1a872f')
    ,lower('0xF67721A2D8F736E75a49FdD7FAd2e31D8676542a')
    ,lower('0x9AD122c22B14202B4490eDAf288FDb3C7cb3ff5E')
    ,lower('0x905b63Fff465B9fFBF41DeA908CEb12478ec7601')
    ,lower('0x07687e702b410Fa43f4cB4Af7FA097918ffD2730')
    Run a query to Download Data