ADDRESS | Current BADDOG | Previous BADDOG | |
|---|---|---|---|
1 | osmo14umk9mfznt7fqyq4ayh0zmwu44etaec3259f6c0 | 428239324 | 428239324 |
2 | osmo14umk9mfznt7fqyq4ayh0zmwu44etaec3259f6c0 | 428239324 | 428239324 |
3 | osmo14umk9mfznt7fqyq4ayh0zmwu44etaec3259f6c0 | 428239324 | 428239324 |
4 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 276053517 |
5 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 276053517 |
6 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 276053517 |
7 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 276053517 |
8 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 276053517 |
9 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 276053517 |
10 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 276053517 |
11 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 396625414 |
12 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 396625414 |
13 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 396625414 |
14 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 276053517 |
15 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 276053517 |
16 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 276053517 |
17 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 396625414 |
18 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 276053517 |
19 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 396625414 |
20 | osmo1n9v7ldd0z6dp05djptl0nk3e4lpy73xv3a4l3v0 | 396625414 | 396625414 |
misfitsBaddog Holders change
Updated 2024-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
a.address,
round(a.balance / 1000000, 0) AS "Current BADDOG",
( select round(b.balance / 1000000, 0)
FROM osmosis.core.fact_daily_balances
WHERE date = '2024-01-29 00:00:00.000'
AND currency = 'ibc/2FFE07C4B4EFC0DDA099A16C6AF3C9CCA653CC56077E87217A585D48794B0BC7') AS "Previous BADDOG"
FROM
osmosis.core.fact_daily_balances a, osmosis.core.fact_daily_balances b
WHERE
a.currency = 'ibc/2FFE07C4B4EFC0DDA099A16C6AF3C9CCA653CC56077E87217A585D48794B0BC7'
AND a.date >= dateadd(d, -1, GETDATE())
AND a.balance_type = 'liquid'
AND b.date <= dateadd(d, -2, GETDATE())
AND b.currency = 'ibc/2FFE07C4B4EFC0DDA099A16C6AF3C9CCA653CC56077E87217A585D48794B0BC7'
AND a.address = b.address
order by a.balance DESC
Last run: about 1 year ago
...
3229
200KB
25s