SELECT cause, effect, library_size,
round(cast("correlation" AS numeric), 5) AS "correlation",
jaccard_index, round(cast("lower_bound" AS numeric), 5) AS "lower_bound",
round(cast("upper_bound" AS numeric), 5) AS "upper_bound",
round(cast("effect_size" AS numeric), 5) AS "effect_size",
round(cast("effect_size_sd" AS numeric),5) AS "effect_size_sd"
FROM CCM (
ON (SELECT 1) PARTITION BY 1
InputTable ('ccm_input2')
SequenceIdColumn ('id')
TimeColumn ('period')
CauseColumns ('marketindex', 'indexval')
EffectColumns ('indexdate', 'indexchange')
LibrarySize ('10', '25', '50')
Seed ('0')
) ORDER BY cause, effect, library_size;