crypto_edgarOverview
    Updated 2023-12-15
    WITH LEDGER_TOKEN_DRAIN_TABLE AS (
    SELECT
    transfers.FROM_ADDRESS,
    transfers.AMOUNT,
    transfers.DECIMALS,
    PRICE,
    transfers.AMOUNT * PRICE AS AMOUNT_USD,
    transfers.CONTRACT_ADDRESS,
    transfers.SYMBOL
    from
    polygon.core.ez_token_transfers transfers
    LEFT OUTER JOIN polygon.price.ez_hourly_token_prices prices ON (
    transfers.CONTRACT_ADDRESS = prices.TOKEN_ADDRESS -- AND DATE_TRUNC('Hour', transfers.BLOCK_TIMESTAMP) = HOUR
    AND HOUR = (
    SELECT
    MAX(HOUR)
    FROM
    polygon.price.ez_hourly_token_prices
    WHERE
    HOUR >= '2023-12-13'
    AND TOKEN_ADDRESS = transfers.CONTRACT_ADDRESS
    )
    )
    WHERE
    BLOCK_TIMESTAMP >= '2023-12-13'
    AND ORIGIN_FROM_ADDRESS = '0x00003ffa7857408ab714c28b1451914330240000'
    AND TO_ADDRESS = '0x658729879fca881d9526480b82ae00efc54b5c2d'
    )
    SELECT
    COUNT(DISTINCT FROM_ADDRESS) AS NR_ADDRESSED_IMPACTED,
    SUM(AMOUNT_USD) AS TOTAL_STOLEN_USD
    FROM
    LEDGER_TOKEN_DRAIN_TABLE



    Run a query to Download Data