Skip to content

Instantly share code, notes, and snippets.

@mr-easy

mr-easy/binance_start_dates.txt

Last active May 9, 2025 04:32
Show Gist options
  • Save mr-easy/5185b1dcdd5f9f908ff196446f092e9b to your computer and use it in GitHub Desktop.
Save mr-easy/5185b1dcdd5f9f908ff196446f092e9b to your computer and use it in GitHub Desktop.
Download ZIP
Find listing date of any cryptocurrency pair on any exchange using ccxt
Raw
binance_start_dates.txt
## Here is a sample output for binance exchange. These are the start time stamp on which the currency pair got listed om binance exchange.
1INCH/BTC 1608872340001 2020-12-25T04:59:00.001Z
1INCH/BUSD 1614081540001 2021-02-23T11:59:00.001Z
1INCH/USDT 1608872340001 2020-12-25T04:59:00.001Z
1INCHDOWN/USDT 1618471140001 2021-04-15T07:19:00.001Z
1INCHUP/USDT 1618471140001 2021-04-15T07:19:00.001Z
AAVE/BKRW 1602730740001 2020-10-15T02:59:00.001Z
AAVE/BNB 1602730740001 2020-10-15T02:59:00.001Z
AAVE/BRL 1627034340001 2021-07-23T09:59:00.001Z
AAVE/BTC 1602730740001 2020-10-15T02:59:00.001Z
AAVE/BUSD 1602730740001 2020-10-15T02:59:00.001Z
AAVE/ETH 1602730740001 2020-10-15T02:59:00.001Z
AAVE/USDT 1602730740001 2020-10-15T02:59:00.001Z
AAVEDOWN/USDT 1606373940001 2020-11-26T06:59:00.001Z
AAVEUP/USDT 1606373940001 2020-11-26T06:59:00.001Z
ACM/BTC 1614164340001 2021-02-24T10:59:00.001Z
ACM/BUSD 1614164340001 2021-02-24T10:59:00.001Z
ACM/USDT 1614164340001 2021-02-24T10:59:00.001Z
ADA/AUD 1614938340001 2021-03-05T09:59:00.001Z
ADA/BIDR 1624010340001 2021-06-18T09:59:00.001Z
ADA/BKRW 1596085140001 2020-07-30T04:59:00.001Z
ADA/BNB 1523937660001 2018-04-17T04:01:00.001Z
ADA/BRL 1614333540001 2021-02-26T09:59:00.001Z
ADA/BTC 1512044880001 2017-11-30T12:28:00.001Z
ADA/BUSD 1574308740001 2019-11-21T03:59:00.001Z
ADA/ETH 1512044940001 2017-11-30T12:29:00.001Z
ADA/EUR 1605261540001 2020-11-13T09:59:00.001Z
ADA/GBP 1614333540001 2021-02-26T09:59:00.001Z
ADA/PAX 1553659140001 2019-03-27T03:59:00.001Z
ADA/RUB 1616140740001 2021-03-19T07:59:00.001Z
ADA/TRY 1614333540001 2021-02-26T09:59:00.001Z
ADA/TUSD 1545192060001 2018-12-19T04:01:00.001Z
ADA/USDC 1553659140001 2019-03-27T03:59:00.001Z
ADA/USDT 1523937660001 2018-04-17T04:01:00.001Z
ADADOWN/USDT 1594887420001 2020-07-16T08:17:00.001Z
ADAUP/USDT 1594887420001 2020-07-16T08:17:00.001Z
ADX/BNB 1511925120001 2017-11-29T03:12:00.001Z
ADX/BTC 1511924940001 2017-11-29T03:09:00.001Z
ADX/BUSD 1627034340001 2021-07-23T09:59:00.001Z
ADX/ETH 1511925000001 2017-11-29T03:10:00.001Z
ADX/USDT 1635501540001 2021-10-29T09:59:00.001Z
AE/BNB 1518170357616 2018-02-09T09:59:17.616Z
AE/BTC 1518170297593 2018-02-09T09:58:17.593Z
AE/ETH 1518170297604 2018-02-09T09:58:17.604Z
AERGO/BTC 1603274340001 2020-10-21T09:59:00.001Z
AERGO/BUSD 1603274340001 2020-10-21T09:59:00.001Z
AGI/BNB 1528192740001 2018-06-05T09:59:00.001Z
AGI/BTC 1528192740001 2018-06-05T09:59:00.001Z
AGI/ETH 1528192740001 2018-06-05T09:59:00.001Z
AGIX/BTC 1622620740001 2021-06-02T07:59:00.001Z
AGLD/BNB 1633417140001 2021-10-05T06:59:00.001Z
AGLD/BTC 1633417140001 2021-10-05T06:59:00.001Z
...
Raw
find_symbol_start_time.py
#################################################################################################################
## Author: mr-easy ##
## Webpage: mr-easy.github.io ##
#################################################################################################################
## While collecting cryptocurrency data using ccxt library, I found that it's difficult to know the start date ##
## of a currency pair, i.e. the timestamp at which that symbol(currency pair) was listed on that exchange. ##
## This code snippet will help in finding that for any speicific exchange. ##
## It uses binary search and returns the timestamp at which ccxt's fetch_ohlcv return non-empty result. ##
#################################################################################################################
import ccxt
import datetime as dt
def find_start_time(exchange, symbol, start_time, end_time, timeframe):
mid_time = (start_time + end_time)//2
#print(start_time, mid_time, end_time, end_time-start_time)
if(mid_time == start_time): return mid_time+1
ohlcv = exchange.fetch_ohlcv(symbol, timeframe, mid_time, limit=1)
if(len(ohlcv) == 0):
return find_start_time(exchange, symbol, mid_time, end_time, timeframe)
else:
return find_start_time(exchange, symbol, start_time, mid_time, timeframe)
if __name__ == '__main__':
exchange = ccxt.binance({ 'enableRateLimit': True })
exchange.load_markets()
for symbol in exchange.symbols:
start_time = int(dt.datetime(2015,1,1).timestamp() * 1000)
end_time = int(dt.datetime(2021,11,1).timestamp() * 1000)
timeframe = '1m'
symbol_start_time = find_start_time(exchange, symbol, start_time, end_time, timeframe)
print(symbol, "\t", symbol_start_time, "\t", exchange.iso8601 (symbol_start_time))
@normanlmfung
Copy link

Caveats: 1) If listing date lies outside [start_time, end_time], this function will stackoverflow, 2) Even if not, it's still very time consuming.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment