v1-2-9

What's Changed

• Backfills for OP Prices & DEX Trades by @MSilb7 in #1366
• Update OP2 static tables by @MSilb7 in #1369
• Update coinpaprika.yaml by @IoanDraghici in #1371
• Safe by @sche in #1352
• Update NFT Name in OP2 by @MSilb7 in #1374
• OP2 force newer dex runs & Activate Kwenta by @MSilb7 in #1373
• chore(dfi): added DeFiChain's DFI token info by @gjj in #1372
• polygon: dex.trades: add dodoex by @yongjun925 in #1367
• remove duplicates from ethereum erc20 view by @jeff-dude in #1377
• Add view for prices.tokens by @aalan3 in #1379
• Add DUST on solana by @aalan3 in #1381
• [Easy] Add 15 missing tokens by @gentrexha in #1378
• Prices for arbitrum, avalanche_c, gnosis and optimism by @aalan3 in #1385
• chore(prices): add SPS and DEC token by @yashtbc in #1384
• remove duplicates from ethereum erc20 tokens view by @jeff-dude in #1382
• Gnosis oneinch dex trades by @jacubcub in #1383
• Adds ClipperVerifiedCaravel to dex.trades by @aothman in #1387
• feat: improving yearn abstractions by @wei3erHase in #1388
• modified Seaport to add a zone address belonging to OpenSea by @sohwak in #1391
• Add Dex Finance tokens by @Sevik-The-Degen in #1392
• Add Dex Finance tokens by @Sevik-The-Degen in #1393
• introduce dex trades to spellbook using uniswap v1/v2 contract data by @jeff-dude in #1353
• Sudoswap AMM to nft trades by @andrewhong5297 in #1364
• (ignore), duplicate of sudoswap AMM by @andrewhong5297 in #1394
• Added Rubic Exchange token, RBC by @novuses in #1395
• sudoswap: price fix and fee move into new column, break out token_id values by @andrewhong5297 in #1397
• Update nft trades to match dex trades materialization design & ensure incremental / partition design in place by @jeff-dude in #1396

New Contributors

• @IoanDraghici made their first contribution in #1371
• @gjj made their first contribution in #1372
• @yongjun925 made their first contribution in #1367
• @gentrexha made their first contribution in #1378
• @Sevik-The-Degen made their first contribution in #1392
• @novuses made their first contribution in #1395

Full Changelog: v1-2-8...v1-2-9

v1-2-8: fix nft trades and events tx_hash

What's Changed

• added opensea-polygon trades by @sohwak in #1361
• OP2 update contract creator list by @MSilb7 in #1359
• Update tokens.sql by @0xroll in #1365
• nft trades seaport contract -- switch tx_hash and block_number to load columns correctly by @jeff-dude in #1363
• fix tx_hash / block_number column switch on nft events by @jeff-dude in #1370

Full Changelog: v1-2-7...v1-2-8

v1-2-7: update ethereum erc20 tokens on spellbook

What's Changed

• Added Pegaxy Stone (PGX) by @peterrliem in #1354
• Added vigorus token for Pegaxy by @peterrliem in #1355
• [Dex.Trades] Replace GPv2 with Cow Protocol V1 by @bh2smith in #1351
• add terablock token by @yashtbc in #1356
• Update OP Tables in V1 by @MSilb7 in #1357
• [Easy] add 12 missing tokens by @bh2smith in #1362

New Contributors

• @yashtbc made their first contribution in #1356

Full Changelog: v1-2-6...v1-2-7

v1-2-6: update erc20 tokens on spellbook

What's Changed

• Fix erc20 token spaces issue [v1] by @jeff-dude in #1347
• Update Static OP2 Tables by @MSilb7 in #1348
• OP2 - update insert lookbacks by @MSilb7 in #1349
• Add PoolTogether tickets to v2 engine by @dylandesrosier in #1344

Full Changelog: v1-2-5...v1-2-6

v1-2-5 (Erc20.tokens)

What's Changed

• Update coinpaprika.yaml - add SWISE token by @rzeydelis in #1338
• Update tokens.sql by @0xroll in #1339
• Update coinpaprika.yaml by @0xroll in #1341
• [Erc20.tokens] add 13 missing tokens by @bh2smith in #1342
• (Dune v1) modify seaport data in nft.trades to the newest source of seaport.transfers by @sohwak in #1340
• Update tokens.sql by @dylandesrosier in #1343

New Contributors

• @dylandesrosier made their first contribution in #1343

Full Changelog: v1-2-4...v1-2-5

v1-2-4

What's Changed

• Update alter_table_properties.sql for prices.usd_latest by @dot2dotseurat in #1332
• Add sETH2 coinpaprika.yaml by @rzeydelis in #1333
• Revert "Add sETH2 coinpaprika.yaml" by @masquot in #1336
• Opensea: patch error - to avoid division_by_zero by @sohwak in #1335

New Contributors

• @rzeydelis made their first contribution in #1333

Full Changelog: v1-2-3...v1-2-4

price latest and cex addresses

What's Changed

• Update tokens.sql by @0xroll in #1316
• Add hex2numeric function to Postgres by @antonio-mendes in #1315
• [Aztec Connect] ETH price feed and balance bug fixes by @jackiep00 in #1319
• Update ERC20 Tokens by @bh2smith in #1320
• Add cex addresses by @hildobby in #1318
• Add prices.usd_latest by @hildobby in #1321
• Update coingecko.yaml by @0xroll in #1326
• [CoW Protocol] Update Gnosis solvers names by @harisang in #1328
• Nomad bridge transactions view by @springzh in #1327
• add new sqls about nxm.quotation by @sharkxff in #1330
• Add ClipperV2 to Optimism dex.trades by @aothman in #1325

New Contributors

• @harisang made their first contribution in #1328
• @springzh made their first contribution in #1327
• @sharkxff made their first contribution in #1330

Full Changelog: v1-2-2...v1-2-3

Tokens v1-2-2

What's Changed

• Update tokens.sql by @MarcoVugts in #1311
• Update tokens.sql by @0xroll in #1314
• update Dune V2 ethereum nft tokens to 2022-07-23 by @0xbitfly in #1312

New Contributors

• @MarcoVugts made their first contribution in #1311

Full Changelog: v1-2-1...v1-2-2

v1-2-1 Improvements for MagicEden Spells

What's Changed

• Major improvements of MagicEden Spells by @soispoke in #1310

Full Changelog: v1-2-0...v1-2-1

v1-2-0 Add X2Y2 Spells

What's Changed

• Tokemak by @mfuribondo in #1303
• Msilb7 2022 07 20 by @dot2dotseurat in #1306
• Add X2Y2 events to Dune v2 by @hildobby in #1298

Full Changelog: v1-1-9...v1-2-0