SocioCryptoCopy of Edge data 30 D - ver 2
Updated 2022-11-17
999
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 source_opt as (
SELECT *
FROM optimism.core.fact_token_transfers a
LEFT JOIN optimism.core.dim_labels b
ON a.from_address = b.address
WHERE date_trunc('day',block_timestamp) BETWEEN CURRENT_DATE-30 AND CURRENT_DATE -1
AND contract_address = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1'
AND label_type is not null),
target_opt as (
SELECT *
FROM optimism.core.fact_token_transfers a
LEFT JOIN optimism.core.dim_labels b
ON a.to_address = b.address
WHERE date_trunc('day',block_timestamp) BETWEEN CURRENT_DATE-30 AND CURRENT_DATE -1
AND contract_address = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1'
AND label_type is not null),
source_arb as (
SELECT *
FROM arbitrum.core.fact_token_transfers a
LEFT JOIN arbitrum.core.dim_labels b
ON a.from_address = b.address
WHERE date_trunc('day',block_timestamp) BETWEEN CURRENT_DATE-30 AND CURRENT_DATE -1
AND contract_address = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1'
AND label_type is not null),
target_arb as (
SELECT *
FROM arbitrum.core.fact_token_transfers a
LEFT JOIN arbitrum.core.dim_labels b
ON a.to_address = b.address
WHERE date_trunc('day',block_timestamp) BETWEEN CURRENT_DATE-30 AND CURRENT_DATE -1
AND contract_address = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1'
AND label_type is not null),
source_ava as (
SELECT *
FROM avalanche.core.fact_token_transfers a
LEFT JOIN avalanche.core.dim_labels b
Run a query to Download Data