SELECT SUM(price) AS Rim_dapper , date_trunc( day , block_timestamp) as date

FROM flow.core.fact_nft_sales JOIN flow.core.dim_topshot_metadata using (nft_id)

WHERE nft_collection = 'A.0b2a3299cc857e29.TopShot'

AND currency= 'A.ead892083b3e2c6c.DapperUtilityCoin'

AND play_type = 'Rim'

group by date

order by date ASC

),

tbl3 AS(

SELECT SUM(price) AS three_Pointer_dapper , date_trunc( day , block_timestamp) as date2

FROM flow.core.fact_nft_sales JOIN flow.core.dim_topshot_metadata using (nft_id)

WHERE nft_collection = 'A.0b2a3299cc857e29.TopShot'

AND currency= 'A.ead892083b3e2c6c.DapperUtilityCoin'

AND play_type = '3 Pointer'

group by date2

order by date2 ASC

),

tbl5 AS(

SELECT SUM(price) AS Assist_dapper , date_trunc( day , block_timestamp) as date4

FROM flow.core.fact_nft_sales JOIN flow.core.dim_topshot_metadata using (nft_id)

WHERE nft_collection = 'A.0b2a3299cc857e29.TopShot'

AND currency= 'A.ead892083b3e2c6c.DapperUtilityCoin'

AND play_type = 'Assist'

group by date4

order by date4 ASC

),

tbl7 AS(

SELECT SUM(price) AS Block_dapper , date_trunc( day , block_timestamp) as date6

FROM flow.core.fact_nft_sales JOIN flow.core.dim_topshot_metadata using (nft_id)

WHERE nft_collection = 'A.0b2a3299cc857e29.TopShot'

AND currency= 'A.ead892083b3e2c6c.DapperUtilityCoin'

AND play_type = 'Block'

group by date6