Derek2628Exchange balance change copy copy
Updated 2023-11-10
999
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
›
⌄
{{param_DV2m}}-- forked from Exchange balance change copy @ https://flipsidecrypto.xyz/edit/queries/6af3db11-4452-4b36-bc57-f300a1beb765
-- forked from Exchange balance change @ https://flipsidecrypto.xyz/edit/queries/8cc79fd0-78dc-430c-9720-aef8fb0b9955
-- CRYPTOCOM
WITH from_transactions_cryptocom AS (
SELECT
to_date(block_timestamp) as date,
amount_e8 * (-1) as amount
FROM
thorchain.core.fact_transfer_events as c1
WHERE
c1.from_address = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'
AND c1.asset = 'THOR.RUNE'
ORDER BY
date
),
to_transactions_cryptocom AS (
SELECT
to_date(block_timestamp) as date,
amount_e8 as amount
FROM
thorchain.core.fact_transfer_events as c1
WHERE
c1.to_address = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'
AND c1.asset = 'THOR.RUNE'
ORDER BY
date
),
transactions_all_cryptocom AS (
SELECT
*
FROM
from_transactions_cryptocom
UNION
ALL
SELECT
Run a query to Download Data