rajsWormhole Raw Data
    Updated 2022-06-17
    with raw_table AS
    (
    SELECT
    tx_id,
    block_timestamp,
    signers as wallet_address,
    post_token_balances[0]:mint as token_address,
    post_token_balances[0]:uiTokenAmount:uiAmountString - pre_token_balances[0]:uiTokenAmount:uiAmountString as token_amount,
    case when post_token_balances[0]:mint = 'AjkPkq3nsyDe1yKcbyZT7N4aK4Evv9om9tzhQD3wsRC' then '0x111111111117dC0aa78b770fA6A738034120C302'
    when post_token_balances[0]:mint = '4ThReWAbAVZjNVgs5Ui9Pk3cZ5TYaD9u6Y89fp6EFzoF' then '0x009178997aff09a67d4caccfeb897fb79d036214'
    when post_token_balances[0]:mint = '3vAs4D1WE6Na4tCgt4BApgFfENbm8WY7q4cSPD1yM4Cg' then '0x7Fc66500c84A76Ad7e9c93437bFc5Ac33E2DDaE9'
    when post_token_balances[0]:mint = '12uHjozDVgyGWeLqQ8DMCRbig8amW5VmvZu3FdMMdcaG' then '0x8ab7404063ec4dbcfd4598215992dc3f8ec853d7'
    when post_token_balances[0]:mint = '3UCMiSnkcnkPE1pgQ5ggPCBv6dXgVUy16TmMUe1WpG9x' then '0x27702a26126e0b3702af63ee09ac4d1a084ef628'
    when post_token_balances[0]:mint = '9ARQsBfAn65q522cEqSJuse3cLhA31jgWDBGQHeiq7Mg' then '0xac51066d7bec65dc4589368da368b212745d63e8'
    when post_token_balances[0]:mint = 'D559HwgjYGDYsXpmFUKxhFTEwutvS9sya1kXiyCVogCV' then '0xff20817765cb7f73d4bde2e66e067e58d11095c2'
    when post_token_balances[0]:mint = 'EHKQvJGu48ydKA4d3RivrkNyTJTkSdoS32UafxSX1yak' then '0xd46ba6d942050d489dbd938a2c909a5d5039a161'
    when post_token_balances[0]:mint = 'Gq2norJ1kBemBp3mPfkgAUMhMMmnFmY4zEyi26tRcxFB' then '0x8290333cef9e6d528dd5618fb97a76f268f3edd4'
    when post_token_balances[0]:mint = '9LzCMqDgTKYz9Drzqnpgee3SGa89up3a247ypMj2xrqM' then '0x18aaa7115705e8be94bffebde57af9bfc265b998'
    when post_token_balances[0]:mint = 'HysWcbHiYY9888pHbaqhwLYZQeZrcQMXKQWRqS7zcPK5' then '0xbb0e17ef65f82ab018d8edd776e8dd940327b28b'
    when post_token_balances[0]:mint = 'EPeUFDgHRxs9xxEPVaL6kfGQvCon7jmAWKVUHuux1Tpz' then '0x0d8775f648430679a709e98d2b0cb6250d2887ef'
    when post_token_balances[0]:mint = 'EDVVEYW4fPJ6vKw5LZXRGUSPzxoHrv6eWvTqhCr8oShs' then '0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c'
    when post_token_balances[0]:mint = '33fsBLA8djQm82RpHmE3SuVrPGtZBWNYExsEUeKX1HXX' then '0x4fabb145d64652a948d72533023f6e7a623c7c53'
    when post_token_balances[0]:mint = 'nRtfwU9G82CSHhHGJNxFhtn7FLvWP2rqvQvje1WtL69' then '0xaaaebe6fe48e54f431b0c390cfaf0b017d09d42d'
    when post_token_balances[0]:mint = '5TtSKAamFq88grN1QGrEaZ1AjjyciqnCya1aiMhAgFvG' then '0x3506424f91fd33084466f402d5d97f05f8e3b4af'
    when post_token_balances[0]:mint = 'AwEauVaTMQRB71WeDnwf1DWSBxaMKjEPuxyLr1uixFom' then '0xc00e94cb662c3520282e6f5717214004a7f26888'
    when post_token_balances[0]:mint = 'HihxL2iM6L6P1oqoSeiixdJ3PhPYNxvSKH9A2dDqLVDH' then '0x2ba592f78db6436527729929aaf6c908497cb200'
    when post_token_balances[0]:mint = 'DvjMYMVeXgKxaixGKpzQThLoG98nc7HSU7eanzsdCboA' then '0xa0b73e1ff0b80914ab6fe0444e65848c4c34450b'
    when post_token_balances[0]:mint = '7gjNiPun3AzEazTZoFEjZgcBMeuaXdpjHq2raZTmTrfs' then '0xd533a949740bb3306d119cc777fa900ba034cd52'
    when post_token_balances[0]:mint = 'BLvmrccP4g1B6SpiVvmQrLUDya1nZ4B2D1nm9jzKF7sz' then '0x4e3fbd56cd56c3e72c1403e103b45db9da5b9d2b'
    when post_token_balances[0]:mint = 'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o' then '0x6b175474e89094c44da98b954eedeac495271d0f'
    when post_token_balances[0]:mint = '4Hx6Bj56eGyw8EJrrheM6LBQAvVYRikYCWsALeTrwyRU' then '0x92d6c1e31e14520e676a687f0a93788b716beff5'
    when post_token_balances[0]:mint = '6nKUU36URHkewHg5GGGAgxs6szkE4VTioGUT5txQqJFU' then '0x761d38e5ddf6ccf6cf7c55759d5210750b5d60f3'
    when post_token_balances[0]:mint = 'EXExWvT6VyYxEjFzF5BrUxt5GZMPVZnd48y3iWrRefMq' then '0xf629cbd94d3791c9250152bd8dfbdf380e2a3b9c'
    when post_token_balances[0]:mint = 'CLQsDGoGibdNPnVCFp8BAsN2unvyvb41Jd5USYwAnzAg' then '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
    when post_token_balances[0]:mint = '7vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs' then '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    when post_token_balances[0]:mint = 'FR87nWEUxVgerFGhZM8Y4AggKGLnaXswr1Pd8wZ4kZcp' then '0x853d955acef822db058eb8505911ed77f175b99e'
    Run a query to Download Data