flipside

    GrabSG - Voucher Used over Time
    cloudr3nGrabSG - Voucher Used over Time
    Updated 2024-02-14
    SELECT
    date(block_timestamp) as day,
    sum(decoded_log:ERC20TokenValue::integer*pow(10,-6)) as amount,
    sum(amount) over (order by day asc) cumu_amount
    FROM
    polygon.core.ez_decoded_event_logs
    WHERE
    contract_address=lower('0xd2d74e2136d60a3c0d252c6de4102a82f2511def')
    and event_name='MerchantPayment'
    and decoded_log:ERC20Token='0xdc3326e71d45186f113a2f448984ca0e8d201995'
    --and decoded_log:tokenIds!=[3]
    GROUP BY
    day
    ORDER BY
    day desc
    Last run: about 1 year agoAuto-refreshes every 24 hours
    DAY
    AMOUNT
    CUMU_AMOUNT
    1
    		2024-02-14 00:00:00.0001418373.7
    2
    		2024-02-09 00:00:00.000118359.7
    3
    		2024-02-08 00:00:00.0001918358.7
    4
    		2024-02-04 00:00:00.0003218339.7
    5
    		2024-01-31 00:00:00.00012618307.7
    6
    		2024-01-30 00:00:00.0001018181.7
    7
    		2024-01-28 00:00:00.00014018171.7
    8
    		2024-01-27 00:00:00.000518031.7
    9
    		2024-01-25 00:00:00.00043118026.7
    10
    		2024-01-24 00:00:00.0001117595.7
    11
    		2024-01-23 00:00:00.0002417584.7
    12
    		2024-01-21 00:00:00.00021817560.7
    13
    		2024-01-20 00:00:00.000217342.7
    14
    		2024-01-19 00:00:00.00042717340.7
    15
    		2024-01-18 00:00:00.0002516913.7
    16
    		2024-01-16 00:00:00.00014216888.7
    17
    		2024-01-14 00:00:00.00023316746.7
    18
    		2024-01-13 00:00:00.0004716513.7
    19
    		2024-01-12 00:00:00.0002416466.7
    20
    		2024-01-11 00:00:00.0002716442.7
    ...
    141
    5KB
    12s