Hey again. I don't know if you've tried the macro I posted a few days ago yet, but if you have, you'll have discovered that not only does it take a long time to complete, but it doesn't even produce the results you were looking for. Fortunately, after I saw the other threads related to this line of questioning and got ahold of a sample of the data for myself, I was able to come up with something that I've verified works as expected. Assuming you only want variables starting with "Market Name", this new macro produces the following kind of list in a much more reasonable amount of time (around 5 seconds on my machine):
[details=Click Here to See Macro Results]> Market Name BTC 1ST
Market Name ETH 1ST
Market Name BTC ADT
Market Name ETH ADT
Market Name BTC ADX
Market Name ETH ADX
Market Name BTC ANT
Market Name ETH ANT
Market Name BTC ARK
Market Name BTC QWARK
Market Name BTC AUR
Market Name BTC XAUR
Market Name BTC BAT
Market Name ETH BAT
Market Name BTC BCC
Market Name ETH BCC
Market Name USDT BCC
Market Name BTC BNT
Market Name ETH BNT
Market Name BTC BTS
Market Name ETH BTS
Market Name BTC CFI
Market Name ETH CFI
Market Name BTC CRB
Market Name ETH CRB
Market Name BTC CVC
Market Name ETH CVC
Market Name BTC DASH
Market Name ETH DASH
Market Name USDT DASH
Market Name BTC DGB
Market Name ETH DGB
Market Name BTC DGD
Market Name ETH DGD
Market Name BTC DNT
Market Name ETH DNT
Market Name BTC ETC
Market Name ETH ETC
Market Name USDT ETC
Market Name BTC ETH
Market Name USDT ETH
Market Name BTC FCT
Market Name ETH FCT
Market Name BTC FUN
Market Name ETH FUN
Market Name BTC GNO
Market Name ETH GNO
Market Name BTC GNT
Market Name ETH GNT
Market Name BTC AGRS
Market Name BTC GRS
Market Name BTC GUP
Market Name ETH GUP
Market Name BTC HMQ
Market Name ETH HMQ
Market Name BTC LGD
Market Name ETH LGD
Market Name BTC LTC
Market Name ETH LTC
Market Name USDT LTC
Market Name BTC LUN
Market Name ETH LUN
Market Name BTC MANA
Market Name ETH MANA
Market Name BTC MCO
Market Name ETH MCO
Market Name BTC MTL
Market Name ETH MTL
Market Name BTC MYST
Market Name ETH MYST
Market Name BTC NEO
Market Name ETH NEO
Market Name USDT NEO
Market Name BTC NMR
Market Name ETH NMR
Market Name BTC OMG
Market Name ETH OMG
Market Name USDT OMG
Market Name BTC PAY
Market Name ETH PAY
Market Name BTC PTOY
Market Name ETH PTOY
Market Name BTC QRL
Market Name ETH QRL
Market Name BTC QTUM
Market Name ETH QTUM
Market Name BTC REP
Market Name ETH REP
Market Name BTC RLC
Market Name ETH RLC
Market Name BTC SALT
Market Name ETH SALT
Market Name BTC SC
Market Name ETH SC
Market Name BTC SNGLS
Market Name ETH SNGLS
Market Name BTC SNT
Market Name ETH SNT
Market Name BTC STORJ
Market Name ETH STORJ
Market Name BTC STRAT
Market Name ETH STRAT
Market Name BTC TIME
Market Name ETH TIME
Market Name BTC TIX
Market Name ETH TIX
Market Name BTC TKN
Market Name ETH TKN
Market Name BTC TRST
Market Name ETH TRST
Market Name BTC WAVES
Market Name ETH WAVES
Market Name BTC WINGS
Market Name ETH WINGS
Market Name BTC XEM
Market Name ETH XEM
Market Name BTC XLM
Market Name ETH XLM
Market Name BTC XMR
Market Name ETH XMR
Market Name USDT XMR
Market Name BTC XRP
Market Name ETH XRP
Market Name USDT XRP
Market Name BTC ZEC
Market Name ETH ZEC
Market Name USDT ZEC
Market Name BTC 1ST
Market Name ETH 1ST
Market Name BTC ADT
Market Name ETH ADT
Market Name BTC ADX
Market Name ETH ADX
Market Name BTC ANT
Market Name ETH ANT
Market Name BTC BAT
Market Name ETH BAT
Market Name BTC BCC
Market Name ETH BCC
Market Name USDT BCC
Market Name BTC BNT
Market Name ETH BNT
Market Name BTC BTS
Market Name ETH BTS
Market Name BTC CFI
Market Name ETH CFI
Market Name BTC CRB
Market Name ETH CRB
Market Name BTC CVC
Market Name ETH CVC
Market Name BTC DASH
Market Name ETH DASH
Market Name USDT DASH
Market Name BTC DGB
Market Name ETH DGB
Market Name BTC DGD
Market Name ETH DGD
Market Name BTC DNT
Market Name ETH DNT
Market Name BTC ETC
Market Name ETH ETC
Market Name USDT ETC
Market Name BTC FCT
Market Name ETH FCT
Market Name BTC FUN
Market Name ETH FUN
Market Name BTC GNO
Market Name ETH GNO
Market Name BTC GNT
Market Name ETH GNT
Market Name BTC GUP
Market Name ETH GUP
Market Name BTC HMQ
Market Name ETH HMQ
Market Name BTC LGD
Market Name ETH LGD
Market Name BTC LTC
Market Name ETH LTC
Market Name USDT LTC
Market Name BTC LUN
Market Name ETH LUN
Market Name BTC MANA
Market Name ETH MANA
Market Name BTC MCO
Market Name ETH MCO
Market Name BTC MTL
Market Name ETH MTL
Market Name BTC MYST
Market Name ETH MYST
Market Name BTC NEO
Market Name ETH NEO
Market Name USDT NEO
Market Name BTC NMR
Market Name ETH NMR
Market Name BTC OMG
Market Name ETH OMG
Market Name USDT OMG
Market Name BTC PAY
Market Name ETH PAY
Market Name BTC PTOY
Market Name ETH PTOY
Market Name BTC QRL
Market Name ETH QRL
Market Name BTC QTUM
Market Name ETH QTUM
Market Name BTC REP
Market Name ETH REP
Market Name BTC RLC
Market Name ETH RLC
Market Name BTC SALT
Market Name ETH SALT
Market Name BTC SC
Market Name ETH SC
Market Name BTC SNGLS
Market Name ETH SNGLS
Market Name BTC SNT
Market Name ETH SNT
Market Name BTC STORJ
Market Name ETH STORJ
Market Name BTC STRAT
Market Name ETH STRAT
Market Name BTC TIME
Market Name ETH TIME
Market Name BTC TIX
Market Name ETH TIX
Market Name BTC TKN
Market Name ETH TKN
Market Name BTC TRST
Market Name ETH TRST
Market Name BTC WAVES
Market Name ETH WAVES
Market Name BTC WINGS
Market Name ETH WINGS
Market Name BTC XEM
Market Name ETH XEM
Market Name BTC XLM
Market Name ETH XLM
Market Name BTC XMR
Market Name ETH XMR
Market Name USDT XMR
Market Name BTC XRP
Market Name ETH XRP
Market Name USDT XRP
Market Name BTC ZEC
Market Name ETH ZEC
Market Name USDT ZEC
Market Name BTC BCC
Market Name ETH BCC
Market Name USDT BCC
Market Name BTC DASH
Market Name ETH DASH
Market Name USDT DASH
Market Name BTC ETC
Market Name ETH ETC
Market Name USDT ETC
Market Name BTC ETH
Market Name USDT ETH
Market Name BTC LTC
Market Name ETH LTC
Market Name USDT LTC
Market Name BTC NEO
Market Name ETH NEO
Market Name USDT NEO
Market Name BTC OMG
Market Name ETH OMG
Market Name USDT OMG
Market Name BTC XMR
Market Name ETH XMR
Market Name USDT XMR
Market Name BTC XRP
Market Name ETH XRP
Market Name USDT XRP
Market Name BTC ZEC
Market Name ETH ZEC
Market Name USDT ZEC
[/details]
With the disclaimer that you really should probably follow @Tom and @JMichaelTX's advice about using something other than KM for large JSON-based data sets like this, if you're set on using KM for this task, this new macro should get you much closer than my last one did:
