Flipside Data ScienceNear On-chain Labels
Updated 2023-10-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
BLOCK_TIMESTAMP as timestamp,
TX_HASH as hash,
SIGNER_ID as actor ,
TRY_PARSE_JSON(NODE_DATA):value:blockchain :: string as blockchain,
TRY_PARSE_JSON(NODE_DATA):value:contract_address :: string as contract_address,
TRY_PARSE_JSON(NODE_DATA):value:contract_name :: string as contract_name,
TRY_PARSE_JSON(NODE_DATA):value:protocol :: string as protocol ,
TRY_PARSE_JSON(NODE_DATA):value:label_type :: string as label_type,
TRY_PARSE_JSON(NODE_DATA):value:label_subtype :: string as label_subtype,
TRY_PARSE_JSON(NODE_DATA):value:discord_handle :: string as discord_handle
from near.social.fact_decoded_actions
where TRY_PARSE_JSON(NODE_DATA):value:gateway ='flipside_gateway'
and TRY_PARSE_JSON(NODE_DATA):value:method ='register_label'
and NODE ='index'
Run a query to Download Data