ShapeShift2024-06-13 04:07 PM
Updated 2024-06-13Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
s.from_asset,
s.asset_usd,
s.rune_usd,
se.tx_id,
se.memo,
s.affiliate_address,
s.affiliate_fee_basis_points,
s.from_amount,
s.from_amount_usd,
FROM
thorchain.defi.fact_swaps s
JOIN
thorchain.defi.fact_swaps_events se
ON
se.tx_id = s.tx_id
WHERE
s.affiliate_address IN ('ss', 'thor1xmaggkcln5m5fnha2780xrdrulmplvfrz6wj3l')
AND NOT REGEXP_LIKE(se.memo, '.*:\\d+/\\d+/\\d+:.*');
QueryRunArchived: QueryRun has been archived