with event_table as (

select

block_timestamp,

tx_hash,

event_name,

get(get(get(full_decoded_log, 'data'),0),'value') as account,

get(get(get(full_decoded_log, 'data'),1),'value') as token,

get(get(get(full_decoded_log, 'data'),2),'value') as amount,

get(get(get(full_decoded_log, 'data'),5),'value') /pow(10,18) as usdg_amount,

get(get(get(full_decoded_log, 'data'),6),'value') /pow(10,18) as glp_amount

from arbitrum.core.fact_decoded_event_logs

where contract_address in (lower('0x321F653eED006AD1C29D174e17d96351BDe22649'), --GLP Manager Old version

lower('0x3963FfC9dff443c2A94f21b129D429891E32ec18')) --GLP manager current version)

),

tokens(contract_address, symbol, decimals, underlying_name) as (

select * from

values

(lower('0xff970a61a04b1ca14834a43f5de4533ebddb5cc8'), 'USDC', 6, 'USDC.e'),

(lower('0xaf88d065e77c8cc2239327c5edb3a432268e5831'), 'USDC', 6, 'USDC'),

(lower('0x82af49447d8a07e3bd95bd0d56f35241523fbab1'), 'WETH', 18, 'WETH'),

(lower('0xda10009cbd5d07dd0cecc66161fc93d7c9000da1'), 'DAI', 18, 'DAI'),

(lower('0xf97f4df75117a78c1a5a0dbb814af92458539fb4'), 'LINK', 18, 'LINK'),

(lower('0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9'), 'USDT', 6, 'USDT'),

(lower('0xfa7f8980b0f1e64a2062791cc3b0871572f1f7f0'), 'UNI', 18, 'UNI'),

(lower('0xfea7a6a0b346362bf88a9e4a88416b77a57d6c2a'), 'MIM', 18, 'MIM'),

(lower('0x17fc002b466eec40dae837fc4be5c67993ddbd6f'), 'FRAX', 18, 'FRAX'),

(lower('0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f'), 'WBTC', 8, 'WBTC')

),

liquidity as (

select