The latest transactions table fails to show what we really want to see, the last parsed / published / fetched transactions.
This SQL request will show the created transactions from the last date that appears in the transaction table:
```mysql
SELECT a.id, a.created_at_utc
FROM transaction a
INNER JOIN (
SELECT DATE(MAX(created_at_utc)) max_date
FROM transaction
) b ON DATE(a.created_at_utc) = b.max_date;
```
We're mostly interested by big insider buys, the table should display this information better. The number of transactions is not very useful as it gives no indication to what is behind.
We're mostly interested by big insider buys, the table should display this information better. The number of transactions is not very useful as it gives no indication to what is behind.
The latest transactions table fails to show what we really want to see, the last parsed / published / fetched transactions.
This SQL request will show the created transactions from the last date that appears in the transaction table:
To kill two birds with one stone, the other table can be changed to accept multiple durations, last week, last month, last 6 months...
We're mostly interested by big insider buys, the table should display this information better. The number of transactions is not very useful as it gives no indication to what is behind.
fixed by #28