extract(day from block_timestamp) as day,

extract(month from block_timestamp) as month,

extract(year from block_timestamp) as year,

round(sum(price),0),

round(sum(case when nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' then price else 0 end),0),

round(sum(case when nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' then price else 0 end)/sum(price), 3),

round(sum(case when nft_address in ('0x60e4d786628fea6478f785a6d7e704777c86a7c6','0xba30e5f9bb24caa003e9f2f0497ad287fdf95623',

'0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d','0x34d85c9cdeb23fa97cb08333b511ac86e1c4e258','0x22c36bfdcef207f9c0cc941936eff94d4246d14a')

then price else 0 end)/sum(price), 3)

from ethereum.core.ez_nft_sales

where currency_symbol in ('eth', 'weth', 'WETH', 'ETH') and block_timestamp > '2022-01-01'--and platform_name = 'opensea'

and lower(nft_address) not in ('0x81Ae0bE3A8044772D04F32398bac1E1B4B215aa8', -- dreadfulz

'0x81ae0be3a8044772d04f32398bac1e1b4b215aa8', -- dreadfulz

'0x4E1f41613c9084FdB9E34E11fAE9412427480e56', -- terraforms

'0x4e1f41613c9084fdb9e34e11fae9412427480e56', -- terraforms

'0x1dfe7Ca09e99d10835Bf73044a23B73Fc20623DF', -- more loot

'0x1dfe7ca09e99d10835bf73044a23b73fc20623df', -- more loot

'0xfF36cA1396d2a9016869274F1017d6C2139f495E', -- dementorstown

'0xff36ca1396d2a9016869274f1017d6c2139f495e', -- dementorstown

lower('0x8DcB8B2d721c022552d826F8bcf2995747248d31'), -- women ape yacht club

lower('0xdDE772F55da0DFB7f62C976B29A6eb01DAfEe0e3'), -- unidentified (LR)

lower('0x671eF54DbfDbD63cE01562457bC9A318eA7e6B60'), -- unidentified (LR)

lower('0xeD9e14346EdE00f1c19B69C098406FBb1693cb2A'), -- foolish child

lower('0x3169ca704192b1DDE76EeFDf69146A797B81fe80'), -- rare pepe birds

lower('0xEb1E9bCDFDDc74afa683d367292545142Fee9b8F'), -- metabeats studio

lower('0xa0BaE4C0410D79398703Cbd9A30d010D414ab0dA'), -- ascii birds

lower('0x7a48E016122B4786E3b96414598Fc608c8DC3aD4'), -- Hype Pass

lower('0x7Bd29408f11D2bFC23c34f18275bBf23bB716Bc7'), -- meebits

'0xff9c1b15b16263c61d017ee9f65c50e4ae0113d7', -- loot

'0xfb3765e0e7ac73e736566af913fa58c3cfd686b7', -- audioglyphs