SELECT volume_alltime , sales_alltime , unique_buyers_alltime+13500 unique_buyers_alltime, volume_alltime/sales_alltime avg_price_alltime, volume_30, volume_30_prev, sales_30, unique_buyers_30, ((volume_30) * 100 /(volume_30_prev))-100 AS growth_30, (volume_30)/(sales_30) avg_price_30 , volume_7, volume_7_prev, sales_7, unique_buyers_7, (volume_7 * 100 /volume_7_prev)-100 AS growth_7, volume_7/sales_7 avg_price_7 , volume_1, volume_1_prev, sales_1, unique_buyers_1, (volume_1 * 100 /volume_1_prev)-100 AS growth_1, volume_1/sales_1 avg_price_1 FROM ( SELECT sum( CASE WHEN event_type IN ('TokensWithdrawn', 'BonusWithdrawn', 'FUCAndBonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null') THEN EVENT_DATA:amount ELSE 0 END) -sum( CASE WHEN event_type = 'TokensDeposited' AND EVENT_DATA:to = '0xc9e33923da7232e0' THEN EVENT_DATA:amount ELSE 0 END) AS volume_alltime , count( CASE WHEN event_type IN ('TokensWithdrawn', 'BonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null') THEN EVENT_DATA:from END) AS sales_alltime , count(DISTINCT CASE WHEN event_type IN ('TokensWithdrawn', 'BonusWithdrawn', 'FUCAndBonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null') THEN EVENT_DATA:from END) AS unique_buyers_alltime , sum( CASE WHEN event_type IN ('TokensWithdrawn', 'BonusWithdrawn', 'FUCAndBonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null') AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 30 THEN EVENT_DATA:amount ELSE 0 END) -sum( CASE WHEN event_type = 'TokensDeposited' AND EVENT_DATA:to = '0xc9e33923da7232e0' AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 30 THEN EVENT_DATA:amount ELSE 0 END)AS volume_30 , sum( CASE WHEN event_type IN ('TokensWithdrawn', 'BonusWithdrawn', 'FUCAndBonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null') AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 30 * 2 AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)> 24 * 30 THEN EVENT_DATA:amount ELSE 0 END) -sum( CASE WHEN event_type = 'TokensDeposited' AND EVENT_DATA:to = '0xc9e33923da7232e0' AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 30 * 2 AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)> 24 * 30 THEN EVENT_DATA:amount ELSE 0 END) AS volume_30_prev , count( CASE WHEN event_type IN ('TokensWithdrawn', 'BonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null') AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 30 THEN EVENT_DATA:from END) AS sales_30 , count(DISTINCT CASE WHEN event_type IN ('TokensWithdrawn', 'BonusWithdrawn', 'FUCAndBonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null') AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 30 THEN EVENT_DATA:from END) AS unique_buyers_30 , sum( CASE WHEN event_type IN ('TokensWithdrawn', 'BonusWithdrawn', 'FUCAndBonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null') AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 7 THEN EVENT_DATA:amount ELSE 0 END) -sum( CASE WHEN event_type = 'TokensDeposited' AND EVENT_DATA:to = '0xc9e33923da7232e0' AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 7 THEN EVENT_DATA:amount ELSE 0 END) AS volume_7 , sum( CASE WHEN event_type IN ('TokensWithdrawn', 'BonusWithdrawn', 'FUCAndBonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null') AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 7 * 2 AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)> 24 * 7 THEN EVENT_DATA:amount ELSE 0 END) -sum( CASE WHEN event_type = 'TokensDeposited' AND EVENT_DATA:to = '0xc9e33923da7232e0' AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 7 * 2 AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)> 24 * 7 THEN EVENT_DATA:amount ELSE 0 END) AS volume_7_prev , count( CASE WHEN event_type IN ('TokensWithdrawn', 'BonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null') AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 7 THEN EVENT_DATA:from END) AS sales_7 , count(DISTINCT CASE WHEN event_type IN ('TokensWithdrawn', 'BonusWithdrawn', 'FUCAndBonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null') AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 7 THEN EVENT_DATA:from END) AS unique_buyers_7 , sum( CASE WHEN event_type IN ('TokensWithdrawn', 'BonusWithdrawn', 'FUCAndBonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null') AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 1 THEN EVENT_DATA:amount ELSE 0 END) -sum( CASE WHEN event_type = 'TokensDeposited' AND EVENT_DATA:to = '0xc9e33923da7232e0' AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 1 THEN EVENT_DATA:amount ELSE 0 END) AS volume_1 , sum( CASE WHEN event_type IN ('TokensWithdrawn', 'BonusWithdrawn', 'FUCAndBonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null') AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 1 * 2 AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)> 24 * 1 THEN EVENT_DATA:amount ELSE 0 END) -sum( CASE WHEN event_type = 'TokensDeposited' AND EVENT_DATA:to = '0xc9e33923da7232e0' AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 1 * 2 AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)> 24 * 1 THEN EVENT_DATA:amount ELSE 0 END) AS volume_1_prev , count( CASE WHEN event_type IN ('TokensWithdrawn', 'BonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null') AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 1 THEN EVENT_DATA:from END) AS sales_1 , count(DISTINCT CASE WHEN event_type IN ('TokensWithdrawn', 'BonusWithdrawn', 'FUCAndBonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null') AND datediff('hours', block_timestamp, CURRENT_TIMESTAMP)< 24 * 1 THEN EVENT_DATA:from END) AS unique_buyers_1 FROM flow.core.fact_events WHERE event_contract = 'A.4eded0de73020ca5.FazeUtilityCoin' AND ( ( event_type IN ('TokensWithdrawn', 'BonusWithdrawn', 'FUCAndBonusWithdrawn') AND EVENT_DATA:from NOT IN ('0x4eded0de73020ca5', 'null')) OR ( event_type = 'TokensDeposited' AND EVENT_DATA:to = '0xc9e33923da7232e0') ) )

Query	Creator	Created
Untitled Query flow	vishalvas	Feb 1, 2023
Growth Query flow	vishalvas	Jan 11, 2023
Untitled Query	vishalvas	Feb 1, 2023
Based on input to wallet flow	vishalvas	Jan 12, 2023
updated FC Query flow	vishalvas	Jan 31, 2023
Untitled Query flow	vishalvas	Feb 1, 2023

vishalvas