alitaslimiDaily Awarded Prizes
Updated 2022-06-22Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH
ethereum AS (
SELECT
block_timestamp::date AS date,
COUNT(DISTINCT to_address) AS winners,
SUM(amount) AS volume,
AVG(amount) AS average_prize
FROM
ethereum.core.ez_token_transfers
WHERE
date > (CURRENT_DATE - 60)
AND contract_address = '0xdd4d117723c257cee402285d3acf218e9a8236e1' AND from_address = '0xb9a179dca5a7bf5f8b9e088437b3a85ebb495efe'
GROUP BY
date
),
polygon AS (
SELECT
block_timestamp::date AS date,
COUNT(DISTINCT event_inputs:to) AS winners,
SUM(TO_NUMBER(event_inputs:value) / POW(10, 6)) AS volume,
AVG(TO_NUMBER(event_inputs:value) / POW(10, 6)) AS average_prize
FROM
flipside_prod_db.polygon.events_emitted
WHERE
date > (CURRENT_DATE - 60)
AND contract_address = '0x6a304dfdb9f808741244b6bfee65ca7b3b3a6076' AND event_inputs:from = '0x8141bcfbcee654c5de17c4e2b2af26b67f9b9056'
GROUP BY
date
),
prices AS (
SELECT
hour::date AS date,
AVG(price) AS price
FROM
ethereum.core.fact_hourly_token_prices
WHERE
Run a query to Download Data