theericstonemissing bals
    Updated 2021-03-22

    select
    block_id,
    tx_id,
    block_timestamp,
    event_amount / 10 ^ 6 as event_amount,
    event_from,
    event_to,
    event_type,
    tx_from,
    tx_to,
    tx_type
    from public.udm_events_algorand uee
    where
    blockchain = 'algorand'
    and block_timestamp < '2020-06-01'
    and event_amount > 0
    and uee.event_to in (
    'UPY6CHCDXL56XKX472ISFTSAEB6WVSSRMPL66A4F4D2GAOTAXKL5KL7I2A',
    'P4YDFXSWGQHC4FQUWMWZX7PEIZXIQ65D2AAFNEBYNGL77KSYRBTJORQUB4',
    'TIKICBDBVMOH7LP5AUDATB5HJUNIANZFAZ46LLPXRAB5TD7BBPHAIYBJIQ',
    'NE4IC76YOZBI6DJDNPBIU2GZ7E7KEUOAOWPJ2C5HNPBAPLR6Y2VMQFZJXU',
    'UW4XUW56TBA6MPU6WOAN4HNAZO4A4PKZU6CJITLOIFM3GNJRUTH3LEP76Q',
    'CMJ7TXI4II5G56HOORJWLCV3YECJYTVS3EY6FTGYTDMMQ2Z6ATEP3ZDZXE',
    'EL5EGZL4AT5HTLNH7S3DYYY2VLNO7YFQUOJBVKPOGCGHA2VRUIB5WVX7VE',
    'N5XVAOKR4SGYSFRNCVMXZGKHEGTS2RS5OJEHOZAB4GT2LEMTWEHD7TSIVA',
    '57OQI5J752KTLP5H7TZUNHNMZIKA33YFPUYP7QV3J4CBVAJJDJYOAUHU7Q',
    '2LMYJMEUP7O5LB26QEAO2T3H3RCNSZOGVD23HGUX6AZ4WBMXYTAP2273IQ',
    'BNGRNXGSRKPXFWA44O4XWZW6TEDVVBIURGKEZILZZWDAC4XK6DCGH65XSM'
    ) and
    uee.event_from NOT IN(
    '4VNSA2GZVUD5ZNO62OVVNP4NEL2LIEE5N3MZEK4BKH62KGKRLVINFZYTZM','IVCEEIH2Q32DZNRTS5XFVEFFAQGERNZHHQT6S4UPY7ORJMHIQDSTX7YM4E','PLFHBIRGM3ZWGAMCXTREX2N537TWOMFIQXHFO2ZGQOEPZU473SYBVGVA5M','OGP6KK5KCMHT4GOEQXJ4LLNJ7D6P6IH7MV5WZ5EX4ZWACHP75ID5PPEE5E','AYBHAG2DAIOG26QEV35HKUBGWPMPOCCQ44MQEY32UOW3EXEMSZEIS37M2U','2XKK2L6HOBCYHGIGBS3N365FJKHS733QOX42HIYLSBARUIJHMGQZYAQDRY','ZBSPQQG7O5TR5MHPG3D5RS2TIFFD5NMOPR77VUKURMN6HV2BSN224ZHKGU','7NQED6NJ4NZU7B5HGGFU2ZEC2UZQYU2SA5S4QOE2EXBVAR4CNAHIXV2XYY','RX2ZKVJ43GNYDJNIOB6TIX26U7UEQFUQY46OMHX6CXLMMBHENJIH4YVLUQ','RHSKYCCZYYQ2BL6Z63626YUETJMLFGVVV47ED5D55EKIK4YFJ5DQT5CV4A','RJS6FDZ46ZZJIONLMMCKDJHYSJNHHAXNABMAVSGH23ULJSEAHZC6AQ6ALE','AZ2KKAHF2PJMEEUVN4E2ILMNJCSZLJJYVLBIA7HOY3BQ7AENOVVTXMGN3I','2LMYJMEUP7O5LB26QEAO2T3H3RCNSZOGVD23HGUX6AZ4WBMXYTAP2273IQ','N5BGWISAJSYT7MVW2BDTTEHOXFQF4QQH4VKSMKJEOA4PHPYND43D6WWTIU','VVW6BVYHBG7MZQXKAR3OSPUZVAZ66JMQHOBMIBJG6YSPR7SLMNAPA7UWGY','P4YDFXSWGQHC4FQUWMWZX7PEIZXIQ65D2AAFNEBYNGL77KSYRBTJORQUB4','KF7X4ZABZUQU7IFMHSKLDKWCS4F3GZLOLJRDAK5KMEMDAGU32CX36CJQ5M','BTEESEYQMFLWZKULSKLNDELYJTOOQK6ZT4FBCW3TOZQ55NZYLOO6BRQ5K4','E36JOZVSZZDXKSERASLAWQE4NU67HC7Q6YDOCG7P7IRRWCPSWXOI245DPA','I5Q6RRN44OZWYMX6YLWHBGEVPL7S3GBUCMHZCOOLJ245TONH7PERHJXE4A','2GYS272T3W2AP4N2VX5BFBASVNLWN44CNVZVKLWMMVPZPHVJ52SJPPFQ2I','D5LSV2UGT4JJNSLJ5XNIF52WP4IHRZN46ZGWH6F4QEF4L2FLDYS6I6R35Y','UWMSBIP2CGCGR3GYVUIOW3YOMWEN5A2WRTTBH6Y23KE3MOVFRHNXBP6IOE','OF3MKZZ3L5ZN7AZ46K7AXJUI4UWJI3WBRRVNTDKYVZUHZAOBXPVR3DHINE','2PPWE36YUMWUVIFTV2A6U4MLZLGROW4GHYIRVHMUCHDH6HCNVPUKPQ53NY','JRGRGRW4HYBNAAHR7KQLLBAGRSPOYY6TRSINKYB3LI5S4AN247TANH5IQY','D7YVVQJXJEFOZYUHJLIJBW3ATCAW46ML62VYRJ3SMGLOHMWYH4OS3KNHTU','PZJKH2ILW2YDZNUIYQVJZ2MANRSMK6LCHAFSAPYT6R3L3ZCWKYRDZXRVY4','3MODEFJVPGUZH3HDIQ6L2MO3WLJV3FK3XSWKFBHUGZDCHXQMUKD4B7XLMI','WNSA5P6C5IIH2UJPQWJX6FRNPHXY7XZZHOWLSW5ZWHOEHBUW4AD2H6TZGM','OO65J5AIFDS6255WL3AESTUGJD5SUV47RTUDOUGYHEIME327GX7K2BGC6U','DM6A24ZWHRZRM2HWXUHAUDSAACO7VKEZAOC2THWDXH4DX5L7LSO3VF2OPU','NTJJSFM75RADUOUGOBHZB7IJGO7NLVBWA66EYOOPU67H7LYIXVSPSI7BTA','DAV2AWBBW4HBGIL2Z6AAAWDWRJPTOQD6BSKU2CFXZQCOBFEVFEJ632I2LY','M5VIY6QPSMALVVPVG5LVH35NBMH6XJMXNWKWTARGGTEEQNQ3BHPQGYP5XU','WZZLVKMCXJG3ICVZSVOVAGCCN755VHJKZWVSVQ6JPSRQ2H2OSPOOZKW6DQ','XEJLJUZRQOLBHHSOJJUE4IWI3EZOM44P646UDKHS4AV2JW7Z
    )
    order by event_amount desc;
    Run a query to Download Data