TOTAL_TRADES | TOTAL_ITEMS | TOTAL_VOLUME_USD | BUYERS | |
---|---|---|---|---|
1 | 583200 | 19199653 | 18462697.7464017 | 48207 |
TheLaughingManoverview stats
Updated 4 hours ago
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
›
⌄
-- forked from base sales search @ https://flipsidecrypto.xyz/studio/queries/a0f255cb-4118-4ac1-80ef-5e0cfaa05aaa
with offer_sales as (
SELECT
logs.block_timestamp
, 'collection-offer' as label
, logs.tx_hash
, buyer
, seller
, symbol
, amount
, amount_usd
, collection
, nft_contract
, token_id
, quantity
from ronin.core.fact_event_logs logs
LEFT JOIN (
SELECT
tx_hash
, from_address as buyer
, symbol
, amount
, amount_usd
from ronin.core.ez_token_transfers
WHERE 1=1
--AND tx_hash = '0xb93daf89d0a2a32e00382888ce2425e058319751fc481768cd5fc53f82f5f86e'
AND to_address = '0x3ef234bc2a04d86f6041e419458d9acbd077f2c1' --Collection Offer Proxy
) pays on logs.tx_hash = pays.tx_hash
LEFT JOIN (
SELECT
tx_hash
, from_address as seller
, contract_address as nft_contract
, name as collection
, token_id
Last run: about 4 hours ago
1
42B
21s