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.000 | 88890 | 0000000000022f1c78b9acf9d012064f3c97811dc5798d8b8fad4760f9490ec1 | 2010-10-31 23:01:21.000 | 1 | 00000000000c813bf09968d0cc4a7f8fe89fd5727cc061ad46abaac9bd4ed8ae | 00000000000d2dd413fc868e10abbd5cb16c990b53e4e6e3a948c03ab0339dcf | 1b153263 | 000000000000000000000000000000000000000000000000011158099087e73c | 3091.736890412 | 7537d785921cd4789159d700e819610468bcbf8f87c1815912d4ed50875fec1d | 3347886650 | 215 | 215 | 1 | 860 | [
"7537d785921cd4789159d700e819610468bcbf8f87c1815912d4ed50875fec1d"
] | 3c929e017a77a73b48138280b440856b | 2023-06-29 13:48:21.827 | 2023-06-29 13:48:21.827 | |
2 | 2010-10-31 23:46:11.000 | 88891 | 00000000000c813bf09968d0cc4a7f8fe89fd5727cc061ad46abaac9bd4ed8ae | 2010-10-31 23:10:49.000 | 2 | 000000000007accbff359757a2d3b408b72317c714607eb5684547bf8633394f | 0000000000022f1c78b9acf9d012064f3c97811dc5798d8b8fad4760f9490ec1 | 1b153263 | 0000000000000000000000000000000000000000000000000111641d59408990 | 3091.736890412 | 2b09058cfe6a4e5092ae1bcc92b28b6bcfd9354f386c174b20805731a4ff9623 | 3685179504 | 1815 | 1815 | 1 | 7260 | [
"36207f5172d82ee2591099a7b5bc5b68792aa09f606f06625b2e1b2ac40f5af3",
"0fd36c57a2cda5ea996232f579b009e701596a7f1f61e487b7a518319aede64f"
] | 7956bb90c19996641f2cafe86091adb8 | 2023-06-29 13:48:21.827 | 2023-06-29 13:48:21.827 | |
3 | 2010-10-31 23:46:32.000 | 88892 | 000000000007accbff359757a2d3b408b72317c714607eb5684547bf8633394f | 2010-10-31 23:15:58.000 | 1 | 00000000000438156269d96638072e7b0d38910fc47107079536d4fe3bd37315 | 00000000000c813bf09968d0cc4a7f8fe89fd5727cc061ad46abaac9bd4ed8ae | 1b153263 | 0000000000000000000000000000000000000000000000000111703121f92be4 | 3091.736890412 | 0c96c2a9065ce6b78ff8bfbba07d4213cb94856c0caa088d4d2c49edb7079a50 | 396576490 | 216 | 216 | 1 | 864 | [
"0c96c2a9065ce6b78ff8bfbba07d4213cb94856c0caa088d4d2c49edb7079a50"
] | 31f4ea0542e6f887f0bb8df52a1ec899 | 2023-06-29 13:48:21.827 | 2023-06-29 13:48:21.827 | |
4 | 2010-11-01 00:03:20.000 | 88893 | 00000000000438156269d96638072e7b0d38910fc47107079536d4fe3bd37315 | 2010-10-31 23:26:07.000 | 1 | 00000000000edd1033ecabdcfa96033cb7673f4ffa1c32589157cea65e30504d | 000000000007accbff359757a2d3b408b72317c714607eb5684547bf8633394f | 1b153263 | 00000000000000000000000000000000000000000000000001117c44eab1ce38 | 3091.736890412 | 651d521c9ecaa01ed85d0a34005d564506a23681d085d0fc0859cc2a63926af4 | 931664645 | 215 | 215 | 1 | 860 | [
"651d521c9ecaa01ed85d0a34005d564506a23681d085d0fc0859cc2a63926af4"
] | 960d2e9e0ed1dae7f9ccb96cff9d3fd3 | 2023-06-29 13:48:21.827 | 2023-06-29 13:48:21.827 | |
5 | 2010-11-01 00:07:16.000 | 88894 | 00000000000edd1033ecabdcfa96033cb7673f4ffa1c32589157cea65e30504d | 2010-10-31 23:36:44.000 | 1 | 00000000000ec649430f9266929f21a30946b6f717a078ddd64bdac22dcae7c9 | 00000000000438156269d96638072e7b0d38910fc47107079536d4fe3bd37315 | 1b153263 | 00000000000000000000000000000000000000000000000001118858b36a708c | 3091.736890412 | 416e572717be2e0f51bd6122cde2d200d794b78b0c32fa8ae470328173f2dea4 | 874645000 | 215 | 215 | 1 | 860 | [
"416e572717be2e0f51bd6122cde2d200d794b78b0c32fa8ae470328173f2dea4"
] | 06cba9a88369abca82d6e20d97e99ad8 | 2023-06-29 13:48:21.827 | 2023-06-29 13:48:21.827 | |
6 | 2010-11-01 00:16:14.000 | 88895 | 00000000000ec649430f9266929f21a30946b6f717a078ddd64bdac22dcae7c9 | 2010-10-31 23:40:37.000 | 2 | 00000000000438fb2bf26c09e27c823661d0c9d195c030cd6ba7f98efd263d32 | 00000000000edd1033ecabdcfa96033cb7673f4ffa1c32589157cea65e30504d | 1b153263 | 0000000000000000000000000000000000000000000000000111946c7c2312e0 | 3091.736890412 | 1e18d1332968eb3978f29d784005700b452160c825e6ca505d000f45580b2c31 | 3946878472 | 373 | 373 | 1 | 1492 | [
"eb301ec89860fff20f059a2bd4bc4f3eb5decb7a8805e75097a180f94e208959",
"8822a54b2587e5c7a3752c55ee1bcf08bb54330824348675f30551fd6857f0dd"
] | e1231dac683cc6970b0db129ed4f2006 | 2023-06-29 13:48:21.827 | 2023-06-29 13:48:21.827 | |
7 | 2010-11-01 00:24:42.000 | 88896 | 00000000000438fb2bf26c09e27c823661d0c9d195c030cd6ba7f98efd263d32 | 2010-10-31 23:46:11.000 | 2 | 0000000000102df62ceb4b9c721d2df73d73ec892df6555ee17e13f218adb7b1 | 00000000000ec649430f9266929f21a30946b6f717a078ddd64bdac22dcae7c9 | 1b153263 | 0000000000000000000000000000000000000000000000000111a08044dbb534 | 3091.736890412 | 76db730faab158113db8b681d66036102a6003fb67ebf415ec8e04dcba33c57f | 1198503454 | 4819 | 4819 | 1 | 19276 | [
"b36f80fb99367ce9d6cae06215d4a53a502ac2764b9cd86c82be36fa839b2d1b",
"ebceee81b8ab0315376c71c45f4281f57f9745e31f6d9d1392e1c26d8be056cf"
] | 9ffa345b2812af59cf220b4da77d8391 | 2023-06-29 13:48:21.827 | 2023-06-29 13:48:21.827 | |
8 | 2010-11-01 00:31:54.000 | 88897 | 0000000000102df62ceb4b9c721d2df73d73ec892df6555ee17e13f218adb7b1 | 2010-10-31 23:46:32.000 | 2 | 000000000003dfa7ead0417aa325c6add9c54713c07bcab4aab5b5d4ec354491 | 00000000000438fb2bf26c09e27c823661d0c9d195c030cd6ba7f98efd263d32 | 1b153263 | 0000000000000000000000000000000000000000000000000111ac940d945788 | 3091.736890412 | dc1cbef71ee9f79a5c652a490e2653c953d88887be775be33bde3c1c1f0af149 | 1894887052 | 373 | 373 | 1 | 1492 | [
"a19b08cc15d292cbea433c8e5ef370f6da681880d6da89379b1052cb77cc9f7e",
"3f6d60f393ebf375d491997b478bb61b5dbeba70bdc02867ef58c1ef36e93723"
] | d860560a0dfb3288796978f18ff333c5 | 2023-06-29 13:48:21.827 | 2023-06-29 13:48:21.827 | |
9 | 2010-11-01 00:53:15.000 | 88898 | 000000000003dfa7ead0417aa325c6add9c54713c07bcab4aab5b5d4ec354491 | 2010-11-01 00:03:20.000 | 2 | 00000000000199e374f5d55fcf27c72445b501032d217b838e68f5db56704490 | 0000000000102df62ceb4b9c721d2df73d73ec892df6555ee17e13f218adb7b1 | 1b153263 | 0000000000000000000000000000000000000000000000000111b8a7d64cf9dc | 3091.736890412 | 5c0182cf0b36a99c060a0fa4404a9b747d3da01b05e87fef82f4fa7bce3ddcc6 | 474791181 | 473 | 473 | 1 | 1892 | [
"0efa5a147eb3a9437692ee6740f7607ac69b244dd610d7c6d1bd7ac33ec689bb",
"94cba16af5c9b3118dbb2cc0469967c6a0a1e32479acdf160f571a4512461f45"
] | d6ee7b3b36173224366cfb05f8d6ec53 | 2023-06-29 13:48:21.827 | 2023-06-29 13:48:21.827 | |
10 | 2010-11-01 01:00:30.000 | 88899 | 00000000000199e374f5d55fcf27c72445b501032d217b838e68f5db56704490 | 2010-11-01 00:07:16.000 | 2 | 0000000000127d00a0ec58e83f7ac54f5e5486e10f8cf0dae3824fcb6072862d | 000000000003dfa7ead0417aa325c6add9c54713c07bcab4aab5b5d4ec354491 | 1b153263 | 0000000000000000000000000000000000000000000000000111c4bb9f059c30 | 3091.736890412 | 0882e76064299d4e9da8e7fe31e01c994bde567e82f5fcd968cb79c2fc200f72 | 1329980637 | 476 | 476 | 1 | 1904 | [
"cb811d90cf931fad0a68163c022b373bff41b2d99d11c3a582b175b089f8e9aa",
"51d4bfa340a16f2649a8d2d79db483ac9548980d57de5fc1b0b4ee8e4675ef39"
] | dd08435080d6b88061f3c374673504c4 | 2023-06-29 13:48:21.827 | 2023-06-29 13:48:21.827 |
itspauloalmeidaCTE exemple
Updated 2025-01-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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
10
6KB
2s