1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
import { fetchAsync } from '@0x/utils';
import * as R from 'ramda';
import { Connection } from 'typeorm';
export interface TradingPair {
fromSymbol: string;
toSymbol: string;
latestSavedTime: number;
}
const COINLIST_API = 'https://min-api.cryptocompare.com/data/all/coinlist?BuiltOn=7605';
interface CryptoCompareCoinListResp {
Data: Map<string, CryptoCompareCoin>;
}
interface CryptoCompareCoin {
Symbol: string;
BuiltOn: string;
SmartContractAddress: string;
}
const TO_CURRENCIES = ['USD', 'EUR', 'ETH', 'USDT'];
const ETHEREUM_IDENTIFIER = '7605';
const HTTP_OK_STATUS = 200;
interface StaticPair {
fromSymbol: string;
toSymbol: string;
}
const SPECIAL_CASES: StaticPair[] = [
{
fromSymbol: 'ETH',
toSymbol: 'USD',
},
];
/**
* Get trading pairs with latest scraped time for OHLCV records
* @param conn a typeorm Connection to postgres
*/
export async function fetchOHLCVTradingPairsAsync(
conn: Connection,
source: string,
earliestBackfillTime: number,
): Promise<TradingPair[]> {
// fetch existing ohlcv records
const latestTradingPairs: Array<{
from_symbol: string;
to_symbol: string;
latest: string;
}> = await conn.query(`SELECT
MAX(end_time) as latest,
from_symbol,
to_symbol
FROM raw.ohlcv_external
GROUP BY from_symbol, to_symbol;`);
// build addressable index: { fromsym: { tosym: time }}
const latestTradingPairsIndex: { [fromSym: string]: { [toSym: string]: number } } = {};
latestTradingPairs.forEach(pair => {
const latestIndex: { [toSym: string]: number } = latestTradingPairsIndex[pair.from_symbol] || {};
latestIndex[pair.to_symbol] = parseInt(pair.latest, 10); // tslint:disable-line:custom-no-magic-numbers
latestTradingPairsIndex[pair.from_symbol] = latestIndex;
});
// match time to special cases
const specialCases: TradingPair[] = SPECIAL_CASES.map(pair => {
const latestSavedTime =
R.path<number>([pair.fromSymbol, pair.toSymbol], latestTradingPairsIndex) || earliestBackfillTime;
return R.assoc('latestSavedTime', latestSavedTime, pair);
});
// get token symbols used by Crypto Compare
const allCoinsResp = await fetchAsync(COINLIST_API);
if (allCoinsResp.status !== HTTP_OK_STATUS) {
return [];
}
const allCoins: CryptoCompareCoinListResp = await allCoinsResp.json();
const erc20CoinsIndex: Map<string, string> = new Map();
Object.entries(allCoins.Data).forEach(pair => {
const [symbol, coinData] = pair;
if (coinData.BuiltOn === ETHEREUM_IDENTIFIER && coinData.SmartContractAddress !== 'N/A') {
erc20CoinsIndex.set(coinData.SmartContractAddress.toLowerCase(), symbol);
}
});
// fetch all tokens that are traded on 0x
const rawEventTokenAddresses: Array<{ tokenaddress: string }> = await conn.query(
`SELECT DISTINCT(maker_token_address) as tokenaddress FROM raw.exchange_fill_events UNION
SELECT DISTINCT(taker_token_address) as tokenaddress FROM raw.exchange_fill_events`,
);
// tslint:disable-next-line:no-unbound-method
const eventTokenAddresses = R.pluck('tokenaddress', rawEventTokenAddresses).map(R.toLower);
// join token addresses with CC symbols
const eventTokenSymbols: string[] = eventTokenAddresses
.filter(tokenAddress => erc20CoinsIndex.has(tokenAddress))
.map(tokenAddress => erc20CoinsIndex.get(tokenAddress) as string);
// join traded tokens with fiat and latest backfill time
const eventTradingPairs: TradingPair[] = R.chain(sym => {
return TO_CURRENCIES.map(fiat => {
const pair = {
fromSymbol: sym,
toSymbol: fiat,
latestSavedTime: R.path<number>([sym, fiat], latestTradingPairsIndex) || earliestBackfillTime,
};
return pair;
});
}, eventTokenSymbols);
// join with special cases
return R.concat(eventTradingPairs, specialCases);
}
|