crypto_edgarOverview
Updated 2023-12-15Copy Reference Fork
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
34
35
36
›
⌄
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