Decred unrevoked missed tickets.

height.txt

620744

queries.sh

#!/bin/sh

psql -U dcrdata -d dcrdata -A -t -c "SELECT best_block_height FROM meta;" > height.txt
psql -U dcrdata -d dcrdata -c "COPY (SELECT ticket_hash, height, trunc((price*1e8)::numeric) AS price FROM misses INNER JOIN tickets ON ticket_hash = tx_hash WHERE spend_tx_db_id IS NULL ORDER BY height, ticket_hash) TO STDOUT WITH CSV HEADER DELIMITER ',';" > unrevoked_misses.csv
echo "$(psql -U dcrdata -d dcrdata -A -t -c "SELECT trunc(SUM(price)::numeric, 8) FROM misses INNER JOIN tickets ON ticket_hash = tx_hash WHERE spend_tx_db_id IS NULL;") DCR" > sum.txt

sum.txt

187816.29841320 DCR

unrevoked_misses.csv