with gains_pairs_list as (

select 0 as pair_index, 'Crypto' as group_name, 0 as group_index, 0 as fee_index, 'BTC/USD' as pair_name

union

select 1, 'Crypto', 0, 0, 'ETH/USD'

union

select 2, 'Crypto', 0, 0, 'LINK/USD'

union

select 3, 'Crypto', 0, 0, 'DOGE/USD'

union

select 4, 'Crypto', 0, 0, 'MATIC/USD'

union

select 5, 'Crypto', 0, 0, 'ADA/USD'

union

select 6, 'Crypto', 0, 0, 'SUSHI/USD'

union

select 7, 'Crypto', 0, 0, 'AAVE/USD'

union

select 8, 'Crypto', 0, 0, 'ALGO/USD'

union

select 9, 'Crypto', 0, 0, 'BAT/USD'

union

select 10, 'Crypto', 0, 0, 'COMP/USD'

union

select 11, 'Crypto', 0, 0, 'DOT/USD'

union

select 12, 'Crypto', 0, 0, 'EOS/USD'

union

select 13, 'Crypto', 0, 0, 'LTC/USD'

union

select 14, 'Crypto', 0, 0, 'MANA/USD'

union

select 15, 'Crypto', 0, 0, 'OMG/USD'

union

select 16, 'Crypto', 0, 0, 'SNX/USD'