Tables & Schemas

Array(Tuple(
    id UUID,            -- Probalytics outcome ID
    platform_id String, -- Platform's native outcome ID
    name String,        -- Outcome name (e.g., "Yes", "No", "Trump")
    index UInt8         -- Position in the outcomes list
))

SELECT
    id,
    title,
    outcome.id as outcome_id,
    outcome.name as outcome_name
FROM markets
ARRAY JOIN outcomes as outcome
WHERE platform = 'POLYMARKET'
LIMIT 5;

Tuple(
    id UUID,            -- Probalytics outcome ID
    platform_id String, -- Platform's native outcome ID
    name String,        -- Outcome name
    index UInt8         -- Position index
)

SELECT
    outcome.id as outcome_id,
    outcome.platform_id as platform_outcome_id,
    outcome.name as outcome_name,
    outcome.index as outcome_index,
    price,
    volume
FROM trades
LIMIT 5;

SELECT
    name,
    contract_name,
    block_number,
    data
FROM chain_events
WHERE name = 'OrderFilled'
  AND block_timestamp >= now() - INTERVAL 1 HOUR
ORDER BY block_number DESC
LIMIT 10;

SELECT
    m.title,
    t.price,
    t.volume,
    t.outcome.name
FROM trades t
JOIN markets m ON t.market_id = m.id
WHERE m.platform = 'POLYMARKET'
LIMIT 10;

ORDER BY (platform, created_at, id, platform_id)

ORDER BY (platform, trader_id, created_at, id)
PARTITION BY toYYYYMM(created_at)

ORDER BY (contract_name, contract_address, block_number, log_index, block_hash, data_hash)

-- Filter by date range
WHERE created_at >= '2024-01-01' AND created_at < '2024-02-01'

-- Extract components
SELECT toYear(created_at), toMonth(created_at), toDayOfWeek(created_at)

-- Prices are typically 0-1 (probability as decimal)
WHERE price BETWEEN 0.1 AND 0.5

-- Safe arithmetic
SELECT sum(volume), avg(price)

-- String comparison
WHERE platform = 'POLYMARKET'

-- Also works (position-based)
WHERE platform = 1

-- Check if array contains value
WHERE has(tags, 'politics')

-- Expand array to rows using ARRAY JOIN
SELECT outcome.name
FROM markets
ARRAY JOIN outcomes as outcome

-- Array length
WHERE length(outcomes) > 2

SELECT
    outcome.id,
    outcome.platform_id,
    outcome.name,
    outcome.index
FROM trades