flipside

    fixed-purple
    datavortexfixed-purple
    Updated 2025-04-13
    SELECT distinct token_address, price, symbol hour FROM ethereum.price.ez_prices_hourly



    -- 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 WBTC
    --0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 WETH
    --0x3073f7aaa4db83f95e9fff17424f71d4751a3073 MOVE
    --0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 USDC
    --0xdac17f958d2ee523a2206206994597c13d831ec7 USDT

    /*

    WITH base_events AS (
    SELECT
    tx_hash,
    sender,
    block_timestamp,
    success,
    event.value:type::string AS event_type,
    event.value:data:amount::string AS amount,
    event.value:data:executor_fee::string AS executor_fee,
    event.value:data:executor_address::string AS executor_address,
    event.value:data:executor_deposit_address::string AS executor_deposit_address,
    event.value:data:coin_type::string AS coin_type,
    event.value:data:dst_eid::string AS dst_eid,
    event.value:data:from_address::string AS from_address,
    event.value:data:store::string AS store,
    event.value:data:account::string AS account,
    event.value:data:guid::string AS oft_guid,
    event.value:data:amount_received_ld::string AS amount_received_ld,
    event.value:data:amount_sent_ld::string AS amount_sent_ld
    FROM
    movement.core.fact_transactions,
    LATERAL FLATTEN(input => events) AS event
    WHERE
    SPLIT_PART(payload_function, '::', 1) = '0x4d2969d384e440db9f1a51391cfc261d1ec08ee1bdf7b9711a6c05d485a4110a'
    Last run: about 1 month ago
    TOKEN_ADDRESS
    PRICE
    HOUR
    1
    		0xdac17f958d2ee523a2206206994597c13d831ec70.9997632025-04-13 10:00:00.000
    2
    		0x1cdd2eab61112697626f7b4bb0e23da4febf7b7c0.998542025-04-13 10:00:00.000
    3
    		0x1cdd2eab61112697626f7b4bb0e23da4febf7b7c0.9940172025-04-13 09:00:00.000
    4
    		0xdac17f958d2ee523a2206206994597c13d831ec70.9998622025-04-13 09:00:00.000
    5
    		0x1cdd2eab61112697626f7b4bb0e23da4febf7b7c0.9975262025-04-13 08:00:00.000
    6
    		0xdac17f958d2ee523a2206206994597c13d831ec70.9998752025-04-13 08:00:00.000
    7
    		0xdac17f958d2ee523a2206206994597c13d831ec70.9997992025-04-13 07:00:00.000
    8
    		0x1cdd2eab61112697626f7b4bb0e23da4febf7b7c0.9953392025-04-13 07:00:00.000
    9
    		0xdac17f958d2ee523a2206206994597c13d831ec70.9997882025-04-13 06:00:00.000
    10
    		0x1cdd2eab61112697626f7b4bb0e23da4febf7b7c1.0022025-04-13 06:00:00.000
    11
    		0xdac17f958d2ee523a2206206994597c13d831ec70.9997062025-04-13 05:00:00.000
    12
    		0x1cdd2eab61112697626f7b4bb0e23da4febf7b7c1.0012025-04-13 05:00:00.000
    13
    		0xdac17f958d2ee523a2206206994597c13d831ec70.9997212025-04-13 04:00:00.000
    14
    		0x1cdd2eab61112697626f7b4bb0e23da4febf7b7c0.9990052025-04-13 04:00:00.000
    15
    		0x1cdd2eab61112697626f7b4bb0e23da4febf7b7c0.995062025-04-13 03:00:00.000
    16
    		0xdac17f958d2ee523a2206206994597c13d831ec70.9998722025-04-13 03:00:00.000
    17
    		0x1cdd2eab61112697626f7b4bb0e23da4febf7b7c1.12025-04-13 02:00:00.000
    18
    		0xdac17f958d2ee523a2206206994597c13d831ec70.9999052025-04-13 02:00:00.000
    19
    		0x1cdd2eab61112697626f7b4bb0e23da4febf7b7c1.0992025-04-13 01:00:00.000
    20
    		0xdac17f958d2ee523a2206206994597c13d831ec70.9998952025-04-13 01:00:00.000
    ...
    92098
    7MB
    5s