SQL Console

Query Xahau data indexed by WinDB, read-only, right in the browser.

Query

Ctrl+Enter Read-only · at most 1,000 rows · 30 s a query · 12 queries a minute

Tables (33)

2.5M

Date

String

UInt64

UInt32

260.2k

String

UInt64

UInt32

Nullable(String)

UInt64

UInt32

Nullable(FixedString(64))

UInt16

DateTime('UTC')

UInt8

UInt32

212.2k

String

DateTime('UTC')

UInt64

String

UInt64

String

Nullable(FixedString(48))

String

Nullable(FixedString(48))

DateTime('UTC')

Nullable(DateTime('UTC'))

String

Nullable(String)

Nullable(DateTime)

Nullable(DateTime('UTC'))

12.2M

Date

String

SimpleAggregateFunction(sum, UInt64)

1.1k

Date

Decimal(18, 6)

UInt16

UInt32

13.3k

LowCardinality(String)

Date

UInt32

13.8k

LowCardinality(FixedString(64))

DateTime('UTC')

UInt64

String

Enum8('Created' = 1, 'Destroyed' = 2, 'Installed' = 3, 'InstalledThenUninstalled' = 4, 'Uninstalled' = 5, 'Modified' = 6)

19.5k

LowCardinality(FixedString(64))

UInt64

String

Date

UInt32

59.5M

LowCardinality(FixedString(64))

DateTime('UTC')

UInt64

String

LowCardinality(String)

UInt8

String

795

LowCardinality(FixedString(64))

UInt64

String

Nullable(String)

Array(Tuple(HookParameterName String, HookParameterValue String))

FixedString(64)

String

DateTime('UTC')

UInt32

Float64

FixedString(48)

DateTime('UTC')

UInt64

UInt32

39.4k

String

DateTime('UTC')

Float64

UInt32

26.6M

UInt32

DateTime('UTC')

UInt16

UInt64

UInt16

Date

FixedString(48)

String

UInt64

UInt32

FixedString(48)

String

UInt64

UInt32

String

FixedString(48)

UInt8

UInt16

String

DateTime('UTC')

Nullable(DateTime('UTC'))

Date

String

UInt32

Date

String

Nullable(UInt32)

LowCardinality(String)

Decimal(18, 6)

Float64

Nullable(String)

Nullable(FixedString(48))

String

UInt32

Nullable(String)

Nullable(DateTime('UTC'))

FixedString(64)

String

UInt32

LowCardinality(String)

UInt64

String

Nullable(String)

LowCardinality(String)

Nullable(Decimal(18, 6))

Nullable(Float64)

Nullable(String)

Nullable(FixedString(48))

LowCardinality(String)

Nullable(Decimal(18, 6))

Nullable(Float64)

Nullable(String)

Nullable(FixedString(48))

Nullable(String)

DateTime('UTC')

Date

String

UInt32

Date

String

LowCardinality(String)

Decimal(18, 6)

Float64

Nullable(String)

Nullable(FixedString(48))

FixedString(64)

UInt32

UInt8

String

Nullable(String)

LowCardinality(String)

Nullable(Decimal(18, 6))

Nullable(Float64)

Nullable(String)

Nullable(FixedString(48))

DateTime('UTC')

Nullable(DateTime('UTC'))

FixedString(64)

String

UInt32

LowCardinality(String)

String

FixedString(64)

Nullable(String)

Nullable(UInt16)

Nullable(Float64)

Nullable(UInt32)

Nullable(UInt8)

Nullable(String)

Nullable(UInt8)

Nullable(DateTime('UTC'))

DateTime('UTC')

String

UInt32

Float64

DateTime('UTC')

UInt32

String

FixedString(64)

Array(Tuple(Issuer String, CredentialTypeHEX String, CredentialType String))

Nullable(DateTime('UTC'))

UInt32

2.4M

Date

String

Float64

UInt32

194k

String

Float64

UInt32

1.4B

UInt64

String

DateTime64(9, 'UTC')

UInt32

UInt16

Array(Tuple(Issuer String, CredentialType String))

UInt8

String

FixedString(64)

String

LowCardinality(Nullable(FixedString(64)))

Decimal(18, 6)

String

Nullable(FixedString(48))

Float64

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

String

Array(Tuple(XRP Decimal(18, 6), token_value Float64, token_issuer String, token_currency String))

UInt8

String

Nullable(FixedString(48))

String

UInt8

String

Nullable(FixedString(48))

String

Array(String)

UInt8

String

Array(Tuple(Issuer String, CredentialType String))

UInt8

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

UInt64

Int64

Decimal(18, 6)

String

Nullable(FixedString(48))

Float64

Decimal(18, 6)

String

Nullable(FixedString(48))

Float64

UInt32

FixedString(64)

String

Nullable(FixedString(48))

UInt32

String

Array(FixedString(64))

String

FixedString(64)

String

UInt32

Nullable(UInt32)

String

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

String

Nullable(UInt32)

FixedString(64)

String

FixedString(64)

Decimal(18, 6)

String

Nullable(FixedString(48))

Float64

FixedString(32)

UInt64

UInt32

FixedString(64)

String

FixedString(64)

UInt32

Int64

UInt32

String

Array(Tuple(Amount_XRP Decimal(18, 6), Destination String, GovernanceFlags String, GovernanceMarks String))

UInt16

String

UInt16

String

Array(Tuple(HookParameterName String, HookParameterValue String))

UInt8

Array(Tuple(position UInt8, HookHash Nullable(String), CreateCode Nullable(String), Flags UInt32, HookApiVersion Nullable(Int8), HookName Nullable(String), HookNamespace Nullable(FixedString(64)), HookOn Nullable(FixedString(64)), HookOnIncoming Nullable(FixedString(64)), HookOnOutgoing Nullable(FixedString(64)), HookCanEmit Nullable(FixedString(64)), Fee Nullable(Int64)))

UInt8

String

FixedString(64)

String

Nullable(FixedString(48))

Decimal(18, 6)

String

Nullable(FixedString(48))

Float64

Decimal(18, 6)

String

Nullable(FixedString(48))

Float64

UInt32

UInt16

Nullable(UInt32)

Decimal(18, 6)

Float64

String

FixedString(48)

String

UInt64

String

Nullable(FixedString(48))

Array(Tuple(MemoData String, MemoFormat Nullable(String), MemoType Nullable(String)))

UInt8

UInt32

String

Decimal(18, 6)

String

Nullable(FixedString(48))

Float64

String

UInt32

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

FixedString(64)

String

Array(FixedString(64))

FixedString(64)

UInt32

FixedString(64)

UInt32

String

Array(Tuple(account Nullable(String), currency Nullable(String), issuer Nullable(String), type Nullable(UInt8)))

FixedString(64)

String

UInt32

String

UInt32

Int64

UInt32

Int64

Array(Tuple(RemarkName String, RemarkValue Nullable(String), Flags Nullable(UInt32)))

UInt8

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

UInt32

String

Decimal(18, 6)

String

Nullable(FixedString(48))

Float64

Array(Tuple(Account String, SignerWeight UInt16, WalletLocator Nullable(FixedString(64))))

UInt8

UInt32

Array(String)

UInt8

Nullable(UInt32)

Decimal(21, 6)

Float64

String

Nullable(FixedString(48))

FixedString(40)

Decimal(21, 6)

Float64

String

Nullable(FixedString(48))

UInt8

UInt32

FixedString(64)

UInt32

LowCardinality(String)

UInt16

UInt32

Decimal(18, 6)

String

Nullable(FixedString(48))

Float64

UInt8

String

FixedString(64)

Array(FixedString(64))

String

Array(Tuple(Issuer String, CredentialType String))

UInt8

String

FixedString(64)

UInt32

String

UInt64

Decimal(18, 6)

Float64

String

Nullable(FixedString(48))

UInt16

UInt8

String

Array(String)

String

Decimal(18, 6)

UInt16

Switch network

Tools & Services

SQL Console

Tables (33)