Ahmed Muzammil mze3e
mze3e
/ google-bigquery-de-duplication.sql
Created
August 7, 2021 17:42
Google BigQuery De Duplication
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE OR REPLACE TABLE `amazon_products.amazon_products` | |
| AS | |
| Select asin, brand, title, feature, description, price, image, also_buy, also_view, rank, category, similar_item, tech1, tech2, fit, main_cat, details from ( | |
| SELECT asin, brand, title, feature, description, price, image, also_buy, also_view, rank, category, similar_item, tech1, tech2, fit, main_cat, details, | |
| ROW_NUMBER() OVER ( PARTITION BY asin ORDER BY asin ) AS rownum | |
| FROM `amazon_products.amazon_products_latest`) A | |
| where A.rownum=1 | |
| order by asin |
mze3e
/ crypto_exchanges.yaml
Created
August 5, 2024 06:32
Top Cryptocurrency Spot Exchanges extracted from CoinMarketCap. CoinMarketCap ranks and scores exchanges based on traffic, liquidity, trading volumes, and confidence in the legitimacy of trading volumes reported.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| exchanges: | |
| - Binance | |
| - Coinbase Exchange | |
| - OKX | |
| - Bybit | |
| - Upbit | |
| - Kraken | |
| - Gate.io | |
| - HTX | |
| - Bitfinex |
OlderNewer