kasadeghUntitled Query
Updated 2022-08-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH Data_Opensea AS(
SELECT
DATE(block_timestamp) as date,
tx_id AS id,
MAX(IFF(event_inputs:to != '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073' AND event_inputs:from != '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d', event_inputs:value / 1e18, 0)) as price,
MAX(IFF(event_inputs:to = '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073', event_inputs:value / 1e18, 0)) as fee
--MAX(IFF(event_inputs:to != '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073' AND event_inputs:from != '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d', event_inputs:to::string, '')) as buyer,
--MAX(IFF(event_inputs:to != '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073' AND event_inputs:from != '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d', event_inputs:from::string, '')) as seller,
FROM polygon.events_emitted
WHERE event_name = 'Transfer' AND tx_to_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
GROUP BY 1,2
),
SELECT sum(fee) AS USD_Fee
FROM Data_Opensea o JOIN ETH_Price e ON o.date=e.date
Run a query to Download Data