primo_dataaurory staking
Updated 2022-07-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- 2. How have token staking and nft expedition patterns changed in the bear market?
--staking
-- s8xD6gTYrdwDFtGxpUpGJXHoi3p5yspV3a4QYPJ5bA6RQjFdDvBbbsUk3odpNvELZPP4fc2LqsV8Wg2KU9HqTr7
-- 5SqnXmCP4PA2tRWLeScc84SSWkuZnfXGizusz7DWzwHUzm2171q3SRB2cXtzQSMAu88FZE2mCNSeZJQ8pA7kmNzZ
-- xaury address = xAURp5XmAG7772mfkSy6vRAjGK9JofYjc3dmQDWdVDP
-- https://app.flipsidecrypto.com/velocity/queries/587766c9-2a91-48c4-92c5-4da63202a9f9
/* select date(block_timestamp) dt
, count(tx_id) ct
from solana.core.fact_swaps
where --swap_from_mint = 'AURYydfxJib1ZkTir1Jn1J9ECYUtjb6rKQVmtYaixWPP' -- AURY
swap_to_mint = 'xAURp5XmAG7772mfkSy6vRAjGK9JofYjc3dmQDWdVDP' -- xAURY
and date(block_timestamp) > date('2021-12-01')
group by 1 */
Run a query to Download Data