itspauloalmeidaCTE exemple
    Updated 2025-01-02
    select * from ethereum.core.fact_transactions where tx_hash = '0xd779332c5A52566Dada11A075a735b18DAa6c1f4';

    select * from ethereum.core.fact_transactions limit 5;

    select * from ethereum.core.fact_transactions where from_address = '0xd779332c5A52566Dada11A075a735b18DAa6c1f4';


    -- exemple
    WITH penguins as
    (
    SELECT *
    FROM ethereum.nft.ez_nft_sales
    WHERE nft_address = lower('0xBd3531dA5CF5857e7CfAA92426877b022e612cf8')
    and block_timestamp::date >= '2025-01-01'
    )
    SELECT
    buyer_address,
    count(DISTINCT tokenid) as n_nfts
    FROM penguins
    GROUP BY buyer_address
    ORDER BY n_nfts DESC
    LIMIT 15


    --new definition exemple CTE

    WITH swaps_total as
    (SELECT *
    FROM ethereum.defi.ez_dex_swaps
    WHERE block_timestamp::date >= CURRENT_DATE - 30
    and platform in('uniswap-v2', 'uniswap-v3')
    )
    SELECT PLATFORM,
    count(DISTINCT TX_HASH) as n_swaps
    FROM swaps_total
    GROUP BY PLATFORM
    Last run: about 1 month ago
    BLOCK_TIMESTAMP
    BLOCK_NUMBER
    BLOCK_HASH
    MEDIAN_TIME
    TX_COUNT
    NEXT_BLOCK_HASH
    PREVIOUS_BLOCK_HASH
    BITS
    CHAINWORK
    DIFFICULTY
    MERKLE_ROOT
    NONCE
    SIZE
    STRIPPED_SIZE
    VERSION
    WEIGHT
    ERROR
    TXS
    FACT_BLOCKS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    2010-10-31 23:40:37.000888900000000000022f1c78b9acf9d012064f3c97811dc5798d8b8fad4760f9490ec12010-10-31 23:01:21.000100000000000c813bf09968d0cc4a7f8fe89fd5727cc061ad46abaac9bd4ed8ae00000000000d2dd413fc868e10abbd5cb16c990b53e4e6e3a948c03ab0339dcf1b153263000000000000000000000000000000000000000000000000011158099087e73c3091.7368904127537d785921cd4789159d700e819610468bcbf8f87c1815912d4ed50875fec1d33478866502152151860
    [ "7537d785921cd4789159d700e819610468bcbf8f87c1815912d4ed50875fec1d" ]
    3c929e017a77a73b48138280b440856b2023-06-29 13:48:21.8272023-06-29 13:48:21.827
    2
    2010-10-31 23:46:11.0008889100000000000c813bf09968d0cc4a7f8fe89fd5727cc061ad46abaac9bd4ed8ae2010-10-31 23:10:49.0002000000000007accbff359757a2d3b408b72317c714607eb5684547bf8633394f0000000000022f1c78b9acf9d012064f3c97811dc5798d8b8fad4760f9490ec11b1532630000000000000000000000000000000000000000000000000111641d594089903091.7368904122b09058cfe6a4e5092ae1bcc92b28b6bcfd9354f386c174b20805731a4ff962336851795041815181517260
    [ "36207f5172d82ee2591099a7b5bc5b68792aa09f606f06625b2e1b2ac40f5af3", "0fd36c57a2cda5ea996232f579b009e701596a7f1f61e487b7a518319aede64f" ]
    7956bb90c19996641f2cafe86091adb82023-06-29 13:48:21.8272023-06-29 13:48:21.827
    3
    2010-10-31 23:46:32.00088892000000000007accbff359757a2d3b408b72317c714607eb5684547bf8633394f2010-10-31 23:15:58.000100000000000438156269d96638072e7b0d38910fc47107079536d4fe3bd3731500000000000c813bf09968d0cc4a7f8fe89fd5727cc061ad46abaac9bd4ed8ae1b1532630000000000000000000000000000000000000000000000000111703121f92be43091.7368904120c96c2a9065ce6b78ff8bfbba07d4213cb94856c0caa088d4d2c49edb7079a503965764902162161864
    [ "0c96c2a9065ce6b78ff8bfbba07d4213cb94856c0caa088d4d2c49edb7079a50" ]
    31f4ea0542e6f887f0bb8df52a1ec8992023-06-29 13:48:21.8272023-06-29 13:48:21.827
    4
    2010-11-01 00:03:20.0008889300000000000438156269d96638072e7b0d38910fc47107079536d4fe3bd373152010-10-31 23:26:07.000100000000000edd1033ecabdcfa96033cb7673f4ffa1c32589157cea65e30504d000000000007accbff359757a2d3b408b72317c714607eb5684547bf8633394f1b15326300000000000000000000000000000000000000000000000001117c44eab1ce383091.736890412651d521c9ecaa01ed85d0a34005d564506a23681d085d0fc0859cc2a63926af49316646452152151860
    [ "651d521c9ecaa01ed85d0a34005d564506a23681d085d0fc0859cc2a63926af4" ]
    960d2e9e0ed1dae7f9ccb96cff9d3fd32023-06-29 13:48:21.8272023-06-29 13:48:21.827
    5
    2010-11-01 00:07:16.0008889400000000000edd1033ecabdcfa96033cb7673f4ffa1c32589157cea65e30504d2010-10-31 23:36:44.000100000000000ec649430f9266929f21a30946b6f717a078ddd64bdac22dcae7c900000000000438156269d96638072e7b0d38910fc47107079536d4fe3bd373151b15326300000000000000000000000000000000000000000000000001118858b36a708c3091.736890412416e572717be2e0f51bd6122cde2d200d794b78b0c32fa8ae470328173f2dea48746450002152151860
    [ "416e572717be2e0f51bd6122cde2d200d794b78b0c32fa8ae470328173f2dea4" ]
    06cba9a88369abca82d6e20d97e99ad82023-06-29 13:48:21.8272023-06-29 13:48:21.827
    6
    2010-11-01 00:16:14.0008889500000000000ec649430f9266929f21a30946b6f717a078ddd64bdac22dcae7c92010-10-31 23:40:37.000200000000000438fb2bf26c09e27c823661d0c9d195c030cd6ba7f98efd263d3200000000000edd1033ecabdcfa96033cb7673f4ffa1c32589157cea65e30504d1b1532630000000000000000000000000000000000000000000000000111946c7c2312e03091.7368904121e18d1332968eb3978f29d784005700b452160c825e6ca505d000f45580b2c31394687847237337311492
    [ "eb301ec89860fff20f059a2bd4bc4f3eb5decb7a8805e75097a180f94e208959", "8822a54b2587e5c7a3752c55ee1bcf08bb54330824348675f30551fd6857f0dd" ]
    e1231dac683cc6970b0db129ed4f20062023-06-29 13:48:21.8272023-06-29 13:48:21.827
    7
    2010-11-01 00:24:42.0008889600000000000438fb2bf26c09e27c823661d0c9d195c030cd6ba7f98efd263d322010-10-31 23:46:11.00020000000000102df62ceb4b9c721d2df73d73ec892df6555ee17e13f218adb7b100000000000ec649430f9266929f21a30946b6f717a078ddd64bdac22dcae7c91b1532630000000000000000000000000000000000000000000000000111a08044dbb5343091.73689041276db730faab158113db8b681d66036102a6003fb67ebf415ec8e04dcba33c57f119850345448194819119276
    [ "b36f80fb99367ce9d6cae06215d4a53a502ac2764b9cd86c82be36fa839b2d1b", "ebceee81b8ab0315376c71c45f4281f57f9745e31f6d9d1392e1c26d8be056cf" ]
    9ffa345b2812af59cf220b4da77d83912023-06-29 13:48:21.8272023-06-29 13:48:21.827
    8
    2010-11-01 00:31:54.000888970000000000102df62ceb4b9c721d2df73d73ec892df6555ee17e13f218adb7b12010-10-31 23:46:32.0002000000000003dfa7ead0417aa325c6add9c54713c07bcab4aab5b5d4ec35449100000000000438fb2bf26c09e27c823661d0c9d195c030cd6ba7f98efd263d321b1532630000000000000000000000000000000000000000000000000111ac940d9457883091.736890412dc1cbef71ee9f79a5c652a490e2653c953d88887be775be33bde3c1c1f0af149189488705237337311492
    [ "a19b08cc15d292cbea433c8e5ef370f6da681880d6da89379b1052cb77cc9f7e", "3f6d60f393ebf375d491997b478bb61b5dbeba70bdc02867ef58c1ef36e93723" ]
    d860560a0dfb3288796978f18ff333c52023-06-29 13:48:21.8272023-06-29 13:48:21.827
    9
    2010-11-01 00:53:15.00088898000000000003dfa7ead0417aa325c6add9c54713c07bcab4aab5b5d4ec3544912010-11-01 00:03:20.000200000000000199e374f5d55fcf27c72445b501032d217b838e68f5db567044900000000000102df62ceb4b9c721d2df73d73ec892df6555ee17e13f218adb7b11b1532630000000000000000000000000000000000000000000000000111b8a7d64cf9dc3091.7368904125c0182cf0b36a99c060a0fa4404a9b747d3da01b05e87fef82f4fa7bce3ddcc647479118147347311892
    [ "0efa5a147eb3a9437692ee6740f7607ac69b244dd610d7c6d1bd7ac33ec689bb", "94cba16af5c9b3118dbb2cc0469967c6a0a1e32479acdf160f571a4512461f45" ]
    d6ee7b3b36173224366cfb05f8d6ec532023-06-29 13:48:21.8272023-06-29 13:48:21.827
    10
    2010-11-01 01:00:30.0008889900000000000199e374f5d55fcf27c72445b501032d217b838e68f5db567044902010-11-01 00:07:16.00020000000000127d00a0ec58e83f7ac54f5e5486e10f8cf0dae3824fcb6072862d000000000003dfa7ead0417aa325c6add9c54713c07bcab4aab5b5d4ec3544911b1532630000000000000000000000000000000000000000000000000111c4bb9f059c303091.7368904120882e76064299d4e9da8e7fe31e01c994bde567e82f5fcd968cb79c2fc200f72132998063747647611904
    [ "cb811d90cf931fad0a68163c022b373bff41b2d99d11c3a582b175b089f8e9aa", "51d4bfa340a16f2649a8d2d79db483ac9548980d57de5fc1b0b4ee8e4675ef39" ]
    dd08435080d6b88061f3c374673504c42023-06-29 13:48:21.8272023-06-29 13:48:21.827
    10
    6KB
    2s