I hereby claim:
- I am hmatejx on github.
- I am hmatejx (https://keybase.io/hmatejx) on keybase.
- I have a public key ASDB6OK7bnkPenG7Zq30JV4aJFOIDDQPkYZriMacP7KNIwo
To claim this, I am signing this object:
hmatejx hmatejx
hmatejx
/ get_inter_exchange_payments.sql
Created
February 17, 2019 08:07
xRapid - get inter-exchange payments
This file contains 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
| WITH | |
| Ledgers AS ( | |
| SELECT LedgerIndex, CloseTime, CloseTimeTimestamp | |
| FROM xrpledgerdata.fullhistory.ledgers | |
| ), | |
| Transactions AS ( | |
| SELECT Account, Destination, SourceTag, DestinationTag, Fee, TransactionType, AmountXRP / 1000000 as Amount, LedgerIndex, TransactionResult, | |
| CASE | |
| WHEN Account IN ("rrpNnNLKrartuEqfJGpqyDwPj1AFPg9vn1", "rGFuMiw48HdbnrUbkRYuitXTmfrDBNTCnX", "rDsbeomae4FXwgQTJp9Rs64Qg9vDiTCdBv", "rvYAfWj5gh67oV6fW32ZzP3Aw4Eubs59B", " rUobSiUpYH2S97Mgb4E7b7HuzQj2uzZ3aD") THEN "Bitstamp" | |
| WHEN Account IN ("rPVMhWBsfF9iMXYj3aAzJVkPDTFNSyWdKy", "rE3sV9KSWeSiaAapsZGcSDfiFRSshK8Bqj") THEN "Bittrex" |
hmatejx
/ process_inter_exchange_payments.sql
Last active
February 17, 2019 13:30
xRapid - process inter-exchange payments
This file contains 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
| WITH step1 AS ( | |
| SELECT | |
| CloseTime AS Time, CloseTimeTimestamp AS Timestamp, LedgerIndex, Account, Destination, SourceTag, DestinationTag, Fee, Amount, | |
| CONCAT(xSource, "->", xDestination) AS xLeg, xSource, xDestination | |
| FROM xRapid.InterExchange), | |
| step2 AS ( | |
| SELECT | |
| Time, Timestamp, LedgerIndex, Account, Destination, SourceTag, DestinationTag, Fee, Amount, xLeg, xSource, xDestination, | |
| LEAD(Amount, 1, 0) OVER (PARTITION BY xLeg, DestinationTag ORDER BY LedgerIndex DESC) AS leadAmount, | |
| LEAD(Timestamp, 1, 0) OVER (PARTITION BY xLeg, DestinationTag ORDER BY LedgerIndex DESC) AS leadTimestamp, |
hmatejx
/ keybase.md
Created
February 26, 2019 15:53
hmatejx
/ gist:e04768bb609b590b1ac152e3d6b69fdb
Created
March 7, 2022 21:02
This file contains 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
| { | |
| "version": 1, | |
| "data": [ | |
| { | |
| "interestCoin": "CEL", | |
| "originalInterestCoin": "BTC", | |
| "totalInterestInCoin": "21.426041357529846155", | |
| "totalInterestInUsd": "64.278124072589538465", | |
| "distributionRuleUsed": "InterestWithThreshold_FirstNCoins", | |
| "interest_on_first_n_coins": "0.00165605513661538461545085759008", |
This file contains 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
| Address Name | |
| r4hYwnBsNH764iTfhRSopu4M3Ct5gMkCGD BW | |
| rJJpadphZDS2zKeheW4NiGE2UmdRjaTJLd BW | |
| rpeLWnD5gCvxQp3V537drERQE24rg5yDyd BW | |
| rKm6XqTFgJUpwwHhuXoPdGPtcbEhtj3Sza BW | |
| rBV8rBpa56jqzuDpnsJKyoCfQ2KtWDAx2V BW | |
| rpxyLEdkPiDVuG75ouVD2ApoKtvXf5zgwj DMM | |
| rKP8QPCMPsxSBR7MW3SjuwADdV3ELHmDeC DMM | |
| rHnd99GBCXDNiNkSme6wq5V3EDdpfHrSyp DMM | |
| rQHoYXU12UhnsYDW7dQdVPKTbDLENJnVQr DMM |
hmatejx
/ xRapid_exchange_addresses.txt
Last active
May 14, 2022 14:55
xRapid partner exchange addresses
This file contains 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
| Bitstamp: rrpNnNLKrartuEqfJGpqyDwPj1AFPg9vn1, rGFuMiw48HdbnrUbkRYuitXTmfrDBNTCnX, rDsbeomae4FXwgQTJp9Rs64Qg9vDiTCdBv, rvYAfWj5gh67oV6fW32ZzP3Aw4Eubs59B, rUobSiUpYH2S97Mgb4E7b7HuzQj2uzZ3aD | |
| Bittrex: rPVMhWBsfF9iMXYj3aAzJVkPDTFNSyWdKy, rE3sV9KSWeSiaAapsZGcSDfiFRSshK8Bqj | |
| Bitso: rG6FZ31hDHN1K5Dkbma3PSB5uVCuVVRzfn, rHZaDC6tsGN2JWGeXhjKL6664RNCq5hu4B, raXLsnnJVaLMDixEoXHXe56WQXKczbD8ub, rGfGdVYLDSbji5mqfMvdpx4c8JyyfqVFgf, rfEu1Wnr7LxStoFx8DBdzgr8M16FBUbH3K, rLSn6Z3T8uCxbcd1oxwfGQN1Fdn5CyGujK | |
| Coins.ph: rU2mEJSLqBRkYLVTv55rFTgQajkLTnT6mA |