flipside

    Daily Numbers
    hessDaily Numbers
    Updated 17 hours ago
    WITH basic AS (
    SELECT
    a.block_timestamp,
    a.block_number,
    a.tx_hash,
    CONCAT('0x', SUBSTR(HEX_ENCODE(data), 25, 40)) AS user,
    value,
    tx_fee,
    b.status
    FROM
    sei.core_evm.fact_event_logs a
    LEFT JOIN
    sei.core_evm.fact_transactions b
    ON
    a.tx_hash = b.tx_hash
    WHERE
    a.block_timestamp::date >= '2024-05-01'
    AND b.block_timestamp::date >= '2024-05-01'

    UNION ALL

    SELECT
    block_timestamp,
    block_number,
    tx_hash,
    from_address AS user,
    value,
    tx_fee,
    status
    FROM
    sei.core_evm.fact_transactions
    WHERE
    block_timestamp::date >= '2024-04-27'
    )

    select block_timestamp::Date as date,
    Last run: about 17 hours ago
    DATE
    QUARTER
    PRODUCED_BLOCKS
    TRANSACTIONS
    ADDRESSES
    AVG_TX_PER_USER
    AVG_7_DAY_MOVING_ADDRESS_COUNT
    AVG_7_DAY_MOVING_TX_COUNT
    TOTAL_FEES
    AVG_FEE
    MAX_FEE
    MEDIAN_FEE
    MIN_FEE
    1
    		2024-05-27 00:00:00.000Q2-2024 (EVM Launch)1414152013910.935252139152051.9520220930.022441478233.7980330.0000614410
    2
    		2024-05-28 00:00:00.000Q2-2024 (EVM Launch)694372827879.252859463440112.821895210.00069597216581.1589180.0000975870
    3
    		2024-05-29 00:00:00.000Q2-2024 (EVM Launch)154081622517489.282037891.3338342.3337.6891989260.00022216697271.1590140.0000614410
    4
    		2024-05-30 00:00:00.000Q2-2024 (EVM Launch)4662852058171730.3191611097.7519271.2578.0061363170.00094707869022.4903890.0000890930
    5
    		2024-05-31 00:00:00.000Q2-2024 (EVM Launch)130406176194248570.9030181375.250655.858.5833729350.00027985598583.7980330.0000890930
    6
    		2024-06-01 00:00:00.000Q2-2024 (EVM Launch)163981236177338169.8541851709.58157692.7291335510.00036291072361.29420.0000890934.19137635e-7
    7
    		2024-06-02 00:00:00.000Q2-2024 (EVM Launch)2071294127963691111.8385261992.571128893.14251.9402042570.0001216854190.0068575810.0000890930.000021
    8
    		2024-06-03 00:00:00.000Q2-2024 (EVM Launch)1894892939322223132.2231222021.37514952393.8757377530.00030380497653.7980330.0000830170
    9
    		2024-06-04 00:00:00.000Q2-2024 (EVM Launch)171590249368268492.9090912339.518050470.0804849930.00026325659453.7980330.0000830470
    10
    		2024-06-05 00:00:00.000Q2-2024 (EVM Launch)146957200459226888.3858022524.625204651.12548.9839990750.00022456230010.0089446760.0002722350
    11
    		2024-06-06 00:00:00.000Q2-2024 (EVM Launch)1805932696511439187.3877692486236329.37559.6577503820.00020156143490.021933565590.0000831820
    12
    		2024-06-07 00:00:00.000Q2-2024 (EVM Launch)109602119155131690.5433132435.875244716.550.6367408450.00033887503410.025940168860.0002879230
    13
    		2024-06-08 00:00:00.000Q2-2024 (EVM Launch)104986112453139180.8432782299.125236748.87540.7992200030.00028063846470.0073412880.0002879230
    14
    		2024-06-09 00:00:00.000Q2-2024 (EVM Launch)276982899080336.1021171976.875210850.516.7125718880.00026246265290.0055486470.0002422740
    15
    		2024-06-10 00:00:00.000Q2-2024 (EVM Launch)131911366374018.4635141608160958.87515.4830686170.00027790265670.024227621850.0002422350
    16
    		2024-06-11 00:00:00.000Q2-2024 (EVM Launch)2046823770167614.1825781539.625127188.62546.4232341990.00045934945733.1545570.0002421930
    17
    		2024-06-12 00:00:00.000Q2-2024 (EVM Launch)2742438283363510.5317741658.510080361.4026366260.00036869160112.4156720.0002010570
    18
    		2024-06-13 00:00:00.000Q2-2024 (EVM Launch)239053314235449.35158181879888.37535.0149168890.00024747623042.7154770.00021404850
    19
    		2024-06-14 00:00:00.000Q2-2024 (EVM Launch)134981434315219.429981828.2547974.87514.4342875330.0002576631120.023951950.0002422470
    20
    		2024-06-15 00:00:00.000Q2-2024 (EVM Launch)125981300569018.847826175034706.12514.2102199560.00027318415050.012620401930.0002422470.000021
    ...
    335
    48KB
    87s