Nige7777Transaction Fees
Updated 2021-07-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
-- select
-- event_attributes:"0_amount"[0]:amount / POW(10,6) AS amount0,
-- event_attributes:"1_amount"[0]:amount / POW(10,6) as amount1,
-- event_attributes:"2_amount"[0]:amount / POW(10,6) as amount2,
-- event_attributes:"3_amount"[0]:amount / POW(10,6) as amount3,
-- event_attributes:"4_amount"[0]:amount / POW(10,6) as amount4,
-- event_attributes,
-- *
-- -- sum(fee) as transaction_fee,
-- , date_trunc('day',block_timestamp)
-- *
-- from terra.msg_events
-- where tx_id = 'E75B421AF41C4C943FEBFF660F76C14346F15962C45074C0CF12348598E250F6'-- 'BB4B8657D1340D0650834D7F108DCBC2CC3F09DDE05C6063BD24E76432900BF4'
-- --and event_type = 'transfer'
select * from terra.msgs WHERE tx_id = 'E75B421AF41C4C943FEBFF660F76C14346F15962C45074C0CF12348598E250F6'
Run a query to Download Data