flipside

    2024-02-06 09:05 AM
    AnalyticSages2024-02-06 09:05 AM
    Updated 2024-02-06
    --ethereum.core.ez_token_transfers
    --ethereum.core.dim_labels

    SELECT
    block_timestamp,
    tx_hash,
    origin_from_address,
    l.label,
    l.address_name,
    amount_usd,
    symbol
    FROM ethereum.core.ez_token_transfers t
    JOIN ethereum.core.dim_labels l
    ON l.address = t.contract_address

    WHERE amount_usd IS NOT NULL

    ORDER BY 6 DESC

    LIMIT 1000
    Last run: about 1 year ago
    BLOCK_TIMESTAMP
    TX_HASH
    ORIGIN_FROM_ADDRESS
    LABEL
    ADDRESS_NAME
    AMOUNT_USD
    SYMBOL
    1
    		2023-01-26 08:42:35.0000x35e2e4dea6946b68b987fcb4430234b0163552f4395b7197811a2185eb096f270xb1d37a3b73f07682828e002b6ebfd774fa6cae14gravitygravity: general contract1.22739614591555e+71USK
    2
    		2023-01-26 08:43:11.0000xd73b17f4bc5a9d746e0b7102bb521fe5d66737ce6f48167fbcd72c72f2f251590xb1d37a3b73f07682828e002b6ebfd774fa6cae14kujikuji6.05952740108692e+70KUJI
    3
    		2022-07-19 17:16:32.0000x54d4d4baf991c51635443ba943d6169ff24ec4e82efb515e4f3bed2def9017670x13799c1aea48995971d5b2e5a5b69f827083202fassetmantleassetmantle (mntl)1.11794946316844e+70MNTL
    4
    		2022-11-01 13:11:47.0000x35937ed72826da00bdaa784b4b13e703fecbb89e168f900276860f9c68f87d760xb0b258049f6f218ec05a357bdfd747959a077ad7unificationunification3.48419554435977e+67FUND
    5
    		2022-03-15 19:12:17.0000x2dfa2f824f3307ab5657707de5491c7406fa0dc475ad9378b6f47420c36961030xd3e5928cde25ff12711210f8ab428c505c5c2a7acheqdcheqd8.51975034190325e+66CHEQ
    6
    		2022-08-01 07:15:54.0000x8fd7391b8d8ceeb907f891b0e2fc479206c837b06d3446facf03794161e9d75c0x30601d1ac520b7c78d46306409c346ac7794090bomg network (omg)omg network (omg)2.59706583925895e+59OMG
    7
    		2022-08-01 07:11:57.0000xad9e98bc7b4146d19473a1ec8601d946840b91d0c2a8da711841cdfa3739b8100x30601d1ac520b7c78d46306409c346ac7794090bomg network (omg)omg network (omg)8.65688613086317e+58OMG
    8
    		2023-04-25 08:30:23.0000xae5df58211a8f2bc9dcc7040c2a15a2762bf2a149755b8c83d6e27eca557a9b60x1a3177e239d60438078c7c36877a5ecd36d4c991decentralanddecentraland6.23204959243132e+58MANA
    9
    		2023-04-25 09:02:11.0000x8fff10a34ba8bee4f2c37aaf75fb890e1d146adbecb696bb8a67eeb03bb340ac0xb038e798dd142ea6b3183c87d78b12d58f65f629decentralanddecentraland1.87963742336326e+58MANA
    10
    		2023-10-06 14:40:23.0000x4f1a39d727afe07a74e1d960ba55997c418709229d25adac0f05b83e5464f5320xee9039d957d313546e6edcab425aa18b7bfd9e45decentralanddecentraland1.02527720569444e+58MANA
    11
    		2023-10-06 14:44:47.0000xc9b19be499695b68f4da5c1c9bbbc8ccabb72f76624b63f1b6dc392c1da1f7180xee9039d957d313546e6edcab425aa18b7bfd9e45decentralanddecentraland1.02527720569444e+58MANA
    12
    		2022-08-09 02:44:15.0000xae8a4da67096438e845129e781a54416cfefea4694b4deaa0bbb482e981b693a0x2d70cb56705dc7f0b448ec8aadc475fbaee780e2ferfer9.98251636872448e+57FER
    13
    		2022-08-02 04:05:42.0000x91eb4de2a9d8048fbdf15f2a64228784ebc50e9bc1bacb9a78c069de7477fdff0x2d70cb56705dc7f0b448ec8aadc475fbaee780e2vvsvvs (vvs)8.90491010801919e+53VVS
    14
    		2023-06-05 15:34:11.0000xe917dc7c8db0a916a2568af4e333872dc2af478861c117bce399817b0d6cd8c20x489238eb374db471bfcd7009dea9e0747d84724bGREENETHGREENETH8.89426490879783e+50GRE
    15
    		2023-06-08 09:50:59.0000xf2ad666ffc6e8c44ff86243a00514d3f5f29cd2440407483aabb399c2c7c4a3a0x4404da011d10bc73af2ec94798ffe66ac8a541faGREENETHGREENETH8.80513521182703e+50GRE
    16
    		2023-06-05 09:18:23.0000xdaa8d26ec4737c098289f98be2f24c7e961ee8632069d65736417c05cde402ca0x489238eb374db471bfcd7009dea9e0747d84724bGREENETHGREENETH6.85644705435606e+50GRE
    17
    		2023-06-05 07:08:59.0000x4c2311ae06867766f1d7dfb751886664c1a7d503c4095d50760f4d259252474a0x76f36d497b51e48a288f03b4c1d7461e92247d5eGREENETHGREENETH6.75867048118856e+50GRE
    18
    		2023-06-05 07:08:59.0000x0ba73c78b9dc3e8fa5ad7003fd7777e0dcfc7e0d00d882b5513d705b62bedb440x76f36d497b51e48a288f03b4c1d7461e92247d5eGREENETHGREENETH6.75866980532152e+50GRE
    19
    		2023-12-01 14:08:47.0000x8c5d00b00f897b32e8c0950dafb3f5595006f216e90908abcd8fca45fc1771cf0x81c2082e1245fca927fadbeb03635cb833489b00GREENETHGREENETH5.87514709255262e+50GRE
    20
    		2023-12-01 14:08:47.0000x8c5d00b00f897b32e8c0950dafb3f5595006f216e90908abcd8fca45fc1771cf0x81c2082e1245fca927fadbeb03635cb833489b00GREENETHGREENETH5.87514709255262e+50GRE
    ...
    1000
    189KB
    41s