Evgeny Medvedev medvedev1088
medvedev1088
/ stacktrace1.txt
Created
May 8, 2019 10:42
This file contains hidden or 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
| requests.exceptions.ConnectionError: ('Connection aborted.', ConnectionResetError(104, 'Connection reset by peer') | |
| [2019-05-08 01:57:12,394] {base_task_runner.py:101} INFO - Job 35305: Subtask export_receipts_and_logs [2019-05-08 01:57:12,389] {models.py:1760} ERROR - ('Connection aborted.', ConnectionResetError(104, 'Connection reset by peer')) | |
| [2019-05-08 01:57:12,395] {base_task_runner.py:101} INFO - Job 35305: Subtask export_receipts_and_logs Traceback (most recent call last): | |
| [2019-05-08 01:57:12,395] {base_task_runner.py:101} INFO - Job 35305: Subtask export_receipts_and_logs File "/opt/python3.6/lib/python3.6/site-packages/urllib3/connectionpool.py", line 600, in urlopen | |
| [2019-05-08 01:57:12,396] {base_task_runner.py:101} INFO - Job 35305: Subtask export_receipts_and_logs chunked=chunked) | |
| [2019-05-08 01:57:12,396] {base_task_runner.py:101} INFO - Job 35305: Subtask export_receipts_and_logs File "/opt/python3.6/lib/python3.6/site-packages/urllib3/connectionpool.py", line 384, in _make_request | |
| [2 |
medvedev1088
/ parity_traceBlock_7551347.json
Created
April 13, 2019 14:41
This file contains hidden or 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
| { | |
| "jsonrpc": "2.0", | |
| "result": [ | |
| { | |
| "action": { | |
| "callType": "call", | |
| "from": "0xd6e2940d8f314a865596fd5898de399cc55d8031", | |
| "gas": "0x1068", | |
| "input": "0x", | |
| "to": "0x5ce65bcd84ca828497a8f60fd4043263b26b5026", |
medvedev1088
/ parity_traceFilter_7551347_7551347.json
Created
April 13, 2019 14:39
This file contains hidden or 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
| { | |
| "jsonrpc": "2.0", | |
| "result": [ | |
| { | |
| "action": { | |
| "callType": "call", | |
| "from": "0xd6e2940d8f314a865596fd5898de399cc55d8031", | |
| "gas": "0x1068", | |
| "input": "0x", | |
| "to": "0x5ce65bcd84ca828497a8f60fd4043263b26b5026", |
medvedev1088
/ blockchain_throughput_comparison.csv
Last active
May 18, 2021 16:34
This file contains hidden or 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
| chain | throughput | time | |
|---|---|---|---|
| bitcoin_cash | 281 tx/sec | 2018-11-10 14:34:35 UTC | |
| dash | 67 tx/sec | 2018-11-11 10:21:44 UTC | |
| dogecoin | 55 tx/sec | 2014-08-05 02:53:06 UTC | |
| litecoin | 27 tx/sec | 2018-09-03 22:38:57 UTC | |
| ethereum | 27 tx/sec | 2018-10-06 07:49:21 UTC | |
| ethereum_classic | 24 tx/sec | 2019-01-13 08:09:56 UTC | |
| bitcoin | 22 tx/sec | 2015-08-01 01:06:41 UTC | |
| zcash | 8 tx/sec | 2018-08-03 02:08:54 UTC |
medvedev1088
/ bigquery-dogecoin-gini-incomes-limited.sql
Created
January 16, 2019 12:52
This file contains hidden or 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 | |
| d0 as ( | |
| select | |
| array_to_string(x.addresses,',') as address, | |
| date(block_timestamp) as date, | |
| value | |
| from `bigquery-public-data.crypto_dogecoin.transactions` join unnest(outputs) as x | |
| ) | |
| ,daily_incomes as ( | |
| select |
medvedev1088
/ bigquery-godecoin-gini-incomes.sql
Created
January 16, 2019 10:51
This file contains hidden or 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 | |
| d0 as ( | |
| select | |
| array_to_string(x.addresses,',') as address, | |
| date(block_timestamp) as date, | |
| value | |
| from `bigquery-public-data.crypto_dogecoin.transactions` join unnest(outputs) as x | |
| ) | |
| ,daily_incomes as ( | |
| select |
medvedev1088
/ bigquery-bitcoin-gini-sampled.sql
Last active
June 18, 2020 10:34
This file contains hidden or 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 | |
| double_entry_book as ( | |
| select | |
| array_to_string(outputs.addresses,',') as address, | |
| value, block_timestamp | |
| from `crypto-etl-bitcoin-prod.bitcoin_blockchain.transactions` join unnest(outputs) as outputs | |
| union all | |
| select | |
| array_to_string(inputs.addresses,',') as address, | |
| -value as value, block_timestamp |
medvedev1088
/ bigquery-bitcoin-gini.sql
Last active
January 9, 2019 16:17
This file contains hidden or 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 | |
| double_entry_book as ( | |
| select | |
| array_to_string(outputs.addresses,',') as address, | |
| value, block_timestamp | |
| from `crypto-etl-bitcoin-prod.bitcoin_blockchain.transactions` join unnest(outputs) as outputs | |
| union all | |
| select | |
| array_to_string(inputs.addresses,',') as address, | |
| -value as value, block_timestamp |
medvedev1088
/ bigquery-gini.sql
Last active
July 11, 2020 03:50
This file contains hidden or 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 balances as ( | |
| select '2018-01-01' as date, balance | |
| from unnest([1,2,3,4,5]) as balance -- Gini coef: 0.2666666666666667 | |
| union all | |
| select '2018-01-02' as date, balance | |
| from unnest([3,3,3,3]) as balance -- Gini coef: 0.0 | |
| union all | |
| select '2018-01-03' as date, balance | |
| from unnest([4,5,1,8,6,45,67,1,4,11]) as balance -- Gini coef: 0.625 | |
| ), |
medvedev1088
/ bitcoin-balances.sql
Last active
June 10, 2019 08:18
This file contains hidden or 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
| #standardSQL | |
| -- MIT License | |
| -- Copyright (c) 2018 Evgeny Medvedev, [email protected] | |
| with double_entry_book as ( | |
| -- debits | |
| select array_to_string(array(select * from unnest(outputs.addresses) order by 1), ',') as address, | |
| outputs.value as value | |
| from bitcoin_blockchain.transactions as transactions, | |
| unnest(transactions.outputs) as outputs | |
| union all |