lochuynh6040-j3WZQgWhales tracking
    Updated 2024-11-09

    -- Genesis
    -- ('axelar1ren608jc4cnslzsxs08memmmda2djncxcudhh7', 'axelar1wtken7kkklz922ws0g33a60lkrwkd7n45m9jah',
    -- 'axelar1qu4n56ev5prqknfz3l9cfup2ll6y7h2r2628pu', 'axelar1nctnr9x0qexemeld5w7w752rmqdsqqv92dw9am',
    -- 'axelar1ph0qnh7u2fhuqrx0w27mpg338np6uhqhrqh7qs', 'axelar14frs4mpggrww86h2n0ykqjstwypcllsz077e50',
    -- 'axelar1a6rr2ptsw6mw3rqjn0kqq2plxhjfml4dgzsvxh', 'axelar1hahy5n8hx62e23vz9kpw30hppg2zzkssqa0egg',
    -- 'axelar1vvn5n352gqzpndcvzc34v3ermz4anqkv5np7cl', 'axelar1vvn5n352gqzpndcvzc34v3ermz4anqkv5np7cl')


    select count(*), tx_from from axelar.core.fact_transactions where TX_SUCCEEDED=true and tx_from = 'axelar17ewha7y7fr0xsej6xfep88rq30rse9hgynll78' GROUP by tx_from;


    select tx_from as Address, count(*) as total, DATE_TRUNC('DAY', block_timestamp) as Date from axelar.core.fact_transactions where TX_SUCCEEDED=true and tx_from = 'axelar17ewha7y7fr0xsej6xfep88rq30rse9hgynll78' GROUP by DATE_TRUNC('DAY', block_timestamp) order by DATE_TRUNC('DAY', block_timestamp) desc limit 100;


    select tx_from, tx_log, block_timestamp from axelar.core.fact_transactions where TX_SUCCEEDED=true and tx_from in ('axelar1ren608jc4cnslzsxs08memmmda2djncxcudhh7', 'axelar1wtken7kkklz922ws0g33a60lkrwkd7n45m9jah',
    'axelar1qu4n56ev5prqknfz3l9cfup2ll6y7h2r2628pu', 'axelar1nctnr9x0qexemeld5w7w752rmqdsqqv92dw9am',
    'axelar1ph0qnh7u2fhuqrx0w27mpg338np6uhqhrqh7qs', 'axelar14frs4mpggrww86h2n0ykqjstwypcllsz077e50',
    'axelar1a6rr2ptsw6mw3rqjn0kqq2plxhjfml4dgzsvxh', 'axelar1hahy5n8hx62e23vz9kpw30hppg2zzkssqa0egg',
    'axelar1vvn5n352gqzpndcvzc34v3ermz4anqkv5np7cl', 'axelar1vvn5n352gqzpndcvzc34v3ermz4anqkv5np7cl') and DATE_TRUNC('DAY', block_timestamp) <='2022-10-01';
    QueryRunArchived: QueryRun has been archived