Query editor
WITH DAILY_AVG_PRICE AS (SELECTdate_trunc('day', minute) AS ds, avg(price) AS avg_priceFROM prices.usdWHERE symbol = 'TON'AND blockchain IS NULLGROUP BY 1)SELECT tm.block_date, SUM(tm.value / POWER(10, 9)) AS TON_AMOUNT, SUM(tm.value * pu.avg_price/ POWER(10, 9)) AS USD_AMOUNT, ANY_VALUE(tm.tx_hash) AS SAMPLE_TX, ANY_VALUE(tm.comment) AS SAMPLE_COMMENTFROM ton.messages tmLEFT JOIN DAILY_AVG_PRICE puON tm.block_date = pu.ds-- convert to ton_address_raw_to_user_friendly(source, false)WHERE tm.source = '0:E6F3D8824F46B1EFBAB9AFC684793428C55FED69B46A15A49BE69A29BC49E530'AND strpos(tm.comment, 'Reward from Telegram') != 0AND tm.comment IS NOT NULLGROUP BY 1