kasadeghUntitled Query
    Updated 2022-08-24
    with game_info as (
    select game_address,game_name,league_name,sport_name
    from (
    SELECT
    distinct
    regexp_substr_all(SUBSTR(data, 3, len(data)), '.{64}') AS segmented_data,
    concat('0x', substr(segmented_data[0], 25, 40)) as game_address,
    concat (trim(HEX_DECODE_STRING(segmented_data[13] :: STRING), char(0)), ' vs ', trim(HEX_DECODE_STRING(segmented_data[15] :: STRING), char(0))) as game_name,
    ethereum.public.udf_hex_to_int(segmented_data[17] :: STRING) :: STRING as tag,
    CASE
    WHEN tag='1' THEN 'Sport'
    WHEN tag='2' THEN 'Crypto'
    WHEN tag='3' THEN 'Politics'
    WHEN tag='4' THEN 'Pop-culture'
    WHEN tag='5' THEN 'Esports'
    WHEN tag='101' THEN 'Football'
    WHEN tag='102' THEN 'Basketball'
    WHEN tag='201' THEN 'Bitcoin'
    WHEN tag='202' THEN 'Ethereum'
    WHEN tag='6' THEN 'Finance'
    WHEN tag='601' THEN 'TradFi'
    WHEN tag='9001' THEN 'NCAA Mens Football'
    WHEN tag='9002' THEN 'NFL'
    WHEN tag='9003' THEN 'MLB'
    WHEN tag='9004' THEN 'NBA'
    WHEN tag='9005' THEN 'NCAA Mens Basketball'
    WHEN tag='9006' THEN 'NHL'
    WHEN tag='9007' THEN 'MMA'
    WHEN tag='9008' THEN 'WNBA'
    WHEN tag='9010' THEN 'MLS'
    WHEN tag='9011' THEN 'EPL'
    WHEN tag='9012' THEN 'Ligue 1'
    WHEN tag='9013' THEN 'Bundesliga'
    WHEN tag='9014' THEN 'La Liga'
    WHEN tag='9015' THEN 'Serie A'
    WHEN tag='9016' THEN 'UEFA Champions League'
    Run a query to Download Data