rmasTop Traders
Updated 2022-08-22
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
›
⌄
-- Note to reviewers:
-- My original query somehow got published on discover page. https://app.flipsidecrypto.com/velocity/queries/58a3831f-73e3-4f6a-9e28-9b76ea5e235d
-- I got informed that it has been openly shared in one of the Discord channels so it's possible to see exact copies of the code below.
-- As proof that I wrote this code originally, please see the Method section of my dashboard where I explain how this code was written.
WITH
missing_market_data AS (
SELECT column1 AS market_address
, column2 AS game_id
, column3 AS game_label
FROM (VALUES
('0x08ed7d6569e79ae999eac183b43066041e92be87', '0x3636373831623831633638663363656666656130363336643037613535616339', 'Sampdoria vs Atalanta')
, ('0x61e4333a2ff4f68e0f3589633e73b66d0ce226cb', '0x3161363030316234303235666535666464313636303134613732356463393637', 'San Diego Padres vs San Francisco Giants')
, ('0x16bce71aa46ff2972ac77d37795fa47ff87127c6', '0x3438643435626431343565666133643030333233393662333165336532386234', 'AS Monaco vs Stade Rennes')
, ('0x3f41932ffe4b673e0fdc3309ff2094cd91524e57', '0x3566366438366230663736323435306332616134343264336433333934333961', 'Milwaukee Brewers vs Tampa Bay Rays')
, ('0x233e9de3309e6d7ea8b34b3e26918576ef795541', '0x3434306135353135386630363465656136326630653739633333333731616361', 'Lecce vs Inter Milan')
, ('0xae0d0e7c5d9f8d8c17eb48b8d00a823c14dda3e2', '0x3937636133353339663263656466393636346336653333343466336138653264', 'Arsenal FC vs Leicester City')
, ('0xeab632efebd42b1cdc223a74bc48a01d89a26650', '0x3034623363646561636330653933613263336161336639393130653434383734', 'Aston Villa vs Everton')
, ('0xc8050327fea017839e4584b7e416412d71f20a35', '0x6132333064663935356534333037303232316666636633313832613634306231', 'Seattle Mariners vs New York Yankees')
, ('0xfe0bcbd4b5851e4dd183c52226049653dc950e12', '0x3437343735363736666537656564626636636531313266386134643237343966', 'Lazio vs Bologna')
, ('0x1339b86def04bb3192c20f398cfc25a4d93de109', '0x3533353264633765306631343332353431376236393538613565376132656633', 'SC Freiburg vs Borussia Dortmund')
, ('0xc87757f2626614ba67bffc7f624fd4d4e455bd76', '0x3032616334366165626337346464623634653032366138326336343562666366', 'San Diego Padres vs San Francisco Giants')
, ('0xd37063eaf88eea27bef94e934055b54f4ca151e7', '0x3162336235333763623965363438353565373565326663646234633533643666', 'Southampton vs Leeds United')
, ('0x5ad5935a0848ef5fbc1bfe08df1f8ea0f729fc74', '0x3364373634613461336533326235363436343435623065646439623935346230', 'Schalke 04 vs Borussia Monchengladbach')
, ('0x6b91489201f031762a917e85aed3428375083110', '0x3835383063326233396432383037633064663937346438326662653035343331', 'Colorado Rockies vs St. Louis Cardinals')
, ('0x4aba27e6b36a658ed179da600ce90ee08ada7178', '0x3765383137646664663435353265613466643562343365336437353763633436', 'Paris Saint-Germain vs Montpellier')
, ('0x8a895ff38c169cb97984cd0dfd4c608a6b7fd532', '0x3662313536353936323061373633643432303437386463633234353931313535', 'Fiorentina vs Cremonese')
, ('0x9ee0ab940f1913b931a438741a095166ef1855ea', '0x6437313866323233373336666136653137656364383634613262323232326434', 'TSG Hoffenheim vs VfL Bochum')
, ('0xdf1a2c9deaf767c783c3a15d458cae1e59095536', '0x6161373161353436316161363731366332653430336461326235636139303537', 'Wolverhampton vs Fulham')
, ('0x83c3be7bc458476aee274524237b6f360ed63409', '0x6539383330343235343465623735326436303934383762323136353361643632', 'Real Valladolid vs Villarreal')
, ('0xbd99429225e0729bcaed19286866ee7002e8fdf3', '0x3965336335396230353230383636326436666239393361346635633265333739', 'Chicago Cubs vs Washington Nationals')
, ('0x57bd667e31be347bb8d567969a16401c9081a44b', '0x3364313162346634666532323438666130663131643461353935636638646437', 'Chicago Cubs vs Washington Nationals')
, ('0x137f81079dddea8034ed46cd77671c8ea4d5c3fd', '0x3561396561376162643766346564623134356139363639386335336538356265', 'Monza vs Torino')
Run a query to Download Data