TX_HASH | TOKEN_SYMBOL | LOAN_AMOUNT | FEE | LOAN_AMOUNT_USD | FEE_USD | GAS_COST_AVAX | GAS_COST_USD | GROSS_INFLOW_USD | REPAYMENT_USD | REVENUE_USD | OPERATIONAL_COSTS_USD | PROFIT_USD | PROFIT_MARGIN | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0x40fc61aefe6eca39bd57bc37dfa45ca96a953ec60c232dc40b6bb6a09d993d14 | USDC.e | 6043.91 | 5.439519 | 6092.26 | 5.48 | 8.453766195e-12 | 1.54788459e-10 | 0 | 0 | 0 | 5.48 | -5.48 | -0.0008995019911 |
Mrftisole-azure
Updated 3 days ago
999
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 FlashLoanDetails AS (
SELECT
tx_hash,
flashloan_amount AS loan_amount,
premium_amount AS fee,
flashloan_token,
flashloan_token_symbol,
flashloan_amount_usd,
premium_amount_usd,
initiator
FROM avalanche.defi.ez_lending_flashloans
WHERE block_timestamp >= DATEADD('day', -30, CURRENT_TIMESTAMP())
AND tx_hash = '0x40fc61aefe6eca39bd57bc37dfa45ca96a953ec60c232dc40b6bb6a09d993d14'
),
GasCosts AS (
SELECT
tx_hash,
(gas_used * effective_gas_price / 1e18) AS gas_cost_avax,
block_timestamp
FROM avalanche.core.fact_transactions
WHERE tx_hash IN (SELECT tx_hash FROM FlashLoanDetails)
),
AVAXPrice AS (
SELECT
HOUR AS price_timestamp,
AVG(price) AS avax_price_usd
FROM avalanche.price.ez_prices_hourly
WHERE symbol = 'AVAX'
GROUP BY HOUR
),
TokenTransfers AS (
SELECT
tx_hash,
from_address,
to_address,
contract_address AS token_address,
Last run: 3 days ago
1
176B
6s