Skip to content

Instantly share code, notes, and snippets.

BINANCE_QUERY_TEMPLATE = """
SELECT
coalesce(a.pair, b.pair) as pair,
coalesce(a.trade_timestamp, b.trade_timestamp) as trade_timestamp,
coalesce(a.event_timestamp, b.event_timestamp) as event_timestamp,
coalesce(a.trade_id, b.trade_id) as trade_id,
coalesce(a.price, b.price) as price,
coalesce(a.quantity, b.quantity) as quantity,
coalesce(a.buyer_order_id, b.buyer_order_id) as buyer_order_id,
coalesce(a.seller_order_id, b.seller_order_id) as seller_order_id,
from time import sleep
import logging
import json
import boto3
from config import (
DATA_EXCHANGE_REGION,
MARKETPLACE_CATALOG_REGION,
LambdaS3TriggerMappings
@jaredtkatz
jaredtkatz / bs.txt
Created November 15, 2017 01:30
blockstack
Verifying my Blockstack ID is secured with the address 1JPxzVkr5ywyi6v2aWrtWBx8QntHaV5R3D https://explorer.blockstack.org/address/1JPxzVkr5ywyi6v2aWrtWBx8QntHaV5R3D
with open('/usr/share/dict/words','r') as f:
all_words=[]
for word in f:
if word.replace('\n','')[-2:]==('er' or 'or'):
all_words.append(word.replace('\n',''))
from numpy import random as rn
index=rn.randint(0,len(all_words))
print "%s? I hardly know her!" % all_words[index]