sarathopensea fee5
Updated 2022-07-29
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
›
⌄
WITH currency_contracts_raw AS (
SELECT C.*, address_name, label_type, label_subtype, project_name
FROM polygon.core.dim_labels L RIGHT JOIN (
SELECT distinct contract_address
FROM polygon.core.fact_token_transfers
WHERE origin_to_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
) C ON L.address = C.contract_address
),
Opensea_currency_details AS (
SELECT key AS currency_contract, value[0] AS currency_name, value[1] AS symbol, value[2] AS decimals
FROM table(flatten(input => parse_json('{"0x264808855b0a6a5a318d238c6ee9f299179f27fc":["The Space", "SPACE", 18],
"0xe33f8a04faa56dfdaa4a9aa516e05efe56ffda45":["Flower Girls Seeds of Love", "SEEDS", 0],
"0x2791bca1f2de4661ed88a30c99a7a9449aa84174":["USD Coin (PoS)", "USDC", 6],
"0x7ceb23fd6bc0add59e62ac25578270cff1b9f619":["Wrapped Ether", "WETH", 18],
"0x8f3cf7ad23cd3cadbd9735aff958023239c6a063":["(PoS) Dai Stablecoin", "DAI", 18],
"0xc17c30e98541188614df99239cabd40280810ca3":["EverRise", "RISE", 18],
"0xdba7b24257fc6e397cb7368b4bc922e944072f1b":["Vote-escrowed EverRise", "veRISE", 18],
"0xe3a840d79fb6ac538f85c05a35801230830e6cab":["Flower Girls Seeds of Love", "SEEDSOFLOVE ", 0],
"0x70c006878a5a50ed185ac4c87d837633923de296":["REVV", "REVV ", 18],
}')
, outer => true))
),
Opensea_tx_maxval_transfers AS (
SELECT block_timestamp, tx_hash, origin_function_signature, origin_from_address, from_address, to_address, raw_amount/pow(10,decimals) total_payed, contract_address, currency_name, symbol, decimals
FROM (
SELECT tx_hash, contract_address, max(raw_amount) as raw_amount
FROM polygon.core.fact_token_transfers
WHERE origin_to_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
GROUP BY 1,2
) M NATURAL LEFT JOIN polygon.core.fact_token_transfers T LEFT JOIN Opensea_currency_details C ON T.contract_address = C.currency_contract
)
SELECT *
FROM Opensea_tx_maxval_transfers
ORDER BY block_timestamp, tx_hash, total_payed DESC
LIMIT 1000
Run a query to Download Data