By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
40 rows affected
| IndexName | date | symbol | wt | px_change | yest_close |
|---|---|---|---|---|---|
| NIFTY ENERGY | 2021-11-18 | ADANITRANS | 8.2724 | 55.8 | 1857.5 |
| NIFTY ENERGY | 2021-11-18 | ADANIGREEN | 8.6514 | 32.25 | 1313.5 |
| NIFTY ENERGY | 2021-11-18 | RELIANCE | 29.8806 | 9.3 | 2464 |
| NIFTY ENERGY | 2021-11-18 | POWERGRID | 10.5769 | 1.45 | 191.05 |
| NIFTY ENERGY | 2021-11-18 | IOC | 5.2884 | 0.9 | 128.45 |
| NIFTY ENERGY | 2021-11-18 | NTPC | 10.5011 | -1.15 | 136.45 |
| NIFTY ENERGY | 2021-11-18 | GAIL | 4.2758 | -4.05 | 145 |
| NIFTY ENERGY | 2021-11-18 | BPCL | 6.3973 | -8.5 | 413.8 |
| NIFTY ENERGY | 2021-11-18 | ONGC | 9.3012 | -3.1 | 157.4 |
| NIFTY ENERGY | 2021-11-18 | TATAPOWER | 6.8549 | -12.8 | 249.9 |
| NIFTY ENERGY | 2021-11-22 | POWERGRID | 10.6767 | 1.7 | 192.5 |
| NIFTY ENERGY | 2021-11-22 | ADANITRANS | 8.5365 | 0.15 | 1913.3 |
| NIFTY ENERGY | 2021-11-22 | ADANIGREEN | 8.8801 | -4.8 | 1345.75 |
| NIFTY ENERGY | 2021-11-22 | GAIL | 4.164 | -3.65 | 140.95 |
| NIFTY ENERGY | 2021-11-22 | BPCL | 6.2774 | -9.7 | 405.3 |
| NIFTY ENERGY | 2021-11-22 | IOC | 5.3352 | -4.85 | 129.35 |
| NIFTY ENERGY | 2021-11-22 | TATAPOWER | 6.5157 | -9.45 | 237.1 |
| NIFTY ENERGY | 2021-11-22 | NTPC | 10.4317 | -5.15 | 135.3 |
| NIFTY ENERGY | 2021-11-22 | ONGC | 9.1347 | -2.25 | 154.3 |
| NIFTY ENERGY | 2021-11-22 | RELIANCE | 30.0482 | -109.55 | 2473.3 |
| NIFTY ENERGY | 2021-11-23 | ADANIGREEN | 9.1072 | 66.1 | 1340.95 |
| NIFTY ENERGY | 2021-11-23 | POWERGRID | 11.086 | 7.65 | 194.2 |
| NIFTY ENERGY | 2021-11-23 | RELIANCE | 29.5571 | 22.1 | 2363.75 |
| NIFTY ENERGY | 2021-11-23 | NTPC | 10.3281 | 3.35 | 130.15 |
| NIFTY ENERGY | 2021-11-23 | TATAPOWER | 6.439 | 9.3 | 227.65 |
| NIFTY ENERGY | 2021-11-23 | ADANITRANS | 8.7868 | 41.1 | 1913.45 |
| NIFTY ENERGY | 2021-11-23 | IOC | 5.2853 | 1.65 | 124.5 |
| NIFTY ENERGY | 2021-11-23 | GAIL | 4.1748 | 1.2 | 137.3 |
| NIFTY ENERGY | 2021-11-23 | BPCL | 6.3063 | 2 | 395.6 |
| NIFTY ENERGY | 2021-11-23 | ONGC | 8.9296 | 0.15 | 146.55 |
| NIFTY ENERGY | 2021-11-24 | ONGC | 8.7611 | 6.75 | 146.7 |
| NIFTY ENERGY | 2021-11-24 | NTPC | 10.3834 | 1.85 | 133.5 |
| NIFTY ENERGY | 2021-11-24 | BPCL | 6.2123 | 5.75 | 397.6 |
| NIFTY ENERGY | 2021-11-24 | POWERGRID | 11.2937 | 1.45 | 201.85 |
| NIFTY ENERGY | 2021-11-24 | IOC | 5.249 | 1.45 | 126.15 |
| NIFTY ENERGY | 2021-11-24 | GAIL | 4.1276 | 1.7 | 138.5 |
| NIFTY ENERGY | 2021-11-24 | TATAPOWER | 6.5689 | 1.6 | 236.95 |
| NIFTY ENERGY | 2021-11-24 | ADANITRANS | 8.7972 | -17.55 | 1954.55 |
| NIFTY ENERGY | 2021-11-24 | ADANIGREEN | 9.3662 | -15.7 | 1407.05 |
| NIFTY ENERGY | 2021-11-24 | RELIANCE | 29.2407 | -34.45 | 2385.85 |