itsjerryokolo / cryptopunks Goto Github PK
View Code? Open in Web Editor NEWSubgraph for the Cryptopunks marketplace
Subgraph for the Cryptopunks marketplace
Currenty, we don't know how much actually was asked ๐ณ
There's a bug in CryptoPunks contract that causes PunkBought
event emitted from acceptBidForPunk
have wrong value
and toAddress
. Detail here: https://twitter.com/jwahdatehagh/status/1422590642128105475
This results in missing data when querying Sales
by to
field. Can we handle this quirk and inconvenience in this subgraph?
asks(where: { nft: "365" }) {
id
open
amount
created {
blockNumber
timestamp
}
from {
id
}
}
The latest ask has open: false
as it has been withdrawn
query OrderBook {
offers(orderBy: amount, orderDirection: asc, where: {open: true}) {
amount
offerType
}
}
This does not work at the moment. Identified problems so far:
{
"data": {
"punks": [
{
"id": "1546",
"metadata": {
"tokenURI": "https://www.larvalabs.com/cryptopunks/details/1546",
"imageURI": "https://www.larvalabs.com/public/images/cryptopunks/punk1546.png",
"traits": [
{
"id": "blonde-short"
},
{
"id": "choker"
},
{
"id": "female"
}
]
},
"transferedTo": {
"id": "0x48db199821bbd5be47c29bb242e3cdf1ef099d7e"
},
"assignedTo": {
"id": "0x48db199821bbd5be47c29bb242e3cdf1ef099d7e"
},
"purchasedBy": {
"id": "0x8f4fc35cf5ad925bcc1cae81e5da62fca1c2dd2a"
},
"owner": {
"id": "0xb6b4a02dca517564eb98790ff67d42b5b37a3d4e"
},
"wrapped": false,
"currentAsk": {
"amount": "81950000000000000000",
"open": false
},
"currentBid": {
"amount": "75500000000000000000",
"open": false
},
"events": [
{
"from": null,
"to": null,
"amount": null,
"type": "ASK_REMOVED",
"blockNumber": "12773479",
"logNumber": "57",
"blockHash": "0x14c80138deb0d27f7fcc16be3a9f5dd6ee33063620dad64d162b89ee9dc4a09e",
"txHash": "0x01719ad3127c027e462d21cded5f3d87aaca58aae79381898ebef1b0ba9564bd",
"timestamp": "1625568792"
},
{
"from": {
"id": "0x6639c089adfba8bb9968da643c6be208a70d6daa"
},
"to": null,
"amount": "77950000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14408262",
"logNumber": "91",
"blockHash": "0xc82ef38e798bd9510c19991438fc2b0c2987e319b72b61f8ca29996a5c9a6e8a",
"txHash": "0x0357511b62b45996e715316b76ae5aab5a6753e6427bc36c784ba131edeae224",
"timestamp": "1647577937"
},
{
"from": {
"id": "0x805076bb8b11466ae76cfd2d4b67bcb69f449070"
},
"to": {
"id": "0x9c2ecd52e83a5ff9d0c981570a9c6ea044483410"
},
"amount": null,
"type": "TRANSFER",
"blockNumber": "14142322",
"logNumber": "4",
"blockHash": "0xc2f365541ef33d3b83cc190793e47327f7b834f00c20cde331b216218441f8ef",
"txHash": "0x03f7eae3c7107b86a19763d3d7acece5ad99a425475a16adb82aa40cb0295988",
"timestamp": "1644014217"
},
{
"from": {
"id": "0x8f4fc35cf5ad925bcc1cae81e5da62fca1c2dd2a"
},
"to": null,
"amount": "75500000000000000000",
"type": "BID_CREATED",
"blockNumber": "14423559",
"logNumber": "19",
"blockHash": "0x624ad115d8563f6cef70646c523176628b742391a5f4909884b4c4e9537ce9c9",
"txHash": "0x0ff65834f0557ca0cc21a8b3882e7ab2fe8b889d00211cd420d1ec56edaed38c",
"timestamp": "1647783371"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": null,
"amount": "19000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12758117",
"logNumber": "143",
"blockHash": "0xa51cbcf20f49fb5a370de665b1ea799f3b51a8f9809967ef5cf07c79e110b606",
"txHash": "0x153c83b50c8750bc93ce609810e099ab3acce05d322d57da9f80750961a92053",
"timestamp": "1625362013"
},
{
"from": {
"id": "0x6639c089adfba8bb9968da643c6be208a70d6daa"
},
"to": null,
"amount": "81950000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14412909",
"logNumber": "24",
"blockHash": "0x0779e175ced035359676767cd31e14cdb887c490f575b9fdfb04e21c8771927d",
"txHash": "0x15e2233e67b268258c5856380c118daaf38dbb849dcf40d473ab83f36b996f35",
"timestamp": "1647639870"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": {
"id": "0x6639c089adfba8bb9968da643c6be208a70d6daa"
},
"amount": null,
"type": "TRANSFER",
"blockNumber": "14303677",
"logNumber": "796",
"blockHash": "0x23803b67808e8cbd35894c67868d2eb7d290b377205b15d799afe9bdb78a0a35",
"txHash": "0x16519aeb0215c6e5209543f1958c4f69bc716eb4b6fe415b7e4af1176c17b924",
"timestamp": "1646171783"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": null,
"amount": "70000000000000000020",
"type": "BID_CREATED",
"blockNumber": "14302351",
"logNumber": "0",
"blockHash": "0xf9163f0c4f00a1f81a52713eadfd9a21442058bb386e8649df2ecbcb5758368d",
"txHash": "0x172540f2a6b033f1de2f69ca09f3408b12f88382f741442eb37219060c861eca",
"timestamp": "1646153904"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": null,
"amount": "20500000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12736682",
"logNumber": "117",
"blockHash": "0x87ac87f878ada3e013e9287a40e1fcc816c47e3dbace888a8ac276f67ea14072",
"txHash": "0x19019a49614fe0267545c6ffd974746f23b48b9289baaae0217dfff638fb92ae",
"timestamp": "1625073806"
},
{
"from": {
"id": "0x3be89b64e1437bb18da2d26bcbe9bd3daaadfc26"
},
"to": {
"id": "0x48db199821bbd5be47c29bb242e3cdf1ef099d7e"
},
"amount": null,
"type": "TRANSFER",
"blockNumber": "12362039",
"logNumber": "144",
"blockHash": "0xfd5e2cf9d8fba7c470a8e8ad80e4d1c3531fe47fd31d9942d10360f7d4f2963f",
"txHash": "0x197681c58cfa7890f6522ddcea1076c5330075128c01b9bd0f1ed00460179d54",
"timestamp": "1620055517"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": null,
"amount": "20250000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12739353",
"logNumber": "239",
"blockHash": "0x2e2b5ee3331933537d8e0ba2eed85093630169eceb25f0423566a5cfefc0dfb5",
"txHash": "0x1cdc8131116fd36244ee723967981a1c6024045bdf4d4169d65293fc370a4dff",
"timestamp": "1625109407"
},
{
"from": null,
"to": null,
"amount": null,
"type": "ASK_REMOVED",
"blockNumber": "14136221",
"logNumber": "90",
"blockHash": "0xa5f553b4dfe2a8c5d94a72751efd8b43441838c28a487c6d1029112883b5f6ca",
"txHash": "0x201811b86629b98cd709a7bae4bb06864f21b3668f6d0e217b68e4d23597f90e",
"timestamp": "1643933940"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": null,
"amount": "60960000000000000000",
"type": "BID_CREATED",
"blockNumber": "14036157",
"logNumber": "467",
"blockHash": "0xe4f357291920018c914710121948453841086ffde52ae99cd0c1b077f7380df8",
"txHash": "0x24d753d5cae1713e0bf2cb809dfea99f131ffa1a50989231baff3af55485b21b",
"timestamp": "1642597630"
},
{
"from": {
"id": "0x8f4fc35cf5ad925bcc1cae81e5da62fca1c2dd2a"
},
"to": null,
"amount": "75500000000000000000",
"type": "BID_REMOVED",
"blockNumber": "14423581",
"logNumber": "35",
"blockHash": "0x03a3fb290ca3128069d45bfac1051b08a30a2f7afcb8f7075c228d5474616e91",
"txHash": "0x266af19bb34af7f2db4875c2e3abf153c4697af35b2935c42605f2fade5cdcc8",
"timestamp": "1647783633"
},
{
"from": {
"id": "0x3be89b64e1437bb18da2d26bcbe9bd3daaadfc26"
},
"to": null,
"amount": "19800000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12631035",
"logNumber": "92",
"blockHash": "0x891d8c39dba814d06eefc9d853058c9dd700f0a49c3d4da73be4d6272b46182c",
"txHash": "0x3f0444faa533412f1deb89a2ad46dabd8bc75d73b52c08d4048cd5eac08e4422",
"timestamp": "1623653380"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": null,
"amount": "20000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12742697",
"logNumber": "315",
"blockHash": "0xfa73d92bffb724164f231e1cf8cb19f9aa26946aa33d26357ecb1b40451afaa5",
"txHash": "0x4d87f15010f0aa6c2fe976e4d5f9930324de940e27a1c6936476ac5097887eb7",
"timestamp": "1625154511"
},
{
"from": null,
"to": null,
"amount": null,
"type": "ASK_REMOVED",
"blockNumber": "14044781",
"logNumber": "64",
"blockHash": "0x4b8cb15a2f93ce4fa0fb22d7264bb00e23596476bff45367902a25a4a5df5dc4",
"txHash": "0x5029c9ad33227100a6e00426d599fe4684ba56fa6b7fec3681b6f1d5ba38a77c",
"timestamp": "1642712605"
},
{
"from": {
"id": "0x4851512de5bd4d035a56eb95bb4709452091cac7"
},
"to": null,
"amount": "61000000000000000000",
"type": "BID_CREATED",
"blockNumber": "14036178",
"logNumber": "70",
"blockHash": "0xb0a9e7cf41a4f77d38a66b92849fae37877d8edd4d0a526be7452b115bdd1ce9",
"txHash": "0x5129a03424807b4c11aa9adaedf283db65a7c0830f700e2fceaab2387766e955",
"timestamp": "1642597984"
},
{
"from": {
"id": "0x805076bb8b11466ae76cfd2d4b67bcb69f449070"
},
"to": null,
"amount": "109500000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14120839",
"logNumber": "25",
"blockHash": "0x55d0a9de5d29aa8d541887cc56e2f7887ee5f6726e11b637978f9c9d9be5d765",
"txHash": "0x5358a0a1a77c5e4d44c561daea8ce8cdf0dab9b3f2fdc2a1c163a65903db3361",
"timestamp": "1643728464"
},
{
"from": {
"id": "0xd0add237f1cd29c58642d53c4b6a67b0bb07a7c9"
},
"to": {
"id": "0x357f4a1448c59695d44bd5d49c7a100f0bcc39a1"
},
"amount": null,
"type": "TRANSFER",
"blockNumber": "13094017",
"logNumber": "69",
"blockHash": "0x1f78578eeb52fb3b6af4724c9c66d1ce02ff636a6ff0e6693524931dd05500a2",
"txHash": "0x53d97c1bc9749b4454a02b7612afdc83b35b40bbf3d30126ac1bf15da89b7143",
"timestamp": "1629887079"
},
{
"from": {
"id": "0x6639c089adfba8bb9968da643c6be208a70d6daa"
},
"to": null,
"amount": "75950000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14406476",
"logNumber": "153",
"blockHash": "0xcc83f70e8ace657cb2e31d3fa27394a2cdd075238b390762b5be3d7eb2f2bda5",
"txHash": "0x5b60734855f2660c9630c3f3443f14546c249334f85520fdf61f51bfec242861",
"timestamp": "1647553428"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": null,
"amount": "68000000000000000000",
"type": "BID_CREATED",
"blockNumber": "14259276",
"logNumber": "155",
"blockHash": "0xb8aa4210eb3c0ee07ce7b18d895999c96b08b4d75cfb647a98b99b10c88aef7a",
"txHash": "0x5f9648f54bc2a80eac5ddf183ea451808604ea653ad879c007b76164993678e8",
"timestamp": "1645578184"
},
{
"from": null,
"to": null,
"amount": null,
"type": "ASK_REMOVED",
"blockNumber": "12731719",
"logNumber": "143",
"blockHash": "0xf8186beee2dc76f760129ae7a9030d797b582e8dccbc30081812966298dd0216",
"txHash": "0x621e757bc06556c263e42893b1825cd1c8ca216f7e78d1a98473f98a683dc72a",
"timestamp": "1625007290"
},
{
"from": {
"id": "0x1920c59d9db5a261716ca91fb5910c12da6716d2"
},
"to": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"amount": "17974000000000000000",
"type": "SALE",
"blockNumber": "12731719",
"logNumber": "144",
"blockHash": "0xf8186beee2dc76f760129ae7a9030d797b582e8dccbc30081812966298dd0216",
"txHash": "0x621e757bc06556c263e42893b1825cd1c8ca216f7e78d1a98473f98a683dc72a",
"timestamp": "1625007290"
},
{
"from": null,
"to": null,
"amount": null,
"type": "ASK_REMOVED",
"blockNumber": "12761540",
"logNumber": "53",
"blockHash": "0x4cb90b69f112a2d31fa66ea3da116745c953296d9bb9d21ed2d935247a609151",
"txHash": "0x6428846f8c8be3fc6e3b42477a1305e1219f635800ba250758270e65cff3b4a5",
"timestamp": "1625408576"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": {
"id": "0xd0add237f1cd29c58642d53c4b6a67b0bb07a7c9"
},
"amount": "19000000000000000000",
"type": "SALE",
"blockNumber": "12761540",
"logNumber": "54",
"blockHash": "0x4cb90b69f112a2d31fa66ea3da116745c953296d9bb9d21ed2d935247a609151",
"txHash": "0x6428846f8c8be3fc6e3b42477a1305e1219f635800ba250758270e65cff3b4a5",
"timestamp": "1625408576"
},
{
"from": {
"id": "0xa8d31c4546a782085d81a1ec1598054400d7a2ae"
},
"to": null,
"amount": "70000000000000000000",
"type": "BID_REMOVED",
"blockNumber": "14412763",
"logNumber": "118",
"blockHash": "0xe4e0e8e8d5a919ccc8b762a3c0db9a199f7117bb4fecdca265d1dc25e555fff4",
"txHash": "0x6544a8a9b77081e2993c22e0582c6ebb4220ff637fab04714a5b475b64d27a07",
"timestamp": "1647637632"
},
{
"from": {
"id": "0x3be89b64e1437bb18da2d26bcbe9bd3daaadfc26"
},
"to": null,
"amount": "16000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12680032",
"logNumber": "123",
"blockHash": "0xd1f0402b658572d80972af3eddd476878fb8fb71973fb79d19374176e085abf0",
"txHash": "0x65ca71a454882cb2e1bc1e7d08fbd0928fc44e35a8107c5e150e5d227799e88e",
"timestamp": "1624310799"
},
{
"from": {
"id": "0x6639c089adfba8bb9968da643c6be208a70d6daa"
},
"to": null,
"amount": "91950000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14370620",
"logNumber": "113",
"blockHash": "0xd4bf4b6db839fb9dd3bcb24af43298fd3649305d211c3212051ab1a5525247ff",
"txHash": "0x66af50dbf78a7726bf1b465d9b9ea80159ce27a080199a7c0690d023b1a57538",
"timestamp": "1647070592"
},
{
"from": {
"id": "0x6639c089adfba8bb9968da643c6be208a70d6daa"
},
"to": null,
"amount": "79950000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14411974",
"logNumber": "40",
"blockHash": "0x7810bb86463059e6dee416dba7245b062b5322175450fe29f4b81fe8e56252ab",
"txHash": "0x6d91bcfe81f0c180599ed8e03cc8db8a7be19982050615f952d7ada4cc7aafa7",
"timestamp": "1647627160"
},
{
"from": {
"id": "0x357f4a1448c59695d44bd5d49c7a100f0bcc39a1"
},
"to": {
"id": "0xc404dd1cd172aef530db7992c2e1303f3f4d33c4"
},
"amount": null,
"type": "TRANSFER",
"blockNumber": "13094048",
"logNumber": "203",
"blockHash": "0x6afefc79b7146405a9822fabf220dea465cc83c0b771c170b8940b7cc71a68f5",
"txHash": "0x6dc142aededd2546c4110f60656ccc8d8ba3e228d6c0700732cf852ebce25797",
"timestamp": "1629887428"
},
{
"from": null,
"to": {
"id": "0x48db199821bbd5be47c29bb242e3cdf1ef099d7e"
},
"amount": null,
"type": "ASSIGN",
"blockNumber": "3918475",
"logNumber": "60",
"blockHash": "0xf56bfd42cf7f33ce9a4b13b20f42836df6dd372246169130054f57e4541db8e9",
"txHash": "0x6e36e519fabb37e041d5df5baf49155b615df9c7cc188bd88dd4b886656636cd",
"timestamp": "1498230350"
},
{
"from": null,
"to": null,
"amount": null,
"type": "ASK_REMOVED",
"blockNumber": "14136223",
"logNumber": "41",
"blockHash": "0x3ce4ac0dfc8b8e2e66be8da2483f25816f048ef4686bc860e2a5ae87db30a855",
"txHash": "0x6f59068518d44d415d35da2afb2fe5ab89c09b5722c865fa7fab0db1d205baf6",
"timestamp": "1643933965"
},
{
"from": {
"id": "0xc404dd1cd172aef530db7992c2e1303f3f4d33c4"
},
"to": {
"id": "0x579141c6e5afcd2f312542f4d87ac9a2edc45d2c"
},
"amount": null,
"type": "TRANSFER",
"blockNumber": "13320798",
"logNumber": "1",
"blockHash": "0x3dae90315f671b26e0232ff3953c7041d44f060a76726556cb668e6f72302c1a",
"txHash": "0x7073bdff55c9170de750e14788c5d85876c542093fadc3d4984684e13d20094a",
"timestamp": "1632920243"
},
{
"from": {
"id": "0xcba4aa46bdad48c2e6adf83eb79f125daf492502"
},
"to": {
"id": "0x579141c6e5afcd2f312542f4d87ac9a2edc45d2c"
},
"amount": null,
"type": "TRANSFER",
"blockNumber": "13383554",
"logNumber": "110",
"blockHash": "0xd8bd3017dcb05e226d9feadfc005157e343fd87aaa457e98051025e03fb06204",
"txHash": "0x794098525b87a2cc0172a9f54d0010c9872b1825ca20735b7a9f99f0c5ff857c",
"timestamp": "1633769394"
},
{
"from": {
"id": "0x9c2ecd52e83a5ff9d0c981570a9c6ea044483410"
},
"to": null,
"amount": null,
"type": "BID_REMOVED",
"blockNumber": "14302351",
"logNumber": "2",
"blockHash": "0xf9163f0c4f00a1f81a52713eadfd9a21442058bb386e8649df2ecbcb5758368d",
"txHash": "0x79b019a403e9d7ee8b36bbb682397a2f46e97adcfca966d36536737b2e1bf6fd",
"timestamp": "1646153904"
},
{
"from": {
"id": "0x9c2ecd52e83a5ff9d0c981570a9c6ea044483410"
},
"to": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"amount": "70000000000000000020",
"type": "SALE",
"blockNumber": "14302351",
"logNumber": "2",
"blockHash": "0xf9163f0c4f00a1f81a52713eadfd9a21442058bb386e8649df2ecbcb5758368d",
"txHash": "0x79b019a403e9d7ee8b36bbb682397a2f46e97adcfca966d36536737b2e1bf6fd",
"timestamp": "1646153904"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": null,
"amount": "19500000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12750735",
"logNumber": "233",
"blockHash": "0xdf0549123088ab692e54fe4b8910bbb15e35bed9470e0c4b31e71ffd874e15ed",
"txHash": "0x7a4eed05d5a2cae899416a3d91c6fe9ff8fb41b9b97a4daf35ec4b658a45127b",
"timestamp": "1625262479"
},
{
"from": {
"id": "0x9c2ecd52e83a5ff9d0c981570a9c6ea044483410"
},
"to": null,
"amount": "88000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14220334",
"logNumber": "30",
"blockHash": "0x13a38a79249d0461f96a9e69b125ba15bded4979a38d950dd40ff3a4aea947ef",
"txHash": "0x80cf583706bb8dbc2b1ee4e79233dfe761aa2aa3c0ff5a526b91f3848f07e20c",
"timestamp": "1645056915"
},
{
"from": {
"id": "0x6639c089adfba8bb9968da643c6be208a70d6daa"
},
"to": null,
"amount": "84950000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14368384",
"logNumber": "76",
"blockHash": "0x74355f472824e71aece66ff0264e5c36e3f61033cd57c04a4c826f153dc83b84",
"txHash": "0x8114765c608fa83a05cf05802abb379ad81ce97dac6ad505a4c666f0da04ca90",
"timestamp": "1647040631"
},
{
"from": {
"id": "0x4851512de5bd4d035a56eb95bb4709452091cac7"
},
"to": null,
"amount": "62000000000000000000",
"type": "BID_REMOVED",
"blockNumber": "14036405",
"logNumber": "72",
"blockHash": "0xe988e1063ac2a6939310691cbaf0f51453726b098b4f42899346515b2cb371a0",
"txHash": "0x8559740437daabae8debb088ac05b7d175f5500ae2f06dc4a9cf0d710c58590a",
"timestamp": "1642601288"
},
{
"from": {
"id": "0x3be89b64e1437bb18da2d26bcbe9bd3daaadfc26"
},
"to": null,
"amount": "14500000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12680151",
"logNumber": "117",
"blockHash": "0x60a61737dd240590432f99f286809db51f7f167b107d76f0dbc7c6b5d45a14a4",
"txHash": "0x9046795f4910522a91446a5acf00e77985619d11a3c1e0bfa3d3887e13cbc837",
"timestamp": "1624312490"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": null,
"amount": "70000000000000000000",
"type": "BID_CREATED",
"blockNumber": "14297349",
"logNumber": "55",
"blockHash": "0x716d50195a8f76e7c94b7ce25c9370626c481652fce567f20be940d4dd2da186",
"txHash": "0x9180b864d7d3135f8348305b790ff2435f555a4ea9095c92aaf54fdf6be7aa8a",
"timestamp": "1646087236"
},
{
"from": {
"id": "0x6639c089adfba8bb9968da643c6be208a70d6daa"
},
"to": null,
"amount": "89950000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14368590",
"logNumber": "34",
"blockHash": "0x34d6790b81b11a5ef0a0dbdc8a82303fd046cd77ac5e71682a22c0dd3b132b10",
"txHash": "0x94f893e169a246f833a311c2440cf659970ccd6f2f7b605ee83a4b989e924342",
"timestamp": "1647043651"
},
{
"from": {
"id": "0x685cb9e2035d915331379dcbf09d18084f126ba7"
},
"to": null,
"amount": "73500000000000000000",
"type": "BID_CREATED",
"blockNumber": "14422333",
"logNumber": "76",
"blockHash": "0xa1e282bc272f2ba45c0ce326144f9b3166fe05a9237dfa348f174772320b88dc",
"txHash": "0x99120661a76311f663d58c5b19d7d109237c202082ddbf05e004c3fcc1bfd759",
"timestamp": "1647766915"
},
{
"from": {
"id": "0xa8d31c4546a782085d81a1ec1598054400d7a2ae"
},
"to": null,
"amount": "70000000000000000000",
"type": "BID_CREATED",
"blockNumber": "14405375",
"logNumber": "48",
"blockHash": "0xe525cd786efc07cb780905a4694c527a713c60232da4abbc382d606ec1258e30",
"txHash": "0x9e071203f13c1cce6b0f3ce1115d438edbd4d50d51511ce9e39de3faa9f4dd44",
"timestamp": "1647538592"
},
{
"from": {
"id": "0x579141c6e5afcd2f312542f4d87ac9a2edc45d2c"
},
"to": {
"id": "0xcba4aa46bdad48c2e6adf83eb79f125daf492502"
},
"amount": null,
"type": "TRANSFER",
"blockNumber": "13383489",
"logNumber": "506",
"blockHash": "0x92dc9e6ab134c4ac27b202ab5ed1c8f313abb9c4de3f96296055a9fe7d9f8bf9",
"txHash": "0xa16f1f7c16cc3b07e571c9067b16f323cb928f1cc5a079d0d82572219671d10f",
"timestamp": "1633768413"
},
{
"from": {
"id": "0x8f4fc35cf5ad925bcc1cae81e5da62fca1c2dd2a"
},
"to": {
"id": "0xb6b4a02dca517564eb98790ff67d42b5b37a3d4e"
},
"amount": null,
"type": "TRANSFER",
"blockNumber": "14483124",
"logNumber": "151",
"blockHash": "0x94ed8c19b4e9378bc7c67bcf360b72021f8f0cb7178866612b1cadb7b1187ff3",
"txHash": "0xa26d4870c43edf466d8fcfbcfa9349024b0bc785b19e90ee0a75a6ac1638fae1",
"timestamp": "1648583712"
},
{
"from": {
"id": "0x48db199821bbd5be47c29bb242e3cdf1ef099d7e"
},
"to": {
"id": "0x3be89b64e1437bb18da2d26bcbe9bd3daaadfc26"
},
"amount": null,
"type": "TRANSFER",
"blockNumber": "12363998",
"logNumber": "28",
"blockHash": "0xb90e878c44ff9f0a01efa41595323332dfa34cdf59f0a47fb96fe57bca7a6a9e",
"txHash": "0xa2e2ad5679d6912f3113dfd2007a10d4ecf07b4baa75f2094e89125fc0edd016",
"timestamp": "1620081683"
},
{
"from": {
"id": "0x9c2ecd52e83a5ff9d0c981570a9c6ea044483410"
},
"to": null,
"amount": "80000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14230910",
"logNumber": "51",
"blockHash": "0x8db907766a54c4efc1f9eb8098079df44b46a1f27d4c56cae7c653e1f2f802b3",
"txHash": "0xa7ce9dd62c9979be4c990e8ed51c5eaaad6ff32a215b475c120f7f15d439d1d5",
"timestamp": "1645198321"
},
{
"from": {
"id": "0x48db199821bbd5be47c29bb242e3cdf1ef099d7e"
},
"to": {
"id": "0x3be89b64e1437bb18da2d26bcbe9bd3daaadfc26"
},
"amount": null,
"type": "TRANSFER",
"blockNumber": "12354578",
"logNumber": "49",
"blockHash": "0x84fa95c32ad8b9b548c059746820a8e710f506ebaac10ff8e7046dfc308e603a",
"txHash": "0xa862a91ca2e5d3cfc904ecd6d27e48b997d91b00aafb02f2658dc51b56a948f8",
"timestamp": "1619956077"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": null,
"amount": "61060000000000000000",
"type": "BID_CREATED",
"blockNumber": "14036191",
"logNumber": "34",
"blockHash": "0xc58b34b3ff2cf337f85e68e5a4be9984afdf1f7476f1d4834d9ebbd0cda5d992",
"txHash": "0xa9ca24467f2ccda9007335e46db4090fa08ff3836e341e66add9c1ab93f5a60e",
"timestamp": "1642598167"
},
{
"from": null,
"to": null,
"amount": null,
"type": "ASK_REMOVED",
"blockNumber": "14036336",
"logNumber": "201",
"blockHash": "0x6e14442940cf3fdf0cf37454fb7b387a2b3975388c7b424a23f91bbbd6877a60",
"txHash": "0xabaf5f8aaa6235014d8cb9555b0164da25103b1c3c5d05330dc8f2ea6c6fc029",
"timestamp": "1642600286"
},
{
"from": {
"id": "0x579141c6e5afcd2f312542f4d87ac9a2edc45d2c"
},
"to": {
"id": "0x805076bb8b11466ae76cfd2d4b67bcb69f449070"
},
"amount": "63900000000000000000",
"type": "SALE",
"blockNumber": "14036336",
"logNumber": "202",
"blockHash": "0x6e14442940cf3fdf0cf37454fb7b387a2b3975388c7b424a23f91bbbd6877a60",
"txHash": "0xabaf5f8aaa6235014d8cb9555b0164da25103b1c3c5d05330dc8f2ea6c6fc029",
"timestamp": "1642600286"
},
{
"from": {
"id": "0x9c2ecd52e83a5ff9d0c981570a9c6ea044483410"
},
"to": null,
"amount": "72000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14301867",
"logNumber": "18",
"blockHash": "0x262da51437f798333703d3fd13a8bfb150ea50653f5e6a75d84a32be5e006d45",
"txHash": "0xad96855af4a5a19e397c431a8f84026315c0f156f102de2379d5ccbb4d98ff34",
"timestamp": "1646147455"
},
{
"from": {
"id": "0x805076bb8b11466ae76cfd2d4b67bcb69f449070"
},
"to": null,
"amount": "89000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14039559",
"logNumber": "57",
"blockHash": "0x468515a9393e8ffbac6733ad7063860270fa261ba1aa037b7df9dca797a7787e",
"txHash": "0xb40a0837f68166986112d6eb7ef14342108cdc4d35665f8c10467465adf2ff1e",
"timestamp": "1642642671"
},
{
"from": {
"id": "0x9c2ecd52e83a5ff9d0c981570a9c6ea044483410"
},
"to": null,
"amount": "74000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14297305",
"logNumber": "64",
"blockHash": "0x91521a4aade65f92c27bbb3fc4f9a9fee453552a2d584f7ac28d65f1d2ece3e0",
"txHash": "0xb59cf4e89b141c09134da7f01533352245fed65c52d4406c78ee04995e2db0cf",
"timestamp": "1646086655"
},
{
"from": null,
"to": null,
"amount": null,
"type": "ASK_REMOVED",
"blockNumber": "14136223",
"logNumber": "42",
"blockHash": "0x3ce4ac0dfc8b8e2e66be8da2483f25816f048ef4686bc860e2a5ae87db30a855",
"txHash": "0xb86f54b67adc9010bb92e3451f6d05b8cb96c2e87ca93f3a43c4bd6c51029939",
"timestamp": "1643933965"
},
{
"from": {
"id": "0x6639c089adfba8bb9968da643c6be208a70d6daa"
},
"to": null,
"amount": "79950000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14379911",
"logNumber": "36",
"blockHash": "0x3774e23a84025d858eecb2b6b4c62c0de0f157a44dc3a90f5f6fcd568b069f2c",
"txHash": "0xbd7fbf68082e34497a75738ce2dac96e0fb2bad93cd5f00b96aacfaf644a45e4",
"timestamp": "1647196334"
},
{
"from": {
"id": "0x805076bb8b11466ae76cfd2d4b67bcb69f449070"
},
"to": null,
"amount": "135000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14044784",
"logNumber": "192",
"blockHash": "0xd44d4f5086c972ef6f118048bb538894d92c89338a6af3cf06e9364c49b91e37",
"txHash": "0xc4a7755281968494e736ef47832ec5b5588934db76058dec2298f054073fb5e3",
"timestamp": "1642712676"
},
{
"from": {
"id": "0x6639c089adfba8bb9968da643c6be208a70d6daa"
},
"to": null,
"amount": "77950000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14404342",
"logNumber": "76",
"blockHash": "0x3940419b59cddbd788b3e75d9678a0b4cd38a0098e297f793721415e8aa806d4",
"txHash": "0xc6e6b626005ded3765d8e3819f3c150d7b3ea380c58e6c2ae69566b9ac46f9b0",
"timestamp": "1647524423"
},
{
"from": {
"id": "0x805076bb8b11466ae76cfd2d4b67bcb69f449070"
},
"to": null,
"amount": "103500000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14123084",
"logNumber": "38",
"blockHash": "0xca56172965cc7c4b8397072331ecf178f7f7a7fb6cde9ee2cb5e11af68b195f4",
"txHash": "0xd09dea7a5c0cc9cdc95ebc4ce27ea089a92621ff2778fff6073c45fc1a923014",
"timestamp": "1643757754"
},
{
"from": {
"id": "0x6639c089adfba8bb9968da643c6be208a70d6daa"
},
"to": null,
"amount": "74950000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14398139",
"logNumber": "254",
"blockHash": "0xdc566af7dfcff82eec669f0c968ff5329dbdd91d89241f0b8bfeb92005f5c7e4",
"txHash": "0xd3f79fda9b1fe0417fcb4044e45a5e229b15145fc3f78605c147566a6c0a1b76",
"timestamp": "1647440833"
},
{
"from": {
"id": "0x4851512de5bd4d035a56eb95bb4709452091cac7"
},
"to": null,
"amount": "62000000000000000000",
"type": "BID_CREATED",
"blockNumber": "14036207",
"logNumber": "81",
"blockHash": "0xcda70484d53284802e64f77ca52ddca817378e08c5a07b9da371b27a4083f00b",
"txHash": "0xd546807c20450b511d8fcf9e67d03e0267592fb0e00faf7d1b35ad46bf9c2785",
"timestamp": "1642598429"
},
{
"from": {
"id": "0x1920c59d9db5a261716ca91fb5910c12da6716d2"
},
"to": null,
"amount": "17974000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12731714",
"logNumber": "217",
"blockHash": "0xce79e943d93ca0e28a7841be09a25d449d6d305ae656366a1421942c747253c3",
"txHash": "0xdf3c8bfc48e3ca3aaaa889a781e817341e6dff0ebc13837d9cb0d68b5fbc9de9",
"timestamp": "1625007243"
},
{
"from": null,
"to": null,
"amount": null,
"type": "ASK_REMOVED",
"blockNumber": "12680956",
"logNumber": "279",
"blockHash": "0xa7b3e3b973ca43bfe42b17c472ff24fcb2389d3ded99034a6ed075075cfd42eb",
"txHash": "0xdf6f9c115579b385a80b228644fc7fee71dbc8c686aa2c25ab3edb77c104b37b",
"timestamp": "1624323747"
},
{
"from": {
"id": "0x3be89b64e1437bb18da2d26bcbe9bd3daaadfc26"
},
"to": {
"id": "0x1920c59d9db5a261716ca91fb5910c12da6716d2"
},
"amount": "14500000000000000000",
"type": "SALE",
"blockNumber": "12680956",
"logNumber": "280",
"blockHash": "0xa7b3e3b973ca43bfe42b17c472ff24fcb2389d3ded99034a6ed075075cfd42eb",
"txHash": "0xdf6f9c115579b385a80b228644fc7fee71dbc8c686aa2c25ab3edb77c104b37b",
"timestamp": "1624323747"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": null,
"amount": "19750000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12744935",
"logNumber": "56",
"blockHash": "0x6b9cd98bb5c45707363e5d37e15de0aeffc1458e86fa0d2a73014434ab231d3f",
"txHash": "0xe12398050edc5a21bbd6794c647c2f0a99538c9c1451ea485f6fe5652b8e1375",
"timestamp": "1625185129"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": null,
"amount": "19250000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12752679",
"logNumber": "177",
"blockHash": "0x7df35626b3b82ac026333d4f3e10a7675d34e74c43da626f97afd81c85f295dd",
"txHash": "0xe20de0a8b1ca3a68e68aa952a297a9bcef1aeec2a5dbf98a7c1d63f95230f799",
"timestamp": "1625288820"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": null,
"amount": "68000000000000000000",
"type": "BID_REMOVED",
"blockNumber": "14265464",
"logNumber": "15",
"blockHash": "0x45b23ee81c18224a7463041792b344b30d454994e188bc75de12681a532120d1",
"txHash": "0xe471ea117a46787d720cf253de26e047b5dbc3ec3f8ab298306e50e3215b4886",
"timestamp": "1645660739"
},
{
"from": {
"id": "0x6639c089adfba8bb9968da643c6be208a70d6daa"
},
"to": null,
"amount": "79950000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14351033",
"logNumber": "6",
"blockHash": "0x79b28c2f2b0cd90b779190783eafb3f63eb1bd22378c2a144771c077f03aabe1",
"txHash": "0xf65bf8c7517f9414b44208458af7c570bed782d7502517797074c3c9c2a47446",
"timestamp": "1646807540"
},
{
"from": {
"id": "0xd0add237f1cd29c58642d53c4b6a67b0bb07a7c9"
},
"to": null,
"amount": "21900000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12773468",
"logNumber": "385",
"blockHash": "0xfd37d4af4b6fbeca1169e113d6a552457d1dad686f228ac8b336550acd398106",
"txHash": "0xf702cc2799808b109728efcb7638687859916f8c0ce8fed8b44037414f9b0a9d",
"timestamp": "1625568700"
},
{
"from": {
"id": "0x805076bb8b11466ae76cfd2d4b67bcb69f449070"
},
"to": null,
"amount": "90000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14136167",
"logNumber": "45",
"blockHash": "0x9d405d5cbaa6653e845c91cc6d69c72a3b95c58b2aff727740f4196e8628231c",
"txHash": "0xf9dd99ef382fe3cc787140a3f48f1041219069a25635955ab6d9fab2e16848c5",
"timestamp": "1643933144"
},
{
"from": null,
"to": null,
"amount": null,
"type": "ASK_REMOVED",
"blockNumber": "14423595",
"logNumber": "203",
"blockHash": "0x7aaa4eb03355bd4233d9f299411189572bb66eba1f4ee97479d9c2a476710793",
"txHash": "0xfad7645ae6381da2569132ca671a52be431b321b6789ed86a14504707e9a81b4",
"timestamp": "1647783904"
},
{
"from": {
"id": "0x6639c089adfba8bb9968da643c6be208a70d6daa"
},
"to": {
"id": "0x8f4fc35cf5ad925bcc1cae81e5da62fca1c2dd2a"
},
"amount": "81950000000000000000",
"type": "SALE",
"blockNumber": "14423595",
"logNumber": "204",
"blockHash": "0x7aaa4eb03355bd4233d9f299411189572bb66eba1f4ee97479d9c2a476710793",
"txHash": "0xfad7645ae6381da2569132ca671a52be431b321b6789ed86a14504707e9a81b4",
"timestamp": "1647783904"
},
{
"from": {
"id": "0x579141c6e5afcd2f312542f4d87ac9a2edc45d2c"
},
"to": null,
"amount": "63900000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14035850",
"logNumber": "50",
"blockHash": "0x8db147edd7871f6fc77128dca38b82700c2ac07933970c0beaa35aaf9af12fff",
"txHash": "0xfb36e04789e703fa33686d76426dcca446c0b7661bb1be493776b91f804d6f9e",
"timestamp": "1642593454"
}
]
}
]
}
}
The query:
{
transfers(where:{ txHash: "0xa8cb816346d0efa0d1da3d4f945ab3a3a64d4db39959d62164d37224119c916e" }) {
id
}
}
returns "transfers": []
.
But I can confirm there is Transfer
event emitted in this transaction: https://etherscan.io/tx/0xa8cb816346d0efa0d1da3d4f945ab3a3a64d4db39959d62164d37224119c916e#eventlog
Following is the TRANSFER event for punkId 8124 retrieved from the subgraph, and nft is null.
Here's the transfer event with the same txHash for punkId 8124 - https://cryptopunks.app/cryptopunks/details/8124
The tx - https://etherscan.io/tx/0x51fe6a9abaa2fe1f8525d233c4c214886ddfafa770c551bdb4397a8185382732
Note that the Transfer event does not include the punkId. But the second PunkTransfer event includes the correct punkIndex:
Please include the punkId/punkIndex as nft.id in the TRANSFER subgraph event data.
Thanks.
{
accounts {
id
numberOfPunksOwned
punksOwned {
id
}
}
}
query MyQuery {
contracts {
id
}
}
Reference: https://cryptopunks.app/cryptopunks/details/1000
{
punks(where: { id: "1000" }) {
id
owner {
id
}
wrapped
currentAsk {
open
amount
}
}
}
Should be:
{
"data": {
"punks": [
{
"id": "1000",
"owner": {
"id": "0x8ca246551ffa910223a444fdccebfe8daf8ee838"
},
"assignedTo": {
"id": "0xc5d739a29e3f97b59ddb1d8f46aaa2e46496d462"
},
"wrapped": false,
"currentAsk": {
"open": true,
"amount": "144440000000000000000"
}
}
]
}
}
Use transactionHash + logIndex
bids(first: 1) {
created {
id
}
}
{
"errors": [
{
"locations": [
{
"column": 5,
"line": 3
}
],
"message": "Null value resolved for non-null field `created`"
}
]
}
REQUEST : please add data about wrapped punks, the wrapped punk token id
In the schema, something like:
interface NFT {
id: ID!
uri: String!
contract: Contract!
tokenId: BigInt!
transfers: [TransferEvent!]! @derivedFrom(field: "nft")
block: BigInt!
hash: Bytes!
timestamp: BigInt!
}
type Punk @entity extends NFT {
...
}
type WrappedPunk @entity extends NFT {
...
}
e.g. https://etherscan.io/tx/0x6ef062f328311ee26ce0107b2215349ad5bdec7b78ffee9c43f728c050fa437b#eventlog
for https://cryptopunks.app/cryptopunks/details/1473
Here's the current subgraph data for this event:
event: {
"from": {
"id": "0x0fc584529a2aefa997697fafacba5831fac0c22d"
},
"to": null,
"amount": "0",
"type": "ASK_CREATED",
"blockNumber": "14955132",
"logNumber": "357",
"blockHash": "0x9c4acc61d0102f1632c86c8a6f87cfc5adb3919b5f8bfd50caf2664f01d3866d",
"txHash": "0x6ef062f328311ee26ce0107b2215349ad5bdec7b78ffee9c43f728c050fa437b",
"timestamp": "1655110701"
}
Thanks
Here is the data from the subgraph for #8801 that shows the currentBid is still open.
{
"id": "8801",
"metadata": {
"tokenURI": "https://www.larvalabs.com/cryptopunks/details/8801",
"imageURI": "https://www.larvalabs.com/public/images/cryptopunks/punk8801.png",
"traits": [
{
"id": "male"
},
{
"id": "smile"
},
{
"id": "top-hat"
}
]
},
"transferedTo": {
"id": "0xcbd482af76059e2a5e4a825c4cd5ced9f2dfe286"
},
"assignedTo": {
"id": "0xcbd482af76059e2a5e4a825c4cd5ced9f2dfe286"
},
"purchasedBy": {
"id": "0x5382859146010ac16e142b6708f8e178e77f66bc"
},
"owner": {
"id": "0x5382859146010ac16e142b6708f8e178e77f66bc"
},
"wrapped": false,
"currentAsk": {
"amount": "110000000000000000000",
"open": true
},
"currentBid": {
"amount": "95000000000000000000",
"open": true
},
"events": [
{
"from": {
"id": "0x5382859146010ac16e142b6708f8e178e77f66bc"
},
"to": null,
"amount": "110000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14917666",
"blockHash": "0x02f6175309854207124b8cf599fed94f8ca2065c2fe1b6614bba0da49b54cc6e",
"txHash": "0x0148390341d486464e7b96d81520dc8d33bfe13592eee56ac5fc638b34e0bb47",
"timestamp": "1654558885"
},
{
"from": {
"id": "0xf1b65881041243cb07b9a2067014350239af4116"
},
"to": null,
"amount": "3000000000000000000",
"type": "BID_CREATED",
"blockNumber": "11674458",
"blockHash": "0xa5f61a870b8c8dd371c6790c2d92ede30fb1248f74521291af994e7c99f4ba71",
"txHash": "0x07faf9f98eac550681db987bf153237512ac0f9997db390d85b5493b9e3cd3d1",
"timestamp": "1610909626"
},
{
"from": {
"id": "0x18ee9cebca35d323068e5edc5b41ffca11d605b9"
},
"to": null,
"amount": "50000000000000000000",
"type": "BID_CREATED",
"blockNumber": "12187251",
"blockHash": "0x3c6c7604112c877baad88f8cb90a9e7a5240993876ded6174fdb63ca49110ee5",
"txHash": "0x0c64f7992bb2294d0720c12e6e6cab438539863e2a10cf763ba88263c8038957",
"timestamp": "1617726278"
},
{
"from": {
"id": "0xdf612c887e88f8e87ac0d2aa04ffd91f0556cfc0"
},
"to": null,
"amount": "420690000000000000000",
"type": "ASK_CREATED",
"blockNumber": "13367063",
"blockHash": "0xb0d134856d29b95afb38897a1089832c96697ddae85199d1ca1617ee271cecc3",
"txHash": "0x0e96c8d895e620ebd415622ce53cdf95599f56a212e051c50d2240fe667e9e76",
"timestamp": "1633545273"
},
{
"from": {
"id": "0xdf612c887e88f8e87ac0d2aa04ffd91f0556cfc0"
},
"to": null,
"amount": "188880000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14369659",
"blockHash": "0x1342bc6961fd649063553e261f0ee2886dcf2c900733296c88f4640356cdcf12",
"txHash": "0x1532a199db1124ff3c916ef8fddfffcb00ceb36a7229a7739a37d74f7591a4d0",
"timestamp": "1647057032"
},
{
"from": {
"id": "0x577ebc5de943e35cdf9ecb5bbe1f7d7cb6c7c647"
},
"to": null,
"amount": null,
"type": "BID_REMOVED",
"blockNumber": "12187282",
"blockHash": "0xde2da9beabfcfba75abb79e19753f811bbb2d6debde540e7f7d9c85e0463f38b",
"txHash": "0x24f24573e549c258e36a787baf47c546033fde73a1e6600037114a8200cee07d",
"timestamp": "1617726679"
},
{
"from": {
"id": "0x577ebc5de943e35cdf9ecb5bbe1f7d7cb6c7c647"
},
"to": {
"id": "0x18ee9cebca35d323068e5edc5b41ffca11d605b9"
},
"amount": "50000000000000000000",
"type": "SALE",
"blockNumber": "12187282",
"blockHash": "0xde2da9beabfcfba75abb79e19753f811bbb2d6debde540e7f7d9c85e0463f38b",
"txHash": "0x24f24573e549c258e36a787baf47c546033fde73a1e6600037114a8200cee07d",
"timestamp": "1617726679"
},
{
"from": {
"id": "0xdf612c887e88f8e87ac0d2aa04ffd91f0556cfc0"
},
"to": null,
"amount": "388000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "13082683",
"blockHash": "0x31cb0b2e0e85e7e5935e93ef6001de8fe3e17998b94d43f3b36478035a7c5f3a",
"txHash": "0x2f8da1d9de05f436413210d06f139d6da99a8475f6eeebf068d275ef0ec4afd7",
"timestamp": "1629736775"
},
{
"from": {
"id": "0xdf612c887e88f8e87ac0d2aa04ffd91f0556cfc0"
},
"to": null,
"amount": "142000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14617692",
"blockHash": "0xd3a8c81a03805de671f996232d4f0c9265c0f54bc5f51e376fcd3b6eab3824ef",
"txHash": "0x69ab83ba7d7f98d5b73338fe6a04abc23dfb917a8a8ad48dc7f8ce5da4481a3c",
"timestamp": "1650399421"
},
{
"from": {
"id": "0x5382859146010ac16e142b6708f8e178e77f66bc"
},
"to": null,
"amount": "120000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14895272",
"blockHash": "0x5fb7f4b4b74e3ffc700c3bc2359f622d0f735d54e1c0900aabb56689738ab61d",
"txHash": "0x6e9a253d425e978a0044b1253a84aefc5fceb525b392e94c356b3fe4f27faecb",
"timestamp": "1654233169"
},
{
"from": {
"id": "0x18ee9cebca35d323068e5edc5b41ffca11d605b9"
},
"to": null,
"amount": "99000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12823201",
"blockHash": "0xcd69587e2b2866058619c03d2089c6c722b8c5926763b5b1d6e32c2629a54259",
"txHash": "0x6f56590fb0ca3c95b42c26b85627b2ee175fb834acadef18f4f6711b90034225",
"timestamp": "1626239421"
},
{
"from": {
"id": "0x18ee9cebca35d323068e5edc5b41ffca11d605b9"
},
"to": null,
"amount": "149000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12937192",
"blockHash": "0xfc9e64235cfe04527d8961833632197eed7332ab87a40d46229ba36d3542e7c7",
"txHash": "0x7e2d04da031dfaf8d4414dad9939333dcfcbb878b8a65380cb2ff65647d80fbd",
"timestamp": "1627787300"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": null,
"amount": "82000000000000000000",
"type": "BID_REMOVED",
"blockNumber": "14780807",
"blockHash": "0x6fe35aa728296674bf05b24d6bd1e5d3888eef950fb775736b078fa23d5ba98c",
"txHash": "0x82d572a1ae5222f44a6f0376916ae4183968dd3b59ef2242df456bd61b91fc59",
"timestamp": "1652629511"
},
{
"from": {
"id": "0xdf612c887e88f8e87ac0d2aa04ffd91f0556cfc0"
},
"to": null,
"amount": "120000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14724728",
"blockHash": "0x367ef1b131f6321f9064e6c08c6d5e2a3697503a47f241bb6771912b27156f17",
"txHash": "0x85f13a9a8348699c36269cd04e9f71458eca31f22312b3d04d1dc678449333d0",
"timestamp": "1651856361"
},
{
"from": null,
"to": {
"id": "0xcbd482af76059e2a5e4a825c4cd5ced9f2dfe286"
},
"amount": null,
"type": "ASSIGN",
"blockNumber": "3919310",
"blockHash": "0x6e30ee2b5e161e8f66e75788e505c7bfbdd068ad7fb172e1a4f8cd16da93af40",
"txHash": "0x89fe2cef6c64535d214fde5ca924f151cae783063bd7b62f132f48fb40de8160",
"timestamp": "1498244624"
},
{
"from": {
"id": "0xdf612c887e88f8e87ac0d2aa04ffd91f0556cfc0"
},
"to": null,
"amount": "288880000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14103470",
"blockHash": "0x3fe4bf2ed4f16e1fbf09539f322322809723710c81cd6b3f332d4d4510798dc1",
"txHash": "0x90606fcd2801158d9a9e6c27b9e34ece3f6896fc547a0ddf5dbe464d6d384947",
"timestamp": "1643496621"
},
{
"from": {
"id": "0x18ee9cebca35d323068e5edc5b41ffca11d605b9"
},
"to": null,
"amount": "160000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12965075",
"blockHash": "0x20bcb4dee5aaaa2e31595cb5213684aea01c601189d5938c7d62533522a85608",
"txHash": "0x9292b373d258d8319e36f7e5420e3a8b9609889adf05c2d8d4e768230153c377",
"timestamp": "1628167925"
},
{
"from": null,
"to": null,
"amount": null,
"type": "ASK_REMOVED",
"blockNumber": "12930116",
"blockHash": "0xe641395234d56e47a0ce774d1cd71d6ec071c61982440f21a538c818d71d2b88",
"txHash": "0xb5f17253c9a58a7533d8ff316428a5a3f6fe3d29cf30c890cb3524280ece3efc",
"timestamp": "1627690652"
},
{
"from": {
"id": "0xdf612c887e88f8e87ac0d2aa04ffd91f0556cfc0"
},
"to": null,
"amount": "100000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "14771473",
"blockHash": "0x08aea4590b9979f4f1a41937928428c8cf428cca4443ac2c729b9ca01696d233",
"txHash": "0xb8ed0590311933e580bd3376730d5b950217232acb1f48441f6fe6392f151cb0",
"timestamp": "1652501105"
},
{
"from": {
"id": "0x74be0af0bf7254328ddffc09425ff71d64a1a836"
},
"to": null,
"amount": "92000000000000000000",
"type": "BID_CREATED",
"blockNumber": "14781857",
"blockHash": "0xeb6cdd089cc5c6e1518c8fefce91aa89f9aa1077df8dd53ad644d750172ed621",
"txHash": "0xc23ca0b4cf6540aee7964ff7d752e182c9a9f566b74586bbf478b9873d1eb884",
"timestamp": "1652643632"
},
{
"from": null,
"to": null,
"amount": null,
"type": "ASK_REMOVED",
"blockNumber": "12966475",
"blockHash": "0x3ed975e64ecd3faa6bd0aa7707f88fc18d490ce71fb5b5fc244fb921d536e122",
"txHash": "0xca2cb4e8a9574d3d7e2439cb4292d30b99c8c118f4a82d4319951d251d3e6668",
"timestamp": "1628186959"
},
{
"from": {
"id": "0x18ee9cebca35d323068e5edc5b41ffca11d605b9"
},
"to": {
"id": "0xdf612c887e88f8e87ac0d2aa04ffd91f0556cfc0"
},
"amount": "160000000000000000000",
"type": "SALE",
"blockNumber": "12966475",
"blockHash": "0x3ed975e64ecd3faa6bd0aa7707f88fc18d490ce71fb5b5fc244fb921d536e122",
"txHash": "0xca2cb4e8a9574d3d7e2439cb4292d30b99c8c118f4a82d4319951d251d3e6668",
"timestamp": "1628186959"
},
{
"from": {
"id": "0x5382859146010ac16e142b6708f8e178e77f66bc"
},
"to": null,
"amount": "95000000000000000000",
"type": "BID_CREATED",
"blockNumber": "14786352",
"blockHash": "0xa9cae3fe9d91d9baaf4f00a3d2f8a023572b60d75088b6ca590783c2936a692a",
"txHash": "0xda8b946a1f2f43e10b5bb3694e85602912c33712d07e54b410981e5bd3378931",
"timestamp": "1652705300"
},
{
"from": {
"id": "0xdf612c887e88f8e87ac0d2aa04ffd91f0556cfc0"
},
"to": null,
"amount": null,
"type": "BID_REMOVED",
"blockNumber": "14788076",
"blockHash": "0xe199bcacdbc93231c515166da46121337b7c01751a4d3fdbd5727843a4849476",
"txHash": "0xe3500627327c42382e8a2fe0341677803a390b13a219f2c22b17b21e92447563",
"timestamp": "1652728969"
},
{
"from": {
"id": "0xdf612c887e88f8e87ac0d2aa04ffd91f0556cfc0"
},
"to": {
"id": "0x5382859146010ac16e142b6708f8e178e77f66bc"
},
"amount": "95000000000000000000",
"type": "SALE",
"blockNumber": "14788076",
"blockHash": "0xe199bcacdbc93231c515166da46121337b7c01751a4d3fdbd5727843a4849476",
"txHash": "0xe3500627327c42382e8a2fe0341677803a390b13a219f2c22b17b21e92447563",
"timestamp": "1652728969"
},
{
"from": {
"id": "0x18ee9cebca35d323068e5edc5b41ffca11d605b9"
},
"to": null,
"amount": "140000000000000000000",
"type": "ASK_CREATED",
"blockNumber": "12248078",
"blockHash": "0xa1cc51730af724f98379fcfbe4ca9678aaa4bfee6d962169ea09785fa890c6ce",
"txHash": "0xe5b3cfd30ea2802f0da236cef19abd27251d58b4794e9672fd71c4ad3fb83702",
"timestamp": "1618534911"
},
{
"from": {
"id": "0x7174039818a41e1ae40fdcfa3e293b0f41592af2"
},
"to": null,
"amount": "50000000000000007",
"type": "BID_CREATED",
"blockNumber": "3930245",
"blockHash": "0xb3e242918f4b46168ffccea072546b65a825625d883c1da11e1100f447ff7f8b",
"txHash": "0xf07e3e35c61e2ee0d0e79fbd9fda274d1f60e6918fc12ed42c808000666d94f7",
"timestamp": "1498436739"
},
{
"from": {
"id": "0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685"
},
"to": null,
"amount": "82000000000000000000",
"type": "BID_CREATED",
"blockNumber": "14771472",
"blockHash": "0x3a2fe83429ff536a280bf8f5a82d844203c15d113e09f8d15ad48030aa7542f9",
"txHash": "0xf13f9ae5150837fdac9c2f6f3796462f1d39ce75799e6a25bea5a5b5fb4bd040",
"timestamp": "1652501100"
},
{
"from": {
"id": "0xf1b65881041243cb07b9a2067014350239af4116"
},
"to": null,
"amount": "3000000000000000000",
"type": "BID_REMOVED",
"blockNumber": "11708106",
"blockHash": "0x36bd11289b8069b6962513a883d0625caa20012cd057d10130ebbe7453618dab",
"txHash": "0xfcbacf09a450126ff98faffae9b755b8e8bf4ede73fb2fecfb501ae15d969c1d",
"timestamp": "1611355617"
}
]
}
Here's the screenshot from https://cryptopunks.app/cryptopunks/details/8801 showing that there is no active bid.
Thx
createAskCreated
You only need to call these once, so no reason to have them getOrCreate...
See: https://cryptopunks.app/cryptopunks/accountinfo?account=0xa25803ab86a327786bb59395fc0164d826b98298
I've found so far four punkIds [4000, 4576, 8086, 8829] that have 2 or 3 events (transactions) executed within the same blocknumber.
It is currently not possible to determine the order of the events from the subgraph data.
Please include the logIndex
event field in the events subgraph data.
Examples follow:
https://cryptopunks.app/cryptopunks/details/4000 has 3 events within the same block: Offered, Offered Withdrawn, then Offered.
https://cryptopunks.app/cryptopunks/details/4576 as 2 events within the same block: Offered Withdrawn, then Offered.
Thanks
{
accounts {
id
numberOfPunksOwned
}
}
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.