commanderjoseph-761gwXETH BIG CAPS Whale
    Updated 2024-12-20
    With
    buys
    AS
    (
    SELECT
    DATE_TRUNC('day', block_timestamp) AS transaction_date,
    COUNT(DISTINCT tx_hash) AS whale_buys,
    COUNT(DISTINCT origin_from_address) AS whale_buyer,
    SUM(amount_in) AS whale_buy_volume_eth
    FROM
    ethereum.defi.ez_dex_swaps
    WHERE
    token_out = lower('0xB36cF340a35f9860D0Bb59AFb0355580f0000DAD')
    AND
    token_in = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    AND
    amount_in >= 1
    --swap_from_amount_usd >= 1000
    GROUP
    BY
    1
    ORDER
    BY
    2
    DESC
    ),

    sells
    AS
    (
    SELECT
    DATE_TRUNC('day', block_timestamp) AS transaction_date,
    COUNT(DISTINCT tx_hash) AS whale_sells,
    COUNT(DISTINCT origin_from_address) AS whale_seller,
    SUM(amount_out) AS whale_sell_volume_eth
    FROM
    Last run: 14 days ago
    TRANSACTION_DATE
    WHALE_BUYER
    WHALE_SELLER
    WHALE_BUYS
    WHALE_SELLS
    WHALE_BUY_VOLUME_ETH
    WHALE_SELL_VOLUME_ETH
    WHALE_BUY_BUY
    WHALE_SELL_SELL
    1
    2024-12-20 00:00:00.00056568.41392732912.5626788942536
    2
    2024-12-19 00:00:00.0009610615.580399.2889435839036
    3
    2024-12-18 00:00:00.0001211141223.16955705721.055306539168132
    4
    2024-12-17 00:00:00.000889915.8602183216.4065596827272
    5
    2024-12-16 00:00:00.000748413.8600897516.7105384385616
    6
    2024-12-15 00:00:00.0001416212458.03564892141.35262543294384
    7
    2024-12-14 00:00:00.00052526.7159654362.991837777254
    8
    2024-12-13 00:00:00.000313141.46401990491
    9
    2024-12-12 00:00:00.000111151.16405021311
    10
    2024-10-27 00:00:00.000111121.69672240511
    11
    2024-10-11 00:00:00.00012121.4925373132.17946935814
    12
    2024-09-30 00:00:00.000111111.35510755111
    13
    2024-07-24 00:00:00.000213151.02752900561
    14
    2024-07-10 00:00:00.000111111.4280849411
    15
    2024-05-20 00:00:00.00011111.271575411.88876494211
    16
    2024-04-17 00:00:00.00012121.3063683052.12040949114
    17
    2024-04-08 00:00:00.00021212.1640797091.02988250841
    18
    2024-04-04 00:00:00.00021213.067211681.3072438641
    19
    2024-04-03 00:00:00.00031318.6209907712.00923371691
    20
    2024-03-25 00:00:00.00031414.11.195109099121
    35
    2KB
    5s