ehsanstUntitled Query
Updated 2022-12-12Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with tx1 as(select TX_ID,MIN(FROM_ASSET) as FROM_ASSET,MIN(TO_ASSET) as TO_ASSET,count(*)
FROM thorchain.core.fact_swaps
WHERE AFFILIATE_ADDRESS = 'te'
group by TX_ID
having(count(*))>=2),
tx2 as(
select TX_ID,sum(TO_AMOUNT) as AFF_Fee,sum(TO_AMOUNT*COALESCE(RUNE_USD, 1)) as AFF_Fee_USD,min(TO_ASSET) as rn
FROM thorchain.core.fact_swaps
WHERE NATIVE_TO_ADDRESS = 'te' and TO_ASSET='THOR.RUNE' and AFFILIATE_ADDRESS = 'te'
group by TX_ID
having(count(*))>=2)
select tx1.TX_ID,tx1.FROM_ASSET,tx1.TO_ASSET,AFF_Fee,AFF_Fee_USD from tx1 join tx2 on tx1.TX_ID=tx2.TX_ID
order by AFF_Fee_USD desc
select * from thorchain.core.fact_swaps_events where tx_id='E0F91EAAD070AF56F0A87237096C574F81DDC50C44BD9A340C60014976323B11'
select * from thorchain.core.fact_swaps where RUNE_USD is NULL limit 100
select TO_AMOUNT*COALESCE(RUNE_USD, 1),* from thorchain.core.fact_swaps
where TX_ID='B051DC776B4449A094511AE2082BBBBD278E3ACE121AD1B56A9C56E69EAA4A21'
AND NATIVE_TO_ADDRESS = 'te' and TO_ASSET='THOR.RUNE'
select * from thorchain.core.fact_swaps limit 100
select TX_ID,MIN(FROM_ASSET) as FROM_ASSET,MIN(TO_ASSET) as TO_ASSET,count(*)
FROM thorchain.core.fact_swaps
WHERE AFFILIATE_ADDRESS = 'te'
group by TX_ID
having(count(*))<2
select * from thorchain.core.fact_swaps_events where tx_id='72148219B62C2ED79F6E5AD1422C84F0A8F886801FCE0AE8E8C706AD2E3BD29A' limit 100
SELECT fact_swaps.BLOCK_TIMESTAMP AS TIMESTAMP, fact_swaps.TX_ID, fact_swaps.FROM_ASSET, fact_swaps.TO_ASSET, fact_swaps.FROM_AMOUNT_USD AS SWAP_VALUE_USD, fact_swaps.AFFILIATE_ADDRESS, fact_swaps.AFFILIATE_FEE_BASIS_POINTS AS BASIS_POINTS, fact_swaps_events.MEMO
FROM thorchain.core.fact_swaps
Run a query to Download Data