flipside

    intelligent-crimson
    zer0mode8-LWVs4bintelligent-crimson
    Updated 2025-02-25
    /*SELECT CONTRACT_ADDRESS
    FROM ethereum.core.ez_token_transfers
    WHERE SYMBOL = 'FLOCK' ;*/

    /*SELECT AMOUNT, AMOUNT_USD, CONTRACT_ADDRESS, SYMBOL*/
    /*SELECT * FROM ethereum.core.ez_token_transfers
    WHERE CONTRACT_ADDRESS = '0xb33d999469a7e6b9ebc25a3a05248287b855ed46'
    ORDER BY AMOUNT DESC limit 10 ;*/

    /*SELECT * FROM ethereum.defi.ez_dex_swaps*/
    /* WHERE CONTRACT_ADDRESS = '0xb33d999469a7e6b9ebc25a3a05248287b855ed46' */
    /* WHERE token_out = '0xb33d999469a7e6b9ebc25a3a05248287b855ed46'
    ORDER BY amount_out DESC limit 10 ;*/

    /*SELECT * FROM ethereum.core.dim_contracts
    WHERE SYMBOL = 'FLOCK' ;*/

    SELECT * FROM ethereum.core.dim_contracts
    WHERE ADDRESS LIKE '0xb33d%' AND SYMBOL = 'FLOCK';


    Last run: 2 months ago
    ADDRESS
    SYMBOL
    NAME
    DECIMALS
    CREATED_BLOCK_NUMBER
    CREATED_BLOCK_TIMESTAMP
    CREATED_TX_HASH
    CREATOR_ADDRESS
    DIM_CONTRACTS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    CONTRACT_METADATA
    1
    		0xb33d999469a7e6b9ebc25a3a05248287b855ed46FLOCKFlockerz18206612052024-09-02 06:50:47.0000x570b760dacfdccf4e009201cbd2b5f78849f6d028728692888004f714bbc124c0xa46196997f220d3fd3705be776415870e9897f9d859c52ab228ee3e4e38b850618aa80562024-09-02 20:33:30.6852025-01-30 00:12:00.673
    1
    311B
    3s