CATEGORY | VOLUME_USD | SAMPLE1 | SAMPLE2 | |
|---|---|---|---|---|
1 | RON | 11244866.2894407 | 0xfffff2829eb39cdf3a748870a2634dd2010c620b0fac16b531de0643ea60a9dd | 0x00001ea289e9102d1f92534571cf35b4b4667585541badfff6a9d7c3b61fc35a |
2 | Others | 115227.43 | 0xffc65b4f05b7b82e4ac63e26f84252d0a8e8b75d1772b5426b01a2fd6ac5da67 | 0x37cddb7a5593ca1ce60374951d3fb58579b8ff5bf98d10d53efb114ebd7a8470 |
3 | WETH | 1637536.78 | 0xfff955013011da78c8e2defad18e3953a2c92bbecc3f934aa9fc0d3cd59d33cf | 0x00044fdbbc05e407399dbee9ee4c299f38b45340dd6a962740dd94432b64346b |
4 | USDC | 271238.31 | 0xfffd8826d4adb7200c3eb2541714eccc0aff63663055b4a0fcc99cd6ec9a741f | 0x0000661e05b02d0e622339a9f95a8cd7e6b08d0d5c0d21845d72e6074a29921b |
5 | WRON | 2475255.56 | 0xffff5fde86416bfdf5ace6c9ccd1776daa228ace69079825478dbbee73854fe5 | 0x00015784f4978d16be8fa312c8feaf5fdd92c1865224e105553e7cd0c7325bc7 |
6 | LUA | 1653103.57 | 0xfffff4fb071ad902a1b5f619b8c8038217b7e2e46f950d4f0cf5f4a0344c5866 | 0x0000426578c1f6065cbedead4938c2ece95176776dcb4df0df54ab03108c2f75 |
7 | AXS | 464381.08 | 0xfffbd72d628a10ddef1b61e9b2cf39e92097477d1b46e2d0f473f95a35ab32ae | 0x0002210334f3b4e3083d0ead8dc42421ebbdd097ce2e04902768ee9277e50dce |
TheLaughingManvolume by SYMBOL
Updated 8 days 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 daily stats @ https://flipsidecrypto.xyz/studio/queries/1559bf8f-7fd2-4743-b905-eaeafe88ee95
-- forked from overview stats @ https://flipsidecrypto.xyz/studio/queries/e3ee9fde-7c78-4a72-add7-9a9d880f215d
-- 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
Last run: 8 days ago
7
1KB
18s