kasadeghUntitled Query
Updated 2022-08-24
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
›
⌄
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