flipside

    rewards
    realistrewards
    Updated 2025-03-08
    -- with base as (
    SELECT
    block_timestamp::date as date,
    sum(block_reward/ pow(10,6)) as block_reward_adj,
    sum(puzzle_reward/ pow(10,6)) as puzzle_reward_adj,
    sum(block_reward_adj) over (ORDER BY date) as total_block_reward,
    sum(puzzle_reward_adj) over (ORDER by date) as total_puzzle_reward,
    count(DISTINCT block_hash) as no_of_blocks,
    sum(no_of_blocks) over (ORDER BY date) as total_block_number,
    max(puzzle_reward/pow(10,6)) * 3/2 as coinbase_reward,
    sum(puzzle_reward/pow(10,6)) * 3/2 as coinbase_reward_total
    FROM aleo.core.fact_blocks
    group by 1
    order by 1
    -- )
    -- SELECT
    -- *,
    -- max(puzzle_reward/pow(10,6)) * 3/2 as coinbase_reward
    -- FROM base
    -- group by all
    -- order by date
    Last run: about 1 month ago
    DATE
    BLOCK_REWARD_ADJ
    PUZZLE_REWARD_ADJ
    TOTAL_BLOCK_REWARD
    TOTAL_PUZZLE_REWARD
    NO_OF_BLOCKS
    TOTAL_BLOCK_NUMBER
    COINBASE_REWARD
    COINBASE_REWARD_TOTAL
    1
    		2024-09-04 00:00:00.000153643.607832222764.769229153643.607832222764.76922917781778190.2587385334147.1538435
    2
    		2024-09-05 00:00:00.000970933.066736531477.1451441124576.674568754241.9143732965231430190.248018797215.717716
    3
    		2024-09-06 00:00:00.000898329.515283379417.8058122022906.1898511133659.7201852979661226190.069041569126.708718
    4
    		2024-09-07 00:00:00.000902915.33975382216.2292532925821.5296011515875.9494382993091156189.889068573324.3438795
    5
    		2024-09-08 00:00:00.000903622.521346375535.5348063829444.0509471891411.48424430100121256189.708705563303.302209
    6
    		2024-09-09 00:00:00.000916411.007248376226.6264034745855.0581952267638.11064730623151879189.5269155564339.9396045
    7
    		2024-09-10 00:00:00.000900337.986506376370.0163655646193.0447012644008.12701229944181823189.3422985564555.0245475
    8
    		2024-09-11 00:00:00.000870865.658211368782.0985396517058.7029123012790.22555128864210687189.161565553173.1478085
    9
    		2024-09-12 00:00:00.000871382.789042377381.856547388441.4919543390172.08209128705239392188.9876565566072.78481
    10
    		2024-09-13 00:00:00.000905328.09946378251.4744948293769.5914143768423.55658530114269506188.8142055567377.211741
    11
    		2024-09-14 00:00:00.000903956.41528373029.7718399197726.0066944141453.32842430166299672188.632611559544.6577585
    12
    		2024-09-15 00:00:00.000903235.633153370354.40579410100961.6398474511807.73421830192329864188.4506655555531.608691
    13
    		2024-09-16 00:00:00.000899089.575031374794.72490411000051.2148784886602.45912229924359788188.268057562192.087356
    14
    		2024-09-17 00:00:00.000889961.658441370041.94234311890012.8733195256644.40146529640389428188.088036555062.9135145
    15
    		2024-09-18 00:00:00.000888801.259104360722.69442412778814.1324235617367.09588929787419215187.909143541084.041636
    16
    		2024-09-19 00:00:00.000909136.313273378258.40971813687950.4456965995625.50560730274449489187.729467567387.614577
    17
    		2024-09-20 00:00:00.000873056.851619371071.16578114561007.2973156366696.67138828908478397187.546725556606.7486715
    18
    		2024-09-21 00:00:00.000879323.197434372919.92335515440330.4947496739616.59474329133507530187.372509559379.8850325
    19
    		2024-09-22 00:00:00.000868147.956196364794.09207316308478.4509457104410.68681628834536364187.196523547191.1381095
    20
    		2024-09-23 00:00:00.000885153.329334369878.71900117193631.7802797474289.40581729442565806187.022814554818.0785015
    ...
    186
    23KB
    2s