-- Question 3: What percentage of people receiving the FWBpro airdrop have held onto their tokens? -- Were people more likely to sell right after the start of the airdrop or has selling happened over time? -- Are there any patterns to holding vs selling behavior among wallets? -- Were larger holders of $FWB Classic more likely to try and mitigate risk after the hack? -- Payout 1.52 FWB -- Grand Prize 4.56 FWB -- Level Intermediate with airdrops as ( select * from ethereum.udm_events where -- tx_id = '0x13863fa2110bf7f20e265a2ac4b82e8e0c582da0a94e9fa33354f732fce8a1a1' and origin_address = '0x523d643e3d7c455d043ee11b51bc8ec08f6ff474' and contract_address = '0x35bd01fc9d6d5d81ca9e055db88dc49aa2c699a8' -- FWBPro and to_address <> '0x0a965a4caf929338044c593d82d385c4c898d8c6' -- FWB-WETH UNI-V2 LP POOL and block_timestamp::date = '2021-03-20' and origin_function_signature = '0x6a761202' -- execTransaction and event_name = 'transfer' ), fwb_swaps as ( select * from ethereum.dex_swaps where token_address = '0x35bd01fc9d6d5d81ca9e055db88dc49aa2c699a8' -- FWB and direction = 'IN' and block_timestamp::date >= '2021-03-20' -- and tx_id = '0x75b25d85ba5abb4962577b77f8ae0aad0e699ae6882b3c6e33b57d9cbf18f35f' ), swaps_with_address as ( select e.from_address as swapper, s.* from ethereum.udm_events e join fwb_swaps s on e.tx_id = s.tx_id and e.contract_address = s.token_address where e.event_name = 'transfer' and e.block_timestamp::date >= '2021-03-20' ), airdroppers_swapping as ( select a.block_timestamp as airdrop_date, a.amount as airdrop_amount, s.block_timestamp as swap_date, s.amount_in as swapped_amount, (datediff(days, airdrop_date, swap_date)) as n_days_airdrop_to_swap, s.* from swaps_with_address s join airdrops a on s.swapper = a.to_address and s.block_timestamp > a.block_timestamp and s.amount_in <= a.amount ) select count(distinct swapper) as n_wallets, CASE WHEN n_days_airdrop_to_swap > 0 and n_days_airdrop_to_swap <= 25 THEN 'a.0-25 Days' WHEN n_days_airdrop_to_swap > 25 and n_days_airdrop_to_swap <= 50 THEN 'b.25-50 Days' WHEN n_days_airdrop_to_swap > 50 and n_days_airdrop_to_swap <= 75 THEN 'c.50-75 Days' WHEN n_days_airdrop_to_swap > 75 and n_days_airdrop_to_swap <= 100 THEN 'd.75-100 Days' WHEN n_days_airdrop_to_swap > 100 and n_days_airdrop_to_swap <= 125 THEN 'e.100-125 Days' WHEN n_days_airdrop_to_swap > 125 and n_days_airdrop_to_swap <= 150 THEN 'f.125-150 Days' WHEN n_days_airdrop_to_swap > 150 and n_days_airdrop_to_swap <= 175 THEN 'g.150-175 Days' WHEN n_days_airdrop_to_swap > 175 and n_days_airdrop_to_swap <= 200 THEN 'h.175-200 Days' WHEN n_days_airdrop_to_swap > 200 THEN 'i.> 200 Days' END as category from airdroppers_swapping group by category order by category

3.FWB-FWBpro Airdrop