I hereby claim:
- I am halink0803 on github.
- I am halink0803 (https://keybase.io/halink0803) on keybase.
- I have a public key ASBTazKyMNN63yFfMiT_XxOoOun5928DR0T_idxKWHG9YAo
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
| import { ethereum } from '@graphprotocol/graph-ts'; | |
| import { PubSub } from '@google-cloud/pubsub'; | |
| import { Block } from '../../generated/schema'; | |
| export function handleBlock(block: ethereum.Block): void { | |
| let id = block.hash.toHex() | |
| let blockEntity = new Block(id) | |
| blockEntity.number = block.number | |
| blockEntity.timestamp = block.timestamp |
| package main | |
| import ( | |
| "context" | |
| "encoding/json" | |
| "log" | |
| "os" | |
| "sort" | |
| "time" |
brew install rename (osx)
sudo pacman -S perl-rename (arch linux)// Find all \n without precede by \n and followed by \n
(?<!\n)\n(?!\n)| [ | |
| { | |
| "timestamp": 1618410797000, | |
| "block_number": 6560905, | |
| "tx_hash": "0x74d75409850edbcde10de7a36ba4fa71e5b796065cf670d0302883b8005f3433", | |
| "token_info": { | |
| "src_addr": "0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee", | |
| "src_symbol": "BNB", | |
| "dst_addr": "0x55d398326f99059ff775485246999027b3197955", | |
| "dst_symbol": "USDT" |
CREATE OR REPLACE FUNCTION get_erc20_transfer(text, text, integer, integer) RETURNS text AS
$$
DECLARE
query_final text;
wallet ALIAS FOR $1;
token ALIAS FOR $2;
from_time ALIAS FOR $3;
to_time ALIAS FOR $4;
BEGIN| #!/bin/bash | |
| find ~/Library/Group\ Containers/ -type d -name OfficeFileCache -exec rm -r {} + |
| CREATE CONTINUOUS QUERY "wallet_fee" ON "trade_logs" | |
| RESAMPLE EVERY 1h FOR 1d | |
| BEGIN | |
| SELECT SUM("amount") as "sum_amount" | |
| INTO "hourly_wallet_fees" | |
| FROM "wallet_fees" | |
| GROUP BY "reserve_addr", "wallet_addr", time(1h) | |
| END | |
| CREATE CONTINUOUS QUERY "wallet_fee_1d" ON "trade_logs" |
From device
turn off sync data.Clear bookmark, history, password and more from this device.=> all your synced data will be cleared from the device.
From cloud