DATE | BLOCKCHAIN | REVENUE_LINK | REVENUE_USD | CUMULATIVE_REVENUE_LINK | CUMULATIVE_REVENUE_USD | |
---|---|---|---|---|---|---|
1 | 2024-01-30 00:00:00.000 | polygon | 0 | 0 | 26201.98276026 | 184072.188599805 |
2 | 2024-01-29 00:00:00.000 | polygon | 13.564457993 | 194.649972195 | 26201.98276026 | 184072.188599805 |
3 | 2024-01-28 00:00:00.000 | polygon | 15.380099104 | 220.429100531 | 26188.418302268 | 183877.53862761 |
4 | 2024-01-27 00:00:00.000 | polygon | 0 | 0 | 26173.038203164 | 183657.109527078 |
5 | 2024-01-26 00:00:00.000 | polygon | 0.2067854283 | 2.946692353 | 26173.038203164 | 183657.109527078 |
6 | 2024-01-25 00:00:00.000 | polygon | 0.2064849924 | 2.814390447 | 26172.831417735 | 183654.162834725 |
7 | 2024-01-24 00:00:00.000 | polygon | 9.383429621 | 134.089209289 | 26172.624932743 | 183651.348444278 |
8 | 2024-01-23 00:00:00.000 | polygon | 0 | 0 | 26163.241503121 | 183517.259234989 |
9 | 2024-01-22 00:00:00.000 | polygon | 10.523956965 | 158.069833615 | 26163.241503121 | 183517.259234989 |
10 | 2024-01-21 00:00:00.000 | polygon | 0.1981526942 | 3.095145083 | 26152.717546156 | 183359.189401374 |
11 | 2024-01-20 00:00:00.000 | polygon | 0 | 0 | 26152.519393462 | 183356.094256291 |
12 | 2024-01-19 00:00:00.000 | polygon | 0.710459326 | 10.38336305 | 26152.519393462 | 183356.094256291 |
13 | 2024-01-18 00:00:00.000 | polygon | 75.711188969 | 1102.679387908 | 26151.808934136 | 183345.710893241 |
14 | 2024-01-17 00:00:00.000 | polygon | 0 | 0 | 26076.097745168 | 182243.031505334 |
15 | 2024-01-16 00:00:00.000 | polygon | 39.636632959 | 600.494989334 | 26076.097745168 | 182243.031505334 |
16 | 2024-01-15 00:00:00.000 | polygon | 2.639778386 | 40.99225176 | 26036.461112208 | 181642.536516 |
17 | 2024-01-14 00:00:00.000 | polygon | 4.541857723 | 67.806786927 | 26033.821333823 | 181601.54426424 |
18 | 2024-01-13 00:00:00.000 | polygon | 5.047770325 | 71.856753423 | 26029.2794761 | 181533.737477313 |
19 | 2024-01-12 00:00:00.000 | polygon | 137.603458138 | 2043.562731287 | 26024.231705775 | 181461.88072389 |
20 | 2024-01-11 00:00:00.000 | polygon | 25.41505879 | 380.971731264 | 25886.628247637 | 179418.317992603 |
zakkisyedPolygon CCIP Revenue
Updated 2024-01-30Copy 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
›
⌄
-- forked from Final CCIP Data by Blockchain @ https://flipsidecrypto.xyz/edit/queries/3e37c678-d3c1-42b6-b0ad-a143f1f606a7
-- forked from Final Data @ https://flipsidecrypto.xyz/edit/queries/fffe0ba1-8e4a-4ae8-8f5c-789b0cc3b230
WITH
logs_poly AS (
SELECT tx_hash, 'polygon' AS blockchain
FROM polygon.core.fact_event_logs
WHERE topics[0] = '0xaffc45517195d6499808c643bd4a7b0ffeedf95bea5852840d7bfcf63f59e821'
AND block_timestamp >= '2023-07-01'
),
CCIP_fees AS (
SELECT
date_trunc('day', tx.block_timestamp) AS date,
tx.blockchain,
COUNT(tx.tx_hash) AS tx_count,
SUM(tx.amount) AS amount,
CASE
WHEN tx.blockchain = 'polygon' THEN SUM(tx.amount) * AVG(price.PRICE)
ELSE SUM(tx.amount_usd)
END AS amount_usd
FROM (
SELECT
pt.tx_hash,
pt.block_timestamp,
pt.amount,
pt.amount_usd,
'polygon' AS blockchain
FROM polygon.core.ez_token_transfers pt
JOIN logs_poly ON logs_poly.tx_hash = pt.tx_hash
WHERE contract_address = lower('0xb0897686c545045aFc77CF20eC7A532E3120E0F1')
) AS tx
LEFT JOIN crosschain.price.ez_hourly_token_prices price
Last run: over 1 year ago
213
18KB
94s