negin-khDaily volume on Overtime Markets over the past two weeks
Updated 2022-08-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
block_timestamp:: DATE AS DAY,
SUM(Total_AMOUNT)
FROM
(SELECT
block_timestamp,
event_inputs:value::float AS AMOUNT,
CASE WHEN contract_address = '0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9' THEN AMOUNT/POW(10,18)
WHEN contract_address = '0x94b008aa00579c1307b0ef2c499ad98a8ce58e58' THEN AMOUNT/POW(10,6)
WHEN contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607' THEN AMOUNT/POW(10,6)
WHEN contract_address = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' THEN AMOUNT/POW(10,18)
END AS TOTAL_AMOUNT
from optimism.core.fact_event_logs
WHERE event_name = 'Transfer'
and block_timestamp::date >= current_date - 14
and event_inputs:to = '0x170a5714112daeff20e798b6e92e25b86ea603c1'
and event_inputs:from = origin_from_address
and tx_status = 'SUCCESS'
AND contract_address IN ('0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9', '0x94b008aa00579c1307b0ef2c499ad98a8ce58e58' ,
'0x7f5c764cbc14f9669b88837ca1490cca17c31607' , '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' ))
GROUP BY 1
Run a query to Download Data