Published
Edited
Apr 22, 2021
md`# Polymarket Subgraph Last Seen Today`
query = `query ($first: Int!, $skip: Int!, $startDate: BigInt!, $endDate: BigInt!) {
accounts(first: $first, skip: $skip, where: { lastSeenTimestamp_gt: $startDate, lastSeenTimestamp_lte: $endDate }) {
lastSeenTimestamp
id
transactions(first:1 orderBy: timestamp, orderDirection: asc){
timestamp
}
}
}
`
object
momentStartDate = parseInt(moment(object.startDate).format('x')) / 1000
momentEndDate = parseInt(moment(object.endDate).format('x')) / 1000
accountData = getData(query, {startDate: momentStartDate, endDate: momentEndDate, first: object.first, skip: object.skip})
viewof exportForm = form(html`<form>
<select name="exportFormDataType">${Object.keys(accountData.data).map(each => html`<option value="${each}">${each}</option>`)}</select></form>
`)
exportForm.exportFormDataType.toString()
DOM.download(exportCSVFile(accountData.data[exportForm.exportFormDataType], exportForm.exportFormDataType + ".csv"),
exportForm.exportFormDataType + ".csv",
"Export data"
)
Type JavaScript, then Shift-Enter. Ctrl-space for more options. Arrow ↑/↓ to switch modes.
queryTraders = `query ($first: Int!, $skip: Int!, $startDate: BigInt!, $endDate: BigInt!) {
accounts(first: $first, skip: $skip, where: { lastSeenTimestamp_gt: $startDate, lastSeenTimestamp_lte: $endDate }) {
lastTradedTimestamp
id
transactions(first:1 orderBy: timestamp, orderDirection: asc){
timestamp
}
}
}
`
traderData = getData(queryTraders, {startDate: momentStartDate, endDate: momentEndDate, first: object.first, skip: object.skip})
viewof exportForm2 = form(html`<form>
<select name="exportFormDataType">${Object.keys(traderData.data).map(each => html`<option value="${each}">${each}</option>`)}</select></form>
`)
DOM.download(exportCSVFile(traderData.data[exportForm.exportFormDataType], exportForm.exportFormDataType + ".csv"),
exportForm.exportFormDataType + ".csv",
"Export data"
)
md`# All Accounts`
accountsData = getData(`
query ($first: Int!, $skip: Int!) {
global(id: "") {
numTraders
}
}
`, {first: 1000, skip: 0})
accountsData2 = getData(
`
query ($first: Int!, $skip: Int!) {
accounts (first: $first, skip: $skip) {
id
}
}
`,
{ first: 1000, skip: 5000 }
)
Type JavaScript, then Shift-Enter. Ctrl-space for more options. Arrow ↑/↓ to switch modes.
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
