jp12Spindl Polygon Gaming - Sandbox users
Updated 2022-10-12
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 sand as (
SELECT BLOCK_TIMESTAMP, tx_id, from_address, nonce, TO_ADDRESS, FUNCTION_SIGNATURE,
CASE
WHEN TO_ADDRESS = '0xa6e383bda26e4c52a3a3a3463552c42494669abd' THEN 'Token Stakers'
WHEN TO_ADDRESS = '0xbbba073c31bf03b8acf7c28ef0738decf3695683' THEN 'Token Users'
WHEN TO_ADDRESS = '0x4ab071c42c28c4858c4bac171f06b13586b20f30' THEN 'LP Stakers'
END as type
FROM flipside_prod_db.polygon.transactions
WHERE 1=1
and TO_ADDRESS IN ('0xa6e383bda26e4c52a3a3a3463552c42494669abd', '0xbbba073c31bf03b8acf7c28ef0738decf3695683', '0x4ab071c42c28c4858c4bac171f06b13586b20f30')
-- and STATUS = 'SUCCESS'
and SUCCESS = 'TRUE'
UNION
SELECT BLOCK_TIMESTAMP, tx_id, ORIGIN_ADDRESS as from_address, -1 as nonce, TO_ADDRESS, ORIGIN_FUNCTION_SIGNATURE as FUNCTION_SIGNATURE,
'Token Users' as type
FROM flipside_prod_db.polygon.udm_events
WHERE 1=1
and contract_address = '0xbbba073c31bf03b8acf7c28ef0738decf3695683'
UNION
SELECT BLOCK_TIMESTAMP, tx_id, ORIGIN_ADDRESS as from_address, -1 as nonce, TO_ADDRESS, ORIGIN_FUNCTION_SIGNATURE as FUNCTION_SIGNATURE,
'NFT Users' as type
FROM flipside_prod_db.polygon.udm_events
WHERE 1=1
and contract_address = '0x9d305a42a3975ee4c1c57555bed5919889dce63f'
UNION
SELECT BLOCK_TIMESTAMP, tx_id, EVENT_INPUTS:to::string as from_address, -1 as nonce, TX_TO_ADDRESS as TO_ADDRESS, 'N/A' as FUNCTION_SIGNATURE,
'NFT Users' as type
FROM flipside_prod_db.polygon.EVENTS_EMITTED
WHERE 1=1
and contract_address = '0x9d305a42a3975ee4c1c57555bed5919889dce63f'
Run a query to Download Data