flipside

    SQL Basics
    feyikemiSQL Basics
    Updated 2024-02-15
    -- Blockchain Analytics Traning

    SELECT -- * means all
    block_timestamp,
    tx_hash,
    origin_from_address,--Receivers or depositors
    origin_to_address, --Senders or Withdrawals
    contract_address,
    amount_usd,
    symbol,
    token_price
    FROM ethereum.core.ez_token_transfers -- Retrieving data from the ethereum.core.ez_token_transfers
    WHERE amount_usd IS NOT NULL

    ORDER BY amount_usd DESC
    LIMIT 1000
    Last run: over 1 year ago
    BLOCK_TIMESTAMP
    TX_HASH
    ORIGIN_FROM_ADDRESS
    ORIGIN_TO_ADDRESS
    CONTRACT_ADDRESS
    AMOUNT_USD
    SYMBOL
    TOKEN_PRICE
    1
    		2023-01-26 08:42:35.0000x35e2e4dea6946b68b987fcb4430234b0163552f4395b7197811a2185eb096f270xb1d37a3b73f07682828e002b6ebfd774fa6cae140xa4108aa1ec4967f8b52220a4f7e94a8201f2d9060x1b3c515f58857e141a966b33182f2f3feecc10e91.22739614591555e+71USK1.06
    2
    		2023-01-26 08:43:11.0000xd73b17f4bc5a9d746e0b7102bb521fe5d66737ce6f48167fbcd72c72f2f251590xb1d37a3b73f07682828e002b6ebfd774fa6cae140xa4108aa1ec4967f8b52220a4f7e94a8201f2d9060x96543ef8d2c75c26387c1a319ae69c0bee6f3fe76.05952740108692e+70KUJI0.523311
    3
    		2022-07-19 17:16:32.0000x54d4d4baf991c51635443ba943d6169ff24ec4e82efb515e4f3bed2def9017670x13799c1aea48995971d5b2e5a5b69f827083202f0xa4108aa1ec4967f8b52220a4f7e94a8201f2d9060x2c4f1df9c7de0c59778936c9b145ff56813f32951.11794946316844e+70MNTL0.096548
    4
    		2022-11-01 13:11:47.0000x35937ed72826da00bdaa784b4b13e703fecbb89e168f900276860f9c68f87d760xb0b258049f6f218ec05a357bdfd747959a077ad70xa4108aa1ec4967f8b52220a4f7e94a8201f2d9060xe9b076b476d8865cdf79d1cf7df420ee397a7f753.48419554435977e+67FUND0.300901
    5
    		2022-03-15 19:12:17.0000x2dfa2f824f3307ab5657707de5491c7406fa0dc475ad9378b6f47420c36961030xd3e5928cde25ff12711210f8ab428c505c5c2a7a0xa4108aa1ec4967f8b52220a4f7e94a8201f2d9060x70edf1c215d0ce69e7f16fd4e6276ba0d99d4de78.51975034190325e+66CHEQ0.073578
    6
    		2022-08-01 07:15:54.0000x8fd7391b8d8ceeb907f891b0e2fc479206c837b06d3446facf03794161e9d75c0x30601d1ac520b7c78d46306409c346ac7794090b0xd26114cd6ee289accf82350c8d8487fedb8a0c070xd26114cd6ee289accf82350c8d8487fedb8a0c072.59706583925895e+59OMG2.242869834
    7
    		2022-08-01 07:11:57.0000xad9e98bc7b4146d19473a1ec8601d946840b91d0c2a8da711841cdfa3739b8100x30601d1ac520b7c78d46306409c346ac7794090b0xd26114cd6ee289accf82350c8d8487fedb8a0c070xd26114cd6ee289accf82350c8d8487fedb8a0c078.65688613086317e+58OMG2.242869834
    8
    		2023-04-25 08:30:23.0000xae5df58211a8f2bc9dcc7040c2a15a2762bf2a149755b8c83d6e27eca557a9b60x1a3177e239d60438078c7c36877a5ecd36d4c9910x0f5d2fb29fb7d3cfee444a200298f468908cc9420x0f5d2fb29fb7d3cfee444a200298f468908cc9426.23204959243132e+58MANA0.539317
    9
    		2023-04-25 09:02:11.0000x8fff10a34ba8bee4f2c37aaf75fb890e1d146adbecb696bb8a67eeb03bb340ac0xb038e798dd142ea6b3183c87d78b12d58f65f6290x0f5d2fb29fb7d3cfee444a200298f468908cc9420x0f5d2fb29fb7d3cfee444a200298f468908cc9421.87963742336326e+58MANA0.543677
    10
    		2023-10-06 14:44:47.0000xc9b19be499695b68f4da5c1c9bbbc8ccabb72f76624b63f1b6dc392c1da1f7180xee9039d957d313546e6edcab425aa18b7bfd9e450x0f5d2fb29fb7d3cfee444a200298f468908cc9420x0f5d2fb29fb7d3cfee444a200298f468908cc9421.02527720569444e+58MANA0.296557
    11
    		2023-10-06 14:40:23.0000x4f1a39d727afe07a74e1d960ba55997c418709229d25adac0f05b83e5464f5320xee9039d957d313546e6edcab425aa18b7bfd9e450x0f5d2fb29fb7d3cfee444a200298f468908cc9420x0f5d2fb29fb7d3cfee444a200298f468908cc9421.02527720569444e+58MANA0.296557
    12
    		2022-08-09 02:44:15.0000xae8a4da67096438e845129e781a54416cfefea4694b4deaa0bbb482e981b693a0x2d70cb56705dc7f0b448ec8aadc475fbaee780e20x2f32b39023da7d6a6486a85d12b346eb9c2a0d199.98251636872448e+57FER0.08621069396
    13
    		2022-08-02 04:05:42.0000x91eb4de2a9d8048fbdf15f2a64228784ebc50e9bc1bacb9a78c069de7477fdff0x2d70cb56705dc7f0b448ec8aadc475fbaee780e20x839e71613f9aa06e5701cf6de63e303616b0dde38.90491010801919e+53VVS0.000007690430466
    14
    		2023-06-05 15:34:11.0000xe917dc7c8db0a916a2568af4e333872dc2af478861c117bce399817b0d6cd8c20x489238eb374db471bfcd7009dea9e0747d84724b0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b0x087b81c5312bcb45179a05aff5aec5cdddc789b68.89426490879783e+50GRE9.470078207e-7
    15
    		2023-06-08 09:50:59.0000xf2ad666ffc6e8c44ff86243a00514d3f5f29cd2440407483aabb399c2c7c4a3a0x4404da011d10bc73af2ec94798ffe66ac8a541fa0xd8be50f1642621cddc0a0bb8a7041213f382e4bf0x087b81c5312bcb45179a05aff5aec5cdddc789b68.80513521182703e+50GRE7.336271147e-7
    16
    		2023-06-05 09:18:23.0000xdaa8d26ec4737c098289f98be2f24c7e961ee8632069d65736417c05cde402ca0x489238eb374db471bfcd7009dea9e0747d84724b0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b0x087b81c5312bcb45179a05aff5aec5cdddc789b66.85644705435606e+50GRE0.000001153146825
    17
    		2023-06-05 07:08:59.0000x4c2311ae06867766f1d7dfb751886664c1a7d503c4095d50760f4d259252474a0x76f36d497b51e48a288f03b4c1d7461e92247d5e0x2d2a7d56773ae7d5c7b9f1b57f7be05039447b4d0x087b81c5312bcb45179a05aff5aec5cdddc789b66.75867048118856e+50GRE9.196429307e-7
    18
    		2023-06-05 07:08:59.0000x0ba73c78b9dc3e8fa5ad7003fd7777e0dcfc7e0d00d882b5513d705b62bedb440x76f36d497b51e48a288f03b4c1d7461e92247d5e0x2d2a7d56773ae7d5c7b9f1b57f7be05039447b4d0x087b81c5312bcb45179a05aff5aec5cdddc789b66.75866980532152e+50GRE9.196429307e-7
    19
    		2023-12-01 14:08:47.0000x8c5d00b00f897b32e8c0950dafb3f5595006f216e90908abcd8fca45fc1771cf0x81c2082e1245fca927fadbeb03635cb833489b000x7a250d5630b4cf539739df2c5dacb4c659f2488d0x087b81c5312bcb45179a05aff5aec5cdddc789b65.87514709255262e+50GRE1.497964303e-8
    20
    		2023-12-01 14:08:47.0000x8c5d00b00f897b32e8c0950dafb3f5595006f216e90908abcd8fca45fc1771cf0x81c2082e1245fca927fadbeb03635cb833489b000x7a250d5630b4cf539739df2c5dacb4c659f2488d0x087b81c5312bcb45179a05aff5aec5cdddc789b65.87514709255262e+50GRE1.497964303e-8
    ...
    1000
    265KB
    24s