Method :

I used solana.core.fact_transactions, solana.fact_swaps and solana.core.fact_transfers tables for extracting $DUST data.

I used DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ as $DUST contract.

• The volume of swaps increased from the third week of April and reached its peak in the second week of June. After that, the volume of swaps decreased sharply and increased again since the news of August. The number of swappers has also repeated the same pattern.
• The volume in USD of swaps has increased significantly since the third week of August.

• The number of transfers has been increasing over time and reached its peak in late August.
• The total number of transfers so far reaches about 240 thousand transfers.

• The weekly volume of transfers has been between 3 and 6 million $DUST, but in the third week of June, it suddenly increased to 10 million.
• The dollar volume of swaps has been decreasing over time.

• SOL is the most popular token for $DUST users to swap_from/swap_to.

• Raydium and jupiter are the programs that most $DUST transactions have interacted with.

Concolusion :

From this analysis, we obtained the following results :

1. The volume of swaps increased from the third week of April and reached its peak in the second week of June. After that, the volume of swaps decreased sharply and increased again since the news of August. The number of swappers has also repeated the same pattern.
2. The volume in USD of swaps has increased significantly since the third week of August.
3. The number of transfers has been increasing over time and reached its peak in late August.
4. The total number of transfers so far reaches about 240 thousand transfers.
5. The weekly volume of transfers has been between 3 and 6 million $DUST, but in the third week of June, it suddenly increased to 10 million.
6. The dollar volume of swaps has been decreasing over time.
7. SOL is the most popular token for $DUST users to swap_from/swap_to.