A client for Dune Analytics  

This is currently in pre-alpha state with no error handling, but can get the job done

Installation

``shell script
npm i -g dune-client
`

Then set your env variables (todo: better auth for cli):

`shell script


Your session cookie from browser

export SESSION=

The client needs one of your queries to use as a workspace

export QUERY_ID=
`

Usage

`shell script


table mode

$ dune-cli --table 'select block_number, block_time from ethereum.traces limit 5'
submitting: waiting
submitting: done
executing: waiting
executing: done
fetching results
fetched 5 rows
┌─────────┬──────────────┬────────────────────────┐
│ (index) │ block_number │ block_time │
├─────────┼──────────────┼────────────────────────┤
│ 0 │ 46147 │ '2015-08-07T03:30:33Z' │
│ 1 │ 46169 │ '2015-08-07T03:36:53Z' │
│ 2 │ 46170 │ '2015-08-07T03:37:10Z' │
│ 3 │ 46194 │ '2015-08-07T03:43:03Z' │
│ 4 │ 46205 │ '2015-08-07T03:46:15Z' │
└─────────┴──────────────┴────────────────────────┘

JSON mode

$ dune-cli 'select block_number, block_time from ethereum.traces limit 5'
submitting: waiting
submitting: done
executing: waiting
executing: done
fetching results
fetched 5 rows
[
{ block_number: 46147, block_time: '2015-08-07T03:30:33Z' },
{ block_number: 46169, block_time: '2015-08-07T03:36:53Z' },
{ block_number: 46170, block_time: '2015-08-07T03:37:10Z' },
{ block_number: 46194, block_time: '2015-08-07T03:43:03Z' },
{ block_number: 46205, block_time: '2015-08-07T03:46:15Z' }
]

Piping input and output (progress messages are printed to stderr)

$ echo 'select block_number, block_time from ethereum.traces limit 5' | dune-cli | jq '.[2:4]'
submitting: waiting
submitting: done
executing: waiting
executing: done
fetching results
fetched 5 rows
[
{
"block_number": 46170,
"block_time": "2015-08-07T03:37:10Z"
},
{
"block_number": 46194,
"block_time": "2015-08-07T03:43:03Z"
}
]
`

Use as a package

`javascript
const DuneClient = require('dune-client')

async function main() {
const dune = new DuneClient(session, queryId)
const rows = await dune.query('select * from ethereum.traces limit 10')
console.log(rows)
}
``