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)) AND ($237 = 0 OR p.patternname in ($238)) AND ($239 = 0 OR kr.patternclassid in ($240, $241)) AND ($242 = 0 OR kr.patternlengthbars <= $243) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $244 OR relevant = 1) AND ($245 = 0 OR age <= $246) ORDER BY identified DESC, length DESC;

Date: 2021-07-26 06:28:54
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

select stats_createSummaryTables_ChartPattens (cast(4605 as int));

Date: 2021-07-26 06:08:03
Duration: 7m25s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_ChartPattens (cast(4682 as int));

Date: 2021-07-26 06:24:02
Duration: 5m47s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_ChartPattens (cast(4747 as int));

Date: 2021-07-26 06:53:05
Duration: 4m49s
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-26 06:29:10
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

select stats_createSummaryTables_KeyLevels (cast(4737 as int));

Date: 2021-07-26 06:43:35
Duration: 12m24s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_KeyLevels (cast(4677 as int));

Date: 2021-07-26 06:18:14
Duration: 4m19s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_KeyLevels (cast(4618 as int));

Date: 2021-07-26 06:10:35
Duration: 1m19s
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-26 06:47:37
Duration: 16s129ms
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-26 06:01:31
Duration: 8s254ms
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-26 06:33:52
Duration: 7s927ms
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-26 06:33:00
Duration: 0ms
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 > 517186599 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2021-07-26 06:38:12
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((s.symbol ilike '%eurjpy d%' AND timegranularity = 15)) OR ((s.symbol ilike '%eurjpy d%' AND timegranularity = 30)) OR ((s.symbol ilike '%eurjpy %' AND timegranularity = 30)) OR ((s.symbol ilike '%eurjpy d%' AND timegranularity = 60)) OR ((s.symbol ilike '%eurjpy d%' AND timegranularity = 240))) 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 > 517193290 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2021-07-26 06:08:53
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 > 61281623 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, averagequality DESC LIMIT 50;

Date: 2021-07-26 06:09:42
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

WITH a AS ( SELECT *, row_number() OVER (PARTITION BY symbolid, direction ORDER BY datetime DESC) r FROM sa_hist_consecutivecandles ) SELECT DISTINCT a.symbolid, a.qty, a.percentile, a.direction FROM a INNER JOIN symbols s on a.symbolid = s.symbolid INNER JOIN autochartist_stocklist aus on s.symbolid = aus.symbolid WHERE aus.Enabled = 1 AND a.r = 1 AND aus.RecognitionEngine ILIKE 'LEGACYFXMT5 - 1';

Date: 2021-07-26 06:27:48
Duration: 4s214ms
Database: acaweb_fx
User: postgres

WITH a AS ( SELECT *, row_number() OVER (PARTITION BY symbolid, direction ORDER BY datetime DESC) r FROM sa_hist_consecutivecandles ) SELECT DISTINCT a.symbolid, a.qty, a.percentile, a.direction FROM a INNER JOIN symbols s on a.symbolid = s.symbolid INNER JOIN autochartist_stocklist aus on s.symbolid = aus.symbolid WHERE aus.Enabled = 1 AND a.r = 1 AND aus.RecognitionEngine ILIKE 'LEGACYFXMT5 - 1';

Date: 2021-07-26 06:27:48
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((s.symbol ilike '%ustec%' AND timegranularity <= 1440))) 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 > 517068653 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2021-07-26 06:40:59
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

when 1440 then 1 when 240 then 3 when 60 then 4 when 30 then 5 when 15 then 5 end)) ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2021-07-26 06:14:34
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 > 61277759 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, averagequality DESC LIMIT 50;

Date: 2021-07-26 06:25:52
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T30 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 977081, '2021-07-26 07:00:00'::timestamp without time zone, 0.6752, 0.67542, 0.67506, 0.67521, 501, 0, '2021-07-26 06:31:04'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T30 WHERE symbolid = 977081 AND pricedatetime = '2021-07-26 07:00:00'::timestamp without time zone); ;

Date: 2021-07-26 06:31:05
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T15 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 975895, '2021-07-26 07:15:00'::timestamp without time zone, 81.091, 81.104, 81.073, 81.095, 363, 0, '2021-07-26 06:31:04'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T15 WHERE symbolid = 975895 AND pricedatetime = '2021-07-26 07:15:00'::timestamp without time zone); ;

Date: 2021-07-26 06:31:06
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T60 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 1020916, '2021-07-26 06:00:00'::timestamp without time zone, 0.92499, 0.92501, 0.92419, 0.92437, 1932, 0, '2021-07-26 06:01:04'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T60 WHERE symbolid = 1020916 AND pricedatetime = '2021-07-26 06:00:00'::timestamp without time zone); ;

Date: 2021-07-26 06:01:05
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T15 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 969040, '2021-07-26 07:00:00'::timestamp without time zone, 25.654, 25.6547, 25.6518, 25.6547, 19, 0, '2021-07-26 06:31:18'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T15 WHERE symbolid = 969040 AND pricedatetime = '2021-07-26 07:00:00'::timestamp without time zone); INSERT INTO T15 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 969040, '2021-07-26 07:15:00'::timestamp without time zone, 25.6506, 25.6554, 25.6505, 25.6547, 16, 0, '2021-07-26 06:31:18'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T15 WHERE symbolid = 969040 AND pricedatetime = '2021-07-26 07:15:00'::timestamp without time zone); ;

Date: 2021-07-26 06:31:19
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T240 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 919734, '2021-07-25 20:00:00'::timestamp without time zone, 0.8772, 0.8776, 0.8752, 0.87596, 21602, 0, '2021-07-26 06:01:05'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T240 WHERE symbolid = 919734 AND pricedatetime = '2021-07-25 20:00:00'::timestamp without time zone); ;

Date: 2021-07-26 06:01:06
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T1440 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 919749, '2021-07-25 00:00:00'::timestamp without time zone, 0.87508, 0.87786, 0.87354, 0.87596, 26775, 0, '2021-07-26 06:01:07'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T1440 WHERE symbolid = 919749 AND pricedatetime = '2021-07-25 00:00:00'::timestamp without time zone); ;

Date: 2021-07-26 06:01:08
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T15 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 1002016, '2021-07-26 00:15:00'::timestamp without time zone, 34927, 34927, 34919, 34923, 213, 0, '2021-07-26 06:31:04'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T15 WHERE symbolid = 1002016 AND pricedatetime = '2021-07-26 00:15:00'::timestamp without time zone); ;

Date: 2021-07-26 06:31:05
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T30 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 977021, '2021-07-26 07:00:00'::timestamp without time zone, 15685, 15685, 15664, 15668, 174, 0, '2021-07-26 06:31:19'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T30 WHERE symbolid = 977021 AND pricedatetime = '2021-07-26 07:00:00'::timestamp without time zone); ;

Date: 2021-07-26 06:31:20
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T15 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 1010241, '2021-07-26 07:15:00'::timestamp without time zone, 4399.5, 4399.6, 4398.7, 4399, 79, 0, '2021-07-26 06:31:33'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T15 WHERE symbolid = 1010241 AND pricedatetime = '2021-07-26 07:15:00'::timestamp without time zone); ;

Date: 2021-07-26 06:31:35
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T30 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 975941, '2021-07-26 07:00:00'::timestamp without time zone, 4085, 4086.2, 4084.5, 4085.3, 252, 0, '2021-07-26 06:31:23'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T30 WHERE symbolid = 975941 AND pricedatetime = '2021-07-26 07:00:00'::timestamp without time zone); ;

Date: 2021-07-26 06:31:25
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T60 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 989587, '2021-07-26 05:00:00'::timestamp without time zone, 34790, 34806, 34783, 34796, 1994, 0, '2021-07-26 06:01:18'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T60 WHERE symbolid = 989587 AND pricedatetime = '2021-07-26 05:00:00'::timestamp without time zone); ;

Date: 2021-07-26 06:01:20
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T15 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimewritten) VALUES (960516, '2021-07-26 03:45', 0.92444, 0.92449, 0.92422, 0.92448, 0, 0, '2021-07-26 06:01');

Date: 2021-07-26 06:01:59
Database: acaweb_fx
User: postgres

INSERT INTO T15 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimewritten) VALUES (960529, '2021-07-26 03:45', 1.08211, 1.08221, 1.08211, 1.08218, 0, 0, '2021-07-26 06:02');

Date: 2021-07-26 06:02:43
Database: acaweb_fx
User: postgres

INSERT INTO T15 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimewritten) VALUES (960517, '2021-07-26 03:45', 0.67519, 0.67524, 0.67493, 0.67524, 0, 0, '2021-07-26 06:02');

Date: 2021-07-26 06:02:05
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T240 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimewritten) VALUES (960643, '2021-07-26 00:00', 1.08258, 1.08275, 1.08198, 1.08218, 0, 0, '2021-07-26 06:02');

Date: 2021-07-26 06:02:47
Database: acaweb_fx
User: postgres

INSERT INTO T240 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimewritten) VALUES (960630, '2021-07-26 00:00', 0.92598, 0.92614, 0.92422, 0.92448, 0, 0, '2021-07-26 06:02');

Date: 2021-07-26 06:02:04
Database: acaweb_fx
User: postgres

INSERT INTO T240 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimewritten) VALUES (960639, '2021-07-26 00:00', 120.197, 120.213, 119.976, 120.071, 0, 0, '2021-07-26 06:02');

Date: 2021-07-26 06:02:33
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T1440 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 972919, '2021-07-25 00:00:00'::timestamp without time zone, 72, 72.17, 71.3, 71.33, 90375, 0, '2021-07-26 06:01:38'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T1440 WHERE symbolid = 972919 AND pricedatetime = '2021-07-25 00:00:00'::timestamp without time zone); ;

Date: 2021-07-26 06:01:39
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T60 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 1021171, '2021-07-26 06:00:00'::timestamp without time zone, 73.09, 73.12, 72.97, 73, 436, 0, '2021-07-26 06:01:31'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T60 WHERE symbolid = 1021171 AND pricedatetime = '2021-07-26 06:00:00'::timestamp without time zone); ;

Date: 2021-07-26 06:01:33
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T30 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 982421, '2021-07-26 07:00:00'::timestamp without time zone, 6999.2, 7003.2, 6999, 7001.2, 172, 0, '2021-07-26 06:31:24'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T30 WHERE symbolid = 982421 AND pricedatetime = '2021-07-26 07:00:00'::timestamp without time zone); ;

Date: 2021-07-26 06:31:26
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T15 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 982420, '2021-07-26 07:15:00'::timestamp without time zone, 7002, 7003.2, 7000, 7001.2, 84, 0, '2021-07-26 06:31:23'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T15 WHERE symbolid = 982420 AND pricedatetime = '2021-07-26 07:15:00'::timestamp without time zone); ;

Date: 2021-07-26 06:31:24
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T30 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 986841, '2021-07-26 06:30:00'::timestamp without time zone, 15596.5, 15601.5, 15587.5, 15595, 162, 0, '2021-07-26 06:01:56'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T30 WHERE symbolid = 986841 AND pricedatetime = '2021-07-26 06:30:00'::timestamp without time zone); ;

Date: 2021-07-26 06:01:58
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T15 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 975945, '2021-07-26 07:15:00'::timestamp without time zone, 15600, 15600.5, 15596.5, 15598, 76, 0, '2021-07-26 06:31:19'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T15 WHERE symbolid = 975945 AND pricedatetime = '2021-07-26 07:15:00'::timestamp without time zone); ;

Date: 2021-07-26 06:31:21
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T15 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 1020609, '2021-07-26 06:15:00'::timestamp without time zone, 4390.75, 4390.75, 4390, 4390.25, 40, 0, '2021-07-26 06:31:51'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T15 WHERE symbolid = 1020609 AND pricedatetime = '2021-07-26 06:15:00'::timestamp without time zone); ;

Date: 2021-07-26 06:31:53
Database: acaweb_fx
User: postgres

x Hide

INSERT INTO T30 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 1010172, '2021-07-26 06:30:00'::timestamp without time zone, 3.26929, 3.26929, 3.26929, 3.26929, 32, 0, '2021-07-26 06:31:42'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T30 WHERE symbolid = 1010172 AND pricedatetime = '2021-07-26 06:30:00'::timestamp without time zone); INSERT INTO T30 (SymbolID, PriceDateTime, Open, High, Low, Close, Volume, BSF, sastdatetimereceived) SELECT 1010172, '2021-07-26 07:00:00'::timestamp without time zone, 3.26878, 3.26878, 3.26813, 3.26828, 61, 0, '2021-07-26 06:31:42'::timestamp without time zone WHERE NOT EXISTS ( SELECT 1 FROM T30 WHERE symbolid = 1010172 AND pricedatetime = '2021-07-26 07:00:00'::timestamp without time zone); ;

Date: 2021-07-26 06:31:44
Database: acaweb_fx
User: postgres

x Hide