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:
{ | |
"version": 1, | |
"data": [ | |
{ | |
"interestCoin": "CEL", | |
"originalInterestCoin": "BTC", | |
"totalInterestInCoin": "21.426041357529846155", | |
"totalInterestInUsd": "64.278124072589538465", | |
"distributionRuleUsed": "InterestWithThreshold_FirstNCoins", | |
"interest_on_first_n_coins": "0.00165605513661538461545085759008", |
Address Name | |
r4hYwnBsNH764iTfhRSopu4M3Ct5gMkCGD BW | |
rJJpadphZDS2zKeheW4NiGE2UmdRjaTJLd BW | |
rpeLWnD5gCvxQp3V537drERQE24rg5yDyd BW | |
rKm6XqTFgJUpwwHhuXoPdGPtcbEhtj3Sza BW | |
rBV8rBpa56jqzuDpnsJKyoCfQ2KtWDAx2V BW | |
rpxyLEdkPiDVuG75ouVD2ApoKtvXf5zgwj DMM | |
rKP8QPCMPsxSBR7MW3SjuwADdV3ELHmDeC DMM | |
rHnd99GBCXDNiNkSme6wq5V3EDdpfHrSyp DMM | |
rQHoYXU12UhnsYDW7dQdVPKTbDLENJnVQr DMM |
I hereby claim:
To claim this, I am signing this object:
Bitstamp: rrpNnNLKrartuEqfJGpqyDwPj1AFPg9vn1, rGFuMiw48HdbnrUbkRYuitXTmfrDBNTCnX, rDsbeomae4FXwgQTJp9Rs64Qg9vDiTCdBv, rvYAfWj5gh67oV6fW32ZzP3Aw4Eubs59B, rUobSiUpYH2S97Mgb4E7b7HuzQj2uzZ3aD | |
Bittrex: rPVMhWBsfF9iMXYj3aAzJVkPDTFNSyWdKy, rE3sV9KSWeSiaAapsZGcSDfiFRSshK8Bqj | |
Bitso: rG6FZ31hDHN1K5Dkbma3PSB5uVCuVVRzfn, rHZaDC6tsGN2JWGeXhjKL6664RNCq5hu4B, raXLsnnJVaLMDixEoXHXe56WQXKczbD8ub, rGfGdVYLDSbji5mqfMvdpx4c8JyyfqVFgf, rfEu1Wnr7LxStoFx8DBdzgr8M16FBUbH3K, rLSn6Z3T8uCxbcd1oxwfGQN1Fdn5CyGujK | |
Coins.ph: rU2mEJSLqBRkYLVTv55rFTgQajkLTnT6mA |
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, |
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" |