select stats_createSummaryTables_ChartPattens (cast(4768 as int));

Date: 2021-07-25 23:58:02
Duration: 1h28m18s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_ChartPattens (cast(4780 as int));

Date: 2021-07-25 23:53:40
Duration: 1h16m55s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_ChartPattens (cast(4854 as int));

Date: 2021-07-25 23:56:57
Duration: 29m37s
Database: acaweb_fx
User: postgres

x Hide

SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1), results AS ( SELECT DISTINCT ON (s.symbolid) kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM keylevels_results kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON kr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on kr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON kr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3, $4, $5, $6, $7, $8, $9)) AND ($10 = 0 OR s.exchange in ($11)) AND ($12 = 0 OR s.symbol in ($13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262)) AND ($263 = 0 OR p.patternname in ($264)) AND ($265 = 0 OR kr.patternclassid in ($266, $267)) AND ($268 = 0 OR kr.patternlengthbars <= $269) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $270 OR relevant = 1) AND ($271 = 0 OR age <= $272) ORDER BY identified DESC, length DESC;

Date: 2021-07-25 23:41:09
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

select stats_createSummaryTables_KeyLevels (cast(4853 as int));

Date: 2021-07-25 23:57:36
Duration: 30m47s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_KeyLevels (cast(4789 as int));

Date: 2021-07-25 23:13:18
Duration: 18m34s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_KeyLevels (cast(4791 as int));

Date: 2021-07-25 23:13:18
Duration: 18m34s
Database: acaweb_fx
User: postgres

x Hide

)) AND patternclassid = $1 AND patternlengthbars >= $2 AND a.PatternID & $3 > 0 AND dftt.dayofweek = $4 AND a.resultuid > $5 AND c.nonliquid = $6 AND c.deleted = 0 AND dss.enabled = 1 ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2021-07-25 23:40:45
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

Date: 2021-07-25 23:18:48
Duration: 32s384ms
Database: acaweb_fx
User: postgres

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

Date: 2021-07-25 23:47:49
Duration: 30s931ms
Database: acaweb_fx
User: postgres

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

Date: 2021-07-25 23:43:26
Duration: 30s892ms
Database: acaweb_fx
User: postgres

x Hide

WITH pet as ( select enddate, t.symbolid, row_number() over (partition by t.symbolid order by enddate desc) r from powerstats_trumpet t inner join brokersymbollist bsl on t.symbolid = bsl.symbolid and bsl.brokerid = 637 ) select _xml FROM ( select * from ( select distinct replace(symbol, ' ', '~') || '%<' || dayofweek || '_' || fromtime || '><15>' || round(ave_15, 5) || '</15><30>' || round(ave_30, 5) || '</30><60>' || round(ave_60, 5) || '</60><240>' || round(ave_240, 5) || '</240><1440>' || round(ave_1440, 5) || '</1440></' || dayofweek || '_' || fromtime || '>' as _xml, replace(symbol, ' ', '~') as symbol, dayofweek, fromtime, round(ave_15, 5) as ave_15, round(ave_30, 5) as ave_30, round(ave_60, 5) as ave_60, round(ave_240, 5) as ave_240, round(ave_1440, 5) as ave_1440 from symbols s inner join brokersymbollist bsl on s.symbolid = bsl.symbolid inner join pet on pet.r = 1 and bsl.symbolid = pet.symbolid and bsl.brokerid = 637 inner join powerstats_trumpet pt on bsl.symbolid = pt.symbolid and pet.enddate = pt.enddate where case when 637 != 285 then 1 = 1 else 1 = 0 end and case when 161 > 500 and 637 != 412 then s.exchange ilike 'FOREX' ELSE 1 = 1 END) b order by symbol, dayofweek, fromtime) a;

Date: 2021-07-25 23:05:02
Duration: 1m28s
Database: acaweb_fx
User: postgres

WITH pet as ( select enddate, t.symbolid, row_number() over (partition by t.symbolid order by enddate desc) r from powerstats_trumpet t inner join brokersymbollist bsl on t.symbolid = bsl.symbolid and bsl.brokerid = 661 ) select _xml FROM ( select * from ( select distinct replace(symbol, ' ', '~') || '%<' || dayofweek || '_' || fromtime || '><15>' || round(ave_15, 5) || '</15><30>' || round(ave_30, 5) || '</30><60>' || round(ave_60, 5) || '</60><240>' || round(ave_240, 5) || '</240><1440>' || round(ave_1440, 5) || '</1440></' || dayofweek || '_' || fromtime || '>' as _xml, replace(symbol, ' ', '~') as symbol, dayofweek, fromtime, round(ave_15, 5) as ave_15, round(ave_30, 5) as ave_30, round(ave_60, 5) as ave_60, round(ave_240, 5) as ave_240, round(ave_1440, 5) as ave_1440 from symbols s inner join brokersymbollist bsl on s.symbolid = bsl.symbolid inner join pet on pet.r = 1 and bsl.symbolid = pet.symbolid and bsl.brokerid = 661 inner join powerstats_trumpet pt on bsl.symbolid = pt.symbolid and pet.enddate = pt.enddate where case when 661 != 285 then 1 = 1 else 1 = 0 end and case when 229 > 500 and 661 != 412 then s.exchange ilike 'FOREX' ELSE 1 = 1 END) b order by symbol, dayofweek, fromtime) a;

Date: 2021-07-25 23:40:01
Duration: 1m28s
Database: acaweb_fx
User: postgres

WITH pet as ( select enddate, t.symbolid, row_number() over (partition by t.symbolid order by enddate desc) r from powerstats_trumpet t inner join brokersymbollist bsl on t.symbolid = bsl.symbolid and bsl.brokerid = 665 ) select _xml FROM ( select * from ( select distinct replace(symbol, ' ', '~') || '%<' || dayofweek || '_' || fromtime || '><15>' || round(ave_15, 5) || '</15><30>' || round(ave_30, 5) || '</30><60>' || round(ave_60, 5) || '</60><240>' || round(ave_240, 5) || '</240><1440>' || round(ave_1440, 5) || '</1440></' || dayofweek || '_' || fromtime || '>' as _xml, replace(symbol, ' ', '~') as symbol, dayofweek, fromtime, round(ave_15, 5) as ave_15, round(ave_30, 5) as ave_30, round(ave_60, 5) as ave_60, round(ave_240, 5) as ave_240, round(ave_1440, 5) as ave_1440 from symbols s inner join brokersymbollist bsl on s.symbolid = bsl.symbolid inner join pet on pet.r = 1 and bsl.symbolid = pet.symbolid and bsl.brokerid = 665 inner join powerstats_trumpet pt on bsl.symbolid = pt.symbolid and pet.enddate = pt.enddate where case when 665 != 285 then 1 = 1 else 1 = 0 end and case when 365 > 500 and 665 != 412 then s.exchange ilike 'FOREX' ELSE 1 = 1 END) b order by symbol, dayofweek, fromtime) a;

Date: 2021-07-25 23:52:02
Duration: 1m27s
Database: acaweb_fx
User: postgres

x Hide

)) AND breakout >= 0.0 AND patternendtime = LatestBarAtBreakoutTime AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 517187511 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2021-07-25 23:54:44
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

)) AND patternlengthbars >= 20 AND averagequality >= 0.0 AND (timequality >= 0.0 OR timequality = - 1) AND errormargin >= 0.0 AND 1 - noise >= 0.0 AND s.nonliquid = 0 AND PatternID & 63 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND PatternEndPrice > - 1 AND a.resultuid > 61315079 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, averagequality DESC LIMIT 50;

Date: 2021-07-25 23:48:49
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

)) AND breakout = - 1 AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 517253307 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2021-07-25 23:52:50
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((c.symbol ilike '%usdcad%' AND timegranularity = 15)) OR ((c.symbol ilike '%usdcad%' AND timegranularity = 30)) OR ((c.symbol ilike '%usdcad%' AND timegranularity = 60)) OR ((c.symbol ilike '%usdcad%' AND timegranularity = 240)) OR ((c.symbol ilike '%usdcad%' AND timegranularity = 1440))) AND patternclassid = $1 AND patternlengthbars >= $2 AND a.PatternID & $3 > 0 AND dftt.dayofweek = $4 AND a.resultuid > $5 AND c.nonliquid = $6 AND c.deleted = 0 AND dss.enabled = 1 ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2021-07-25 23:56:50
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), results AS ( SELECT DISTINCT ON (s.symbolid) fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM fibonacci_results fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_fibonacci_results rar ON rar.resultuid = fr.resultuid WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR s.symbol in ($7)) AND ($8 = 0 OR fr.pattern in ($9)) AND ($10 = 0 OR fr.patternlengthbars <= $11) AND ($12 = 0 OR ($13 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($14 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $15 OR relevant = 1) AND ($16 = 0 OR age <= $17) ORDER BY identified DESC, length DESC;

Date: 2021-07-25 23:12:11
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

select updateresultsmaterializedview ();

Date: 2021-07-25 23:28:07
Duration: 4m38s
Database: acaweb_fx
User: postgres

select updateresultsmaterializedview ();

Date: 2021-07-25 23:24:59
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((c.symbol ilike '%xauusd%' AND timegranularity = 240)) OR ((c.symbol ilike '%eurusd%' AND timegranularity = 1440)) OR ((c.symbol ilike '%xauusd%' AND timegranularity = 1440))) AND patternclassid = $1 AND patternlengthbars >= $2 AND a.PatternID & $3 > 0 AND dftt.dayofweek = $4 AND a.qtytp >= $5 AND a.resultuid > $6 AND c.nonliquid = $7 AND c.deleted = 0 AND dss.enabled = 1 ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2021-07-25 23:00:40
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

)) AND patternlengthbars >= 20 AND averagequality >= 0.0 AND (timequality >= 0.0 OR timequality = - 1) AND errormargin >= 0.0 AND 1 - noise >= 0.0 AND s.nonliquid = 0 AND PatternID & 63 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND PatternEndPrice = - 1 AND a.resultuid > 61321453 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, averagequality DESC LIMIT 50;

Date: 2021-07-25 23:00:40
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'Forex4You - 1';

Date: 2021-07-25 23:03:00
Database: acaweb_fx
User: postgres

SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'VALBURYFUTURES - 1';

Date: 2021-07-25 23:03:00
Database: acaweb_fx
User: postgres

SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'AMANACAPITAL - 1';

Date: 2021-07-25 23:03:00
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T15 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 1010646, '2021-07-26 00:30:00'::timestamp without time zone, 9.147, 9.14763, 9.14409, 9.14427, 72, 0, '2021-07-25 23:46:13'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T15 WHERE symbolid = 1010646 AND pricedatetime = '2021-07-26 00:30:00'::timestamp without time zone); ;

Date: 2021-07-25 23:46:16
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T30 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 1002852, '2021-07-23 23:30:00'::timestamp without time zone, 1.7268, 1.72754, 1.72662, 1.72717, 1112, 0, '2021-07-25 23:05:13'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T30 WHERE symbolid = 1002852 AND pricedatetime = '2021-07-23 23:30:00'::timestamp without time zone); ;

Date: 2021-07-25 23:05:15
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T15 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 969890, '2021-07-26 00:15:00'::timestamp without time zone, 12.903, 12.908, 12.895, 12.908, 25, 0, '2021-07-25 23:48:13'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T15 WHERE symbolid = 969890 AND pricedatetime = '2021-07-26 00:15:00'::timestamp without time zone); INSERT INTO T15 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 969890, '2021-07-26 00:30:00'::timestamp without time zone, 12.895, 12.908, 12.895, 12.907, 5, 0, '2021-07-25 23:48:13'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T15 WHERE symbolid = 969890 AND pricedatetime = '2021-07-26 00:30:00'::timestamp without time zone); ;

Date: 2021-07-25 23:48:15
Database: acaweb_fx
User: postgres

x Hide

SELECT extract(epoch from datetimeupdate) FROM latest_candle_datetime_per_receng WHERE recognitionengine ilike 'ATFX - 1';

Date: 2021-07-25 23:32:37
Database: acaweb_fx
User: postgres

SELECT extract(epoch from datetimeupdate) FROM latest_candle_datetime_per_receng WHERE recognitionengine ilike 'ATFX - 1';

Date: 2021-07-25 23:57:28
Database: acaweb_fx
User: postgres

SELECT extract(epoch from datetimeupdate) FROM latest_candle_datetime_per_receng WHERE recognitionengine ilike 'ATFX - 1';

Date: 2021-07-25 23:42:28
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO Autochartist_Results (ResultID, SymbolID, Bandwidth, Pattern, QtyTP, GMTTimeFound, Direction, InitialTrend, Breakout, VolumeIncrease, Noise, Symmetry, PredictionPriceFrom, PredictionPriceTo, PredictionTimeFrom, PredictionTimeTo, PatternStartTime, PatternEndTime, PatternStartPrice, PatternEndPrice, Resx0, Resx1, Supportx0, Supportx1, Resy0, Resy1, Supporty0, Supporty1, SupportGradient, ResGradient, RiskReward, PatternQuality, TrendChange, MaxMovementAfterBreakout, LatestBarAtBreakoutTime, LatestBarAtBreakoutPrice, PatternLengthBars, TemporaryPattern, relevancestartdistance, simulation, writtendatetime) SELECT DISTINCT '974490-1|44400.4792|44400.9375|44400.3958|44400.7083|120.159|120.2045|119.812|119.8895', 974490, 5.000000000000000000000000000000, 'Rising Wedge', 4, '2021-07-25 21:47:49'::timestamp without time zone, - 1, 0.178293008962997073800000000000, - 1.000000000000000000000000000000, 0.000000000000000000000000000000, 0.735737329566097719700000000000, 0.192688398044381953300000000000, 120.055828122051153200000000000000, 120.107261717521311100000000000000, '2021-07-26 00:45:00'::timestamp without time zone, '2021-07-27 08:22:30'::timestamp without time zone, '2021-07-23 09:30:00'::timestamp without time zone, '2021-07-26 00:45:00'::timestamp without time zone, 119.867000000000004400000000000000, 120.144000000000005500000000000000, '2021-07-23 11:30:00'::timestamp without time zone, '2021-07-23 22:30:00'::timestamp without time zone, '2021-07-23 09:30:00'::timestamp without time zone, '2021-07-23 17:00:00'::timestamp without time zone, 120.159000000000006000000000000000, 120.204499999999995900000000000000, 119.811999999999997600000000000000, 119.889499999999998200000000000000, 0.002583333333333352397000000000, 0.001034090909090679133000000000, 1.268629870584670360000000000000, 0.211748025813760426500000000000, 'Continuation', 0.000000000000000000000000000000, '2021-07-26 00:45:00'::timestamp without time zone, 120.144000000000005500000000000000, 57, 0, 0.331000000000003069600000000000, 0, CURRENT_TIMESTAMP::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM Autochartist_Results WHERE (breakout = - 1.000000000000000000000000000000 and resx0 = '2021-07-23 11:30:00'::timestamp without time zone and resx1 = '2021-07-23 22:30:00'::timestamp without time zone and supportx0 = '2021-07-23 09:30:00'::timestamp without time zone and supportx1 = '2021-07-23 17:00:00'::timestamp without time zone and resy0 = 120.159000000000006000000000000000 and resy1 = 120.204499999999995900000000000000 and supporty0 = 119.811999999999997600000000000000 and supporty1 = 119.889499999999998200000000000000 and symbolid = 974490) or resultid = '974490-1|44400.4792|44400.9375|44400.3958|44400.7083|120.159|120.2045|119.812|119.8895') LIMIT 1 ON CONFLICT DO NOTHING; ;

Date: 2021-07-25 23:48:18
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T240 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 982533, '2021-07-23 20:00:00'::timestamp without time zone, 1.6002, 1.60171, 1.60001, 1.60001, 5486, 0, '2021-07-25 23:01:12'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T240 WHERE symbolid = 982533 AND pricedatetime = '2021-07-23 20:00:00'::timestamp without time zone); ;

Date: 2021-07-25 23:01:13
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T1440 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 919608, '2021-07-23 00:00:00'::timestamp without time zone, 0.91993, 0.92219, 0.9187, 0.91958, 130512, 0, '2021-07-25 23:46:14'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T1440 WHERE symbolid = 919608 AND pricedatetime = '2021-07-23 00:00:00'::timestamp without time zone); ;

Date: 2021-07-25 23:46:16
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO keylevels_results (bandwidth, breakout, patternid, gmttimefound, approachingtimestamp, approachingregion, qtytp, patternlengthbars, patternprice, x0, x1, x2, x3, x4, x5, x6, x7, x8, x9, breakoutbars, breakoutprice, patternendtime, atbaridentified, atpriceidentified, errorMargin, direction, symbolid, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimebars, uniquepointsvalue, furthestPrice, relevancestartdistance, patternclassid, patternstarttime, stoplosslevel, simulation, writtendatetime) SELECT DISTINCT 2.000000000000000000000000000000, - 1, 1, '2021-07-25 21:45:48'::timestamp without time zone, '2021-07-26 00:30:00', 0.001200000000000019410000000000, 3, 27, 1.598840000000000039000000000000, '2021-07-23 23:30:00', '2021-07-23 22:00:00', '2021-07-23 17:45:00', '', '', '', '', '', '', '', 46, 1.598975999999999953000000000000, '2021-07-26 00:30:00'::timestamp without time zone, '2021-07-26 00:30:00', 1.597679999999999989000000000000, 0.000255000000000005005600000000, 1, 982480, 0.000000000000000000000000000000, 0.000000000000000000000000000000, '1900-01-01 00:00:00'::timestamp without time zone, 0, '|982480|1.59884|1|2021-07-26 00:30:00|2021-07-26 00:30:00|1|-1', 1.597183999999999937000000000000, 0.001656000000000101835000000000, 2, '2021-07-23 17:45:00', 1.595820000000000016000000000000, 0, CURRENT_TIMESTAMP::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM keylevels_results WHERE uniquepointsvalue = '|982480|1.59884|1|2021-07-26 00:30:00|2021-07-26 00:30:00|1|-1') LIMIT 1 ON CONFLICT DO NOTHING; ;

Date: 2021-07-25 23:46:16
Database: acaweb_fx
User: postgres

x Hide