alfredowhite993Untitled Query
Updated 2022-08-08
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
Deposit AS (SELECT sum(AMOUNT) To_AMOUNT FROM ethereum.core.ez_eth_transfers WHERE ETH_TO_ADDRESS = '0x303467f7f37077B3E18Fd8caF6F8AF95316651ce'),
withdraw AS (SELECT sum(AMOUNT) From_AMOUNT FROM ethereum.core.ez_eth_transfers WHERE ETH_FROM_ADDRESS = '0x303467f7f37077B3E18Fd8caF6F8AF95316651ce')
SELECT To_AMOUNT - From_AMOUNT FROM Deposit,withdraw*/
SELECT * -- sum(AMOUNT) From_AMOUNT
FROM flipside_prod_db.algorand.account_asset
WHERE ADDRESS IN ('12npXN5HCgxkeXT7ToS3E6AU1KEwxdL87LYGepw9YUqCEvtz',
'15HeCURxNZ2ZvpM9NSVzGR38n2Cy3NWNPsVZoQAPv6U9HShZ',
'16hoTC4kTB9dp93wdy5ftUWHkhApVMyhfweqAMy4PWtthxmr',
'16ijkudbUsHQuqgPLHegqbeuD3MLnZPCXQRdaXwPBSRq9hZt',
'1mz1vgozUF4Kds3VeUgrzw1JWqcDeRwUw2JXzPLiY9Wqd5A',
'23vCxYdyNHyJqveYDiW6X87DqXrwjvi7FsWVWv9iwgj4',
'253rw8YjRZrpZ2gotgvMHqLifRxGafAaBoBPgj8vz1Q7',
'28PWjU5fSU3hJymjgRrt2YPgu5YBSkztRtN5XWJYREtP',
'2trB7nBoarzhBZqqH1Tunn6p1xH5F9uuZHsciQTWBmjq',
'364KiBcLVdnDx8jz2D2fgiGc9Wuqr1eZRAPcDqCswrzs',
'3HbQTL241Z2Bw1osCiDcM1jjo5ggH4rR4vuhmDsw1idk',
'3P7ZWQPTPKEL7S6NFWXKPGYY3N3IUPOUHTWNA7RMNGOKJFS5X77IWZPKA4',
'4IWB7J7SST73WE6Y5DDLW3G6YDMZGQQJAL4NKX33T4BI2FKM6BWD6GYYOI',
'55Ms5DEYCzt7kR5JPsjcwxfHHsu8FURAYjfJtZzV2YAJ',
'56EY7VQVLMX2DWAFRERRI6UYH34CZVMEWJC53BV7TJAWGDOPNC4NPRLNPI',
'5GygjtT7SR7TjTsvErTGXcMtdwZRoQmsFm2ardWzahrg',
'5NCumGDSmK7pn2xStESGpJ9spjdRPnkVBaA7VL4bhyeE',
'5OCUUHI4ONFDJWCOTEM2HVLKO526YZ4Y6PDPJPVFE4SRYSFSJEIHQZPEWU',
'5OFNN6QTEW72OBAHVLADOUAI5MOJM2CSUCOQ2CSKMXNAZLWIR3ZGPBWUVY',
'5VQPML22ZUC5LJUAZKF27Y3AS6S4FSBOFJZOWL7DSUOVM2TERE2SGQYBKY',
'5cASgxekXrGd1iTuRZ3uoNyJv1THZ9LHDLC5Sgn6L1sZ',
'5f4bdbb4c2faeb991b93ae896d1529ae011f7fe066d7c5cfce94c69adf967ff1',
'64GYPIB2KPJYIKK344YS6CCJYVGWLQBBS3U6LKVMI7PM7NCGZQDAPZIZI4',
'6rC8infqMg5DLWnzmEhdXTw4mjJN4HxDhxatqCCB3sxN',
'6x9WLLKdBTcDjCdLtXhRNTppjEmk8PYFCQG5XCBES6bK',
'74RHFDTQSD4GH4G4B2NM3J3OUGRRWNP3UTOD73T7A7ETYGEFY4BUYF3J4E',
'75VMMERDLNZJI4KYWD2JHP7FKVM2NMUUUZJPZPC72KXLNHEMPPBLIZQC5U',
'7RVg96QgLxA323ebNbsV7ExWDkeit67dghnnMdTQeiHS',
'8pokKkNhdS34NGPkSjgdz4aF2DB96g9SNFR9vHKt8ZF3',
Run a query to Download Data