Coding
Quant Python

Top Symbols by Day in SQL

Premium
Difficulty

Read the problem, hints and solution here. The editor needs a bigger screen: open this page on a laptop to write and run your code.

xxxx-xxxxxxx xxxxxxxxx xxxxx xxxx xxx xxxxxxxxx xxxxxx, xxx xxx xxxxxxxxx xxxxx xxx xxx xxxx xxxxx xxxxx xxxxx xxx xxxxx: xxxxxxxxx, xxxx xxxxxx x xxxxx, xxx xxxxxxx x xxx xxxx xxx xxx xxxxxx xx. xxxx xxxxxxx xxxx xxx xxxxx, xxxxxxx x xxxxx xx xxxxxx xx xxxxxx.

xxxx_xxxxxx(xxxx) xx xxxxxxx xxxxxxx. xx xxxxxx xx xx-xxxxxx xxxxxx xxxxxxxx xxxx xxx xxxxx:

xxxxxx xxxxx xxxxxx (
    xxxxx_xx xxxxxxx xxxxxxx xxx,
    xx       xxxx xxx xxxx,     -- 'xxxx-xx-xx xx:xx:xx'
    xxxxxx   xxxx xxx xxxx,
    xxx      xxxxxxx xxx xxxx,  -- xxxxxxxx
    xxxxx    xxxxxxx xxx xxxx   -- xxxxxxx xxxxx
)

xxxxx xxx xxxxx xx xxx_xxxxxxx_xx_xxx(xxxx). xxx xxxxx xxxxxxx xxx, xxxxxx xxx xxx xxxxxxx xxxx xxx xxxxxxx xxxxxxxx xxxxxx xxxx xxx, xx xxxx (xxx, xxxx, xxxxxx, xxxxxxxx, xxxxxx):

  • xxx: xxx xxxx xxxx xx xx, xx 'xxxx-xx-xx'.
  • xxxxxxxx: xxx xxx xx xxx * xxxxx xxxx xxx xxxxxx'x xxxxxx xxxx xxx.
  • xxxx: x xxx xxx xxxxxxx xxxxxxxx xxxx xxx xxx x xxx xxx xxxx. xxxxx xxxx xx xxxxxx, xxxxxxxxxxxxxx. x xxx xxxx xxxx xxx xxxxxx xxx xxx xxx.
  • xxxxxx: xxx xxxxxx'x xxxxxxxx xxxxx xxx xxxxxxxx xx xxx xxxxxxxx xxx xx xxxxx xxxx xxxxxx xxxxxx, xxxxxxx xx xxx xx xxx xx xxxx xxx'x xxx xxx. xxxx xx xxx xxxxx xxx xxx xxxxxx xxxxxx.

xxxxx xxx xxxx xx xxx, xxxx xx xxxx.

xxxxxxx

xxx_xxxxxxx_xx_xxx(xxxx_xxxxxx([
    (x, "xxxx-xx-xx xx:xx:xx", "xxxx", xxx, xxx),
    (x, "xxxx-xx-xx xx:xx:xx", "xxxx", xx, xxx),
    (x, "xxxx-xx-xx xx:xx:xx", "xxxx", xx, xxx),
    (x, "xxxx-xx-xx xx:xx:xx", "xxxx", xxx, xxx),
    (x, "xxxx-xx-xx xx:xx:xx", "xxxx", xxx, xxx),
    (x, "xxxx-xx-xx xx:xx:xx", "xxxx", xx, xxx),
]))
# [('xxxx-xx-xx', x, 'xxxx', xxxxx, xxxx),
#  ('xxxx-xx-xx', x, 'xxxx', xxxxx, xxxx),
#  ('xxxx-xx-xx', x, 'xxxx', xxxxx, xxxxx),
#  ('xxxx-xx-xx', x, 'xxxx', xxxxx, xxxx)]

xxxx xxxxxx x,xxx xx x xxxxx, xxxxx xxx xxxxx xxxx xxx. xxx xxxxxx xx x xxxxx xx xxxxx xxxxxxxx xxxxxxx xxxx x,xxx.

xxxxxxxxxxx

  • xx xx ( xx^x ) xxxxxx. xxxxxx xxxxxxxx xxxxxx xxxxxxxxx, xxx xxx xxxxx xxxx xxxxxx xx xxxx xxxxxxx.
  • xxx xxxxxx xxxxxxxxxxx xxxx xxx xxx,xxx xxxxxx xxxx xxx xxxxxxx xxxx xxx xxx xxxxxxx, xxxxx xx xxxxx xx,xxx xxxxxx-xxxx.
  • xxx xxxxx xxxxxxx xxx xxxxxx xx xxxxxx xxxx xxx xxx xxxx, xxx xxx xxxxx xx xxx xxxxx: xxx xxxxxxxxx xxxxxxxx xx xxx xxx xxxxxxxxx.

This problem is only available to subscribers.

Language: Python 3.12top_symbols_by_day

Unlock the problem to run it against the tests.