jp12Crypto-Unicorns RBW Usage
Updated 2023-04-28Copy 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 raw as (
SELECT block_timestamp, tx_hash, 'Breeding' as activity, contract_address,
IFF(contract_address = '0x431cd3c9ac9fc73644bf68bf5691f4b83f9e104f', 'RBW', 'UNIM') as token,
RAW_AMOUNT / 1e18 as amount
FROM polygon.core.fact_token_transfers
WHERE 1=1
AND ORIGIN_FUNCTION_SIGNATURE = '0xd2df3a9e'
and TO_ADDRESS = '0x94f557dddb245b11d031f57ba7f2c4f28c4a203e'
UNION
SELECT block_timestamp, tx_hash, 'Evolution' as activity, contract_address,
IFF(contract_address = '0x431cd3c9ac9fc73644bf68bf5691f4b83f9e104f', 'RBW', 'UNIM') as token,
RAW_AMOUNT / 1e18 as amount
FROM polygon.core.fact_token_transfers
WHERE 1=1
AND ORIGIN_FUNCTION_SIGNATURE = '0x65b4613f'
and TO_ADDRESS = '0x94f557dddb245b11d031f57ba7f2c4f28c4a203e'
UNION
SELECT block_timestamp, tx_hash, 'Transfer To Game' as activity, contract_address,
IFF(contract_address = '0x431cd3c9ac9fc73644bf68bf5691f4b83f9e104f', 'RBW', 'UNIM') as token,
RAW_AMOUNT / 1e18 as amount
FROM polygon.core.fact_token_transfers
WHERE 1=1
AND ORIGIN_FUNCTION_SIGNATURE = '0x51782474'
and TO_ADDRESS = '0x94f557dddb245b11d031f57ba7f2c4f28c4a203e'
UNION
SELECT block_timestamp, tx_hash, 'Transfer From Game' as activity, contract_address,
IFF(contract_address = '0x431cd3c9ac9fc73644bf68bf5691f4b83f9e104f', 'RBW', 'UNIM') as token,
RAW_AMOUNT / 1e18 as amount
FROM polygon.core.fact_token_transfers
WHERE 1=1
AND ORIGIN_FUNCTION_SIGNATURE = '0xdd7944f5'
Run a query to Download Data