Query editor
With market_mapping as (SELECT blockchain, market_id, token_address, symbol_name, decimalsFROM query_4831341), margin_contracts(blockchain, contract_address) as (VALUES('arbitrum', 0x6bd780e7fdf01d77e4d475c821f1e7ae05409072)-- ('berachain', 0x003Ca23Fd5F0ca87D01F6eC6CD14A8AE60c2b97D),-- ('mantle', 0xE6Ef4f0B2455bAB92ce7cC78E35324ab58917De8),-- ('zkevm', 0x836b557Cf9eF29fcF49C776841191782df34e4e5)), dataset_pricing as (SELECT date_trunc('day', from_unixtime(unix_time)) as time, market_mapping.symbol_name, token, blockchain, max_by(close_price_usd, unix_time) as priceFROM dune.steakhouse.dataset_shogun_dolomite as dolomite_datasetJOIN market_mapping on dolomite_dataset.token = market_mapping.token_address--AND dolomite_dataset.chain = market_mapping.blockchainWHERE dolomite_dataset.chain='arbitrum'GROUP BY 1, 2, 3, 4), all_trade_keys as (SELECT 'arbitrum' as blockchain,bytearray_substring(data, 1, 32) as position_keyFROM arbitrum.logsJOIN margin_contracts USING (contract_address)WHERE topic0 = 0x54d4cc60cf7d570631cc1a58942812cb0fc461713613400f56932040c3497d19-- and contract_address = 0x6bd780e7fdf01d77e4d475c821f1e7ae05409072and bytearray_substring(data, 1 + 12, 20) NOT IN(0x0000000000000000000000000000000000000000,0xffffffffffffffffffffffffffffffffffffffff)GROUP BY 1, 2), deposits as (SELECT time, market_mapping.blockchain, user, market_mapping.symbol_name, amount/POWER(10, market_mapping.decimals) as amount, tx_hashFROM (SELECT date_trunc('day', block_time) as time, 'arbitrum' as blockchain, bytearray_substring(topic1, 1+12, 20) as user, bytearray_to_decimal(bytearray_substring(data, 1+12 + 32 + 4, 16)) as token, bytearray_to_uint256(bytearray_substring(data, 1+12 + 32 * 3 + 4, 16)) as amount, tx_hashFROM arbitrum.logsJOIN margin_contracts USING (contract_address)WHERE-- contract_address = 0x6bd780e7fdf01d77e4d475c821f1e7ae05409072 andtopic0 = 0x2bad8bc95088af2c247b30fa2b2e6a0886f88625e0945cd3051008e0e270198f) as deposits joinmarket_mapping on deposits.token = market_mapping.market_id AND deposits.blockchain = market_mapping.blockchainWHERE amount <> CAST(0 AS UINT256)), withdraws as (SELECT time