with tbl1 AS

SELECT footprint_utils.get(

'/v2/chain/transactions',

{

'chain': 'zkSync Era',

'start_time': '2022-07-01 00:00:00',

'end_time': '2023-08-10 00:00:00',

'from_address': lower ('{{address}}')

}

) as response

,tbl2 as (SELECT

VALUE:"block_number" AS "block_number" ,

VALUE:"value" / pow(10,18) AS "value",

VALUE:"block_timestamp" AS "block_timestamp",

VALUE:"hash" AS "hash",

VALUE:"receipt_contract_address" AS "receipt_contract_address",

VALUE:"from_address" AS "from_address",

VALUE:"to_address" AS "to_address",

VALUE: "gas" AS "gas",

VALUE: "max_fee_per_gas" AS "max_fee_per_gas",

VALUE: "max_priority_fee_per_gas" AS "max_priority_fee_per_gas",

VALUE: "nonce" AS "nonce",

VALUE: "receipt_status" AS "receipt_status",

VALUE: "transaction_index" AS "transaction_index",

VALUE: "transaction_type" AS "transaction_type",

VALUE: "receipt_gas_used" AS "receipt_gas_used",

VALUE: "gas_price"/ pow (10,18) AS "gas_price",