winnie-fsv2 FINAL ARB Movements for Airdropped Protocols LABELED with NAMES copy
Updated 2023-05-23
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
›
⌄
-- forked from Deebs-DeFi-I-Orbital-Command-j9fRbz / v2 FINAL ARB Movements for Airdropped Protocols LABELED with NAMES @ https://flipsidecrypto.xyz/Deebs-DeFi-I-Orbital-Command-j9fRbz/q/final-arb-movements-for-airdropped-protocols-labeled-fWMg_F
SELECT
date_trunc('day', BLOCK_TIMESTAMP) AS DATE,
CASE
when FROM_ADDRESS='0x978982772b8e4055b921bf9295c0d74eb36bc54e' THEN 'SUSHISWAP'
when FROM_ADDRESS='0x0eb5b03c0303f2f47cd81d7be4275af8ed347576' THEN 'TREASURE'
when FROM_ADDRESS='0x2fa6f21ecfe274f594f470c376f5bdd061e08a37' THEN 'DOPEX'
when FROM_ADDRESS='0x25877b9413cc7832a6d142891b50bd53935fef82' THEN 'CURVE'
when FROM_ADDRESS='0x750129c21c7846cfe0ce2c966d84c0bca5658497' THEN 'RADIANT CAPITAL'
when FROM_ADDRESS='0x283c41b726634fbd6b72aa22741b202db7e56aac' THEN 'CAP'
when FROM_ADDRESS='0xc9032419aa502fafa107775dca8b7d07575d9db5' THEN 'VESTA FINANCE'
when FROM_ADDRESS='0xbbe98d590d7eb99f4a236587f2441826396053d3' THEN 'PLUTUSDAO'
when FROM_ADDRESS='0x053d55f9b5af8694c503eb288a1b7e552f590710' THEN 'AAVE'
when FROM_ADDRESS='0x71890ac6209fae61e9d66691c47b168b8300a7c5' THEN '1INCH'
when FROM_ADDRESS='0xc097ea3ea6d6851e8c274ace6373107c5a253f62' THEN 'DFORCE'
when FROM_ADDRESS='0xfa82f1ba00b0697227e2ad6c668abb4c50ca0b1f' THEN 'JONES DAO'
when FROM_ADDRESS='0x28fda5fb2ac9436bc4bb8bedafee25a550956de6' THEN 'GALXE'
when FROM_ADDRESS='0x03ff2d78afb69e0859ec6beb4cf107d3741e97ab' THEN 'CAMELOT'
when FROM_ADDRESS='0x01d3e7271c278aa3aa56eeba6a109b2c200679fa' THEN 'DODO'
when FROM_ADDRESS='0xf8e93a7d954f7d31d5fa54bc0eb0e384412a158d' THEN 'GAINS NETWORK'
when FROM_ADDRESS='0x029a4a97e892e7270d9b3b90bfef95599bc6bfd6' THEN 'MUX PROTOCOL'
when FROM_ADDRESS='0x3f5eddad52c665a4aa011cd11a21e1d5107d7862' THEN 'SPERAX'
when FROM_ADDRESS='0x3f5eddad52c665a4aa011cd11a21e1d5107d7862' THEN 'BEEFY FINANCE'
when FROM_ADDRESS='0xffb9422a08258e73c139fc32a25e10410c14ce8b' THEN 'PREMIA'
when FROM_ADDRESS='0x8b059bf6ce7c279a5bfec006f439db1e5c4a924c' THEN 'TRIDENT'
when FROM_ADDRESS='0xc405d5f309c8b02151eea53a8093aa1a7982fa92' THEN 'DAMNED PIRATES SOCIETY'
when FROM_ADDRESS='0x7bb054db7b9155b27f26008f9f5733a179699748' THEN 'RICEDEFI WALLET'
when FROM_ADDRESS='0x691fa1d4dc25f39a22dc45ca98080cf21ca7ec64' THEN 'BUFFER FINANCE'
when FROM_ADDRESS='0xfd1506eabc34891529933e5ec2c87a4eba5d9c86' THEN 'MULTICHAIN'
when FROM_ADDRESS='0xd3440dd072db409118309589417155fce1b8cf25' THEN 'XTOKEN'
when FROM_ADDRESS='0x5be4fb908a43d61b1c8086fe62e39ae8ec483926' THEN 'ZYBERSWAP'
END AS PROJECT,
FROM_ADDRESS,
sum(AMOUNT_USD) AS Moved_Amount_USD
Run a query to Download Data