raw transactions per wallet

Total # of Transactions

1
with alltransactions
2
AS (
3
4
SELECT
5
block_time,
6
success,
7
gas_price/10^9 AS gas_prices,
8
gas_used,
9
(gas_price*gas_used)/10^18 AS eth_paid_for_tx,
10
hash
11
FROM ethereum.transactions
12
WHERE "from" = CONCAT('\x', substring('{{1. Eth Address}}' from 3))::bytea
13
AND block_time >= '{{2. Start Date}}'
14
AND block_time < '{{3. End Date}}')
15
16
SELECT
17
count(*)
18
FROM alltransactions
19
Copied!

Transaction Success Rate

1
with alltransactions
2
AS (
3
4
SELECT
5
block_time,
6
success,
7
gas_price/10^9 AS gas_prices,
8
gas_used,
9
(gas_price*gas_used)/10^18 AS eth_paid_for_tx,
10
hash
11
FROM ethereum.transactions
12
WHERE "from" = CONCAT('\x', substring('{{1. Eth Address}}' from 3))::bytea
13
AND block_time >= '{{2. Start Date}}'
14
AND block_time < '{{3. End Date}}')
15
16
SELECT
17
success,
18
count(success)*100/sum(count(*)) over ()
19
FROM alltransactions
20
GROUP by success
21
ORDER BY success DESC
Copied!

Running Total of # of Transactions

1
with alltransactions
2
AS (
3
4
SELECT
5
block_time,
6
success,
7
gas_price/10^9 AS gas_prices,
8
gas_used,
9
(gas_price*gas_used)/10^18 AS eth_paid_for_tx,
10
hash
11
FROM ethereum.transactions
12
WHERE "from" = CONCAT('\x', substring('{{1. Eth Address}}' from 3))::bytea
13
AND block_time >= '{{2. Start Date}}'
14
AND block_time < '{{3. End Date}}')
15
16
SELECT
17
block_time,
18
COUNT(block_time) over (ORDER BY block_time ASC) AS "Total # of Transactions"
19
FROM alltransactions
Copied!
Last modified 3mo ago