#### Get blockhash https://polkadot.subscan.io/block/8328589
blockHash: `0xc122411bf315eb6643eb5946b3b1a4e641c3db24a0ebf9bd3f73d6e4bc333092`
timestamp: `2021-12-28 07:17:00 (+UTC)`
#### Fetch funds for ongoing crowdloans at blockHeight 8328589
https://polkadot.js.org/apps/?rpc=wss%3A%2F%2Frpc.polkadot.io#/chainstate <- blockHash
```
[
[
[
2,028
]
{
depositor: 13pQt6LnK2tXZtXbiQ6PBYikEoNTi6MXkeBdQCeyR9hm6k1p
verifier: null
deposit: 5,000,000,000,000
raised: 11,822,680,000,000
end: 8,801,000
cap: 50,000,000,000,000,000
lastContribution: {
Ending: 8,318,046
}
firstPeriod: 7
lastPeriod: 14
trieIndex: 22
}
]
[
[
2,035
]
{
depositor: 1zunQTaRifL1XULrRLPgSbf6YbkZnjeJiQfwZuxVoJR5mhA
verifier: null
deposit: 5,000,000,000,000
raised: 298,940,826,552,099
end: 9,388,800
cap: 80,000,000,000,000,000
lastContribution: {
Ending: 8,318,974
}
firstPeriod: 7
lastPeriod: 14
trieIndex: 24
}
]
[
[
2,032
]
{
depositor: 14gZicKnmFj3238utrQ6B7CGWBeNGntKUyoUHqoTN85FnHWk
verifier: null
deposit: 5,000,000,000,000
raised: 10,563,933,316,304,004
end: 9,388,800
cap: 500,000,000,000,000,000
lastContribution: {
Ending: 8,319,001
}
firstPeriod: 7
lastPeriod: 14
trieIndex: 15
}
]
[
[
2,021
]
{
depositor: 12LxQoLA9hebiMSPT3G7ixz73LLuYomMNuRLqX7c9bRWxDFG
verifier: null
deposit: 5,000,000,000,000
raised: 67,841,402,419,511,901
end: 9,388,800
cap: 500,000,000,000,000,000
lastContribution: {
Ending: 8,319,066
}
firstPeriod: 7
lastPeriod: 14
trieIndex: 20
}
]
[
[
2,027
]
{
depositor: 14r48SVtMrJKxUWD9ijDy8aQU3asTXja8qny9mzXTutdByju
verifier: null
deposit: 5,000,000,000,000
raised: 61,146,597,570,835
end: 9,388,800
cap: 60,000,000,000,000,000
lastContribution: {
Ending: 8,315,208
}
firstPeriod: 7
lastPeriod: 14
trieIndex: 16
}
]
[
[
2,008
]
{
depositor: 13QrQ7Xos6bseivYW3xRjvi4T2iHihxVnTrQgyHmWGTNv972
verifier: null
deposit: 5,000,000,000,000
raised: 115,964,254,641,249
end: 9,388,800
cap: 50,000,000,000,000,000
lastContribution: {
Ending: 8,317,101
}
firstPeriod: 7
lastPeriod: 14
trieIndex: 13
}
]
[
[
2,000
]
{
depositor: 1muqpuFcWvy1Q3tf9Tek882A6ngz46bWPsV6sWiYccnVjKb
verifier: null
deposit: 5,000,000,000,000
raised: 325,159,802,323,576,263
end: 8,179,200
cap: 500,000,000,000,000,000
lastContribution: {
Ending: 7,756,102
}
firstPeriod: 6
lastPeriod: 13
trieIndex: 0
}
]
[
[
2,002
]
{
depositor: 14e4GmLj5CccWe9Rant9q6yQro1oysqvKiBiHcpCRoscZ1yY
verifier: null
deposit: 5,000,000,000,000
raised: 97,524,874,268,038,525
end: 8,179,200
cap: 500,000,000,000,000,000
lastContribution: {
Ending: 8,159,302
}
firstPeriod: 6
lastPeriod: 13
trieIndex: 5
}
]
[
[
2,017
]
{
depositor: 16RzEcgXVzXXn2gEQbqqp74Pw7MJSb7PKtz29BhVZmpXBKRn
verifier: null
deposit: 5,000,000,000,000
raised: 10,652,411,476,305
end: 9,388,800
cap: 4,000,000,000,000,000
lastContribution: {
Ending: 8,316,804
}
firstPeriod: 7
lastPeriod: 14
trieIndex: 23
}
]
[
[
2,011
]
{
depositor: 14fhPR28n9EHZitNyf6wjYZVBPwKgcgogVjJPTzvCcb8qi9G
verifier: null
deposit: 5,000,000,000,000
raised: 6,203,810,528,169,667
end: 9,388,800
cap: 77,500,000,000,000,000
lastContribution: {
Ending: 8,318,748
}
firstPeriod: 7
lastPeriod: 14
trieIndex: 19
}
]
[
[
2,004
]
{
depositor: 12KHAurRWMFJyxU57S9pQerHsKLCwvWKM1d3dKZVx7gSfkFJ
verifier: {
Sr25519: 0x16732d1a045c9351606743bf786aad1db344e5dd51e15d6417deb3828044080e
}
deposit: 5,000,000,000,000
raised: 357,599,313,927,924,796
end: 8,179,199
cap: 1,000,000,000,000,000,000
lastContribution: {
Ending: 7,815,351
}
firstPeriod: 6
lastPeriod: 13
trieIndex: 2
}
]
[
[
2,019
]
{
depositor: 12EXcpt1CwnSAF9d7YWrh91bQw6R5wmCpJUXPWi7vn2CZFpJ
verifier: null
deposit: 5,000,000,000,000
raised: 39,881,134,229,020,362
end: 9,388,800
cap: 250,000,000,000,000,000
lastContribution: {
Ending: 8,319,000
}
firstPeriod: 7
lastPeriod: 14
trieIndex: 17
}
]
[
[
2,031
]
{
depositor: 143pzStAtMv3RbYbcHyr2xHipWPkme8VjVgAr4QDQP8d3Xrc
verifier: null
deposit: 5,000,000,000,000
raised: 20,780,502,465,772,093
end: 9,388,800
cap: 200,000,000,000,000,000
lastContribution: {
Ending: 8,319,029
}
firstPeriod: 7
lastPeriod: 14
trieIndex: 18
}
]
[
[
2,012
]
{
depositor: 15kjdKF4hRbYWzLjovPiohT5pVheXhhk8oKHr3DyTaxF2evd
verifier: null
deposit: 5,000,000,000,000
raised: 107,515,186,195,417,478
end: 8,179,200
cap: 400,000,000,000,000,000
lastContribution: {
Ending: 8,058,505
}
firstPeriod: 6
lastPeriod: 13
trieIndex: 6
}
]
[
[
2,026
]
{
depositor: 16LKv69ct6xDzSiUjuz154vCg62dkyysektHFCeJe85xb6X
verifier: null
deposit: 5,000,000,000,000
raised: 4,540,976,322,397,717
end: 9,388,800
cap: 250,000,000,000,000,000
lastContribution: {
Ending: 8,318,356
}
firstPeriod: 7
lastPeriod: 14
trieIndex: 14
}
]
[
[
2,003
]
{
depositor: 1EdsnniYSKNjHNAvDgvBfRNzKnSzi6kgsHQFCG4PhAyyJWH
verifier: null
deposit: 5,000,000,000,000
raised: 2,229,392,885,136,282
end: 9,388,800
cap: 300,000,000,000,000,000
lastContribution: {
Ending: 8,318,867
}
firstPeriod: 7
lastPeriod: 14
trieIndex: 10
}
]
[
[
2,006
]
{
depositor: 1j5YyEGdcPd9BxkzVNNjKkqdi5f7g3Dd7JMgaGUhsMrZ6dZ
verifier: null
deposit: 5,000,000,000,000
raised: 103,335,520,433,166,970
end: 8,179,200
cap: 350,000,010,000,000,000
lastContribution: {
Ending: 7,957,704
}
firstPeriod: 6
lastPeriod: 13
trieIndex: 3
}
]
[
[
2,013
]
{
depositor: 152deMvsN7wxMbSmdApsds6LWNNNGgsJ8TTpZLTD2ipEHNg3
verifier: null
deposit: 5,000,000,000,000
raised: 1,548,870,188,216,392
end: 9,388,800
cap: 120,000,000,000,000,000
lastContribution: {
Ending: 8,318,984
}
firstPeriod: 7
lastPeriod: 14
trieIndex: 21
}
]
]
```
remove finished parachains (https://polkadot.subscan.io/crowdloan?status=completed&firstSlot=&lastSlot=&keyword=)
[2012, 2002, 2006, 2004, 2000]
#### Take parachainId and raised funds
```
[
[
[
2,028
]
{
raised: 11,822,680,000,000
}
]
[
[
2,035
]
{
raised: 298,940,826,552,099
}
]
[
[
2,032
]
{
raised: 10,563,933,316,304,004
}
]
[
[
2,021
]
{
raised: 67,841,402,419,511,901
}
]
[
[
2,027
]
{
raised: 61,146,597,570,835
}
]
[
[
2,008
]
{
raised: 115,964,254,641,249
}
]
[
[
2,017
]
{
raised: 10,652,411,476,305
}
]
[
[
2,011
]
{
raised: 6,203,810,528,169,667
}
]
[
[
2,019
]
{
raised: 39,881,134,229,020,362
}
]
[
[
2,031
]
{
raised: 20,780,502,465,772,093
}
]
[
[
2,026
]
{
raised: 4,540,976,322,397,717
}
]
[
[
2,003
]
{
raised: 2,229,392,885,136,282
}
]
[
[
2,013
]
{
raised: 1,548,870,188,216,392
}
]
]
```
as JSON
## Wrong data - first attempt
```
[
{
"paraId": 2028,
"raised": 11822680000000
},
{
"paraId": 2035,
"raised": 298940826552099
},
{
"paraId": 2032,
"raised": 10563933316304004
},
{
"paraId": 2021,
"raised": 67841402419511901
},
{
"paraId": 2027,
"raised": 61146597570835
},
{
"paraId": 2008,
"raised": 115964254641249
},
{
"paraId": 2017,
"raised": 10652411476305
},
{
"paraId": 2011,
"raised": 6203810528169667
},
{
"paraId": 2019,
"raised": 39881134229020362
},
{
"paraId": 2031,
"raised": 20780502465772093
},
{
"paraId": 2026,
"raised": 4540976322397717
},
{
"paraId": 2003,
"raised": 2229392885136282
},
{
"paraId": 2013,
"raised": 1548870188216392
}
]
```
## New data - second attempt
```
[
{
"paraId": 2028,
"raised": 9582680000000
},
{
"paraId": 2035,
"raised": 0
},
{
"paraId": 2032,
"raised": 10298433723431093
},
{
"paraId": 2021,
"raised": 44789452421946083
},
{
"paraId": 2027,
"raised": 45001960094462
},
{
"paraId": 2008,
"raised": 97447754641250
},
{
"paraId": 2017,
"raised": 3570000000000
},
{
"paraId": 2011,
"raised": 4223045629673761
},
{
"paraId": 2019,
"raised": 32807564465113413
},
{
"paraId": 2031,
"raised": 16314090556010806
},
{
"paraId": 2026,
"raised": 4177952921257180
},
{
"paraId": 2003,
"raised": 2193001461183467
},
{
"paraId": 2013,
"raised": 1335790716448714
}
]
```
## New data - third attempt
```
[
{
"paraId": 2028,
"raised": 11872680000000
},
{
"paraId": 2035,
"raised": 327832545591199
},
{
"paraId": 2032,
"raised": 10604925651304003
},
{
"paraId": 2021,
"raised": 69855871629814677
},
{
"paraId": 2027,
"raised": 62216597570835
},
{
"paraId": 2008,
"raised": 116406504641249
},
{
"paraId": 2017,
"raised": 10652411476305
},
{
"paraId": 2011,
"raised": 6234671876465465
},
{
"paraId": 2019,
"raised": 40566426104228034
},
{
"paraId": 2031,
"raised": 20851163816812267
},
{
"paraId": 2026,
"raised": 4547513322397717
},
{
"paraId": 2003,
"raised": 2234445901136282
},
{
"paraId": 2013,
"raised": 1609411448804431
}
]
```