'How can I get summary of transaction history from etherscan to example Time Diff between first and last for a fraud detection model
I want to create data prep script that pulls live data from the blokchcain (possibly using a centralized cache or API like etherscan). I'm wondering what is easy way to scrape all this data from blockchain in Python? I need the following columns for my fraud detection model.
Here is a description of the rows in the dataset:
Address: The address of the ethereum account
FLAG: Whether the transaction is fraud or not (This is our "target" column) Avg min between sent tnx: Average time between sent transactions for account in minutes
Avgminbetweenreceivedtnx: Average time between received transactions for account in minutes
TimeDiffbetweenfirstand_last(Mins): Time difference between the first and last transaction
Sent_tnx: Total number of sent normal transactions
Received_tnx: Total number of received normal transactions
NumberofCreated_Contracts: Total Number of created contract transactions
UniqueReceivedFrom_Addresses: Total Unique addresses from which account received transactions
UniqueSentTo_Addresses20: Total Unique addresses from which account sent transactions
MinValueReceived: Minimum value in Ether ever received
MaxValueReceived: Maximum value in Ether ever received
AvgValueReceived: Average value in Ether ever received
MinValSent: Minimum value of Ether ever sent
MaxValSent: Maximum value of Ether ever sent
AvgValSent: Average value of Ether ever sent
MinValueSentToContract: Minimum value of Ether sent to a contract
ERC20MostRecTokenType: Most received token for account via ERC20 transactions
The dataset comes from this link: https://www.kaggle.com/vagifa/ethereum-frauddetection-dataset/version/1
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|