This is a Next.js project bootstrapped with create-next-app.

Getting Started

First, run the development server:

npm run dev
# or
yarn dev

Open http://localhost:3000 with your browser to see the result.

You can start editing the page by modifying pages/index.tsx. The page auto-updates as you edit the file.

API routes can be accessed on http://localhost:3000/api/hello. This endpoint can be edited in pages/api/hello.ts.

The pages/api directory is mapped to /api/*. Files in this directory are treated as API routes instead of React pages.

Queries

select
  *
from
  usery76xn3t.transaction_log t
where
  t.transaction_to = '0xd3b5d9a561c293fb42b446fe7e237daa9bf9aa84'
and
  t.transaction_from = '0xbd178fe085a12505473a96a57d6f2ce0bbf3a490'

select
  *
from
  usery76xn3t.transaction_log t
where
  t.transaction_to = '0xd3b5d9a561c293fb42b446fe7e237daa9bf9aa84'
and
  t.name = 'Transfer'

select
  sum(cast(params[3].value as float(38,0)))
from
  usery76xn3t.transaction_log t
where
  t.transaction_to = '0xd3b5d9a561c293fb42b446fe7e237daa9bf9aa84'
and
  t.name = 'Transfer'

SELECT
  SUM(CAST(params[3].value as FLOAT(38,0))) / POW(10, 18) AS total_sum,
  EXTRACT(MONTH FROM t.timestamp) AS transaction_month
FROM
  usery76xn3t.transaction_log t
WHERE
  t.transaction_to = '0xd3b5d9a561c293fb42b446fe7e237daa9bf9aa84'
  AND t.name = 'Transfer'
  AND t.transaction_function_name = 'deposit'
GROUP BY
  EXTRACT(MONTH FROM t.timestamp)

SELECT
  SUM(CAST(params[3].value as FLOAT(38,0))) / POW(10, 18) AS total_sum,
  EXTRACT(MONTH FROM t.timestamp) AS transaction_month
FROM
  usery76xn3t.transaction_log t
WHERE
  t.transaction_to = '0xd3b5d9a561c293fb42b446fe7e237daa9bf9aa84'
  AND t.name = 'Transfer'
  AND t.transaction_function_name = 'withdraw'
GROUP BY
  EXTRACT(MONTH FROM t.timestamp)