andurilResupply Score
Updated 2023-01-09
99
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
›
⌄
⌄
/*
select
date(block_timestamp) as date,
count (distinct (signers[0])) as wallets
from
solana.fact_transactions
where
date(block_timestamp) = '2022-04-20'
--tx_id = '3ewLkrMQWd3GhKHJp3qfh4sPUoiYB9mPB9dwnb3tftP7xg5jKD9bfpytAww5xZJ5dj5GkekrUNMmENNTzMcgoQpe'and
--log_messages[0] = 'Program FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW invoke [1]'
and log_messages[1] like '%Refueling%'
--log_messages[4] = 'Program log: Creating Ship Escrow Account'
group by 1
fuel - fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim
ammo - ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK
tool - tooLsNYLiVqzg8o4m3L2Uetbn62mvMWRqkog6PQeYKL
food - foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG
*/
with r4_deposits as (
select
date(block_timestamp) as date,
--tx_id,
inner_instruction:instructions[0]:parsed:info:mint as mint,
inner_instruction:instructions[0]:parsed:info:tokenAmount:amount as amount
from
flipside_prod_db.solana.fact_events
where
date >= '2022-05-12'
and
program_id = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW'
and mint = 'ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK'
Run a query to Download Data