saadiqMythics Royalties by Platform
Updated 2023-10-11
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 Moonbirds Royalties by Platform @ https://flipsidecrypto.xyz/edit/queries/753f55fa-e44e-4f0b-9c07-f37bffe4c9a6
WITH txns AS (
SELECT
block_timestamp,
platform_name,
price,
creator_fee,
CASE
WHEN price > 0 THEN ROUND(creator_fee / price * 100, 2)
ELSE '0'
END AS eff_royalty_rate,
tx_hash
FROM
ethereum.nft.ez_nft_sales
WHERE
nft_address = LOWER('0xc0ffee8ff7e5497c2d6f7684859709225fcc5be8')
AND tx_hash NOT IN (
'0xe19b5cdc2c7d47ab5a8c711c5706a18afabf176907cd15fa2d88c43837882d23',
'0xc68ed7081ff5417df4d59ba9ca97bff590de506d57ebbe1c343d05d1c8e8b27b',
'0xdb6df0f9ab97a681a2a62c58f3f1011411d59017ecdd0157474c59d5756265a5',
'0x9ab65d8c9a710a7f527287e7e82b4ab9f85c30d4f5d0c79ffc88117b488ec135',
'0xb6b64790b6006124656911e0847a6e4ce1e788337986027c00a8db7f7b6f657a',
'0x48e97a661f8139db1dd5cbcbf22b1fc9e448e03ad2f0c1dafdbb07caa0cd2377',
'0xfcdd6c12d0e7ddbfffe2426fc45d7f8adb93f4cab50d74d7d57f03c548962fe3',
'0x70c920480d533a260a4e0c83386292c8b730b256890d1be5d521dcd836f90793',
'0x708801625dd366396f93add2808d4f09051ef8eb00d2b4b2f1fa48e8fcb65680',
'0xfede37eb0c0dc73cdcd49b5ff1567e474c03e8b5430e1a69046e60a9eb05ab72',
'0x3011d9990a6f1ed02e95119df1083e5e8e55c550e752ec8d1021e387851df108'
)
AND block_timestamp > DATEADD (DAY, -90, CURRENT_DATE) --AND block_timestamp < CURRENT_DATE
AND block_timestamp < DATE_TRUNC ('week', CURRENT_DATE)
)
SELECT
LEFT (DATE_TRUNC ('week', block_timestamp), 10) AS PERIOD
-- LEFT (DATE_TRUNC ('day', block_timestamp), 10) AS PERIOD
,
Run a query to Download Data