main.sql

SELECT
	t0. "id",
	t0. "inserted_at"::timestamp AT TIME ZONE 'Etc/UTC' AT TIME ZONE 'Europe/Amsterdam',
	o1. "inserted_at"::timestamp AT TIME ZONE 'Etc/UTC' AT TIME ZONE 'Europe/Amsterdam',
	o1. "id",
	o3. "id" AS "client_order_id",
	o4. "id" AS "hedge_order_id",
	o1. "source",
	c2. "slug",
	t0. "position",
	t0. "crypto_asset",
	t0. "amount",
	t0. "price",
	t0. "fiat_fee",
	t0. "fiat_amount"
FROM
	"trades" AS t0
	LEFT OUTER JOIN "orders" AS o1 ON o1. "id" = t0. "order_id"
	LEFT OUTER JOIN "counterparties" AS c2 ON c2. "id" = t0. "counterparty_id"
	LEFT OUTER JOIN "orders" AS o3 ON o3. "id" = o1. "client_order_id"
	LEFT OUTER JOIN "orders" AS o4 ON o4. "client_order_id" = o1. "id"
WHERE
	TRUE
	AND t0. "inserted_at" >= '2021-05-29'::date::timestamp AT TIME ZONE 'Europe/Amsterdam' AT TIME ZONE 'UTC'
	AND t0. "inserted_at" < '2021-05-30'::date::timestamp AT TIME ZONE 'Europe/Amsterdam' AT TIME ZONE 'UTC'
ORDER BY
	t0. "inserted_at"
LIMIT 20 OFFSET 0