# Downloading all "Transfer" transactions of a BSC token from a date

**URL:** <https://community.bitquery.io/t/downloading-all-transfer-transactions-of-a-bsc-token-from-a-date/950>\
**Category:** GraphQL API\
**Created:** [March 31, 2022, 3:28pm UTC](https://community.bitquery.io/t/downloading-all-transfer-transactions-of-a-bsc-token-from-a-date/950 "2022-03-31T15:28:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rockandgrohl](https://sea2.discourse-cdn.com/flex016/user_avatar/community.bitquery.io/rockandgrohl/32/499_2.png) [@rockandgrohl](https://community.bitquery.io/u/rockandgrohl)\
**Post date:** [March 31, 2022, 3:28pm UTC](https://community.bitquery.io/t/downloading-all-transfer-transactions-of-a-bsc-token-from-a-date/950/1 "2022-03-31T15:28:07Z")

</div>

Hi guys, hopefully it’s a quick one, please be gentle as I’m a total noob.

I’m doing some investigatory work and need to export to CSV all transactions from a BSC token, with a few parameters:

Token address: 0x8076c74c5e3f5852037f31ff0093eeb8c8add8d3  
Token name: Safemoon

On BSCScan, you can see the “Method” has a few names - I want to only exclude “Migrate” - so I’m only looking for “Transfer” or “Swap exact tokens for ETH” (or others)

And I’d like to only see records from AFTER 2021-12-29 15:59:59 UTC

Based on estimations, this should result in some 60,000 or so records.

I’d like to see the BSC / USD equivalent of the Safemoon tokens that were transferred.

My reasoning for this is that the Safemoon team enacted a 100% tax after the above date and so anybody that transferred tokens had them effectively confiscated with no route to recover them.

This is what I have so far:

query MyQuery {  
ethereum(network: bsc) {  
smartContractCalls(  
smartContractAddress: {is: “0x8076c74c5e3f5852037f31ff0093eeb8c8add8d3”}  
time: {since: “2021-12-29T16:00:00”}  
smartContractMethod: {is: “transfer”}

```
) {
  count
}

```

}  
}

This results in 68,605 records which sounds right, but I want to list them all individually and export them rather than a count.

Thank you!

---

<div class="post-metadata">

**Author:** ![aman](https://avatars.discourse-cdn.com/v4/letter/a/90ced4/32.png) [@aman](https://community.bitquery.io/u/aman)\
**Post date:** [April 1, 2022, 4:43am UTC](https://community.bitquery.io/t/downloading-all-transfer-transactions-of-a-bsc-token-from-a-date/950/2 "2022-04-01T04:43:55Z")

</div>

The total count is a lot higher

```auto
query MyQuery {
  ethereum(network: bsc) {
    smartContractCalls(
      smartContractAddress: {is: "0x8076c74c5e3f5852037f31ff0093eeb8c8add8d3"}
      time: {since: "2021-12-29T16:00:00"}
      smartContractMethod: {not: "Migrate"}
    ) {
      count
    }
  }
}

```

![image](https://us1.discourse-cdn.com/flex016/uploads/bitquery/original/1X/ada401cb37e679d4934c46af8ee9024a170d24e6.png)

I am attaching some links that could help you:  
1, [Tabular Data Available and it's downloadable in CSV](https://community.bitquery.io/t/tabular-data-available-and-its-downloadable-in-csv/750)  
2. [safemoon smartcontract](https://graphql.bitquery.io/ide/safemoon-smartcontract)

You can check articles on community and graphql queries on [https://graphql.bitquery.io/](https://graphql.bitquery.io/)

Hope this helps

---

<div class="post-metadata">

**Author:** ![rockandgrohl](https://sea2.discourse-cdn.com/flex016/user_avatar/community.bitquery.io/rockandgrohl/32/499_2.png) [@rockandgrohl](https://community.bitquery.io/u/rockandgrohl)\
**Post date:** [April 1, 2022, 9:42am UTC](https://community.bitquery.io/t/downloading-all-transfer-transactions-of-a-bsc-token-from-a-date/950/3 "2022-04-01T09:42:28Z")

</div>

Hi, I think there’s an issue with the “not” because when you remove it, the total is still

“count”: 1161317

So if I say "not: “migrate”, or just remove it entirely, the count is still 1,161,317 (actually it’s 1,161,318)

For that reason I’m sticking to just “transfer” for now, but I’ll need to do an additional transaction to get swap exact eth for tokens because I’ll need to log purchases as well as transfers.