Collection Details
Namespace:
parahmeen
Dataset:
Collection:
Hastra
Owner:
0x6f7d3b8adc9ee889d3f147bf526f298d6cf07fc7
Transaction:
Timestamp:
Nov.25.2023 05:53:39 PM
Status:
OnChain
Collection Documents
| _id | Aela | View |
|---|---|---|
3589b6f8cd4156c7f0d0dcd3d6e9c644bad250766f2e40ce385f9c76644398fa4 | WITH raw_tx AS (
SELECT
date_trunc('hour', block_time) as block_hour,
1000 as amt,
gas_used / 1e18 * gas_price as gas
FROM arbitrum.transactions
WHERE
block_date >= TRY_CAST('2023-11-23' AS DATE)
AND block_number >= 153659479
AND "from" = to
AND FROM_UTF8(data) = 'data:,{"p":"fair-20","op":"mint","tick":"fair","amt":"1000"}'
AND success = TRUE
ORDER BY
block_number,
index
LIMIT 10000000
)
select
block_hour,
sum(amt) as minted_amt,
sum(gas) as minted_gas,
sum(sum(amt)) over (
order by
block_hour
) as total_minted_amt,
sum(sum(gas)) over (
order by
block_hour
) as total_minted_gas,
cast(
sum(sum(amt)) over (
order by
block_hour
) as double
) / 10000000000 as minted_per
from
raw_tx
group by
block_hour
order by
block_hour desc | View |
3589b6f8cd4156c7f0d0dcd3d6e9c644bad250766f2e40ce385f9c76644398fa3 | Maret | View |
3589b6f8cd4156c7f0d0dcd3d6e9c644bad250766f2e40ce385f9c76644398fa1 | WITH raw_tx AS (
SELECT
date_trunc('hour', block_time) as block_hour,
1000 as amt,
gas_used / 1e18 * gas_price as gas
FROM arbitrum.transactions
WHERE
block_date >= TRY_CAST('2023-11-23' AS DATE)
AND block_number >= 153659479
AND "from" = to
AND FROM_UTF8(data) = 'data:,{"p":"fair-20","op":"mint","tick":"fair","amt":"1000"}'
AND success = TRUE
ORDER BY
block_number,
index
LIMIT 10000000
)
select
block_hour,
sum(amt) as minted_amt,
sum(gas) as minted_gas,
sum(sum(amt)) over (
order by
block_hour
) as total_minted_amt,
sum(sum(gas)) over (
order by
block_hour
) as total_minted_gas,
cast(
sum(sum(amt)) over (
order by
block_hour
) as double
) / 10000000000 as minted_per
from
raw_tx
group by
block_hour
order by
block_hour desc | View |