ezyquant.reader.SETDataReader.get_symbols_by_index#

SETDataReader.get_symbols_by_index(index_list: List[str] | None = None, start_date: str | None = None, end_date: str | None = None) → DataFrame#

Data from table SECURITY_INDEX.

Parameters:

  • index_list (Optional[List[str]] = None) –

    index (SECTOR.N_SYMBOL_FEED)

    • SETWB

    • SETTHSI

    • SETCLMV

    • SETHD

    • sSET

    • SET100

    • SET50

  • start_date (Optional[str] = None) – start of as_of_date (D_AS_OF).

  • end_date (Optional[str] = None) – end of as_of_date (D_AS_OF).

Returns:

  • as_of_date: date - D_AS_OF

  • index: str - SECTOR.N_SYMBOL_FEED

  • symbol: str - SECURITY.N_SECURITY

  • seq: int - SECURITY_INDEX.S_SEQ

Return type:

pd.DataFrame

Note

  • SET50 filter S_SEQ 1-50

  • SET100 filter S_SEQ 1-100

  • SETHD filter S_SEQ 1-30

Examples

>>> from ezyquant import SETDataReader
>>> sdr = SETDataReader()
>>> sdr.get_symbols_by_index(index_list=["SET50"], start_date="2022-01-04", end_date="2022-01-04")
   as_of_date  index  symbol  seq
0  2022-01-04  SET50     OSP    1
1  2022-01-04  SET50     CBG    2
2  2022-01-04  SET50      TU    3
3  2022-01-04  SET50    MINT    4
4  2022-01-04  SET50     CPF    5
5  2022-01-04  SET50    STGT    6
6  2022-01-04  SET50   TISCO    7
7  2022-01-04  SET50     KTB    8
8  2022-01-04  SET50     TTB    9
9  2022-01-04  SET50     SCB   10
10 2022-01-04  SET50   KBANK   11
11 2022-01-04  SET50     BBL   12
12 2022-01-04  SET50  TIDLOR   13
13 2022-01-04  SET50     MTC   14
14 2022-01-04  SET50   SAWAD   15
15 2022-01-04  SET50     KTC   16
16 2022-01-04  SET50   PTTGC   17
17 2022-01-04  SET50     IVL   18
18 2022-01-04  SET50    SCGP   19
19 2022-01-04  SET50     SCC   20
20 2022-01-04  SET50     AWC   21
21 2022-01-04  SET50     CPN   22
22 2022-01-04  SET50      LH   23
23 2022-01-04  SET50      OR   24
24 2022-01-04  SET50    GULF   25
25 2022-01-04  SET50   BGRIM   26
26 2022-01-04  SET50    GPSC   27
27 2022-01-04  SET50      EA   28
28 2022-01-04  SET50     TOP   29
29 2022-01-04  SET50     PTT   30
30 2022-01-04  SET50   RATCH   31
31 2022-01-04  SET50    IRPC   32
32 2022-01-04  SET50    EGCO   33
33 2022-01-04  SET50   PTTEP   34
34 2022-01-04  SET50   BANPU   35
35 2022-01-04  SET50     CRC   36
36 2022-01-04  SET50    COM7   37
37 2022-01-04  SET50  GLOBAL   38
38 2022-01-04  SET50   CPALL   39
39 2022-01-04  SET50   HMPRO   40
40 2022-01-04  SET50    BDMS   41
41 2022-01-04  SET50      BH   42
42 2022-01-04  SET50     BEM   43
43 2022-01-04  SET50     AOT   44
44 2022-01-04  SET50     BTS   45
45 2022-01-04  SET50    DTAC   46
46 2022-01-04  SET50   TRUEE   47
47 2022-01-04  SET50  ADVANC   48
48 2022-01-04  SET50  INTUCH   49
49 2022-01-04  SET50     KCE   50