kasadeghq2
Updated 2022-08-01
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 opensea_trasactions_fee as
(
SELECT TX_ID,
AMOUNT,
AMOUNT_USD,
SYMBOL,
BLOCK_TIMESTAMP::date as day
FROM polygon.udm_events
WHERE to_address = '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073'
AND symbol IS NOT NULL
AND from_address='0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
AND AMOUNT_USD is not null
),
opensea_trasactions_all_info as
(
select t1.CONTRACT_ADDRESS as nft_address,
t2.day,
t2.SYMBOL,
t2.AMOUNT as fee_token_amount,
t2.AMOUNT_USD as fee_usd_amount
from flipside_prod_db.polygon.events_emitted as t1
join opensea_trasactions_fee as t2
on t1.TX_ID=t2.TX_ID
where t1.CONTRACT_ADDRESS not in
('0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' --WETH: 0x7ceb23fd6bc0add59e62ac25578270cff1b9f619
,'0x70c006878a5a50ed185ac4c87d837633923de296' --REW: 0x70c006878a5a50ed185ac4c87d837633923de296
,'0x8f3cf7ad23cd3cadbd9735aff958023239c6a063' --DAI: 0x8f3cf7ad23cd3cadbd9735aff958023239c6a063
,'0x2791bca1f2de4661ed88a30c99a7a9449aa84174' --USDC : 0x2791bca1f2de4661ed88a30c99a7a9449aa84174
,'0xfede379e48c873c75f3cc0c81f7c784ad730a8f7'
,'0x0000000000000000000000000000000000001010'
)
and t1.CONTRACT_ADDRESS is not null
)
Run a query to Download Data